on-01
Tables (9)
Cart (Untitled8)
- cart_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.user_id — NOT NULL
- product_id (Key3) — Foreign key → Product.product_id — NOT NULL
Category (Untitled3)
- category_id (Key) — Primary key — NOT NULL
- cname (Field)
Chat (Untitled4)
- chat_id (Key) — Primary key — NOT NULL
- message (Field2)
- user_id (Key2) — Foreign key → User.user_id — NOT NULL
Comment (Untitled7)
- comment_id (Key) — Primary key — NOT NULL
- Field
- Field2
- Field3
Notice (Untitled5)
- notice_id (Key) — Primary key — NOT NULL
- topic (Field)
- content (Field2)
Order (Untitled2)
- order_id (Key) — Primary key — NOT NULL
- order_date (Field2)
- total_price (Field3)
- progress (Field)
- user_id (Key2) — Foreign key → User.user_id — NOT NULL
Orderdetail (Untitled6)
- order_detail_id (Key) — Primary key — NOT NULL
- order_id (Key2) — Foreign key → Order.order_id — NOT NULL
- product_id (Key3) — Foreign key → Product.product_id — NOT NULL
Product (Untitled)
- product_id (Key) — Primary key — NOT NULL
- pname (Field)
- pdescription (Field2)
- pdiscount (Field3)
- pprice (Field4)
- pcategory (Field5)
- powner (Field6)
- pcomment (Field7)
- category_id (Key2) — Foreign key → Category.category_id — NOT NULL
User (회원정보)
- user_id (Key) — Primary key — NOT NULL
- username (Field)
- password (Field2)
- address (Field3)
- number (Field4)
- email (Field5)
- usertype (Field6)
- create_date (Field7)
- notice_id (Key2) — Foreign key → Notice.notice_id — NOT NULL