tms_fleet

User Interface Terms Mapped to Database Elements

Vehicle

User interface	Database equivalent
	vehicle→'car_id'
	vehicle→'car_model'

Elevated pricing tiers

Here are user interface names mapped to their database counterparts. Often times guessing or trying to deduce the correct relations for these will make you guess wrong. Below is a great example of this:

User interface	Database equivalent
price per km	price_per_km
price per kilometer class 2	price_per_km_elevated_tier_1
???	price_per_km_elevated_tier_2

---

Subpages

• SELECT & UPDATE agreement.assistance_addition values
• SELECT & UPDATE agreement.monthly_fee
• SELECT & UPDATE agreement.valid_from
• SELECT & UPDATE agreement.valid_until
• SELECT & UPDATE shift_agreement.valid_from
• SELECT agreement FULL table
• SELECT company FULL table
• SELECT vehicle FULL table
• UPDATE agreement.price_per_km
• UPDATE agreement.price_per_km_elevated_tier_1
• UPDATE agreement.stair_climber_addition
• UPDATE agreement.start_fee_elevated
• UPDATE agreement.start_fee_normal
• UPDATE agreement.stretcher_addition
• UPDATE agreement.wait_fee_per_minute
• UPDATE trip_bill.bill-'operator_fees' (VAT) inside of the bill JSON