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