쇼핑몰
테이블 (4)
Product
- product_id — bigint — 기본 키 — NOT NULL
- product_name — varchar(50) — NOT NULL
- product_price — VARCHAR(255)
- product_description — varchar(200) — NOT NULL
- product_image — varchar(600) — NOT NULL
- product_disply_yn — enum('Y','N') — NOT NULL
- created_at — TIMESTAMP
- modified_at — TIMESTAMP
- pd_category_id — bigint — 외래 키 → Product_category.pd_category_id — NOT NULL
Product_category
- pd_category_id — bigint — 기본 키 — NOT NULL
- pd_category_name — varchar(20) — NOT NULL
- pd_category_parent_id — bigint — 부모의 카테고리 번호. 생략 할지고민중
order
- order_id — bigint — 기본 키 — NOT NULL
- user_id — bigint — NOT NULL
- order_payment_yn — enum — NOT NULL — Y = 결재O , N = 결재 X
- order_cancel_yn — enum — NOT NULL — Y = 주문 O , N = 주문 취소
- order_zipcode — varchar(7) — NOT NULL
- order_address — varchar30) — NOT NULL
- order_address_info — varchar(30) — NOT NULL
- order_phonenumber — int — NOT NULL
- order_requirement — varchar(100)
- created_at — TIMESTAMP
- modified_at — TIMESTAMP
user
- user_id — bigint — 기본 키 — NOT NULL
- user_role — int — NOT NULL — user=0, admin = 1
- user_name — varchar(15) — NOT NULL
- user_nickname — varchar(15)
- user_email — varchar(30)
- user_password — varchar — 비밀번호 타입은 알고리즘에 따라 변경
- user_phonenumber — int — 휴대폰 입력시 - 제외 입력
- created_at — TIMESTAMP
- modified_at — TIMESTAMP