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)