Project

Tables (4)

board

  • board_id — INT
  • board_title — VARCHAR(100) — NOT NULL
  • board_content — TEXT — NOT NULL

comment

  • comment_id — INT
  • comment_content — VARCHAR(500)
  • comment_date — DATETIME — NOT NULL
  • review_id — INT — Foreign key → review.review_id — NOT NULL
  • member_id — INT — Foreign key → member.member_id — NOT NULL

member

  • member_id — INT
  • member_loginid — VARCHAR(50) — NOT NULL
  • member_nickname — VARCHAR(100) — NOT NULL
  • member_email — VARCHAR(200) — NOT NULL
  • member_pwd — VARCHAR(300) — NOT NULL
  • member_phone — VARCHAR(20)

review

  • review_id — INT
  • review_title — VARCHAR(100) — NOT NULL
  • review_content — TEXT — NOT NULL
  • review_hit — INT — NOT NULL
  • review_date — DATETIME — NOT NULL
  • review_score — INT — NOT NULL
  • member_id — INT — Foreign key → member.member_id — NOT NULL
  • board_id — INT — Foreign key → board.board_id — NOT NULL