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