MOIT
Tables (4)
applications
- id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → moit_posts.id — NOT NULL — UNIQUE(post_id, applicant_id) 조합 — 같은 글 중복 신청 방지
- applicant_id — BIGINT — Foreign key → users.id — NOT NULL — UNIQUE(post_id, applicant_id) 조합 — 같은 글 중복 신청 방지
- status — VARCHAR(20) — NOT NULL
- applied_at — DATETIME — NOT NULL
comments
- id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → moit_posts.id — NOT NULL
- author_id — BIGINT — Foreign key → users.id — NOT NULL
- content — VARCHAR(1000) — NOT NULL
- created_at — DATETIME — NOT NULL
- update_at — DATETIME
moit_posts
- id — BIGINT — Primary key — NOT NULL
- author_id — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- category — VARCHAR(30) — NOT NULL
- capacity — INT — NOT NULL
- current_count — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- deadline — DATETIME — NOT NULL
- open_chat_url — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL