National Heavy Vehicle Regulator

Explore the interactive ERD

Table & Field Reference

vehicle_component_set_controller_item

Column	Type	Keys
`vehicle_component_id`	Unknown	PKFK
`vehicle_component_set_controller_id`	Unknown	PKFK

vehicle_component_set_controller

Column	Type	Keys
`id`	Unknown	PK
`vehicle_component_set_type_id`	Unknown	FK
`archived`	Unknown
`archived_2`	Unknown
`code`	Unknown
`component_fixed_from`	Unknown
`ends`	Unknown
`name`	Unknown
`operation_account_id`	Unknown
`short_name`	Unknown

access_instrument_controller_file_list

Column	Type	Keys
`index`	Unknown	PK
`access_instrument_controller_id`	Unknown	PKFK
`file_group_id`	Unknown
`name`	Unknown
`note`	Unknown
`prefix`	Unknown
`size`	Unknown
`type`	Unknown
`uploaded`	Unknown
`uploaded_by`	Unknown
`version`	Unknown

access_instrument_controller_condition_template_config

Column	Type	Keys
`id`	Unknown	PK
`access_instrument_controller_condition_id`	Unknown	PKFK
`access_instrument_controller_id`	Unknown	PKFK
`example_value`	Unknown
`field_type`	Unknown
`help`	Unknown
`label`	Unknown
`list`	Unknown
`max`	Unknown
`min`	Unknown
`numeric_value`	Unknown
`uom`	Unknown
`value`	Unknown

access_instrument_controller_condition

Column	Type	Keys
`id`	Unknown	PK
`access_instrument_controller_id`	Unknown	PKFK
`account_name`	Unknown
`asset_detail_id`	Unknown
`category`	Unknown
`code`	Unknown
`concerns`	Unknown
`condition_group_id`	Unknown
`condition_header`	Unknown
`groups`	Unknown
`is_auto_applied`	Unknown
`name`	Unknown
`partner_account_id`	Unknown
`permit_partner_condition_id`	Unknown
`permit_standard_condition_id`	Unknown
`reason`	Unknown
`reasons`	Unknown
`risk_mitigation`	Json
`segment_ids`	Json
`status`	Unknown
`template`	Unknown

access_instrument_controller

Column	Type	Keys
`id`	Unknown	PK
`actual_expiry_date`	Instant
`approval`	Unknown
`carriage`	Unknown
`com_law_ref_num`	Unknown
`created`	Instant
`created_by`	Unknown
`deactivated`	Unknown
`description`	Unknown
`exemption_types`	Json
`expiry_date`	Instant
`guide`	Unknown
`guide_alert`	Unknown
`ip`	Unknown
`modified`	Instant
`modified_by`	Unknown
`modified_offline`	Instant
`name`	Unknown
`network_tag`	Unknown
`notes`	Unknown
`operation_account_id`	Unknown
`policy_type`	Unknown
`revokes`	Unknown
`start_date`	Instant
`status`	Unknown
`transitional`	Unknown

vehicle_combination_type_controller

Column	Type	Keys
`id`	Unknown	PK
`archived`	Unknown
`body_types`	Json
`description`	Unknown
`hauling_units`	Json
`name`	Unknown
`operation_account_id`	Unknown
`orders`	Unknown
`towed_units`	Json

access_network_category_mapping_controller_map_state_map_view_layer

Column	Type	Keys
`index`	Unknown	PK
`access_network_category_mapping_controller_id`	Unknown	PKFK
`filter_condition`	Json
`is_etl`	Unknown
`layer_id`	Unknown
`visibility`	Unknown

access_network_category_mapping_controller_network

Column	Type	Keys
`network_id`	Unknown	PK
`access_network_category_mapping_controller_id`	Unknown	PKFK
`created`	Instant
`created_by`	Unknown
`created_partner_account_id`	Unknown
`date_updated`	LocalDate
`description`	Unknown
`guide_alert`	Unknown
`ip`	Unknown
`modified`	Instant
`modified_by`	Unknown
`modified_offline`	Instant
`network_display_name`	Unknown
`network_name`	Unknown
`network_type`	Unknown
`non_osm_network_flag`	Unknown
`related_access_product_document_id`	Unknown
`related_network_id`	Unknown
`rich_description`	Unknown
`status`	Unknown
`w_kid`	Unknown

