fleet_vehicle_log_contract


Description

Vehicle Contract

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('fleet_vehicle_log_contract_id_seq'::regclass)
fleet_service_type_fleet_vehicle_log_contract_rel.fleet_vehicle_log_contract_id fleet_service_type_fleet_vehi_fleet_vehicle_log_contract_i_fkey C
vehicle_id int4 10 null
fleet_vehicle.id fleet_vehicle_log_contract_vehicle_id_fkey R

Vehicle
cost_subtype_id int4 10 √ null
fleet_service_type.id fleet_vehicle_log_contract_cost_subtype_id_fkey N

Type
company_id int4 10 √ null
res_company.id fleet_vehicle_log_contract_company_id_fkey N

Company
user_id int4 10 √ null
res_users.id fleet_vehicle_log_contract_user_id_fkey N

Responsible
insurer_id int4 10 √ null
res_partner.id fleet_vehicle_log_contract_insurer_id_fkey N

Vendor
create_uid int4 10 √ null
res_users.id fleet_vehicle_log_contract_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id fleet_vehicle_log_contract_write_uid_fkey N

Last Updated by
name varchar 2147483647 √ null

Name
ins_ref varchar 64 √ null

Reference
state varchar 2147483647 √ null

Status
cost_frequency varchar 2147483647 null

Recurring Cost Frequency
date date 13 √ null

Date
start_date date 13 √ null

Contract Start Date
expiration_date date 13 √ null

Contract Expiration Date
notes text 2147483647 √ null

Terms and Conditions
amount numeric 0 √ null

Cost
cost_generated numeric 0 √ null

Recurring Cost
active bool 1 √ null

Active
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
fleet_vehicle_log_contract_pkey Primary key Asc id
fleet_vehicle_log_contract__user_id_index Performance Asc user_id

Relationships

Close relationships within degrees of separation