workwave
Tables (6)
columns
- id — BIGINT — Primary key — NOT NULL — 식별자
- team_id — BIGINT — Foreign key → teams.id — NOT NULL — 식별자
- name — VARCHAR(50) — NOT NULL — 명칭
- position — INT — NOT NULL — 순서
team_invites
- id — BIGINT — Primary key — NOT NULL — 식별자
- team_id — BIGINT — Foreign key → teams.id — NOT NULL — 식별자
- user_id — BIGINT — Foreign key → users.id — NOT NULL — 식별자
- status — VARCHAR(50) — NOT NULL — 상태(Pending/Accepted)
team_members
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL — 식별자
- team_id — BIGINT — Foreign key → teams.id — NOT NULL — 식별자
- role — VARCHAR(50) — NOT NULL — 역할(리더/팀원)
teams
- id — BIGINT — Primary key — NOT NULL — 식별자
- team_name — VARCHAR(50) — NOT NULL — 팀명
tickets
- id — BIGINT — Primary key — NOT NULL — 식별자
- column_id — BIGINT — Foreign key → columns.id — NOT NULL — 식별자
- assignee_id — BIGINT — Foreign key → users.id — NOT NULL — 식별자
- position — INT — NOT NULL — 티켓 순서
- title — VARCHAR(255) — NOT NULL — 티켓 제목
- tag — VARCHAR(50) — NOT NULL — 티켓 태그
- workload — DOUBLE — NOT NULL — 작업분량(시간)
- deadline — DATETIME — NOT NULL — 작업기한
users
- id — BIGINT — Primary key — NOT NULL — 식별자
- username — VARCHAR(50) — NOT NULL — 계정
- password — VARCHAR(255) — NOT NULL — 비밀번호