Guest User

\d+ shop_orderitem

a guest
Apr 2nd, 2022
9
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.38 KB | None | 0 0
  1. Table "public.shop_orderitem"
  2. Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description
  3. ----------+---------+-----------+----------+----------------------------------------+---------+-------------+--------------+-------------
  4. id | bigint | | not null | nextval('order_item_id_seq'::regclass) | plain | | |
  5. quantity | integer | | not null | | plain | | |
  6. item_id | bigint | | not null | | plain | | |
  7. order_id | bigint | | not null | | plain | | |
  8. Indexes:
  9. "order_item_pkey" PRIMARY KEY, btree (id)
  10. "order_item_item_id_00cc36f1" btree (item_id)
  11. "order_item_item_id_order_id_f5021ee0_uniq" UNIQUE CONSTRAINT, btree (item_id, order_id)
  12. "order_item_order_id_0ca9e92e" btree (order_id)
  13. Foreign-key constraints:
  14. "order_item_item_id_00cc36f1_fk_item_id" FOREIGN KEY (item_id) REFERENCES shop_item(id) DEFERRABLE INITIALLY DEFERRED
  15. "order_item_order_id_0ca9e92e_fk_order_id" FOREIGN KEY (order_id) REFERENCES shop_order(id) DEFERRABLE INITIALLY DEFERRED
  16. Access method: heap
Advertisement
Add Comment
Please, Sign In to add comment