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