CREATE TABLE segments (
    id serial PRIMARY KEY,
    name character varying(100) NOT NULL,
    status integer NOT NULL
);

CREATE TABLE segmentlinks (
    id serial PRIMARY KEY,
    parent_seg_id integer NOT NULL,
    child_seg_id integer NOT NULL,
    sequence_no integer NOT NULL
);