BM ERP ERD
Tables (9)
Attendances (Untitled5)
- attendance_id (Key) — Primary key — NOT NULL
- employee_id (Key2) — Foreign key → Employee.employee_id — NOT NULL
- date (Field)
- time_in (Field2)
- time_out (Field3)
- is_wfh (Field4) — boolean
Candidates (CopyOfUntitled3)
- employee_id (Key) — Primary key — NOT NULL
- department_id (Key2) — int — Foreign key → Departments.department_id — NOT NULL
- candidate_name_vn (Field2) — char (100)
- candidate_email (Field3) — char (150)
- candidate_dob (Field4)
- candidate_phonenumber (Field5) — char (20)
- candidate_address (Field6) — char (150)
- candidate_education (Field7)
- candidate_experience (Field8)
- candidate_socialmedia (Field9)
- image_blob (Field10)
- salary_expected (Field11) — float
- CV (Field12)
- evaluation (Field13)
Departments (CopyOfCopyOfUntitled)
- department_id (Key) — int — Primary key — NOT NULL
- department_name (Field) — char (250)
Employee (Untitled3)
- employee_id (Key) — Primary key — NOT NULL
- department_id (Key2) — int — Foreign key → Departments.department_id — NOT NULL
- employee_name_en (Field) — char (100)
- employee_name_vn (Field2) — char (100)
- employee_email (Field3) — char (150)
- employee_dob (Field4)
- employee_phonenumber (Field5) — char (20)
- employee_address (Field6) — char (150)
- employee_education (Field7)
- employee_experience (Field8)
- employee_socialmedia (Field9)
- image_blob (Field10)
- salary (Field11) — float
- contract (Field12)
- evaluation (Field13)
- CV (Field14)
Permissions (CopyOfUntitled)
- role_id (Key) — int — Primary key — NOT NULL
- permission_name (Field) — char (250)
Roles (Untitled)
- role_id (Key) — int — Primary key — NOT NULL
- role_name (Field) — char (250)
Users (Untitled4)
- user_id (Key) — Primary key — NOT NULL
- role_id (Key2) — int — Foreign key → Roles.role_id — NOT NULL
- user_email (Field)
access_permission (Untitled2)
- access_id (Key) — Primary key — NOT NULL
- role_id (Key2) — int — Foreign key → Roles.role_id — NOT NULL
- role_id (Key3) — int — Foreign key → Permissions.role_id — NOT NULL
- is_read (Field) — boolean
- is_create (Field2) — boolean
- is_update (Field3) — boolean
- is_delete (Field4) — boolean
- is_approve (Field5) — boolean
day_off (Untitled6)
- dayoff_id (Key) — Primary key — NOT NULL
- employee_id (Key2) — Foreign key → Employee.employee_id — NOT NULL
- date (Field)
- from_time (Field2)
- to_time (Field3)
- reason (Field4)
- status (Field5)