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