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 — 비밀번호