1. auth_group
No Field Name Type Size Description Null Key
1idNumber-1  
2nameText80  

2. auth_group_permissions
No Field Name Type Size Description Null Key
1idNumber-1  
2group_idNumber-1  
3permission_idNumber-1  

3. auth_permission
No Field Name Type Size Description Null Key
1idNumber-1  
2nameText255  
3content_type_idNumber-1  
4codenameText100  

4. auth_user
No Field Name Type Size Description Null Key
1idNumber-1  
2passwordText128  
3last_loginDate/Time16  
4is_superuserYes/No-1  
5usernameText30  
6first_nameText30  
7last_nameText30  
8emailText254  
9is_staffYes/No-1  
10is_activeYes/No-1  
11date_joinedDate/Time16  

5. auth_user_groups
No Field Name Type Size Description Null Key
1idNumber-1  
2user_idNumber-1  
3group_idNumber-1  

6. auth_user_user_permissions
No Field Name Type Size Description Null Key
1idNumber-1  
2user_idNumber-1  
3permission_idNumber-1  

7. corsheaders_corsmodel
No Field Name Type Size Description Null Key
1idNumber-1  
2corsText255  

8. django_admin_log
No Field Name Type Size Description Null Key
1idNumber-1  
2action_timeDate/Time16  
3object_idMemo-1  
4object_reprText200  
5action_flagNumber-1  
6change_messageMemo-1  
7content_type_idNumber-1  
8user_idNumber-1  

9. django_content_type
No Field Name Type Size Description Null Key
1idNumber-1  
2app_labelText100  
3modelText100  

10. django_migrations
No Field Name Type Size Description Null Key
1idNumber-1  
2appText255  
3nameText255  
4appliedDate/Time16  

11. django_session
No Field Name Type Size Description Null Key
1session_keyText40  
2session_dataMemo-1  
3expire_dateDate/Time16  

12. location_checkpointlocation
No Field Name Type Size Description Null Key
1idNumber-1  
2nameText100  
3latitudeNumber-1  
4longitudeNumber-1  
5short_descriptionText200  
6radiusNumber-1  
7point_typeText1  
8created_dateDate/Time16  

13. location_location
No Field Name Type Size Description Null Key
1idNumber-1  
2gps_dateDate/Time16  
3created_dateDate/Time16  
4latitudeNumber-1  
5longitudeNumber-1  
6vehicle_idNumber-1  
7status_descriptionText100  

14. spatial_ref_sys
No Field Name Type Size Description Null Key
1sridNumber-1  
2auth_nameText256  
3auth_sridNumber-1  
4srtextText2048  
5proj4textText2048  

15. staff_driver
No Field Name Type Size Description Null Key
1idNumber-1  
2is_activeYes/No-1  
3date_joinedDate/Time16  
4addressMemo-1  
5short_descriptionMemo-1  
6user_idNumber-1  

16. staff_profile
No Field Name Type Size Description Null Key
1idNumber-1  
2roleText1  
3user_idNumber-1  

17. vehicle_alertconfig
No Field Name Type Size Description Null Key
1idNumber-1  
2alert_valueNumber-1  
3alert_type_idNumber-1  

18. vehicle_alerttype
No Field Name Type Size Description Null Key
1idNumber-1  
2alt_nameText100  
3alt_levelText10  
4alt_codeText2  

19. vehicle_cartype
No Field Name Type Size Description Null Key
1idNumber-1  
2nameText100  
3short_descriptionText200  
4car_idNumber-1  

20. vehicle_checktransport
No Field Name Type Size Description Null Key
1idNumber-1  
2cts_gps_idText50  
3cts_start_datetimeDate/Time16  
4cts_end_datetimeDate/Time16  
5cts_monitorYes/No-1  
6cts_imageText100  
7cts_between_datetimeDate/Time16  
8cts_image1Text100  
9cts_image2Text100  
10cts_manifestText50  
11cts_facname_betweenText500  
12cts_facname_endText500  
13cts_facname_startText500  
14cts_facreg_betweenText500  
15cts_facreg_endText500  
16cts_facreg_startText500  
17cts_end_reasonText500  
18cts_crashText10  

