mart
Tables (6)
category (Untitled2)
- category_id (Key) — INT(11) — Primary key — NOT NULL
- category_name (Field)
order (Untitled4)
- order_id (Key) — INT(11) — Primary key — NOT NULL
- user_id (Key2) — VARCHAR(50) — Foreign key → user.user_id — NOT NULL
- user_id (Field) — VARCHAR(50)
- order_date (Field2) — DATE
- total_price (Field3) — INT(11)
- order_state (Field4)
orderdetail (Untitled3)
- orderdetail_id (Key) — INT(11) — Primary key — NOT NULL
- product_id (Key2) — INT(11) — Foreign key → product.product_id — NOT NULL
- category_id (Key22) — INT(11) — Foreign key → product.category_id — NOT NULL
- order_id (Key3) — INT(11) — Foreign key → order.order_id — NOT NULL
- user_id (Key23) — VARCHAR(50) — Foreign key → order.user_id — NOT NULL
- order_id (Field) — INT(11)
- product_name (Field2) — VARCHAR(45)
- count INT (Field3) — INT(11)
- orderdetail_price (Field4) — INT(11)
product (Untitled)
- product_id (Key) — INT(11) — Primary key — NOT NULL
- category_id (Key2) — INT(11) — Foreign key → category.category_id — NOT NULL
- product_name (Field) — VARCHAR(45)
- product_price (Field2) — INT(11)
- img_path (Field3) — VARCHAR(255)
- category (Field4)
product (Untitled6)
- product_id (Key) — Primary key — NOT NULL
- Field
user (Untitled5)
- user_id (Key) — VARCHAR(50) — Primary key — NOT NULL
- user_pw (Field) — VARCHAR(5)
- user_name (Field2) — VARCHAR(45)
- address (Field3) — VARCHAR(100)
- phone (Field4) — VARCHAR(45)
- tel (Field5)