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