CREATE TABLE ec_creditcards ( creditcard_id integer PRIMARY KEY NOT NULL, user_id integer NOT NULL, creditcard_type char(1), creditcard_number varchar(16), creditcard_last_four char(4), creditcard_expire char(5), billing_address integer, failed_p bool DEFAULT false, CONSTRAINT ec_creditcards_billing_address_fkey REFERENCES ec_addresses (), CONSTRAINT ec_creditcards_pkey REFERENCES ec_addresses (), CONSTRAINT ec_creditcards_user_id_fkey REFERENCES ec_addresses (), CONSTRAINT ec_creditcards_user_id_fkey REFERENCES users (), CONSTRAINT ec_creditcards_billing_address_fkey REFERENCES users (), CONSTRAINT ec_creditcards_pkey REFERENCES users () ); CREATE INDEX ec_creditcards_by_user_idx ON ec_creditcards (user_id); CREATE TRIGGER RI_ConstraintTrigger_c_341769 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341770 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341774 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341775 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341847 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341848 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341952 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341953 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to ec_creditcards: --ec_financial_transactions(ec_creditcards_billing_address_fkey) --ec_financial_transactions(ec_creditcards_pkey) --ec_financial_transactions(ec_creditcards_user_id_fkey) --ec_orders(ec_creditcards_billing_address_fkey) --ec_orders(ec_creditcards_pkey) --ec_orders(ec_creditcards_user_id_fkey) -- Table size: 0 bytes -- Table rows: 0
Begin main content
