leave_modules
Tables (12)
cache
- key — varchar(255) — Primary key — NOT NULL
- value — mediumtext — NOT NULL
- expiration — int(11) — NOT NULL
cache_locks
- key — varchar(255) — Primary key — NOT NULL
- owner — varchar(255) — NOT NULL
- expiration — int(11) — NOT NULL
claim_outstation
- id — int(11) — Primary key — NOT NULL
- users_id — bigint(20) — Foreign key → users.id
- project_id — int(11) — NOT NULL — from db PSM table project
- claim_type — varchar(50) — NOT NULL
- date — date — NOT NULL
- trfid — varchar(50)
- timein — varchar(50) — NOT NULL
- timeout — varchar(50) — NOT NULL
- location — varchar(50)
- task — longtext
- status — varchar(50)
- check_by — bigint(20)
- approve_by — bigint(20)
- process_by — bigint(20)
- comment — text
- session_name — varchar(50)
- total_out — double(10, 2)
- date_submitted — timestamp — NOT NULL
- submission_group_id — varchar(13)
claim_overtime
- id — int(11) — Primary key — NOT NULL
- users_id — bigint(20) — Foreign key → users.id
- project_id — int(11) — NOT NULL — from db PSM table project
- claim_type — varchar(50)
- start — varchar(50)
- day — varchar(50)
- timein — varchar(50)
- timeout — varchar(50)
- otimein — varchar(50)
- otimeout — varchar(50)
- location — varchar(50)
- task — longtext
- total — double(10, 2)
- status — varchar(50)
- check_by — bigint(20)
- approve_by — bigint(20)
- process_by — bigint(20)
- comment — text
- session_name — varchar(50)
- total_overtime_amount — double(10, 2) — NOT NULL
- date_submitted — timestamp — NOT NULL
- submission_group_id — varchar(13)
claim_standby
- id — int(11) — Primary key — NOT NULL
- users_id — bigint(20) — Foreign key → users.id
- project_id — int(11) — NOT NULL — from db PSM table project
- claim_type — varchar(50) — NOT NULL
- datestart — date — NOT NULL
- dateend — date — NOT NULL
- location — varchar(50)
- task — longtext
- status — varchar(50)
- check_by — bigint(20)
- approve_by — bigint(20)
- process_by — bigint(20)
- comment — text
- session_name — varchar(50)
- total_standby — double(10, 2)
- date_submitted — timestamp — NOT NULL
- submission_group_id — varchar(13)
failed_jobs
- id — bigint(20) — Primary key — NOT NULL
- uuid — varchar(255) — NOT NULL
- connection — text — NOT NULL
- queue — text — NOT NULL
- payload — longtext — NOT NULL
- exception — longtext — NOT NULL
- failed_at — timestamp — NOT NULL
job_batches
- id — varchar(255) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- total_jobs — int(11) — NOT NULL
- pending_jobs — int(11) — NOT NULL
- failed_jobs — int(11) — NOT NULL
- failed_job_ids — longtext — NOT NULL
- options — mediumtext
- cancelled_at — int(11)
- created_at — int(11) — NOT NULL
- finished_at — int(11)
jobs
- id — bigint(20) — Primary key — NOT NULL
- queue — varchar(255) — NOT NULL
- payload — longtext — NOT NULL
- attempts — tinyint(3) — NOT NULL
- reserved_at — int(10)
- available_at — int(10) — NOT NULL
- created_at — int(10) — NOT NULL
migrations
- id — int(10) — Primary key — NOT NULL
- migration — varchar(255) — NOT NULL
- batch — int(11) — NOT NULL
password_reset_tokens
- email — varchar(255) — Primary key — NOT NULL
- token — varchar(255) — NOT NULL
- created_at — timestamp
sessions
- id — varchar(255) — Primary key — NOT NULL
- user_id — bigint(20)
- ip_address — varchar(45)
- user_agent — text
- payload — longtext — NOT NULL
- last_activity — int(11) — NOT NULL
users
- id — bigint(20) — Primary key — NOT NULL
- staff_id — varchar(50)
- name — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- email_verified_at — timestamp
- password — varchar(255) — NOT NULL
- remember_token — varchar(100)
- created_at — timestamp
- updated_at — timestamp