TimeSheet

Tables (13)

account

  • account_id — int — Primary key — Identity
  • role_id — int — Foreign key → role.role_id — FK role
  • employee_id (employee_id2) — int — Foreign key → employee.employee_id — FK employee
  • email — nvarchar(200) — email employee
  • password — nvarchar(50)
  • access_token — nvarchar
  • imei_mobile — nvarchar(100)
  • verification_code — nvarchar(50)
  • update_time — datetime
  • deletion_flag — byte — 0 : active 1 : inactive

day_off

  • day_off_id — int — Primary key — identity
  • day_off_code — UNIQUE
  • day_off_type — nvarchar(200)
  • day_off_total — int
  • unit — nvarchar(200)
  • update_time — datetime
  • deletion_flag — byte — 0 : active 1 : inactive

department

  • department_id — int — Primary key — identity
  • workplace _id — nvarchar(50) — Foreign key → workplace.workplace _id — FK
  • department_code — nvarchar(50) — unique
  • department_name — nvarchar(200)
  • update_time — datetime
  • deletion_flag — byte — 0 : active 1 : inactive

empl_day_off

  • empl_day_off_id — int — Primary key — identity
  • employee_id — int — Foreign key → employee.employee_id — FK employee
  • day_off_code — string — Foreign key → day_off.day_off_id — identity
  • empl_day_off_type — nvarchar(200)
  • empl_day_off_pending — int
  • empl_day_off_number — int
  • update_time — datetime
  • deletion_flag — byte — 0 : active 1 : inactive

employee

  • employee_id — int — Primary key — Identity
  • role_id — int — Foreign key → role.role_id — FK role
  • department_id — int — Foreign key → department.department_id — FK department
  • approver_id — int — referent employee_id
  • employee_name — nvarchar(100) — full name
  • email — nvarchar(50)
  • date_of_birth — datetime — NOT NULL
  • access_date — datetime — NOT NULL
  • expire_date — datetime
  • relation_ship — nchar(1) — 0: doc than 1: ket hon
  • insurance_number — int
  • update_time — dateime
  • deletion_flag — byte — 0 : active 1 : inactive

request_info

  • request_info_id — int — Primary key — identity
  • employee_id — int — Foreign key → employee.employee_id — FK employee
  • empl_day_off_id — int — Foreign key → empl_day_off.empl_day_off_id — identity
  • approver_id — int — approver
  • request_info_title — nvarchar(100)
  • start_date — date
  • end_date — date
  • partial_day — int — 0: nghỉ sáng 1: nghỉ chiều 2: cả ngày
  • duration — int
  • supervisor — nvarchar(200)
  • comment — text — max 4000 character
  • request_info_status — int — default : 1 1 : request 2 : approver 3 : cancel 4 : reject 5 : close
  • update_time — datetime
  • deletion_flag — byte — 0 : active 1 : inactive

role

  • role_id — int — Primary key — Identity
  • role_code — int — unique default : 0 0 : normal 1 : BOD 2 : HR 3 : Receptionist 4: CLead
  • role_name — nvarchar(200)
  • update_time — datetime
  • deletion_flag — 0 : active 1 : inactive

salary

  • salary_id — int — Primary key — identity
  • employee_id — int — Foreign key → employee.employee_id — FK employee
  • date_start — datetime
  • date_end — datetime
  • update_time — datetime
  • deletion_flag — byte — 0 : active 1 : inactive

setting

  • setting_id — int — Primary key — identity
  • workplace _id — int — Foreign key → workplace.workplace _id — identity
  • rest_time — time
  • setting_time_checkin — time
  • setting_time_checkout — time
  • morning_time_latest — time
  • afternoon_time_latest — time
  • work_late_male — int
  • work_late_female — int
  • update_time — datetime
  • deletion_flag — byte — 0 : active 1 : inactive

t_emp_disaster

  • emp_disaster_id — int — Primary key — identity
  • employee_id — int — Foreign key → employee.employee_id — Identity
  • natural_disaster_id — int — Foreign key → t_natural_disaster.natural_disaster_id — identity
  • emp_disaster_status — byte — 0 : safe 1 : danger
  • update_time — datetime
  • deletion_flag — byte — 0 : active1 : inactive

t_natural_disaster

  • natural_disaster_id — int — Primary key — identity
  • natural_disaster_name — nvarchar(200)
  • natural_disaster_date — datetime
  • disaster_warning_level — nvarchar
  • update_time — datetime
  • deletion_flag — byte — 0 : active1 : inactive

time_sheet

  • time_sheet_id — int — Primary key — identity
  • employee_id — int — Foreign key → employee.employee_id — FK emloyee
  • date — datetime
  • checkin — time
  • checkout — time
  • checking_late — bool — 0: False 1: True
  • checking_early — bool — 0: False 1: True
  • total_working_time — time
  • update_time — datetime
  • deletion_flag — byte — 0 : active 1 : inactive

workplace

  • workplace _id — int — Primary key — identity
  • workplace _code — nvarchar(50) — unique
  • workplace _name — nvarchar(500)
  • nfc_id — nvarchar(50)
  • update_time — datetime
  • deletion_flag — byte — 0 : active 1 : inactive