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