j2735_ui
Tables (14)
bsm
- msg_id — INTEGER — Primary key
- no — BIGSERIAL
- msg_cnt — SMALLINT
- temp_id — BYTEA
- dsecond — INTEGER
- latitude — DOUBLE
- longitude — DOUBLE
- elevation — INTEGER
- speed — INTEGER
- heading — INTEGER
- steering_angle — SMALLINT
- accel_set_long — INTEGER
- accel_set_lat — INTEGER
- accel_set_vert — INTEGER
- accel_set_yaw — INTEGER
- brake_system_status — JSONB
- vehicle_width — INTEGER
- vehicle_length — INTEGER
- create_time — TIMESTAMPTZ
map
- msg_id — INTEGER — Primary key
- no — BIGSERIAL
- region_id — INTEGER
- name — VARCHAR(63)
- revision — INTEGER
- ref_point_lat — DOUBLE
- ref_point_long — DOUBLE
- ref_point_elev — INTEGER
- lane_width — INTEGER
- create_time — TIMESTAMPTZ
map_lane
- msg_id — INTEGER — Foreign key → map.msg_id
- no — BIGSERIAL
- lane_id — INTEGER
- lane_type — VARCHAR(20)
- lane_attributes — JSONB
- maneuvers — INTEGER
- node_list_xy — JSONB
- connects_to — JSONB
pvd
- msg_id — INTEGER — Primary key
- no — BIGSERIAL
- timestamp — INTEGER
- segment_id — INTEGER
- vehicle_id — JSONB
- latitude — DOUBLE
- longitude — DOUBLE
- elevation — INTEGER
- heading — INTEGER
- speed — INTEGER
- pos_accuracy — JSONB
- vehicle_type — JSONB
- create_time — TIMESTAMPTZ
pvd_snapshot
- msg_id — INTEGER — Foreign key → pvd.msg_id
- no — BIGSERIAL
- snapshot_id — INTEGER
- latitude — DECIMAL(10,7)
- longitude — DECIMAL(10,7)
- elevation — INTEGER
- heading — INTEGER
- speed — INTEGER
- pos_accuracy — JSONB
- vehicle_safety — JSONB
- vehicle_status — JSONB
rsa
- msg_id — INTEGER — Primary key
- no — BIGSERIAL
- msg_cnt — INTEGER
- timestamp — INTEGER
- itis_codes — INTEGER
- description — JSONB
- priority — INTEGER
- heading — INTEGER
- extent — INTEGER
- latitude — DOUBLE
- longitude — DOUBLE
- elevation — INTEGER
- speed — INTEGER
- heading_value — INTEGER
- pos_accuracy — JSONB
- time_confidence — INTEGER
- pos_confidence — JSONB
- speed_confidence — JSONB
- further_info_id — VARCHAR(2)
- create_time — TIMESTAMPTZ
spat
- msg_id — INTEGER — Primary key
- no — BIGSERIAL
- region_id — INTEGER
- revision — INTEGER
- status — JSONB
- moy — INTEGER
- time_stamp — INTEGER
- create_time — TIMESTAMPTZ
spat_movement_state
- no — BIGSERIAL — Primary key
- msg_id — INTEGER — Foreign key → spat.msg_id
- movement_id — INTEGER
- signal_group — INTEGER
- state_time_speed — JSONB
- maneuver_assist_list — JSONB
tim
- msg_id — INTEGER — Primary key
- no — BIGSERIAL
- msg_cnt — INTEGER
- timestamp — INTEGER
- packet_id — VARCHAR(9)
- url_base — VARCHAR(45)
- create_time — TIMESTAMPTZ
tim_frame
- frame_id — INTEGER — Primary key
- msg_id — INTEGER — Foreign key → tim.msg_id
- no — BIGSERIAL
- frame_type — VARCHAR(20)
- start_time — INTEGER
- duration — INTEGER
- priority — SMALLINT
- content_type — VARCHAR(20)
- itis_codes — INTEGER
- description — JSONB
- content — JSONB
- url_short — VARCHAR(15)
tim_location
- location_id — INTEGER — Primary key
- frame_id — INTEGER — Foreign key → tim_frame.frame_id
- no — BIGSERIAL
- location_type — VARCHAR(20)
- name — VARCHAR(63)
- anchor_lat — DECIMAL(10,7)
- anchor_long — DECIMAL(10,7)
- anchor_elev — INTEGER
- lane_width — INTEGER
- direction — INTEGER
tim_location_circle
- location_id — INTEGER — Foreign key → tim_location.location_id
- no — BIGSERIAL
- circle_id — INTEGER
- radius — INTEGER
- units — VARCHAR(20)
tim_location_path
- location_id (location_id2) — INTEGER — Foreign key → tim_location.location_id
- no — BIGSERIAL
- path_id — INTEGER
- scale — INTEGER
- offset_type — VARCHAR(10)
- node_list — JSONB
tim_location_region
- location_id — INTEGER — Foreign key → tim_location.location_id
- no — BIGSERIAL
- region_id — INTEGER
- region_points — JSONB