ㅇㅇ

Tables (10)

Board

  • board_num — INT — Primary key — NOT NULL
  • board_title — VARCHAR(255) — NOT NULL
  • board_contants — VARCHAR(255) — NOT NULL
  • board_date — DATE — NOT NULL
  • member_num — INT — Foreign key → Member.member_num — NOT NULL

Delivery

  • Delivery_num — INT — Primary key — NOT NULL
  • Delivery_address — VARCHAR(255) — NOT NULL
  • Delivert_state — INT — NOT NULL

Inquiry

  • inquiry_num — INT — Primary key — NOT NULL — 문의
  • inquiry_title — VARCHAR(255) — NOT NULL
  • inquiry_contant — VARCHAR(255) — NOT NULL
  • inquiry_date — VARCHAR(255) — NOT NULL
  • member_num — INT — Foreign key → Member.member_num — NOT NULL

Inquiry_Comment

  • inqury_comment_num — INT — Primary key — NOT NULL
  • inquiry_num — INT — Foreign key → Inquiry.inquiry_num — NOT NULL
  • inquiry_comment_contants — VARCHAR(255) — NOT NULL

Main_Category

  • main_category_num — INT — Primary key — NOT NULL
  • main_category_name — VARCHAR(255) — NOT NULL

Member

  • member_num — INT — Primary key — NOT NULL
  • member_name — VARCHAR(255) — NOT NULL
  • member_email — VARCHAR(255) — NOT NULL
  • member_id — VARCHAR(255) — NOT NULL
  • member_birthday — DATE — NOT NULL
  • member_gender — VARCHAR(255) — NOT NULL
  • member_password — VARCHAR(255) — NOT NULL
  • member_tel — VARCHAR(255) — NOT NULL
  • state — INT — NOT NULL
  • address — VARCHAR(255) — NOT NULL

Prize

  • prize_num — INT — Primary key — NOT NULL
  • sub_category_num — INT — Foreign key → Sub_Category.sub_category_num — NOT NULL
  • prize_name — VARCHAR(255) — NOT NULL
  • price — INT — NOT NULL
  • prize_comment — VARCHAR(255) — NOT NULL
  • prize_number — INT — NOT NULL

Report

  • report_num — INT — Primary key — NOT NULL
  • board_num — INT — Foreign key → Board.board_num
  • report_time — DATETIME — NOT NULL

Sub_Category

  • sub_category_num — INT — Primary key — NOT NULL
  • sub_category_name — INT — NOT NULL
  • main_category_num — VARCHAR(255) — Foreign key → Main_Category.main_category_num — NOT NULL

prize_image

  • prize_Image_num — INT — Primary key — NOT NULL
  • prize_num — INT — Foreign key → Prize.prize_num — NOT NULL
  • prize_image_url — VARCHAR(255) — NOT NULL
  • prize_sequence — INT — NOT NULL — 상품 이미지 순서