게시판
테이블 (5)
Board (Untitled2)
- board_id (Key) — bigint — 기본 키 — NOT NULL
- user_id (Key2) — bigint — 외래 키 → user.user_id — NOT NULL
- title (Field) — varchar
- content (Field2) — text
- image_url (Field3) — varchar(255)
- created_at (Field4) — timestamp
- modified_at (Field5) — timestamp
- is_notice (Field6) — boolean
- board_status (Field7) — enum
Comment (Untitled3)
- comment_id (Key) — bigint — 기본 키 — NOT NULL
- user_id (Key2) — bigint — 외래 키 → user.user_id — NOT NULL
- board_id (Key3) — bigint — 외래 키 → Board.board_id — NOT NULL
- content (Field) — text
- created_at (Field2) — timestamp
- modified_at (Field3) — timestamp
Role (Untitled4)
- role_id (Key) — bigint — 기본 키 — NOT NULL
- user_id (Key2) — bigint — 외래 키 → user.user_id — NOT NULL
- role (Field) — varchar(10)
View (Untitled5)
- view_id (Key) — bigint — 기본 키 — NOT NULL
- user_id (Key2) — bigint — 외래 키 → user.user_id — NOT NULL
- board_id (Key3) — bigint — 외래 키 → Board.board_id — NOT NULL
user (Untitled)
- user_id (Key) — bigint — 기본 키 — NOT NULL
- email (Field) — varchar(30)
- password (Field2) — varchar(255)
- nickname (Field3) — varchar(10)
- created_at (Field5) — timestamp
- modified_at (Field6) — timestamp
- user_status (Field7) — enum