Displaying 2 results from an estimated 2 matches for "part_number_id".
2006 Jan 11
0
Easy Question, I Think
...OREIGN KEY (group_id)
REFERENCES groups(id) DEFERRABLE INITIALLY DEFERRED;
CREATE TABLE part_numbers (
id serial primary key,
part_number integer NOT NULL,
constraint chk_part_number check (part_number ~''[0-9]*'')
);
CREATE TABLE parts (
id serial primary key,
part_number_id integer NOT NULL,
part_name_id integer NOT NULL,
quantity integer DEFAULT 1 NOT NULL,
side character varying,
size character varying,
"comment" character varying,
constraint chk_side check (side in (''L.H.'', ''R.H.'') or side is nul...
2006 Jan 12
0
Easy Question, I Think [re-post, sorry if dupe]
...OREIGN KEY (group_id)
REFERENCES groups(id) DEFERRABLE INITIALLY DEFERRED;
CREATE TABLE part_numbers (
id serial primary key,
part_number integer NOT NULL,
constraint chk_part_number check (part_number ~''[0-9]*'')
);
CREATE TABLE parts (
id serial primary key,
part_number_id integer NOT NULL,
part_name_id integer NOT NULL,
quantity integer DEFAULT 1 NOT NULL,
side character varying,
size character varying,
"comment" character varying,
constraint chk_side check (side in (''L.H.'', ''R.H.'') or side is nul...