test

Tables (8)

comments

  • id — BIGINT — Primary key
  • task_id (id2) — BIGINT — Foreign key → tasks.id
  • create_by (id3) — BIGINT — Foreign key → project_members.id
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

milestones

  • id — BIGINT — Primary key
  • name — VARCHAR(100) — NOT NULL
  • status — ENUM(시작전, 진행중, 진행완료)
  • created_at — TIMESTAMP

project_members

  • id — BIGINT — Primary key
  • project_id (id2) — BIGINT(Autoincrement) — Foreign key → projects.id
  • user_id (id3) — VARCHAR(100) — Foreign key → users.id
  • role — ENUM('MEMBER', 'ADMIN') — NOT NULL

projects

  • id — BIGINT(Autoincrement) — Primary key
  • name — VARCHAR(100) — NOT NULL
  • status — ENUM('ACTIVE', 'SLEEP', 'CLOSED')
  • created_at — TIMESTAMP

tags

  • id — BIGINT — Primary key
  • name — VARCHAR(50) — NOT NULL

task_tags

  • task_tag_id (id) — autoincrement — Primary key — NOT NULL
  • task_id (id2) — BIGINT — Foreign key → tasks.id
  • tag_id (id3) — BIGINT — Foreign key → tags.id

tasks

  • id — BIGINT — Primary key
  • project_id (id2) — BIGINT(Autoincrement) — Foreign key → projects.id
  • milestone_id (id3) — BIGINT — Foreign key → milestones.id
  • created_by (id4) — BIGINT — Foreign key → project_members.id
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP

users

  • id — VARCHAR(100) — Primary key
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP