CREATE TABLE ec_customer_service_actions ( action_id integer PRIMARY KEY NOT NULL, issue_id integer NOT NULL, interaction_id integer NOT NULL, action_details varchar(4000), follow_up_required varchar(4000), CONSTRAINT ec_customer_service_action_pkey REFERENCES ec_customer_serv_interactions (), CONSTRAINT ec_customer_service_actions_interaction_id_fkey REFERENCES ec_customer_serv_interactions (), CONSTRAINT ec_customer_service_actions_issue_id_fkey REFERENCES ec_customer_serv_interactions (), CONSTRAINT ec_customer_service_actions_issue_id_fkey REFERENCES ec_customer_service_issues (), CONSTRAINT ec_customer_service_action_pkey REFERENCES ec_customer_service_issues (), CONSTRAINT ec_customer_service_actions_interaction_id_fkey REFERENCES ec_customer_service_issues () ); CREATE INDEX ec_csa_by_issue ON ec_customer_service_actions (issue_id); CREATE TRIGGER RI_ConstraintTrigger_a_341777 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341778 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341814 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341815 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341819 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341820 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to ec_customer_service_actions: --ec_cs_action_info_used_map(ec_customer_service_action_pkey) --ec_cs_action_info_used_map(ec_customer_service_actions_interaction_id_fkey) --ec_cs_action_info_used_map(ec_customer_service_actions_issue_id_fkey) -- Table size: 0 bytes -- Table rows: 0
Begin main content
