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