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)