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