리포트

테이블 (4)

admin_content

  • content_id — INT — 기본 키 — NOT NULL
  • report_id — INT — NOT NULL
  • section_key — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • score — INT
  • completed_at — DATETIME

collab_assign

  • assign_id — INT — 기본 키 — NOT NULL
  • report_id — INT — NOT NULL
  • user_id — INT — NOT NULL — 협업자 사용자 ID
  • section_key — VARCHAR(100) — NOT NULL
  • assigned_at — DATETIME — NOT NULL
  • completed_at — DATETIME — 작성완료 시점 (권한 중단)

collab_draft

  • draft_id — INT — 기본 키 — NOT NULL
  • assign_id — INT — NOT NULL
  • temp_content — TEXT — NOT NULL
  • saved_at — DATETIME — NOT NULL

report

  • report_id — INT — 기본 키 — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • status — ENUM('Draft','In Review','Completed') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL