CREATE TABLE ec_user_identification ( user_identification_id integer PRIMARY KEY NOT NULL, date_added timestamptz, user_id integer, email varchar(100), first_names varchar(100), last_name varchar(100), postal_code varchar(80), other_id_info varchar(2000), CONSTRAINT ec_user_identification_pkey REFERENCES users (), CONSTRAINT ec_user_identification_user_id_fkey REFERENCES users () ); CREATE INDEX ec_user_ident_by_email ON ec_user_identification (email); CREATE INDEX ec_user_ident_by_first_names ON ec_user_identification (first_names); CREATE INDEX ec_user_ident_by_last_name ON ec_user_identification (last_name); CREATE INDEX ec_user_ident_by_postal_code ON ec_user_identification (postal_code); CREATE INDEX ec_user_ident_by_user_id ON ec_user_identification (user_id); CREATE TRIGGER ec_user_identificate_date_tr AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE ec_user_identificate_date_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341712 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341713 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341807 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341808 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341837 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341838 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342319 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342320 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to ec_user_identification: --ec_automatic_email_log(ec_user_identification_pkey) --ec_automatic_email_log(ec_user_identification_user_id_fkey) --ec_customer_serv_interactions(ec_user_identification_pkey) --ec_customer_serv_interactions(ec_user_identification_user_id_fkey) --ec_customer_service_issues(ec_user_identification_pkey) --ec_customer_service_issues(ec_user_identification_user_id_fkey) -- Table size: 0 bytes -- Table rows: 0
Begin main content
