hanbitMart

테이블 (5)

게시글

  • Key (post_num) — 기본 키 — NOT NULL
  • Field (post_name)
  • Field (post_content)
  • Field (post_date)
  • Key (user_id) — 외래 키 → 회원.Key — NOT NULL

상품

  • Key (product_id) — 기본 키 — NOT NULL
  • Field (product_name)
  • Field (product_quantity)
  • Field (product_price)
  • Key (mnfc_name) — 외래 키 → 제조업체.Key — NOT NULL
  • Field (mnfc_quantity)
  • Field (mnfc_date)

제조업체

  • Key (mnfc_name) — 기본 키 — NOT NULL
  • Field (mnfc_num)
  • Field (mnfc_location)
  • Field (mnfc_manager)

주문

  • Field (order_num)
  • Field (order_quantity)
  • Field (order_address)
  • Field (order_date)
  • Key (user_id) — 외래 키 → 회원.Key — NOT NULL
  • Key (product_id) — 외래 키 → 상품.Key — NOT NULL

회원

  • Key (user_id) — 기본 키 — NOT NULL
  • Field (user_pw)
  • Field (user_name)
  • Field (user_age)
  • Field (user_job)
  • Field (user_grade)
  • Field (user_milage)