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')