Displaying 2 results from an estimated 2 matches for "part_name_id".
Did you mean:
part_name_iso
2006 Jan 11
0
Easy Question, I Think
...ps(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 null)
);
ALTER TABLE parts ADD CONSTR...
2006 Jan 12
0
Easy Question, I Think [re-post, sorry if dupe]
...ps(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 null)
);
ALTER TABLE parts ADD CONSTR...