\connect - nobody

CREATE SEQUENCE "tablename_colname_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "tb_course_course_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "tb_courseuser_courseusers_i_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "tb_media_media_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "tb_coursesmed_coursesmedia__seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "tb_student_student_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "tb_instructor_instr_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "tb_courseinstructors_ci_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "tb_administrator_admin_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "tb_waitingcourseuser_wcu_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "tb_waitingcourseinst_wci_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "tb_movieactivity_mov_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "tb_advertactivity_ad_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "tb_spy_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "tb_user_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "tb_contact_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

CREATE TABLE "tb_spy" (
	"spy_id" integer DEFAULT nextval('tb_spy_id_seq'::text) NOT NULL,
	"date" TIMESTAMP DEFAULT 'now()' NOT NULL,
	"camera" INTEGER,
	"location" character varying(30) NOT NULL,
	"trigger" INTEGER,
	"delay" INTEGER,
	"image_path" character varying(255),
	"movie_path" character varying(255),
	"movie_length" INTEGER,
	"movie_size" INTEGER,
	"status" character varying(30),
	"hostname" character varying(30),
	"property" character varying(30),
	"operator" character varying(30),
	"contact" character varying(30),
	"stamp" INTEGER
);

CREATE TABLE "tb_user"(
	"user_id" integer DEFAULT nextval('tb_user_id_seq'::text) NOT NULL,
	"firstname" character varying(16) NOT NULL,
	"lastname" character varying(32) NOT NULL,
	"username" character varying(64) NOT NULL,
	"password" character varying(12) NOT NULL,
	"email"	character varying(64) NOT NULL,
	"ident"	character varying(32) NOT NULL,
	"title" character varying(30),
	"activity" character varying(30),
	"company"	character varying(32),
	"address1" character varying(64),
	"address2" character varying(64),
	"city" character varying(32),
	"state"	character varying(16),
	"zip"	character varying(10),
	"country" character varying(16),
	"telephone" character varying(30),
	"fax"	character varying(30),
	"mobile" character varying(30),
	"homephone" character varying(30),
	"photo" character varying(128),
	"biometric" character varying(128),
	"priv"	character varying(16),
	"flags" character varying(512),
	"status" character varying(30),
	"contact" character varying(128),
	"notes" character varying(80)
);

CREATE TABLE "tb_activity" (
	"contact_id" integer DEFAULT nextval('tb_contact_id_seq'::text) NOT NULL,
	"from_id" integer,
	"to_id" integer,
	"date" INTEGER,
	"contact" character varying(512),
	"status" character varying(80),
	"next" character varying(80)
);

CREATE TABLE "tb_spy_storage" (
	"camera" INTEGER,
	"hostname" character varying(30)
);

CREATE TABLE "tb_course" (
	"course_id" integer DEFAULT nextval('tb_course_course_id_seq'::text) NOT NULL,
	"course_name" character varying(30) NOT NULL,
	"course_description" character varying(255),
	Constraint "tb_course_pkey" Primary Key ("course_id")
);

CREATE TABLE "tb_courseusers" (
	"courseusers_id" integer DEFAULT nextval('tb_courseuser_courseusers_i_seq'::text) NOT NULL,
	"cu_courseid" integer NOT NULL,
	"cu_userid" integer NOT NULL,
	Constraint "tb_courseusers_pkey" Primary Key ("courseusers_id")
);

CREATE TABLE "tb_media" (
	"media_id" integer DEFAULT nextval('tb_media_media_id_seq'::text) NOT NULL,
	"media_name" character varying(50) NOT NULL,
	"media_filetype" character varying(10),
	"media_fullpath" character varying(255),
	Constraint "tb_media_pkey" Primary Key ("media_id")
);

CREATE TABLE "tb_coursesmedia" (
	"coursesmedia_id" integer,
	"cm_courseid" integer,
	"cm_mediaid" integer
);

