rebus

Tables (20)

accounts

  • account_id — bigserial — Primary key — NOT NULL
  • login_id — varchar(50) — NOT NULL
  • password_hash — varchar(255) — NOT NULL
  • role — varchar(20) — NOT NULL
  • status — varchar(20)
  • driver_id — int8
  • last_login_at — timestamp
  • created_at — timestamp
  • updated_at — timestamp
  • failed_attempts — int4
  • locked_until — timestamp(6)
  • admin::character — varying
  • agent::character — varying)::text)))

appsju_accident_log

  • accident_id — bigserial — Primary key — NOT NULL
  • driver_id — int8
  • vehicle_id — int8
  • accident_date — date — NOT NULL
  • accident_type — varchar(50)
  • status — varchar(30)
  • location — varchar(200)
  • details — text
  • created_at — timestamp
  • updated_at — timestamp

appsju_accident_log_file

  • file_id — bigserial — Primary key — NOT NULL
  • accident_id — int8 — NOT NULL
  • file_path — text — NOT NULL
  • original_name — varchar(255)
  • mime_type — varchar(100)
  • file_size — int8
  • created_at — timestamp

appsju_inspection

  • inspection_id — bigserial — Primary key — NOT NULL
  • inspection_date — date — NOT NULL
  • vehicle_id — int8
  • vehicle_info — varchar(200)
  • driver_id — int8
  • mileage — int4
  • fuel_level — numeric(6, 2)
  • notes — text
  • created_at — timestamp
  • updated_at — timestamp

appsju_inspection_file

  • file_id — bigserial — Primary key — NOT NULL
  • inspection_id — int8 — NOT NULL
  • file_path — text — NOT NULL
  • original_name — varchar(255)
  • mime_type — varchar(100)
  • file_size — int8
  • created_at — timestamp

appsju_law

  • law_id — bigserial — Primary key — NOT NULL
  • driver_id — int8 — NOT NULL
  • law_name — varchar(200) — NOT NULL
  • fine — numeric(18, 2)
  • violation_date — date — NOT NULL
  • license_no — varchar(50)
  • penalty_points — int4
  • user_score — int4
  • grade — varchar(20)
  • created_at — timestamp
  • updated_at — timestamp
  • vehicle_id — int8

appsju_maintenance_log

  • maintenance_id — bigserial — Primary key — NOT NULL
  • maintenance_date — date — NOT NULL
  • vehicle_id — int8
  • contents — text
  • total_amount — numeric(18, 2)
  • unit_price — numeric(18, 2)
  • quantity — numeric(12, 2)
  • garage_name — varchar(100)
  • maintenance_type — varchar(30)
  • notes — text
  • created_at — timestamp
  • updated_at — timestamp
  • driver_id — int8
  • mileage — int8

appsju_maintenance_log_file

  • file_id — bigserial — Primary key — NOT NULL
  • maintenance_id — int8 — NOT NULL
  • file_path — text — NOT NULL
  • original_name — varchar(255)
  • mime_type — varchar(100)
  • file_size — int8
  • created_at — timestamp

appsju_notice

  • notice_id — bigserial — Primary key — NOT NULL
  • title — varchar(200) — NOT NULL
  • content — text
  • created_at — timestamp
  • updated_at — timestamp

appsju_notice_file

  • file_id — bigserial — Primary key — NOT NULL
  • notice_id — int8
  • file_path — text — NOT NULL
  • original_name — varchar(255)
  • mime_type — varchar(100)
  • file_size — int8
  • created_at — timestamp

appsju_oiling

  • oiling_id — bigserial — Primary key — NOT NULL
  • oiling_date — date — NOT NULL
  • vehicle_id — int8
  • fuel_type — varchar(20)
  • fuel_amount — numeric(12, 2)
  • created_at — timestamp
  • updated_at — timestamp
  • driver_id — int8
  • notes — varchar(500)

appsju_oiling_file

  • file_id — bigserial — Primary key — NOT NULL
  • oiling_id — int8 — NOT NULL
  • file_path — text — NOT NULL
  • original_name — varchar(255)
  • mime_type — varchar(100)
  • file_size — int8
  • created_at — timestamp

drivers

  • driver_id — bigserial — Primary key — NOT NULL
  • driver_name — varchar(100) — NOT NULL
  • license_no — varchar(50)
  • grade — varchar(20)
  • user_score — int4
  • phone — varchar(30)
  • status — varchar(20)
  • created_at — timestamp
  • updated_at — timestamp
  • vehicle_id — int8

drivers_trips

  • trip_id — bigserial — Primary key — NOT NULL
  • board_count — int4
  • created_at — timestamp(6)
  • driver_id — int8 — NOT NULL
  • drop_count — int4
  • route_info — varchar(200)
  • trip_datetime — timestamp(6) — NOT NULL
  • updated_at — timestamp(6)
  • vehicle_id — int8

drivers_working_info

  • trip_id — bigserial — Primary key — NOT NULL
  • driver_id — int8 — NOT NULL
  • vehicle_id — int8
  • trip_datetime — timestamp — NOT NULL
  • board_count — int4
  • drop_count — int4
  • route_info — varchar(200)
  • created_at — timestamp
  • updated_at — timestamp
  • working_info_id — bigserial — NOT NULL

e_emp_wage

  • wage_id — bigserial — Primary key — NOT NULL
  • driver_id — int8 — NOT NULL
  • period_from — date
  • period_to — date
  • details — text
  • created_at — timestamp
  • updated_at — timestamp
  • hourly_base_rate — numeric(12, 2)
  • hourly_weekly_rate — numeric(12, 2)
  • hourly_holiday_rate — numeric(12, 2)
  • hourly_overtime_rate — numeric(12, 2)
  • base_amount — numeric(18, 2)
  • deduction_amount — numeric(18, 2)
  • holiday_amount — numeric(18, 2)
  • overtime_amount — numeric(18, 2)
  • total_amount — numeric(18, 2)
  • weekly_amount — numeric(18, 2)

flyway_schema_history

  • installed_rank — int4 — Primary key — NOT NULL
  • version — varchar(50)
  • description — varchar(200) — NOT NULL
  • type — varchar(20) — NOT NULL
  • script — varchar(1000) — NOT NULL
  • checksum — int4
  • installed_by — varchar(100) — NOT NULL
  • installed_on — timestamp — NOT NULL
  • execution_time — int4 — NOT NULL
  • success — bool — NOT NULL

schedule_renewal

  • schedule_id — bigserial — Primary key — NOT NULL
  • driver_id — int8 — NOT NULL
  • work_date — date — NOT NULL
  • weekday — varchar(10)
  • work_type — varchar(20)
  • check_in — time
  • check_out — time
  • hours_basic — numeric(5, 2)
  • hours_weekly — numeric(5, 2)
  • hours_holiday — numeric(5, 2)
  • hours_overtime — numeric(5, 2)
  • created_at — timestamp
  • updated_at — timestamp
  • time_group_id — int8

time_group_info

  • time_group_id — bigserial — Primary key — NOT NULL
  • group_name — varchar(50) — NOT NULL
  • start_time — time
  • end_time — time
  • description — text
  • created_at — timestamp
  • updated_at — timestamp

vehicles

  • vehicle_id — bigserial — Primary key — NOT NULL
  • vehicle_no — varchar(50) — NOT NULL
  • model — varchar(100)
  • year — int4
  • fuel_type — varchar(20)
  • status — varchar(20)
  • owner_dept — varchar(100)
  • created_at — timestamp
  • updated_at — timestamp