CREATE TABLE bt_priority_codes ( priority_id integer PRIMARY KEY NOT NULL, project_id integer, priority_name varchar(500) NOT NULL, sort_order integer NOT NULL, default_p char(1) DEFAULT 'f'::bpchar NOT NULL ); CREATE UNIQUE INDEX bt_priority_codes_name_un ON bt_priority_codes (project_id, priority_name); CREATE UNIQUE INDEX bt_priority_codes_sort_order_un ON bt_priority_codes (project_id, sort_order); -- Table size: 8,192 bytes -- Table rows: 12