21. vehicle_company
No Field Name Type Size Description Null Key
1idNumber-1  
2comp_tax_idText20  
3comp_name_thText200  
4comp_name_enText200  
5comp_typeText1  

22. vehicle_companyaddress
No Field Name Type Size Description Null Key
1idNumber-1  
2comp_add_noText50  
3comp_add_mooText100  
4comp_add_roadText100  
5comp_add_tumbonText100  
6comp_add_aumperText100  
7comp_add_provinceText100  
8comp_add_zipcodeText100  
9comp_add_telText100  
10comp_add_faxText100  

23. vehicle_crashrecord
No Field Name Type Size Description Null Key
1idNumber-1  
2facregText100  
3facnameText100  
4created_atDate/Time16  
5updated_atDate/Time16  
6old_gps_idText100  
7old_manifest_idText100  
8old_manifest_imgText100  
9latitudeNumber-1  
10longitudeNumber-1  
11reasonText250  
12new_manifest_imgText100  

24. vehicle_currenttsinfo
No Field Name Type Size Description Null Key
1idNumber-1  
2crt_tnsinfo_id_idNumber-1  
3crt_wtr_id_idNumber-1  
4status_lostYes/No-1  
5status_riskYes/No-1  
6status_stop_overtimeYes/No-1  
7created_atDate/Time16  
8stop_overtime_datetimeDate/Time16  
9updated_atDate/Time16  

25. vehicle_dataalert
No Field Name Type Size Description Null Key
1idNumber-1  
2dal_alt_id_idNumber-1  
3dal_tnsinfo_id_idNumber-1  
4dal_wtr_id_idNumber-1  
5created_atDate/Time16  
6activeYes/No-1  
7finished_atDate/Time16  

26. vehicle_mailgroup
No Field Name Type Size Description Null Key
1idNumber-1  
2first_nameText50  
3last_nameText100  
4emailText254  
5created_atDate/Time16  
6alert_type_idNumber-1  
7company_idNumber-1  

27. vehicle_manifest
No Field Name Type Size Description Null Key
1idNumber-1  
2mnf_noText50  
3mnf_weightNumber-1  
4mnf_start_datetimeDate/Time16  
5mnf_end_datetimeDate/Time16  
6mnf_descMemo-1  
7mnf_comp_id_wg_idNumber-1  
8mnf_comp_id_wp_idNumber-1  
9mnf_comp_id_wt_idNumber-1  
10mnf_wty_id_idNumber-1  
11wtr_id_idNumber-1  

28. vehicle_provider
No Field Name Type Size Description Null Key
1idNumber-1  
2pv_nameText100  
3pv_shortnameText50  
4pv_officialIDText50  
5pv_addressText500  
6pv_revenueNoText50  
7pv_contactText50  
8pv_telText50  
9pv_emailText50  
10pv_webText50  
11pv_gpsModelText100  
12pv_specialFuncText500  
13pv_ipText20  
14pv_sendingYes/No-1  
15pv_backDateText10  
16pv_storageText10  
17pv_imageText100  

29. vehicle_risklocation
No Field Name Type Size Description Null Key

30. vehicle_risklocationtype
No Field Name Type Size Description Null Key
1idNumber-1  
2nameText100  
3noteMemo-1  
4updated_atDate/Time16  
5created_atDate/Time16  

31. vehicle_routeprocess
No Field Name Type Size Description Null Key
1idNumber-1  
2rtp_roadnameText50  
3rtp_tumbonText50  
4rtp_aumperText50  
5rtp_provinceText50  
6rtp_datetimeDate/Time16  
7rtp_wtr_id_idNumber-1  

32. vehicle_today
No Field Name Type Size Description Null Key
1provider_nameText100  
2owner_nameText100  
3countNumber-1  
4create_atText10  

33. vehicle_toxictype
No Field Name Type Size Description Null Key
1idNumber-1  
2nameText100  
3short_descriptionText200  
4carry_idNumber-1  

