HomeTeam

Tables (8)

Comment (댓글)

  • id — LONG — Primary key — NOT NULL
  • task_id — LONG — Foreign key → Task.id — NOT NULL
  • member_id — LONG — Foreign key → Member.id — NOT NULL
  • message — VARCHAR(100)
  • created_at — LOCALDATETIME

CommentFile (댓글 첨부 파일)

  • comment_id — LONG — Foreign key → Comment.id — NOT NULL
  • name — VARCHAR(100)
  • data_type — VARCHAR(10)
  • data_class — VARCHAR(10)

Member (팀 멤버)

  • id — LONG — Primary key — NOT NULL
  • name — VARCHAR(20)

Project (프로젝트)

  • id — LONG — Primary key — NOT NULL
  • team_id — LONG — Foreign key → Team.id — NOT NULL
  • start_date — LOCALDATE
  • end_date — LOCALDATE

Task (작업)

  • id — LONG — Primary key — NOT NULL
  • project_id — LONG — Foreign key → Project.id — NOT NULL
  • name — VARCHAR(30)
  • status — VARCHAR(10)
  • created_at — LOCALDATETIME

Task-Member (작업/멤버 맵핑)

  • member_id — LONG — Foreign key → Member.id — NOT NULL
  • task_id — LONG — Foreign key → Task.id — NOT NULL

Team (팀)

  • id — LONG — Primary key — NOT NULL
  • name — VARCHAR(20)

Team-Member (팀/멤버 맵핑)

  • team_id — LONG — Foreign key → Team.id — NOT NULL
  • member_idm (member_id) — LONG — Foreign key → Member.id — NOT NULL