CREATE TABLE "tb_student" (
	"student_id" integer DEFAULT nextval('tb_student_student_id_seq'::text) NOT NULL,
	"student_username" character varying(25) NOT NULL,
	"student_password" character varying(20) NOT NULL,
	"student_lastname" character varying(35) NOT NULL,
	"student_firstname" character varying(35) NOT NULL,
	"student_collegeid" character varying(20),
	"student_emailaddress" character varying(100),
	"student_lastlogin" timestamp with time zone DEFAULT now() NOT NULL,
	Constraint "tb_student_pkey" Primary Key ("student_id")
);

REVOKE ALL on "tb_student" from PUBLIC;
GRANT ALL on "tb_student" to "nobody";

CREATE TABLE "pga_queries" (
	"queryname" character varying(64),
	"querytype" character(1),
	"querycommand" text,
	"querytables" text,
	"querylinks" text,
	"queryresults" text,
	"querycomments" text
);

REVOKE ALL on "pga_queries" from PUBLIC;
GRANT ALL on "pga_queries" to PUBLIC;
GRANT ALL on "pga_queries" to "nobody";

CREATE TABLE "pga_forms" (
	"formname" character varying(64),
	"formsource" text
);

REVOKE ALL on "pga_forms" from PUBLIC;
GRANT ALL on "pga_forms" to PUBLIC;
GRANT ALL on "pga_forms" to "nobody";

CREATE TABLE "pga_scripts" (
	"scriptname" character varying(64),
	"scriptsource" text
);


REVOKE ALL on "pga_scripts" from PUBLIC;
GRANT ALL on "pga_scripts" to PUBLIC;
GRANT ALL on "pga_scripts" to "nobody";

CREATE TABLE "pga_reports" (
	"reportname" character varying(64),
	"reportsource" text,
	"reportbody" text,
	"reportprocs" text,
	"reportoptions" text
);

REVOKE ALL on "pga_reports" from PUBLIC;
GRANT ALL on "pga_reports" to PUBLIC;
GRANT ALL on "pga_reports" to "nobody";

CREATE TABLE "pga_schema" (
	"schemaname" character varying(64),
	"schematables" text,
	"schemalinks" text
);

REVOKE ALL on "pga_schema" from PUBLIC;
GRANT ALL on "pga_schema" to PUBLIC;
GRANT ALL on "pga_schema" to "nobody";

CREATE TABLE "pga_layout" (
	"tablename" character varying(64),
	"nrcols" smallint,
	"colnames" text,
	"colwidth" text
);

REVOKE ALL on "pga_layout" from PUBLIC;
GRANT ALL on "pga_layout" to PUBLIC;
GRANT ALL on "pga_layout" to "nobody";

CREATE TABLE "tb_instructor" (
	"instr_id" integer DEFAULT nextval('tb_instructor_instr_id_seq'::text) NOT NULL,
	"instr_username" character varying(25) NOT NULL,
	"instr_password" character varying(20) NOT NULL,
	"instr_lastname" character varying(50) NOT NULL,
	"instr_firstname" character varying(50) NOT NULL,
	"instr_emailaddress" character varying(255),
	"instr_collegeid" character varying(20),
	"instr_lastlogin" timestamp with time zone DEFAULT now() NOT NULL,
	Constraint "tb_instructor_pkey" Primary Key ("instr_id")
);

CREATE TABLE "tb_courseinstructors" (
	"ci_id" integer DEFAULT nextval('tb_courseinstructors_ci_id_seq'::text) NOT NULL,
	"ci_courseid" integer NOT NULL,
	"ci_instructorid" integer NOT NULL,
	Constraint "tb_courseinstructors_pkey" Primary Key ("ci_id")
);