34. vehicle_transportinformation
No Field Name Type Size Description Null Key
1idNumber-1  
2tnsinfo_gps_idText50  
3tnsinfo_speedNumber-1  
4tnsinfo_datetimeDate/Time16  
5tnsinfo_created_atDate/Time16  
6tnsinfo_latitudeNumber-1  
7tnsinfo_longitudeNumber-1  
8tnsinfo_readYes/No-1  
9data_statusNumber-1  
10engine_statusNumber-1  
11gps_statusNumber-1  
12receive_datetimeDate/Time16  

35. vehicle_userright
No Field Name Type Size Description Null Key
1idNumber-1  
2usernameText100  
3edit_truckYes/No-1  
4edit_riskYes/No-1  
5edit_userYes/No-1  
6edit_providerYes/No-1  
7nameText100  

36. vehicle_vehicle
No Field Name Type Size Description Null Key
1vehicle_idNumber-1  
2date_createdDate/Time16  
3driver_idNumber-1  

37. vehicle_vehiclealert
No Field Name Type Size Description Null Key
1alert_idNumber-1  
2alert_reasonText1000  
3alert_latNumber-1  
4alert_longNumber-1  
5date_createdDate/Time16  
6vehicle_id_idNumber-1  

38. vehicle_vehicledetail
No Field Name Type Size Description Null Key
1idNumber-1  
2companyText100  
3car_idText20  
4gps_idText20  
5vehicle_idNumber-1  

39. vehicle_vehiclestatushistory
No Field Name Type Size Description Null Key
1idNumber-1  
2vehicle_statusText50  
3date_createdDate/Time16  
4vehicle_idNumber-1  

40. vehicle_wastelicense
No Field Name Type Size Description Null Key
1wlc_created_dateDate/Time16  
2idNumber-1  
3wlc_noText50  
4wlc_weightNumber-1  
5wlc_start_datetimeDate/Time16  
6wlc_end_datetimeDate/Time16  
7wlc_updated_dateDate/Time16  
8wlc_descMemo-1  
9wlc_comp_id_idNumber-1  
10wlc_wtr_id_idNumber-1  
11wlc_wtt_id_idNumber-1  
12wlc_wty_id_idNumber-1  

41. vehicle_wastetruck
No Field Name Type Size Description Null Key
1idNumber-1  
2wtr_gps_idText50  
3wtr_plate_idText50  
4wtr_plate_provinceText100  
5owner_nameText100  
6truck_typesText500  
7waste_types_idNumber-1  
8owner_telephoneText100  
9parking_placeText100  
10provider_nameText100  
11remarkMemo-1  
12wpText100  
13created_atDate/Time16  
14updated_atDate/Time16  

42. vehicle_wastetruckhistory
No Field Name Type Size Description Null Key
1idNumber-1  
2wtr_gps_idText50  
3wtr_created_atDate/Time16  
4wtr_id_idNumber-1  

43. vehicle_wastetrucktype
No Field Name Type Size Description Null Key
1idNumber-1  
2wtt_nameText100  
3wtt_wheel_numNumber-1  
4wtt_whee_tireNumber-1  

44. vehicle_wastetype
No Field Name Type Size Description Null Key
1idNumber-1  
2wty_noText50  
3wty_nameText100  

45. geography_columns
No Field Name Type Size Description Null Key
1f_table_catalogMemo-1  
2f_table_schemaMemo-1  
3f_table_nameMemo-1  
4f_geography_columnMemo-1  
5coord_dimensionNumber-1  
6sridNumber-1  
7typeMemo-1  

46. geometry_columns
No Field Name Type Size Description Null Key
1f_table_catalogText256  
2f_table_schemaMemo-1  
3f_table_nameMemo-1  
4f_geometry_columnMemo-1  
5coord_dimensionNumber-1  
6sridNumber-1  
7typeText30  

47. raster_columns
No Field Name Type Size Description Null Key

48. raster_overviews
No Field Name Type Size Description Null Key
1o_table_catalogMemo-1  
2o_table_schemaMemo-1  
3o_table_nameMemo-1  
4o_raster_columnMemo-1  
5r_table_catalogMemo-1  
6r_table_schemaMemo-1  
7r_table_nameMemo-1  
8r_raster_columnMemo-1  
9overview_factorNumber-1