access_network_category_mapping_controller_vehicle_component_detail_product

Column	Type	Keys
`id`	Unknown	PK
`access_network_category_mapping_controller_access_network_category_id`	Unknown	PKFK
`access_network_category_mapping_controller_vehicle_component_detail_index`	Unknown	PKFK
`generic`	Unknown
`make`	Unknown
`model`	Unknown
`note`	Unknown
`pbs_approval_vehicle_mapping_ids`	Json

access_network_category_mapping_controller_vehicle_component_detail_param_engine_product

Column	Type	Keys
`id`	Unknown	PK
`access_network_category_mapping_controller_access_network_category_id`	Unknown	PKFK
`access_network_category_mapping_controller_vehicle_component_detail_index`	Unknown	PKFK
`engine_power`	Unknown
`engine_power_2`	Unknown
`engine_torque`	Unknown
`engine_torque_2`	Unknown

access_network_category_mapping_controller_vehicle_component_detail

Column	Type	Keys
`index`	Unknown	PK
`access_network_category_mapping_controller_access_network_category_id`	Unknown	PKFK
`access_network_category_mapping_controller_id`	Unknown	PKFK
`certification_method`	Json
`drive_ratios`	Unknown
`gearbox_ratios`	Unknown
`param_brake`	Json
`param_com_or_elig`	Json
`param_coupling`	Json
`param_driveline_auto`	Json
`param_driveline_manual`	Json
`param_driveline_peak_engine_torque`	Json
`param_mass`	Json
`param_other`	Json
`param_steer_axle_mass`	Json
`param_suspension`	Json
`param_tare`	Json
`param_tyre`	Json
`param_wheels_axles`	Json

access_network_category_mapping_controller_customer_vehicle

Column	Type	Keys
`id`	Unknown	PK
`access_network_category_mapping_controller_access_network_category_id`	Unknown	PKFK
`access_network_category_mapping_controller_id`	Unknown	PKFK
`a_id_maint`	Unknown
`a_id_mass`	Unknown
`a_label_maint`	Unknown
`a_label_mass`	Unknown
`a_vm_id_maint`	Unknown
`a_vm_id_mass`	Unknown
`amend`	Unknown
`axle_detail_locked`	Unknown
`code`	Unknown
`description`	Unknown
`ext_vehicle_component_id`	Unknown
`gross_combination_mass`	Unknown
`gross_trailer_mass`	Unknown
`gross_vehicle_mass`	Unknown
`idx`	Unknown
`inspected`	Unknown
`last_refreshed`	Unknown
`make`	Unknown
`model`	Unknown
`name`	Unknown
`registered_owner`	Unknown
`registration`	Unknown
`registration_end_date`	Instant
`registration_start_date`	Instant
`registration_status`	Unknown
`state`	Unknown
`status`	Unknown
`vehicle_component_id`	Unknown
`vehicle_id`	Unknown
`vin`	Unknown

access_network_category_mapping_controller_mass_limit_axle_group_mass_limit

Column	Type	Keys
`index`	Unknown	PK
`access_network_category_mapping_controller_access_network_category_id`	Unknown	PKFK
`access_network_category_mapping_controller_mass_limit_index`	Unknown	PKFK
`cml`	Unknown
`foot_note`	Unknown
`from_axle_group`	Unknown
`gml`	Unknown
`hml`	Unknown
`name`	Unknown
`qml`	Unknown
`to_axle_group`	Unknown

access_network_category_mapping_controller_mass_limit_spacing_mass_limit

