25-1-capstone
Tables (5)
Boards (게시판)
- id (Key) — Primary key — NOT NULL
- type (유형) — tip, culture, question
Bookmarks (북마크 게시판)
- id (Key) — Primary key — NOT NULL
- id (Key2) — Foreign key → Post.id — NOT NULL
- user_id (작성자) — Foreign key → Post.user_id — NOT NULL
- board_id (소속 게시판) — Foreign key → Post.board_id — NOT NULL
- post_id (게시글)
- user_id (사용자)
- saved_at (스크랩 시간) — LocalDateTime.now()
- Field
Comment (댓글)
- id (Key) — Primary key — NOT NULL
- id (Key2) — Foreign key → User.id — NOT NULL
- id (Key3) — Foreign key → Post.id — NOT NULL
- user_id (작성자2) — Foreign key → Post.user_id — NOT NULL
- board_id (소속 게시판) — Foreign key → Post.board_id — NOT NULL
- post_id (게시글)
- user_id (작성자)
- content (내용)
- created_at (작성일) — LocalDateTime.now()
Post (게시글)
- id (Key) — Primary key — NOT NULL
- user_id (작성자) — Foreign key → User.id — NOT NULL
- board_id (소속 게시판) — Foreign key → Boards.id — NOT NULL
- title (제목)
- content (내용)
- created_at (작성일) — LocalDateTime.now()
User (유저)
- id (Key) — Primary key — NOT NULL
- name (이름(닉네임))
- email (이메일)
- password (비밀번호)
- org (소속)
- grade (등급) — yb, ob, admin
- registered_at (가입일) — LocalDateTime.now()