projectex01

Tables (7)

board (Untitled2)

  • board_id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → member.member_id — NOT NULL
  • reg_date (Field)
  • title (Field2)
  • board_content (Field3)

comment (CopyOfUntitled3)

  • member_id (Key) — Foreign key → member.member_id — NOT NULL
  • content (Field)
  • reg_date (Field2)

member (Untitled)

  • member_id (Key) — Primary key — NOT NULL
  • product_id (Key2) — Foreign key → product.product_id — NOT NULL
  • pw (Field)
  • nick (Field2)
  • email (Field3)
  • phonenumber (Field4)
  • sms_agree (Field5)
  • email_agree (Field6)
  • profile_img (Field7)
  • member_level (Field8)
  • join_date (Field9)

notice (CopyOfUntitled2)

  • notice_id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → member.member_id — NOT NULL
  • reg_date (Field)
  • title (Field2)
  • notice_content (Field3)

product (CopyOfUntitled)

  • product_id (Key) — Primary key — NOT NULL
  • member_id (FK)
  • product_img1 (Field)
  • product_img2 (Field2)
  • product_img3 (Field3)
  • address (Field4)
  • product_content (Field5)
  • host_email (Field6)
  • host_number (Field7)

reservation (Untitled3)

  • reservation_id (Key) — Primary key — NOT NULL
  • product_id (Key2) — Foreign key → product.product_id — NOT NULL
  • member_id (FK)
  • product_id (FK2)
  • booking_date (Field3)

review (CopyOfUntitled22)

  • review_id (Key) — Primary key — NOT NULL
  • product_id (Key2) — Foreign key → product.product_id — NOT NULL
  • member_id (Key3) — Foreign key → member.member_id — NOT NULL
  • review_star (Field2)
  • reg_date (Field3)
  • content (Field4)