Displaying 2 results from an estimated 2 matches for "sites_dept_fkey".
2007 Feb 07
2
Problems Generating Scaffolding
...(
room character varying(8) NOT NULL,
num_machines integer NOT NULL,
dept character varying(20) NOT NULL,
software character varying(25)[] NOT NULL,
machine_types integer[] NOT NULL,
machine_type character varying(20)[] NOT NULL,
CONSTRAINT sites_pkey PRIMARY KEY (room),
CONSTRAINT sites_dept_fkey FOREIGN KEY (dept)
REFERENCES dept (name) MATCH SIMPLE
ON UPDATE RESTRICT ON DELETE NO ACTION
)
WITHOUT OIDS;
CREATE TABLE free
(
name character varying(15) NOT NULL,
publisher character varying(15),
version character varying(8) NOT NULL,
num_copies integer NOT NULL,
depts c...
2007 Feb 07
5
Problems Generating Scaffolding
...LE sites
(
room character varying(8) NOT NULL,
num_machines integer NOT NULL,
dept character varying(20) NOT NULL,
software character varying(25)[] NOT NULL,
machine_types integer[] NOT NULL,
machine_type character varying(20)[] NOT NULL,
CONSTRAINT sites_pkey PRIMARY KEY (room),
CONSTRAINT sites_dept_fkey FOREIGN KEY (dept)
REFERENCES dept (name) MATCH SIMPLE
ON UPDATE RESTRICT ON DELETE NO ACTION
)
WITHOUT OIDS;
CREATE TABLE free
(
name character varying(15) NOT NULL,
publisher character varying(15),
version character varying(8) NOT NULL,
num_copies integer NOT NULL,
depts characte...