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`