c2oor-db
Tables (3)
Products (상품정보)
- id — INT — Primary key — NOT NULL
- product_name — VARCHAR(20)
- product_size — VARCHAR(10)
- product_price — INT
- product_img — VARCHAR(300)
- create_At — DATE
- update_At — DATE
Reviews (리뷰)
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → Users.id — NOT NULL
- product_id — INT — Foreign key → Products.id — NOT NULL
- review_text — VARCHAR(200)
- creat_At (create_At) — DATE
- update_At — DATE
Users (회원)
- id — INT — Primary key — NOT NULL
- user_nickname (user_id) — VARCHAR(20)
- user_name — VARCHAR(20)
- user_password — CHAR(16)
- user_email — VARCHAR(50)
- user_phone — INT
- creat_At — DATE
- update_At — DATE