Column	Type	Keys
`index`	Unknown	PK
`access_network_category_mapping_controller_access_network_category_id`	Unknown	PKFK
`access_network_category_mapping_controller_mass_limit_index`	Unknown	PKFK
`cml`	Unknown
`foot_note`	Unknown
`from_axle_group`	Unknown
`gml`	Unknown
`hml`	Unknown
`name`	Unknown
`qml`	Unknown
`to_axle_group`	Unknown

access_network_category_mapping_controller_mass_limit

Column	Type	Keys
`index`	Unknown	PK
`access_network_category_mapping_controller_access_network_category_id`	Unknown	PKFK
`config_mass_limits_cml`	Unknown
`config_mass_limits_foot_note`	Unknown
`config_mass_limits_from_axle_group`	Unknown
`config_mass_limits_gml`	Unknown
`config_mass_limits_hml`	Unknown
`config_mass_limits_name`	Unknown
`config_mass_limits_qml`	Unknown
`config_mass_limits_to_axle_group`	Unknown
`name`	Unknown

access_network_category_mapping_controller_access_network_category

Column	Type	Keys
`id`	Unknown	PK
`access_network_category_mapping_controller_id`	Unknown	PKFK
`adf`	Unknown
`alert`	Unknown
`archived`	Unknown
`code`	Unknown
`configuration_compliances`	Json
`configuration_eligibilities`	Json
`configuration_forward_projection`	Unknown
`configuration_has_euro_vi_mass_transfer_allowance`	Unknown
`configuration_height`	Unknown
`configuration_height_unladen`	Unknown
`configuration_id`	Unknown
`configuration_length`	Unknown
`configuration_length_unladen`	Unknown
`configuration_rear_overhang`	Unknown
`configuration_safer_freight_vehicles`	Unknown
`configuration_tare_mass`	Unknown
`configuration_total_mass`	Unknown
`configuration_wheelbase`	Unknown
`configuration_width`	Unknown
`configuration_width_unladen`	Unknown
`description`	Unknown
`filter_fields`	Json
`filter_keywords`	Json
`name`	Unknown
`operation_account_id`	Unknown
`parent`	Unknown
`states`	Json
`vehicle_component_set_archived`	Unknown
`vehicle_component_set_archived_2`	Unknown
`vehicle_component_set_code`	Unknown
`vehicle_component_set_component_fixed_from`	Unknown
`vehicle_component_set_ends`	Unknown
`vehicle_component_set_id`	Unknown
`vehicle_component_set_name`	Unknown
`vehicle_component_set_operation_account_id`	Unknown
`vehicle_component_set_short_name`	Unknown
`vehicle_component_set_type_application_type`	Json
`vehicle_component_set_type_archived`	Unknown
`vehicle_component_set_type_archived_2`	Unknown
`vehicle_component_set_type_body_type`	Unknown
`vehicle_component_set_type_code`	Unknown
`vehicle_component_set_type_example`	Unknown
`vehicle_component_set_type_hierarchy`	Unknown
`vehicle_component_set_type_id`	Unknown
`vehicle_component_set_type_is_pbs`	Unknown
`vehicle_component_set_type_name`	Unknown
`vehicle_component_set_type_operation_account_id`	Unknown
`vehicle_component_set_type_order_num`	Unknown
`vehicle_component_set_type_parent`	Unknown
`vehicle_component_set_type_short_name`	Unknown

access_network_category_mapping_controller

Column	Type	Keys
`id`	Unknown	PK
`vehicle_component_id`	Unknown	FK
`created`	Instant
`created_by`	Unknown
`draft`	Unknown
`ip`	Unknown
`map_state_basemap`	Unknown
`map_state_network_layers`	Json
`map_state_r_avoid_ferries`	Unknown
`map_state_r_avoid_intelligent_routing`	Unknown
`map_state_r_avoid_limited_access_road`	Unknown
`map_state_r_avoid_private_road`	Unknown
`map_state_r_avoid_toll_road`	Unknown
`map_state_r_avoid_unpaved_road`	Unknown
`map_state_r_driving`	Unknown
`map_state_r_oneway`	Unknown
`map_state_r_prefer_b_double`	Unknown
`map_state_r_through_traffic_prohibited`	Unknown
`map_state_r_turns`	Unknown
`modified`	Instant
`modified_by`	Unknown
`modified_offline`	Instant
`order_num`	Unknown

