tool-for-cooperation
Tables (6)
Project (프로젝트)
- project_id (Key) — NOT NULL — Primary key — NOT NULL
- project_name (Field) — NOT NULL
- date_start (Field2) — NOT NULL
- date_end (Field3) — NOT NULL
- status (Field4) — NOT NULL
- date_created (Field5) — NOT NULL
- date_updated (Field6) — NOT NULL
ProjectMember (Untitled2)
- project_member_id (Key) — NOT NULL — Primary key — NOT NULL
- role (Field) — NOT NULL
- userId (Key2) — NOT NULL — Foreign key → User.userId — NOT NULL
- project_id (Key3) — NOT NULL — Foreign key → Project.project_id — NOT NULL
ProjectTask (Untitled3)
- project_task_id (Key) — NOT NULL — Primary key — NOT NULL
- project_id (Key2) — NOT NULL — Foreign key → Project.project_id — NOT NULL
- task_id (Key3) — NOT NULL — Foreign key → Task.task_id — NOT NULL
Task (작업)
- task_id (Key) — NOT NULL — Primary key — NOT NULL
- task_name (Field) — NOT NULL
- date_start (Field2) — NOT NULL
- date_end (Field3) — NOT NULL
- status (Field4) — NOT NULL
- date_created (Field5) — NOT NULL
- date_updated (Field6) — NOT NULL
- project_id (Key2) — NOT NULL — Foreign key → Project.project_id — NOT NULL
TaskMember (Untitled)
- task_member_id (Key) — NOT NULL — Primary key — NOT NULL
- userId (Key2) — NOT NULL — Foreign key → User.userId — NOT NULL
- task_id (Key3) — NOT NULL — Foreign key → Task.task_id — NOT NULL
User (사용자)
- userId (Key) — NOT NULL — Primary key — NOT NULL
- first_name (Field) — NOT NULL
- last_name (Field2) — NOT NULL
- email (Field3) — NOT NULL
- nickname (Field4) — NOT NULL
- password (Field5) — NOT NULL
- date_created (Field6) — NOT NULL
- date_updated (Field7) — NOT NULL