CREATE SEQUENCE category_ids;
CREATE TABLE categories
    (
       category_id int NOT NULL default nextval('category_ids'),
       parent_category_id int
    );

CREATE SEQUENCE link_ids;
CREATE TABLE links
    (
       link_id int NOT NULL default nextval('link_ids'),
       category_id int REFERENCES categories,
       url VARCHAR,
       description VARCHAR
    );