TestTable
Tables (5)
Category (Untitled5)
- category_id (Key) — INT(11) — Primary key — NOT NULL
- category_name (Field) — VARCHAR(50)
Order (Untitled2)
- order_id (Key) — INT(11) — Primary key — NOT NULL
- order_date (Field2) — DATE
- total_price (Field3) — INT(11)
- order_state (Field4) — VARCHAR(20)
- user_id (Key2) — VARCHAR(255) — Foreign key → User.user_id — NOT NULL
OrderDetail (Untitled3)
- orderdetail_id (Key) — INT(11) — Primary key — NOT NULL
- order_id (Key2) — INT(11) — Foreign key → Order.order_id — NOT NULL
- product_id (Key3) — INT(11) — Foreign key → Product.product_id — NOT NULL
- count (Field) — INT(11)
- orderdetail_price (Field2) — INT(11)
Product (Untitled4)
- product_id (Key) — INT(11) — Primary key — NOT NULL
- category_id (Key2) — INT(11) — Foreign key → Category.category_id — NOT NULL
User (Untitled)
- user_id (Key) — VARCHAR(255) — Primary key — NOT NULL
- user_pw (Field) — VARCHAR(255)
- user_name (Field2) — VARCHAR(30)
- user_phone (Field3) — VARCHAR(20)