Skip to content

Instantly share code, notes, and snippets.

@bjaglin
Last active June 1, 2023 08:31
Show Gist options
  • Save bjaglin/6aade613ae7a069e881ecce8c6053924 to your computer and use it in GitHub Desktop.
Save bjaglin/6aade613ae7a069e881ecce8c6053924 to your computer and use it in GitHub Desktop.
--- pgloader
+++ bootstrapped with Django migrations
@@ -1,20 +1,23 @@
Table "bo_merchant_grouporder"
Column | Type | Collation | Nullable | Default
----------------------+--------------------------+-----------+----------+----------------------------------------------------
- id | bigint | | not null | nextval('bo_merchant_grouporder_id_seq'::regclass)
- payment_id | bigint | | |
- garbage | bigint | | not null |
+ id | integer | | not null | nextval('bo_merchant_grouporder_id_seq'::regclass)
+ payment_id | integer | | |
+ garbage | integer | | not null |
date_creation | timestamp with time zone | | not null |
trust_pack_bill | character varying(100) | | |
country_code | character varying(5) | | not null |
backlabel_bill | character varying(100) | | |
sale_certificate_pdf | character varying(100) | | not null |
Indexes:
- "idx_48672_primary" PRIMARY KEY, btree (id)
- "idx_48672_bo_merchant_grouporder_1b9cfef5" btree (country_code)
- "idx_48672_bo_merchant_grouporder_9f377aa4" btree (payment_id)
+ "bo_merchant_grouporder_pkey" PRIMARY KEY, btree (id)
+ "bo_merchant_grouporder_country_code_73003cc7" btree (country_code)
+ "bo_merchant_grouporder_country_code_73003cc7_like" btree (country_code varchar_pattern_ops)
+ "bo_merchant_grouporder_payment_id_a2f2701b" btree (payment_id)
+Foreign-key constraints:
+ "bo_merchant_groupord_payment_id_a2f2701b_fk_bo_mercha" FOREIGN KEY (payment_id) REFERENCES bo_merchant_payment(id) DEFERRABLE INITIALLY DEFERRED
Referenced by:
- TABLE "bo_merchant_sourcing_order" CONSTRAINT "bo_merchant_sourcing_group_order_id_ad500a17_fk_bo_mercha" FOREIGN KEY (group_order_id) REFERENCES bo_merchant_grouporder(id) ON UPDATE RESTRICT ON DELETE RESTRICT
- TABLE "bo_merchant_order" CONSTRAINT "group_order_id_refs_id_debaf860" FOREIGN KEY (group_order_id) REFERENCES bo_merchant_grouporder(id) ON UPDATE RESTRICT ON DELETE RESTRICT
- TABLE "payment_addonservice" CONSTRAINT "payment_addonservice_group_order_id_e79eaab9_fk_bo_mercha" FOREIGN KEY (group_order_id) REFERENCES bo_merchant_grouporder(id) ON UPDATE RESTRICT ON DELETE RESTRICT
+ TABLE "bo_merchant_sourcing_order" CONSTRAINT "bo_merchant_sourcing_group_order_id_ad500a17_fk_bo_mercha" FOREIGN KEY (group_order_id) REFERENCES bo_merchant_grouporder(id) DEFERRABLE INITIALLY DEFERRED
+ TABLE "bo_merchant_order" CONSTRAINT "bo_merchant_order_group_order_id_d5e7a273_fk_bo_mercha" FOREIGN KEY (group_order_id) REFERENCES bo_merchant_grouporder(id) DEFERRABLE INITIALLY DEFERRED
+ TABLE "payment_addonservice" CONSTRAINT "payment_addonservice_group_order_id_e79eaab9_fk_bo_mercha" FOREIGN KEY (group_order_id) REFERENCES bo_merchant_grouporder(id) DEFERRABLE INITIALLY DEFERRED
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment