-- -- Need to handle titles like Mr., Ms., Mrs., Dr., etc. and suffixes -- like M.D., Ph.D., Jr., Sr., III, IV, etc. -- CREATE TABLE persons ( person_id integer PRIMARY KEY NOT NULL, first_names varchar(100) NOT NULL, last_name varchar(100) NOT NULL, bio text(-5), CONSTRAINT persons_person_id_fk REFERENCES parties (), CONSTRAINT persons_pk REFERENCES parties () ); CREATE TRIGGER RI_ConstraintTrigger_a_340742 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340743 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342809 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342810 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343062 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343063 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to persons: --acs_reference_repositories(persons_person_id_fk) --acs_reference_repositories(persons_pk) --users(persons_person_id_fk) --users(persons_pk) -- Table size: 1,155,072 bytes -- Table rows: 22,081
Begin main content
