Project_Now
첫 개인 프로젝트 두근두근
테이블 (5)
Avaliable Time Code (avaliable_time_code)
- Avaliable Time Code (avaliable_time_code) — char(10) — 기본 키 — NOT NULL
- Name (name) — varchar(50)
Time Table (time_table)
- Phone Num (phone_num) — char(11) — 외래 키 → User.Phone Num — NOT NULL
- Time Wake Up (time_wake_up) — time — NOT NULL
- Time Start Work (time_start_work) — time — NOT NULL
- Time Leave home (time_leave_home) — time — NOT NULL
- Time Lunch Break (time_lunch_break) — time — NOT NULL
- Time Quitting Work (time_quitting_work) — time — NOT NULL
- Time ComeBack Home (time_come_back_home) — time
- Time Go To Sleep (time_go_to_sheep) — time — NOT NULL
ToDo (to_do)
- index — int — 기본 키 — NOT NULL
- Phone Num (phone_num) — char(11) — 외래 키 → User.Phone Num — NOT NULL
- Schedule Code (schedule_code) — char(10)
- Sub Schedule Code (sub_schdule_code) — char(10)
- Total Time (total_time) — time
- Allocated Time (allocated_time) — time
- To Do Code (to_do_code) — char(10)
- Etc Name (Etc_name)
- Allocation Point (allocation_point) — int(10)
User (user)
- Phone Num (phone_num) — char(11) — 기본 키 — NOT NULL
- Password (password) — varchar(100) — NOT NULL
- Name (name) — varchar(10) — NOT NULL
- Nickname (nickname) — varchar(100) — NOT NULL
- Gender (gender) — varchar(6) — NOT NULL
- Point JG (point_JG) — int(10)
- Cumulative Count (cumulative_count) — int(10)
- LEVEL (level) — int(1)
- Detail Occupation Code (detail_occupation_code) — char(3)
- UserServiceAgrment (user_service_agrment) — char(1)
- UserInfoAgrment (user_info_agrment) — char(1)
User Schedule (user_schedule)
- Phone Num (phone_num) — char(11) — 외래 키 → Time Table.Phone Num — NOT NULL
- Sleep Time (speep_time) — int(4)
- Awake Time (awake_time) — int(4)
- Morning Prepare Time (morning_prepare_time) — int(4)
- Morning Commute Time (morning_commute_time) — int(4)
- Morning Work Time (morning_work_time) — int(4)
- Lunchtime (lunchtime) — int(4)
- AfterNoonWorTime (Field4) — int(4)
- Field5 — int(4)
- Field6 — int(4)