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