registration_share_vehicle_controller

Column	Type	Keys
`id`	Unknown	PK
`created`	Instant
`created_by`	Unknown
`customer_account_id`	Unknown
`description`	Unknown
`ip`	Unknown
`modified`	Instant
`modified_by`	Unknown
`modified_offline`	Instant
`name`	Unknown
`registration_share_id`	Unknown
`vehicle_id`	Unknown

registration_account_mapping_controller

Column	Type	Keys
`id`	Unknown	PK
`created`	Instant
`created_by`	Unknown
`customer_account_id`	Unknown
`entity_type_basic`	Unknown
`garage_address_postcode`	Unknown
`individual_date_of_birth`	Unknown
`ip`	Unknown
`modified`	Instant
`modified_by`	Unknown
`modified_offline`	Instant
`organisation_abn`	Unknown
`organisation_acn`	Unknown
`registration_id`	Unknown
`registration_individual_id`	Unknown
`registration_jurisdiction`	Unknown
`registration_organisation_id`	Unknown
`registration_plate_number`	Unknown

vehicle_component_type_controller

Column	Type	Keys
`id`	Unknown	PK
`archived`	Unknown
`code`	Unknown
`coupling_front`	Unknown
`coupling_rear`	Unknown
`example`	Unknown
`hierarchy`	Unknown
`is_modifiable`	Unknown
`name`	Unknown
`operation_account_id`	Unknown
`order_num`	Unknown
`osom`	Unknown
`parent`	Unknown
`short_name`	Unknown

vehicle_component_controller_spec_axle

Column	Type	Keys
`index`	Unknown	PK
`vehicle_component_controller_id`	Unknown	PKFK
`vehicle_component_controller_spec_axle_group_index`	Unknown	PKFK
`drive`	Unknown
`liftable`	Unknown
`liftable_optional`	Unknown
`spacing`	Unknown
`steer_optional`	Unknown
`tyre`	Unknown

vehicle_component_controller_spec_axle_group

Column	Type	Keys
`index`	Unknown	PK
`vehicle_component_controller_id`	Unknown	PKFK
`axle_mass`	Unknown
`axle_mass_unladen`	Unknown
`axle_spread`	Unknown
`certified_rf_suspension`	Unknown
`contact_width`	Unknown
`dual_tyre_spacing`	Unknown
`groups`	Unknown
`hydro_pneumatic`	Unknown
`load_sharing`	Unknown
`max_axle_mass`	Unknown
`max_suspension_axle_mass`	Unknown
`nsw_tonne_steer`	Unknown
`steer`	Unknown
`track_width`	Unknown
`tractive_effort_dist`	Unknown
`tyre_size`	Unknown
`tyre_size_txt`	Unknown

vehicle_component_controller

Column	Type	Keys
`id`	Unknown	PK
`vehicle_component_type_id`	Unknown	FK
`archived`	Unknown
`axle_group`	Unknown
`axles`	Unknown
`code`	Unknown
`component_type`	Unknown
`ends`	Unknown
`image_offset`	Unknown
`image_rear_offset`	Unknown
`motorised`	Unknown
`name`	Unknown
`operation_account_id`	Unknown
`short_name`	Unknown
`spec_body_type`	Unknown
`spec_can_reduce_total_mass`	Unknown
`spec_drawbar_length`	Unknown
`spec_fifth_wheel_offset`	Unknown
`spec_forward_overhang`	Unknown
`spec_forward_overhang_radius`	Unknown
`spec_gross_combination_mass`	Unknown
`spec_height_drawbar`	Unknown
`spec_height_front`	Unknown
`spec_height_front_floor`	Unknown
`spec_height_rear`	Unknown
`spec_height_rear_floor`	Unknown
`spec_length`	Unknown
`spec_loads`	Json
`spec_name`	Unknown
`spec_number_of_deck`	Unknown
`spec_rear_overhang`	Unknown
`spec_s_dimension`	Unknown
`spec_tare_mass`	Unknown
`spec_total_mass`	Unknown
`spec_tow_rear_overhang`	Unknown
`spec_volumetric`	Unknown
`spec_wheelbase`	Unknown
`spec_width`	Unknown
`start`	Unknown

