shoes_sell_test

Tables (4)

order_details (주문상세)

  • id (Key) — bigint — Primary key — NOT NULL
  • order_list_id (Key2) — bigint — Foreign key → order_list.id — NOT NULL
  • poduct_id (Key3) — bigint — Foreign key → products.id — NOT NULL
  • quantity (Field) — int — NOT NULL
  • product_price (Field2) — int — NOT NULL

order_list (주문목록)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id
  • ordered_time (Field) — datetime

products (상품)

  • id (Key) — bigint — Primary key — NOT NULL
  • seller_id (Key2) — bigint — Foreign key → user.id
  • name (Field) — varchar(255) — NOT NULL
  • price (Key3) — int — NOT NULL
  • stock (Field2) — int — NOT NULL

user (사용자)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (이름) — varchar(255) — NOT NULL
  • role (역할) — enum('seller','customer')