Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Table "public.shop_orderitem"
- Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description
- ----------+---------+-----------+----------+----------------------------------------+---------+-------------+--------------+-------------
- id | bigint | | not null | nextval('order_item_id_seq'::regclass) | plain | | |
- quantity | integer | | not null | | plain | | |
- item_id | bigint | | not null | | plain | | |
- order_id | bigint | | not null | | plain | | |
- Indexes:
- "order_item_pkey" PRIMARY KEY, btree (id)
- "order_item_item_id_00cc36f1" btree (item_id)
- "order_item_item_id_order_id_f5021ee0_uniq" UNIQUE CONSTRAINT, btree (item_id, order_id)
- "order_item_order_id_0ca9e92e" btree (order_id)
- Foreign-key constraints:
- "order_item_item_id_00cc36f1_fk_item_id" FOREIGN KEY (item_id) REFERENCES shop_item(id) DEFERRABLE INITIALLY DEFERRED
- "order_item_order_id_0ca9e92e_fk_order_id" FOREIGN KEY (order_id) REFERENCES shop_order(id) DEFERRABLE INITIALLY DEFERRED
- Access method: heap
Advertisement
Add Comment
Please, Sign In to add comment