Project

Tables (4)

Copy Of comment (board)

  • Key3 (board_id) — INT — Primary key — NOT NULL
  • comment_content (board_content) — text
  • Field (board_title) — VARCHAR(100)
  • Field (board_score) — DECIMAL(3,1)

comment

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

member

  • Key (member_id) — INT — Primary key — NOT NULL
  • 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_id1 (review_id) — INT — Primary key — NOT NULL
  • Key3 (board_id) — INT — Foreign key → Copy Of comment.Key3 — NOT NULL
  • 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 — NOT NULL