CREATE TABLE "tb_administrator" (
	"admin_id" integer DEFAULT nextval('tb_administrator_admin_id_seq'::text) NOT NULL,
	"admin_username" character varying(25) NOT NULL,
	"admin_password" character varying(20) NOT NULL,
	"admin_emailaddress" character varying(255),
	"admin_lastname" character varying(35),
	"admin_firstname" character varying(30),
	Constraint "tb_administrator_pkey" Primary Key ("admin_id")
);

CREATE TABLE "tb_waitingcourseusers" (
	"wcu_id" integer DEFAULT nextval('tb_waitingcourseuser_wcu_id_seq'::text) NOT NULL,
	"wcu_courseid" integer NOT NULL,
	"wcu_userid" integer NOT NULL,
	Constraint "tb_waitingcourseusers_pkey" Primary Key ("wcu_id")
);

CREATE TABLE "tb_waitingcourseinstructors" (
	"wci_id" integer DEFAULT nextval('tb_waitingcourseinst_wci_id_seq'::text) NOT NULL,
	"wci_courseid" integer NOT NULL,
	"wci_instructorid" integer NOT NULL,
	Constraint "tb_waitingcourseinstructor_pkey" Primary Key ("wci_id")
);

CREATE TABLE "tb_movieactivity" (
	"mov_id" integer DEFAULT nextval('tb_movieactivity_mov_id_seq'::text) NOT NULL,
	"mov_title" text NOT NULL,
	"mov_date" date DEFAULT 'Now()' NOT NULL,
	"mov_time" time DEFAULT 'Now()' NOT NULL,
	"mov_location" text NOT NULL,
	"mov_owner_name" text NOT NULL,
	"mov_operator_name" text NOT NULL,
	"mov_operator_address" text,
	"mov_operator_phone" text,
	"mov_view_type" text NOT NULL,
	"mov_paid" boolean,
	Constraint "tb_movieactivity_pkey" Primary Key ("mov_id")
);

CREATE TABLE "movie" (
	"port" smallint NOT NULL,
	"channel" smallint NOT NULL,
	"type" character varying(80) NOT NULL,
	"title" character varying(80) NOT NULL,
	"actor" character varying(80),
	"release" date,
	"rating" character varying(8),
	"price" real,
	"length" bigint NOT NULL,
	"path" character varying(256) NOT NULL,
	"date" date,
	"showstart" timestamp with time zone NOT NULL,
	"showend" timestamp with time zone NOT NULL
);

CREATE SEQUENCE "user_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

CREATE TABLE "media_user" (
	"user_id" bigint DEFAULT nextval('user_id_seq'::text) NOT NULL,
	"username" character varying(20) NOT NULL,
	"password" character varying(20) NOT NULL,
	"name" character varying(160) NOT NULL,
	"first" character varying(80) NOT NULL,
	"last" character varying(80) NOT NULL,
	"email" character varying(256)
);


