community

Tables (3)

board

  • board_id — long — Primary key — NOT NULL
  • userid — string — Foreign key → user_info.userid — NOT NULL
  • title — string — default "임시제목"
  • content — string(2000) — NOT NULL — default "임시내용"
  • create_date — timestamp — default now()
  • Like — int — NOT NULL
  • hit — int — NOT NULL

reply

  • reply_id — long — Primary key — NOT NULL
  • board_id — long — Foreign key → board.board_id — NOT NULL
  • userid (userid2) — string — Foreign key → user_info.userid — NOT NULL
  • reply_content — string(500) — NOT NULL
  • reply_create_date — timestamp
  • like — int

user_info

  • userid — string — Primary key — NOT NULL
  • password — string — NOT NULL
  • email — string — NOT NULL
  • nick_name — string — NOT NULL