prac

Tables (3)

board (Untitled)

  • board (id) — BIGINT(32) — Primary key — NOT NULL
  • 게시판명 (board) — VARCHAR(50) — NOT NULL

post (Untitled2)

  • Key (id) — BIGINT(32) — Primary key — NOT NULL
  • 유저명 (user_name) — VARCHAR(50) — NOT NULL
  • 비밀번호 (password) — VARCHAR(4) — NOT NULL
  • 이메일 (emial) — VARCHAR(100) — NOT NULL
  • 상태 (status) — VARCHAR(50) — NOT NULL
  • 제목 (title) — VARCHAR(100) — NOT NULL
  • 내용 (content) — TEXT
  • 작성일자 (posted_at) — DATETIME — NOT NULL
  • board (id2) — BIGINT(32) — Foreign key → board.board — NOT NULL

reply (Untitled3)

  • id — BIGINT(32) — Primary key — NOT NULL
  • 유저명 (user_name) — VARCHAR(50) — NOT NULL
  • 비밀번호 (password) — VARCHAR(4) — NOT NULL
  • Key (post_id) — BIGINT(32) — Foreign key → post.Key — NOT NULL
  • status (statue) — VARCHAR(50) — NOT NULL
  • 제목 (title) — VARCHAR(100) — NOT NULL
  • 내용 (content) — TEXT — NOT NULL
  • 답변일시 (replied_at) — DATETIME — NOT NULL