SHOP
Tables (5)
DELIVERY (Untitled3)
- delivery_id (Key) — bigint — Primary key — NOT NULL
- order_id (Key2) — bigint — Foreign key → ORDERS.order_id — NOT NULL
- user_id (PK) — bigint — Foreign key → ORDERS.user_id — NOT NULL
- status (Field) — varchar
- city (Field2) — varchar
- street (Field3) — varchar
- detail (Field4) — varchar
- order_id (Field5) — bigint
ITEM (Untitled5)
- item_id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar
- price (Field2) — int
- stock_quantity (Field3) — int
- dtype (Field4) — varchar
- artist (Field5) — varchar
- etc (Field6) — varchar
- author (Field7) — varchar
- isbn (Field8) — varchar
- manufacturer (Field9) — varchar
ORDERS (Untitled2)
- order_id (Key) — bigint — Primary key — NOT NULL
- user_id (PK) — bigint — Foreign key → USER.user_id — NOT NULL
- order_date (Field) — datetime
- order_status (Field2) — varchar
- user_id (Field3) — int
- orderItem_id (Field4) — bigint
- delivery_id (Field5) — bigint
ORDER_ITEM (Untitled4)
- order_item_id (Key) — bigint — Primary key — NOT NULL
- order_id (Key2) — bigint — Foreign key → ORDERS.order_id — NOT NULL
- item_id (Key3) — bigint — Foreign key → ITEM.item_id — NOT NULL
- user_id (PK) — bigint — Foreign key → ORDERS.user_id — NOT NULL
- order_id (Field) — bigint
- item_id (Field2) — bigint
- order_price (Field3) — int
- count (Field4) — int
USER (Untitled)
- user_id (PK) — bigint — Primary key — NOT NULL
- name (Field) — varchar
- email (Field2) — varchar
- city (Field3) — varchar
- street (Field4) — varchar
- detail (Field5) — varchar
- order_id (Field6) — varchar