go-personal

Tables (3)

board (게시판)

  • board_id (게시판 ID) — NOT NULL — Primary key — NOT NULL
  • board_title (게시판 제목) — NOT NULL
  • board_content (게시판 내용) — NOT NULL
  • created_at (작성시각) — NOT NULL
  • updated_at (수정시각) — NOT NULL
  • deleted_at (삭제시각) — NOT NULL
  • user_id (유저 id) — NOT NULL — Foreign key → user.user_id — NOT NULL

reply (댓글)

  • reply_id (댓글 id) — NOT NULL — Primary key — NOT NULL
  • reply_content (댓글 내용) — NOT NULL
  • board_id (게시판 ID) — NOT NULL — Foreign key → board.board_id — NOT NULL
  • user_id (유저 id) — NOT NULL — Foreign key → user.user_id — NOT NULL
  • created_at (작성시각) — NOT NULL
  • updated_at (수정시각) — NOT NULL
  • deleted_at (삭제시각t) — NOT NULL

user (유저)

  • user_id (유저 id) — NOT NULL — Primary key — NOT NULL
  • user_name (유저 이름) — NOT NULL
  • user_email (유저 아이디) — NOT NULL
  • user_password (유저 비밀번호) — NOT NULL
  • created_at (작성시각) — NOT NULL
  • updated_at (수정시각) — NOT NULL
  • deleted_at (삭제시각) — NOT NULL