TeamPlan

Tables (7)

Project (프로젝트 상세)

  • project_id (Key) — Primary key — NOT NULL
  • project_local_id (Key2) — Foreign key → Project List.project_local_id — NOT NULL
  • project_remote_id (Key3) — Foreign key → Project List.project_remote_id — NOT NULL
  • project_reg_date (Field6)
  • project_name (Field)
  • project_desc (Field5)
  • project_member (Field2)
  • project_todo_complete (Field3)
  • project_todo_ongoing (Field4)
  • project_todo_complete_count (Field7)
  • project_todo_total_count (Field8)

Project List (프로젝트 리스트(Local))

  • project_local_id (Key) — Primary key — NOT NULL
  • user_email (Key2) — String — Foreign key → User.user_email — NOT NULL

Project List (프로젝트 리스트(Remote))

  • project_remote_id (Key) — Primary key — NOT NULL
  • user_email (Key2) — String — Foreign key → User.user_email — NOT NULL

Team (프로젝트 팀)

  • project_id (Key) — Foreign key → Project.project_id — NOT NULL
  • team_list_id (Key2) — Foreign key → Team List.team_list_id — NOT NULL

Team List (소속팀 명단)

  • team_list_id (Key2) — Primary key — NOT NULL
  • user_email (Key) — String — Foreign key → User.user_email — NOT NULL

Todo List (할 일 목록)

  • todo_id (Key2) — Primary key — NOT NULL
  • project_id (Key) — Foreign key → Project.project_id — NOT NULL
  • todo_reg_date (Field4)
  • todo_name (Field2)
  • todo_timeline (Field3)
  • todo_assign (Field5)

User (사용자)

  • user_email (Key) — String — Primary key — NOT NULL
  • user_name (Field) — String
  • user_birth (Field2) — Date
  • user_profile (Field11) — ?
  • user_like1 (Field3) — String
  • user_like2 (Field4) — String
  • user_like3 (Field5) — String
  • user_like4 (Field6) — String
  • user_best1 (Field7) — String
  • user_best2 (Field8) — String
  • user_best3 (Field9) — String
  • user_best4 (Field10) — String