accreditation_activity_template_controller_checklist

Column	Type	Keys
`index`	Unknown	PK
`accreditation_activity_template_controller_id`	Unknown	PKFK
`description`	Unknown
`label`	Unknown
`name`	Unknown
`options`	Json
`selected_option`	Unknown
`sub_label`	Unknown

accreditation_activity_template_controller_outcome_config

Column	Type	Keys
`index`	Unknown	PK
`accreditation_activity_template_controller_id`	Unknown	PKFK
`available_fields`	Json
`description`	Unknown
`event`	Unknown
`label`	Unknown
`outcome`	Unknown
`type`	Unknown

accreditation_activity_template_controller

Column	Type	Keys
`id`	Unknown	PK
`activity_fields`	Json
`activity_state`	Unknown
`activity_type`	Unknown
`application_type`	Unknown
`archived`	Unknown
`created`	Instant
`created_by`	Unknown
`ip`	Unknown
`key`	Unknown
`model_type`	Unknown
`modified`	Instant
`modified_by`	Unknown
`modified_offline`	Instant
`name`	Unknown
`notes`	Unknown
`notes_modifiable`	Unknown
`operations_account_id`	Unknown
`previous_workflow_state`	Unknown
`request_from`	Unknown
`request_to`	Unknown
`status`	Unknown
`subject`	Unknown
`subject_modifiable`	Unknown
`system_sub_type`	Unknown
`system_type`	Unknown
`type`	Unknown
`workflow_state`	Unknown

vehicle_component_connection_controller

Column	Type	Keys
`id`	Unknown	PK
`vehicle_component_type_id`	Unknown	FK
`archived`	Unknown
`can_attach`	Unknown
`operation_account_id`	Unknown
`vehicle_component_type_attach_id`	Unknown

arat_ref_vehicle_controller_file_list

Column	Type	Keys
`index`	Unknown	PK
`arat_ref_vehicle_controller_id`	Unknown	PKFK
`file_group_id`	Unknown
`name`	Unknown
`note`	Unknown
`original_file_name`	Unknown
`prefix`	Unknown
`size`	Unknown
`type`	Unknown
`uploaded`	Unknown
`uploaded_by`	Unknown
`version`	Unknown

arat_ref_vehicle_controller

Column	Type	Keys
`id`	Unknown	PK
`network_id`	Unknown	FK
`created`	Instant
`created_by`	Unknown
`design_vehicle`	Unknown
`ip`	Unknown
`load_parameter_combine_load`	Unknown
`load_parameter_concentrated_load_m`	Unknown
`load_parameter_concentrated_load_v`	Unknown
`load_parameter_contact_width`	Unknown
`load_parameter_lane_load_udl`	Unknown
`load_parameter_loading`	Unknown
`locked_vehicle`	Unknown
`modified`	Instant
`modified_by`	Unknown
`modified_offline`	Instant
`name`	Unknown
`operation_account_id`	Unknown
`partner_account_id`	Unknown
`ratio_parameter_negative_moment_ratio`	Unknown
`ratio_parameter_overall_ratio`	Unknown
`ratio_parameter_pier_reaction_ratio`	Unknown
`ratio_parameter_positive_moment_ratio`	Unknown
`ratio_parameter_shear_ratio`	Unknown
`use_load_parameter`	Unknown
`vehicle_component_set_type_id`	Unknown
`vehicle_description`	Unknown
`vehicle_parameters_d_la`	Unknown
`vehicle_parameters_l_lf`	Unknown
`vehicle_parameters_lane_type`	Unknown
`vehicle_parameters_note`	Unknown