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