workFlow

Tables (5)

COMMENT (Untitled2)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → TASK.task_id — NOT NULL

PROJECT (프로젝트)

  • project_id (Key) — int — Primary key — NOT NULL
  • owner_id (Key2) — int — Foreign key → USER.user_id — NOT NULL
  • project_name (Field3) — varchar
  • description (설명) — varchar
  • created_at (Field2) — datetime
  • updated_at (Field) — datetime

PROJECT_USER (Untitled3)

  • project_user_id (key) — int — Primary key — NOT NULL
  • project_id (key2) — int — Foreign key → PROJECT.project_id — NOT NULL
  • user_id (key3) — int — Foreign key → PROJECT.owner_id — NOT NULL
  • role (Field) — varchar
  • created_at (Field2) — datetime

TASK (Untitled)

  • task_id (Key) — int — Primary key — NOT NULL
  • task_title (Field) — varchar
  • content (Field2) — text
  • status (TODO, DOING, DONE) — varchar
  • due_date (Field4) — datetime
  • create_at (Field3) — datetime
  • update_at (Field5) — datetime

USER (유저)

  • user_id (Key) — int — Primary key — NOT NULL
  • login_id (Field) — varchar
  • password (Field2) — varchar
  • email (Field3) — varchar
  • name (Field4) — varchar
  • role (USER/ADMIN) — varchar
  • created_at (Field6) — datetime
  • updated_at (Field7) — datetime