employee_details 테이블 스키마


FieldTypeNullKeyDefaultExtra
user_idintNOPRINULL
full_namevarchar(100)NONULL
resident_registration_numbervarchar(14)YESNULL
birth_datedateYESNULL
contact_numbervarchar(50)YESNULL
addressvarchar(255)YESNULL
join_datedateYESNULL
contract_typeenum('regular','contract','part_time')NOregular
weekly_holidayvarchar(20)YESNULL
work_hours_per_weekdecimal(4,2)YESNULL
salary_typeenum('annual','monthly','hourly')NOmonthly
salary_amountint unsignedYESNULL
bank_namevarchar(50)YESNULL
account_numbervarchar(50)YESNULL
insurance_national_pensiontinyint(1)NO0
insurance_healthtinyint(1)NO0
insurance_employmenttinyint(1)NO0
insurance_industrial_accidenttinyint(1)NO0
health_cert_issue_datedateYESNULL
health_cert_renewal_datedateYESNULL
default_shiftenum('DAY','NIGHT')YESDAY

users 테이블에서 프로필 이미지 확인:

FieldType
idint
usernamevarchar(50)
full_namevarchar(100)
emailvarchar(100)
rolevarchar(50)
pinvarchar(255)
profile_image_pathvarchar(255)
statusenum('active','resigned')
resignation_datedate
passwordvarchar(255)
reset_tokenvarchar(255)
reset_token_expires_atdatetime
created_atdatetime