CREATE CONSTRAINT TRIGGER "wci_cid_course_id_fk" AFTER DELETE ON "tb_course"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_del" ('wci_cid_course_id_fk', 'tb_waitingcourseinstructors', 'tb_course', 'UNSPECIFIED', 'wci_courseid', 'course_id');
CREATE CONSTRAINT TRIGGER "wci_cid_course_id_fk" AFTER UPDATE ON "tb_course"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('wci_cid_course_id_fk', 'tb_waitingcourseinstructors', 'tb_course', 'UNSPECIFIED', 'wci_courseid', 'course_id');
CREATE CONSTRAINT TRIGGER "course_fk" AFTER DELETE ON "tb_course"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_del" ('course_fk', 'tb_courseusers', 'tb_course', 'UNSPECIFIED', 'cu_courseid', 'course_id');
CREATE CONSTRAINT TRIGGER "course_fk" AFTER UPDATE ON "tb_course"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('course_fk', 'tb_courseusers', 'tb_course', 'UNSPECIFIED', 'cu_courseid', 'course_id');
CREATE CONSTRAINT TRIGGER "course_fk" AFTER DELETE ON "tb_course"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_del" ('course_fk', 'tb_coursesmedia', 'tb_course', 'UNSPECIFIED', 'cm_courseid', 'course_id');
CREATE CONSTRAINT TRIGGER "course_fk" AFTER UPDATE ON "tb_course"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('course_fk', 'tb_coursesmedia', 'tb_course', 'UNSPECIFIED', 'cm_courseid', 'course_id');
CREATE CONSTRAINT TRIGGER "wcu_course_fk" AFTER DELETE ON "tb_course"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_del" ('wcu_course_fk', 'tb_waitingcourseusers', 'tb_course', 'UNSPECIFIED', 'wcu_courseid', 'course_id');
CREATE CONSTRAINT TRIGGER "wcu_course_fk" AFTER UPDATE ON "tb_course"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('wcu_course_fk', 'tb_waitingcourseusers', 'tb_course', 'UNSPECIFIED', 'wcu_courseid', 'course_id');
CREATE CONSTRAINT TRIGGER "ci_cid_fk" AFTER DELETE ON "tb_course"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_del" ('ci_cid_fk', 'tb_courseinstructors', 'tb_course', 'UNSPECIFIED', 'ci_courseid', 'course_id');
CREATE CONSTRAINT TRIGGER "ci_cid_fk" AFTER UPDATE ON "tb_course"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('ci_cid_fk', 'tb_courseinstructors', 'tb_course', 'UNSPECIFIED', 'ci_courseid', 'course_id');
CREATE CONSTRAINT TRIGGER "wcu_cid_courseid_fk" AFTER DELETE ON "tb_course"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_del" ('wcu_cid_courseid_fk', 'tb_waitingcourseusers', 'tb_course', 'UNSPECIFIED', 'wcu_courseid', 'course_id');
CREATE CONSTRAINT TRIGGER "wcu_cid_courseid_fk" AFTER UPDATE ON "tb_course"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('wcu_cid_courseid_fk', 'tb_waitingcourseusers', 'tb_course', 'UNSPECIFIED', 'wcu_courseid', 'course_id');
CREATE CONSTRAINT TRIGGER "course_fk" AFTER INSERT OR UPDATE ON "tb_courseusers"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('course_fk', 'tb_courseusers', 'tb_course', 'UNSPECIFIED', 'cu_courseid', 'course_id');
CREATE CONSTRAINT TRIGGER "cu_uid_std_id_fk" AFTER INSERT OR UPDATE ON "tb_courseusers"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('cu_uid_std_id_fk', 'tb_courseusers', 'tb_student', 'UNSPECIFIED', 'cu_userid', 'student_id');
CREATE CONSTRAINT TRIGGER "course_fk" AFTER DELETE ON "tb_media"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_del" ('course_fk', 'tb_coursesmedia', 'tb_media', 'UNSPECIFIED', 'cm_mediaid', 'media_id');
CREATE CONSTRAINT TRIGGER "course_fk" AFTER UPDATE ON "tb_media"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('course_fk', 'tb_coursesmedia', 'tb_media', 'UNSPECIFIED', 'cm_mediaid', 'media_id');
CREATE CONSTRAINT TRIGGER "course_fk" AFTER INSERT OR UPDATE ON "tb_coursesmedia"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('course_fk', 'tb_coursesmedia', 'tb_course', 'UNSPECIFIED', 'cm_courseid', 'course_id');
CREATE CONSTRAINT TRIGGER "course_fk" AFTER INSERT OR UPDATE ON "tb_coursesmedia"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('course_fk', 'tb_coursesmedia', 'tb_media', 'UNSPECIFIED', 'cm_mediaid', 'media_id');
CREATE CONSTRAINT TRIGGER "wcu_uid_std_id_fk" AFTER DELETE ON "tb_student"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_del" ('wcu_uid_std_id_fk', 'tb_waitingcourseusers', 'tb_student', 'UNSPECIFIED', 'wcu_userid', 'student_id');
CREATE CONSTRAINT TRIGGER "wcu_uid_std_id_fk" AFTER UPDATE ON "tb_student"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('wcu_uid_std_id_fk', 'tb_waitingcourseusers', 'tb_student', 'UNSPECIFIED', 'wcu_userid', 'student_id');
CREATE CONSTRAINT TRIGGER "cu_uid_std_id_fk" AFTER DELETE ON "tb_student"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_del" ('cu_uid_std_id_fk', 'tb_courseusers', 'tb_student', 'UNSPECIFIED', 'cu_userid', 'student_id');
CREATE CONSTRAINT TRIGGER "cu_uid_std_id_fk" AFTER UPDATE ON "tb_student"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('cu_uid_std_id_fk', 'tb_courseusers', 'tb_student', 'UNSPECIFIED', 'cu_userid', 'student_id');
CREATE CONSTRAINT TRIGGER "wci_iid_instr_id_fk" AFTER DELETE ON "tb_instructor"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_del" ('wci_iid_instr_id_fk', 'tb_waitingcourseinstructors', 'tb_instructor', 'UNSPECIFIED', 'wci_instructorid', 'instr_id');
CREATE CONSTRAINT TRIGGER "wci_iid_instr_id_fk" AFTER UPDATE ON "tb_instructor"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('wci_iid_instr_id_fk', 'tb_waitingcourseinstructors', 'tb_instructor', 'UNSPECIFIED', 'wci_instructorid', 'instr_id');
CREATE CONSTRAINT TRIGGER "ci_instr_id_fk" AFTER DELETE ON "tb_instructor"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_del" ('ci_instr_id_fk', 'tb_courseinstructors', 'tb_instructor', 'UNSPECIFIED', 'ci_instructorid', 'instr_id');
CREATE CONSTRAINT TRIGGER "ci_instr_id_fk" AFTER UPDATE ON "tb_instructor"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('ci_instr_id_fk', 'tb_courseinstructors', 'tb_instructor', 'UNSPECIFIED', 'ci_instructorid', 'instr_id');
CREATE CONSTRAINT TRIGGER "ci_cid_fk" AFTER INSERT OR UPDATE ON "tb_courseinstructors"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('ci_cid_fk', 'tb_courseinstructors', 'tb_course', 'UNSPECIFIED', 'ci_courseid', 'course_id');
CREATE CONSTRAINT TRIGGER "ci_instr_id_fk" AFTER INSERT OR UPDATE ON "tb_courseinstructors"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('ci_instr_id_fk', 'tb_courseinstructors', 'tb_instructor', 'UNSPECIFIED', 'ci_instructorid', 'instr_id');
CREATE CONSTRAINT TRIGGER "wcu_uid_std_id_fk" AFTER INSERT OR UPDATE ON "tb_waitingcourseusers"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('wcu_uid_std_id_fk', 'tb_waitingcourseusers', 'tb_student', 'UNSPECIFIED', 'wcu_userid', 'student_id');
CREATE CONSTRAINT TRIGGER "wcu_cid_courseid_fk" AFTER INSERT OR UPDATE ON "tb_waitingcourseusers"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('wcu_cid_courseid_fk', 'tb_waitingcourseusers', 'tb_course', 'UNSPECIFIED', 'wcu_courseid', 'course_id');
CREATE CONSTRAINT TRIGGER "wci_cid_course_id_fk" AFTER INSERT OR UPDATE ON "tb_waitingcourseinstructors"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('wci_cid_course_id_fk', 'tb_waitingcourseinstructors', 'tb_course', 'UNSPECIFIED', 'wci_courseid', 'course_id');
CREATE CONSTRAINT TRIGGER "wci_iid_instr_id_fk" AFTER INSERT OR UPDATE ON "tb_waitingcourseinstructors"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('wci_iid_instr_id_fk', 'tb_waitingcourseinstructors', 'tb_instructor', 'UNSPECIFIED', 'wci_instructorid', 'instr_id');