1234

Tables (5)

attendance

  • id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(255) — Foreign key → users.id — NOT NULL
  • user_name — TEXT — NOT NULL
  • user_alias — TEXT
  • year — TEXT — NOT NULL
  • month — TEXT — NOT NULL
  • total_work_days — INT
  • base_salary — INT
  • overtime_pay — INT
  • night_shift_days — INT
  • night_shift_pay — INT
  • holiday_work_days — INT
  • holiday_work_pay — INT
  • status — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • payment_month — TEXT — NOT NULL
  • payment_day — TEXT — NOT NULL
  • tax_deduction — INT
  • insurance_deduction — INT
  • total_work_hours — INT
  • idx — SMALLINT
  • total_salary — DECIMAL(10,2)
  • INDEX — `fk_attendance_user`

attendance_request

  • id — VARCHAR(36) — Primary key — NOT NULL
  • attendance — VARCHAR(36) — Foreign key → attendance.id
  • requested_amount — TEXT — NOT NULL
  • reason — TEXT — NOT NULL
  • file_path — TEXT
  • created_at — TIMESTAMP
  • status — TEXT
  • status_reason — TEXT
  • updated_at — TIMESTAMP
  • INDEX — `fk_attendance_request_attendance`

schedules

  • id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(255) — Foreign key → users.id — NOT NULL
  • schedule_id — VARCHAR(255) — NOT NULL
  • user_name — VARCHAR(255) — NOT NULL
  • user_alias — VARCHAR(255) — NOT NULL
  • category — VARCHAR(255) — NOT NULL
  • start_date_time — TIMESTAMP — NOT NULL
  • time — VARCHAR(255) — NOT NULL
  • end_date_time — TIMESTAMP — NOT NULL
  • schedule_shift_type — VARCHAR(255) — NOT NULL
  • repeat_r — VARCHAR(255)
  • repeat_end_date — TIMESTAMP
  • created_at — TIMESTAMP
  • description — TEXT
  • processed — TINYINT(1)
  • INDEX — `fk_schedules_user`

users

  • id — VARCHAR(255) — Primary key — NOT NULL
  • user_name — VARCHAR(255) — NOT NULL
  • user_alias — VARCHAR(255)
  • email — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(20)
  • gender — VARCHAR(10)
  • age — INT
  • password — VARCHAR(255)
  • role — VARCHAR(20)
  • created_at — TIMESTAMP

work_hours

  • id — BIGINT — Primary key — NOT NULL
  • user_id — VARCHAR(255) — Foreign key → users.id — NOT NULL
  • user_name — TEXT — NOT NULL
  • user_alias — TEXT — NOT NULL
  • weekly_hours — INT
  • monthly_hours — INT
  • year — TEXT — NOT NULL
  • month — TEXT — NOT NULL
  • week_number — INT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — `fk_work_hours_user`