hello-krafton
테이블 (3)
게시판 (posts)
- ID (id) — BIGINT — 기본 키 — NOT NULL
- Category (category) — VARCHAR(20) — NOT NULL — notice/general
- Title (title) — VARCHAR(200) — NOT NULL
- Content (content) — TEXT — NOT NULL
- Author Id (author_id) — BIGINT — 외래 키 → 사용자.ID — NOT NULL
- View Count (view_count) — INT — NOT NULL
- Created at (created_at) — TIMESTAMP — NOT NULL — DEFAULT
- Updated at (updated_at) — TIMESTAMP — NOT NULL — ON UPDATE
- Deleted at (deleted_at) — TIMESTAMP
사용자 (users)
- ID (id) — BIGINT — 기본 키 — NOT NULL
- Email (email) — VARCHAR(200) — NOT NULL
- Password (password) — VARCHAR(255) — NOT NULL
- Name (name) — VARCHAR(100) — NOT NULL
- Department (department) — VARCHAR(100)
- Created At (created_at) — TIMESTAMP — NOT NULL — DEFAULT
- Updated At (updated_at) — TIMESTAMP — ON UPDATE
- Deleted At (deleted_at) — TIMESTAMP
첨부파일 (files)
- ID (id) — BIGINT — 기본 키 — NOT NULL
- Post Id (post_id) — BIGINT — 외래 키 → 게시판.ID — NOT NULL
- Name (name) — VARCHAR(255) — NOT NULL — notice/general
- Path (path) — VARCHAR(500) — NOT NULL
- Size (size) — BIGINT — NOT NULL
- Type (type) — VARCHAR(100) — NOT NULL
- Created at (created_at) — TIMESTAMP — NOT NULL — DEFAULT
- Updated at (updated_at) — TIMESTAMP — NOT NULL — ON UPDATE
- Deleted at (deleted_at) — TIMESTAMP