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