2111
Tables (30)
address
- addr_num — int — Primary key — NOT NULL
- user_num — int — Foreign key → users.user_num — NOT NULL
- address — varchar(256) — NOT NULL
- detail_address — varchar(256) — NOT NULL
- postal_num — varchar(20) — NOT NULL
- request — varchar(256)
- base — tinyint(1) — NOT NULL
- recipient — varchar(10) — NOT NULL
- phone_num — varchar(20) — NOT NULL
auth_id
- id_num — int — Primary key — NOT NULL
- user_num — int — Foreign key → users.user_num — NOT NULL
- id — varchar(20) — NOT NULL
- pwd — varchar(20) — NOT NULL
- user_email — varchar(50) — NOT NULL
auto_kakao
- kakao_num — int — Primary key — NOT NULL
- user_num — int — Foreign key → users.user_num — NOT NULL
- kakao_email — varchar(64) — NOT NULL
- refresh_token — varchar(128) — NOT NULL
board
- pno — int — Primary key — NOT NULL
- user_num — int — Foreign key → users.user_num — NOT NULL
- ctgr_num — int — Foreign key → codi_ctgr.ctgr_num
- title — varchar(50)
- cate — varchar(50) — NOT NULL
- posttime — date — NOT NULL
- content — varchar(50)
board_product_num
- bpno — int — Primary key — NOT NULL
- pno — int — Foreign key → board.pno
- product_num — int — Foreign key → product.product_num
cart
- cart_num — int — Primary key — NOT NULL
- user_num — int — Foreign key → users.user_num — NOT NULL
- product_code — int — Foreign key → product_code.product_code — NOT NULL
- amount — int — NOT NULL
category
- category_num — int — Primary key — NOT NULL
- category_name — varchar(20)
codi_ctgr
- ctgr_num — int — Primary key — NOT NULL
- ctgr_name — varchar(50)
delivery
- delivery_num — int — Primary key — NOT NULL
- order_num — int — Foreign key → orders.order_num — NOT NULL
- delivery_date — date
- delivery_company — varchar(20) — NOT NULL
- invoice_num — int — NOT NULL
faq
- faq_num — int — Primary key — NOT NULL
- sub_ctgr_num — int — Foreign key → faq_sub_ctgr.sub_ctgr_num — NOT NULL
- question — varchar(50)
- answer — text
faq_ctgr
- ctgr_num — int — Primary key — NOT NULL
- ctgr_name — varchar(10)
faq_sub_ctgr
- sub_ctgr_num — int — Primary key — NOT NULL
- ctgr_num — int — Foreign key → faq_ctgr.ctgr_num — NOT NULL
- sub_ctgr_name — varchar(10)
file
- fno — int — Primary key — NOT NULL
- pno — int — Foreign key → board.pno — NOT NULL
- fname — varchar(50)
inquiry
- inquiry_num — int — Primary key — NOT NULL
- user_num — int — Foreign key → users.user_num — NOT NULL
- product_num — int — Foreign key → product.product_num — NOT NULL
- inquiry_date — timestamp
- inquiry_title — text — NOT NULL
- inquiry_content — text — NOT NULL
inquiry_answer
- answer_num — int — Primary key — NOT NULL
- inquiry_num — int — Foreign key → inquiry.inquiry_num — NOT NULL
- answer — varchar(100)
- answer_date — datetime
order_detail
- order_detail_num — int — Primary key — NOT NULL
- order_num — int — Foreign key → orders.order_num — NOT NULL
- product_code — int — Foreign key → product_code.product_code — NOT NULL
- product_state — varchar(20) — NOT NULL
- amount — int
- total_price — int — NOT NULL
orders
- order_num — int — Primary key — NOT NULL
- user_num — int — Foreign key → users.user_num — NOT NULL
- order_date — datetime — NOT NULL
- address — varchar(256) — NOT NULL
- detail_address — varchar(256) — NOT NULL
- postal_num — varchar(20) — NOT NULL
- delivery_price — int — NOT NULL
- recipient — varchar(10)
- request — varchar(256)
- payment — varchar(20) — NOT NULL
- phone_num — varchar(20)
- order_type — tinyint — NOT NULL — 0: 기본 배송, 1: 교환
- points — int
- totalPrice — int — NOT NULL
point
- point_num — int — Primary key — NOT NULL
- user_num — int — Foreign key → users.user_num — NOT NULL
- order_detail_num — int — Foreign key → order_detail.order_detail_num — NOT NULL
- points — int
- point_type — tinyint — NOT NULL — 0:적립, 1:사용, 2: 취소/환불로 인한 환수
product
- product_num — int — Primary key — NOT NULL
- sub_category_num — int — Foreign key → sub_category.sub_category_num — NOT NULL
- product_name — varchar(30) — NOT NULL
- product_info — varchar(100) — NOT NULL
- product_date — date — NOT NULL
- product_sell — int — NOT NULL
- product_price — int — NOT NULL
- modify_date — date
- delete_date — date
- registration_status — tinyint — NOT NULL
product_code
- product_code — int — Primary key — NOT NULL
- size_num — int — Foreign key → product_size.size_num — NOT NULL
product_color
- color_num — int — Primary key — NOT NULL
- product_num — int — Foreign key → product.product_num — NOT NULL
- color_name — varchar(10)
product_img
- img_num — int — Primary key — NOT NULL
- product_num — int — Foreign key → product.product_num — NOT NULL
- img_name — varchar(64)
- img_type — tinyint — NOT NULL — 0: 메인, 1: 서브, 2: 썸네일
product_refund_or_change
- refund_change_num — int — Primary key — NOT NULL
- order_detail_num — int — Foreign key → order_detail.order_detail_num — NOT NULL
- request_date — datetime — NOT NULL
- refund_or_change_reason — varchar(10) — NOT NULL
- reason_detail — varchar(300) — NOT NULL
- refund_change_amount — int
- bank — varchar(30)
- account_num — varchar(30)
- cancel — tinyint
- change — tinyint
- response_detail — varchar(300)
- approve — tinyint
product_size
- size_num — int — Primary key — NOT NULL
- color_num — int — Foreign key → product_color.color_num — NOT NULL
- size_name — varchar(20)
- product_stock — int
reply
- rno — int — Primary key — NOT NULL
- pno — int — Foreign key → board.pno — NOT NULL
- user_num — int — Foreign key → users.user_num — NOT NULL
- rcontent — varchar(256)
review
- review_num — int — Primary key — NOT NULL
- user_num — int — Foreign key → users.user_num — NOT NULL
- product_code — int — Foreign key → product_code.product_code — NOT NULL
- review_content — varchar(100)
- review_ratings — int
- review_date — date — NOT NULL
review_img
- review_img_num — int — Primary key — NOT NULL
- review_num — int — Foreign key → review.review_num — NOT NULL
- review_img — varchar(100)
sub_category
- sub_category_num — int — Primary key — NOT NULL
- category_num — int — Foreign key → category.category_num — NOT NULL
- sub_category_name — varchar(20)
user_info
- user_info_num — int — Primary key — NOT NULL
- user_num — int — Foreign key → users.user_num — NOT NULL
- user_phone — varchar(20)
- user_rank — varchar(10)
- user_join_date — datetime
- user_update_date — datetime
- user_delete_date — datetime
- is_black_list — tinyint
users
- user_num — int — Primary key — NOT NULL
- user_name — varchar(20) — NOT NULL
- login_type — varchar(10) — NOT NULL
- is_admin — tinyint