=== DATABASE STRUCTURE VIEWER (READ ONLY) === 1. DAFTAR TABEL: ================ - admin - api_tokens - AuditTrail - customer - customerAdmin - customerHistoryLogin - customerLicense - customerLogin - customertbUserGroup - customerViewMap - data - DataTelemetry - distance - dtKendaraan - dtProduk - dtproperties - fuel - HistoryTabel - infAlertSetting - infAlertSettingOli - infHistIMEI - infHistoryAki - infHistoryBan - infHistoryKIR - infHistoryLogin - infHistoryOli - infHistoryStnkPajak - infJenisKendaraan - infRangka - infSettingKendaraan - infTotalKMPerHari - infUserLevelPermissions - infUserLevels - KimGeoCache - KimRawData - KimReport - KimReportData - KimTabungADC - KimTelemetry - KimTelemetryUsers - KimTelemetryUsersGroup - NewDevice - POI - RawKimTelemetry - samator - sysdiagrams - tbADC - tbAlarm - tbAlarmType - tbAlertGeofence - tbCommand - tbCustomer - tbDriver - tbEnterLocationHistory - tbFirmware - tbHMSampoerna - tbJob - tbLatestAlarm - tblatestlocation - tbLatestLockLog - tbLatestLockStatus - tbLicensePIC - tbLicenseTran - tbLicenseTran_20231221 - tblocationName - tblocations - tbLock - tbLockAlarm - tbLockHistory - tbLockLog - tbLockMatrix - tbLockStatus - tbMilotech - tbOrder - tbOrderDetail - tbPetrol - tbPoints - tbSamatorSms - tbSAP - tbSAP1 - tbSAPPlant - tbSelectedAlarm - tbSendCommand - tbsmsauto - tbSystems - tbTelemetry - tbTelemetryName - tbTempHum - tbTransponder - tbTruckType - tbUserGroup - tbUserGroupMulti - tbUsers - tbUserShapes - tbVehicleType - ttxx - ViewMap 2. STRUKTUR TABEL: admin ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- user varchar 50 NO - NO password varchar 50 NO - NO level int - YES - NO id int - NO - YES SAMPLE DATA (3 rows): -------------------------------------------------- user password level id ---------------------------------------------------------------- admin admin165 -1 1 samator KimKim165 1 2 agi_semarang 123456 2 109 ================================================================================ 2. STRUKTUR TABEL: api_tokens ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- id int - NO - YES username varchar 15 NO - NO token varchar 64 NO - NO expired_at datetime - NO - NO created_at datetime - YES (getdate()) NO SAMPLE DATA (3 rows): -------------------------------------------------- id username token expired_at created_at -------------------------------------------------------------------------------- 38 agipelintung1 9afc2397afeae7 2026-04-22 00: 2026-04-15 00: ================================================================================ 2. STRUKTUR TABEL: AuditTrail ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- Id int - NO - YES DateTime datetime - NO - NO Script nvarchar 255 YES - NO User nvarchar 255 YES - NO Action nvarchar 255 YES - NO Table nvarchar 255 YES - NO Field nvarchar 255 YES - NO KeyValue nvarchar -1 YES - NO OldValue nvarchar -1 YES - NO NewValue nvarchar -1 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- Id DateTime Script User Action Table Field KeyValue OldValue NewValue ---------------------------------------------------------------------------------------------------------------------------------------------------------------- 1 2025-12-23 21: /login.php kim login 192.168.1.232 2 2025-12-23 21: /logout.php kim logout 192.168.1.232 3 2025-12-23 21: /login.php agipgfs login 192.168.1.232 ================================================================================ 2. STRUKTUR TABEL: customer ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- id int - NO - YES Name varchar 255 YES - NO Mobile varchar 255 YES - NO Email varchar 255 YES - NO Address text 2147483647 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: customerAdmin ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- user varchar 50 NO - NO password varchar 50 NO - NO level int - YES - NO id int - NO - YES id_parent int - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- user password level id id_parent -------------------------------------------------------------------------------- samator 123456 1 2 -1 ================================================================================ 2. STRUKTUR TABEL: customerHistoryLogin ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- DateTime datetime - NO - NO User varchar 255 YES - NO IP varchar 255 YES - NO Description varchar 255 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- DateTime User IP Description ---------------------------------------------------------------- 2015-09-12 18: rodhi - 114.121.238.24 login 2015-09-22 22: cocacola - 114.120.236.32 login 2023-01-25 10: cocacola - 192.168.1.232 login ================================================================================ 2. STRUKTUR TABEL: customerLicense ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- id int - NO - YES id_customerLogin int - NO - NO id_Group int - NO - NO license varchar 25 NO - NO imei bigint - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- id id_customerLogin id_Group license imei -------------------------------------------------------------------------------- 13 1 552 B 9749 OH NULL 14 1 552 W 9802 F NULL ================================================================================ 2. STRUKTUR TABEL: customerLogin ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- UserLogin varchar 255 NO - NO PasswordLogin varchar 255 NO - NO FullName varchar 255 NO - NO Description varchar 255 YES - NO Active varchar 5 NO - NO id int - NO - YES SAMPLE DATA (3 rows): -------------------------------------------------- UserLogin PasswordLogin FullName Description Active id ------------------------------------------------------------------------------------------------ cocacola 123456 PT Coca Cola NULL Yes 1 ================================================================================ 2. STRUKTUR TABEL: customertbUserGroup ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- userGroupID int - NO - YES des varchar 100 NO - NO minNo int - NO - NO maxNo int - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- userGroupID des minNo maxNo ---------------------------------------------------------------- 552 Samator Bekasi 42420001 42424000 553 AGI Pulogadung 42424001 42428000 ================================================================================ 2. STRUKTUR TABEL: customerViewMap ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- userGroupID int - YES - NO userName varchar 15 NO - NO latitude float - YES - NO longitude float - YES - NO zoom int - YES - NO GMT varchar 5 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: data ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- Col001 bigint - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- Col001 ---------------- 35511700968259 35511700968439 35511700968267 ================================================================================ 2. STRUKTUR TABEL: DataTelemetry ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- TID bigint - NO - NO ReceiveTime datetime - YES - NO Time datetime - YES - NO data varchar 50 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: distance ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- userName char 255 NO - NO locationName char 255 NO - NO lat float - NO - NO lon float - NO - NO distanceTime datetime - YES - NO tid bigint - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- userName locationName lat lon distanceTime tid ------------------------------------------------------------------------------------------------ depotcepu A. Yani -6.96410399999 111.42292 NULL NULL depotcepu Bangkle -6.97150699999 111.442441 NULL NULL depotcepu Kota Cepu -7.153861 111.581829 NULL NULL ================================================================================ 2. STRUKTUR TABEL: dtKendaraan ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- License varchar 50 NO - NO Tahun int - YES - NO Jenis_Kendaraan varchar 50 YES - NO Produk varchar 50 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- License Tahun Jenis_Kendaraan Produk ---------------------------------------------------------------- 0 NULL NULL AE 8078 GA 2005 Engkel NULL AE 8380 FB 2016 Double NULL ================================================================================ 2. STRUKTUR TABEL: dtProduk ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- produk varchar 10 NO - NO warna varchar 255 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- produk warna -------------------------------- LAR 255,66,0,0.7 LIN 255, 247, 0, 0 LOX 37,172,216,0.7 ================================================================================ 2. STRUKTUR TABEL: dtproperties ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- id int - NO - YES objectid int - YES - NO property varchar 64 NO - NO value varchar 255 YES - NO uvalue nvarchar 255 YES - NO lvalue image 2147483647 YES - NO version int - NO ((0)) NO SAMPLE DATA (3 rows): -------------------------------------------------- id objectid property value uvalue lvalue version ---------------------------------------------------------------------------------------------------------------- 1 1 DtgSchemaOBJEC NULL NULL NULL 0 2 1 DtgSchemaGUID {EA3E6268-D998 {EA3E6268-D998 NULL 0 3 1 DtgSchemaNAME DIAGRAM1 DIAGRAM1 NULL 0 ================================================================================ 2. STRUKTUR TABEL: fuel ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- id bigint - NO - YES Nopol varchar 100 YES - NO Nama_Supir varchar 255 YES - NO Tgl date - YES - NO Jumlah_Liter int - YES - NO Harga int - YES - NO Odometer int - YES - NO Catatan varchar -1 YES - NO Tgl_Tambah datetime - YES - NO Tgl_Edit datetime - YES - NO Edit_By varchar 255 YES - NO Edit_By_ID int - YES - NO BBM varchar 255 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: HistoryTabel ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- tid bigint - YES - NO arah varchar 25 YES - NO mesin bit - YES - NO waktu datetime - NO - NO kecepatan decimal - YES - NO jarak decimal - YES - NO lat float - YES - NO lon float - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: infAlertSetting ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- UserGroup int - NO - NO sms varchar 255 YES - NO email varchar 255 YES - NO AlertKIR int - YES - NO AlertSTNKPajak int - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- UserGroup sms email AlertKIR AlertSTNKPajak -------------------------------------------------------------------------------- 553 085755519556, rodhi@outlook. 15 30 611 085755519556, rodhi@outlook. 15 30 ================================================================================ 2. STRUKTUR TABEL: infAlertSettingOli ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- UserGroup int - YES - NO AlertOli int - YES - NO id int - NO - YES JenisKendaraan int - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- UserGroup AlertOli id JenisKendaraan ---------------------------------------------------------------- 553 10000 1 1 553 12000 2 2 553 15000 3 3 ================================================================================ 2. STRUKTUR TABEL: infHistIMEI ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- id bigint - NO - YES idRangka int - NO - NO imei bigint - NO - NO tgl_Create date - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- id idRangka imei tgl_Create ---------------------------------------------------------------- 39 11 35152501843511 2014-03-17 40 12 35152501843599 2014-03-17 41 13 35152501845356 2014-03-17 ================================================================================ 2. STRUKTUR TABEL: infHistoryAki ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- idRangka int - YES - NO Tgl date - YES - NO Keterangan varchar 255 YES - NO id int - NO - YES SAMPLE DATA (3 rows): -------------------------------------------------- idRangka Tgl Keterangan id ---------------------------------------------------------------- 12 2014-11-27 Ganti Aki baru 3 ================================================================================ 2. STRUKTUR TABEL: infHistoryBan ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- id bigint - NO - YES date date - YES - NO noBan int - NO - NO Keterangan text 2147483647 YES - NO idRangka int - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- id date noBan Keterangan idRangka -------------------------------------------------------------------------------- 12 2014-04-10 2 NULL 62 ================================================================================ 2. STRUKTUR TABEL: infHistoryKIR ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- id bigint - NO - YES tgl date - YES - NO idRangka int - NO - NO MasaBerlaku(Bulan) int - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- id tgl idRangka MasaBerlaku(Bulan) ---------------------------------------------------------------- 39 2014-03-18 97 NULL 40 2014-04-08 62 12 ================================================================================ 2. STRUKTUR TABEL: infHistoryLogin ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- DateTime datetime - NO - NO User varchar 255 YES - NO IP varchar 255 YES - NO Description varchar 255 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- DateTime User IP Description ---------------------------------------------------------------- 2026-04-23 01: agimedanfs - A 192.168.1.232 login 2026-05-13 23: sgicikarang - 192.168.1.232 login 2026-05-13 23: sgicikarang - 192.168.1.232 login ================================================================================ 2. STRUKTUR TABEL: infHistoryOli ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- id bigint - NO - YES license varchar 25 YES - NO tgl_Ganti date - YES - NO idRangka int - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- id license tgl_Ganti idRangka ---------------------------------------------------------------- 41 NULL 2014-03-18 97 ================================================================================ 2. STRUKTUR TABEL: infHistoryStnkPajak ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- id int - NO - YES license varchar 15 NO - NO stnk date - YES - NO pajakTahunKe1 date - YES - NO pajakTahunKe2 date - YES - NO pajakTahunKe3 date - YES - NO pajakTahunKe4 date - YES - NO pajakTahunKe5 date - YES - NO idRangka int - NO - NO MasaBerlaku(Bulan) int - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- id license stnk pajakTahunKe1 pajakTahunKe2 pajakTahunKe3 pajakTahunKe4 pajakTahunKe5 idRangka MasaBerlaku(Bulan) ---------------------------------------------------------------------------------------------------------------------------------------------------------------- 62 W 9832 X NULL NULL NULL NULL NULL NULL 10 NULL 63 L 8022 GQ NULL NULL NULL NULL NULL NULL 11 NULL 64 B 9102 FU NULL NULL NULL NULL NULL NULL 12 NULL ================================================================================ 2. STRUKTUR TABEL: infJenisKendaraan ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- id int - NO - YES jenisKendaraan varchar 100 YES - NO image varchar 100 YES - NO jumlahBan int - YES - NO Code varchar 100 YES - NO Photo varchar 255 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- id jenisKendaraan image jumlahBan Code Photo ------------------------------------------------------------------------------------------------ 1 Engkel single ban.jpg 6 E001 engkel truck.j 2 Trailer trailer.jpg 14 T001 trailer-.jpg 4 Tronton tronton.jpg 10 TR001 tronton-.jpg ================================================================================ 2. STRUKTUR TABEL: infRangka ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- id bigint - NO - YES No_Rangka varchar 100 YES - NO Jenis_Kendaraan int - YES - NO Max_KM int - YES - NO User Group int - YES - NO No_Mesin varchar 100 YES - NO IMEI bigint - YES - NO LICENSE varchar 25 YES - NO Tgl_Entry date - YES - NO Tahun int - YES - NO Produk varchar 255 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- id No_Rangka Jenis_Kendaraan Max_KM User Group No_Mesin IMEI LICENSE Tgl_Entry Tahun Produk -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 10 W 9832 X NULL NULL 542 NULL 35477603773885 W 9832 X NULL NULL NULL 11 L 8022 GQ NULL NULL 538 NULL 35250309062682 L 8022 GQ NULL NULL NULL 12 B 9102 FU NULL NULL 542 NULL NULL B 9102 FU NULL NULL NULL ================================================================================ 2. STRUKTUR TABEL: infSettingKendaraan ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- license varchar 10 NO - NO jenisKendaraan_id int - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: infTotalKMPerHari ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- rangka_id int - YES - NO TotalKM real - YES - NO date date - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: infUserLevelPermissions ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- UserLevelID int - NO - NO TableName nvarchar 255 NO - NO Permission int - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- UserLevelID TableName Permission ------------------------------------------------ 0 {F57B511D-2ED0 0 0 {F57B511D-2ED0 0 0 {F57B511D-2ED0 0 ================================================================================ 2. STRUKTUR TABEL: infUserLevels ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- UserLevelID int - NO - NO UserLevelName nvarchar 255 NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- UserLevelID UserLevelName -------------------------------- -1 Administrator 0 Default 1 Pusat ================================================================================ 2. STRUKTUR TABEL: KimGeoCache ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- lat float - YES - NO lon float - YES - NO address varchar 255 YES - NO id int - NO - YES SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: KimRawData ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- TID bigint - NO - NO Data1 varchar 20 YES - NO Data2 varchar 20 YES - NO Data3 varchar 20 YES - NO Data4 varchar 20 YES - NO Data5 varchar 20 YES - NO Data6 varchar 20 YES - NO Data7 varchar 20 YES - NO Data8 varchar 20 YES - NO Data9 varchar 20 YES - NO Data10 varchar 20 YES - NO Data11 varchar 20 YES - NO Data12 varchar 20 YES - NO Data13 varchar 20 YES - NO Data14 varchar 20 YES - NO Data15 varchar 20 YES - NO Data16 varchar 20 YES - NO Data17 varchar 20 YES - NO Data18 varchar 20 YES - NO Data19 varchar 20 YES - NO Data20 varchar 20 YES - NO ReceiveTime datetime - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: KimReport ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- id int - NO - YES contact varchar 150 NO - NO ReportDay tinyint - NO - NO ReportWarning tinyint - NO - NO Name varchar 150 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- id contact ReportDay ReportWarning Name -------------------------------------------------------------------------------- 1 telemetry@myso 1 1 Telemetry 2 dukimnet@yahoo 1 1 Bos Besar 3 fiqih@mysolusi 1 1 Bos Besar ================================================================================ 2. STRUKTUR TABEL: KimReportData ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- id int - NO - YES idKimReport int - NO - NO TIDdataTelemetry varchar 255 YES - NO status tinyint - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- id idKimReport TIDdataTelemetry status ---------------------------------------------------------------- 1 1 35958501383242 20 2 1 35152501726462 0 4 2 35152501726462 0 ================================================================================ 2. STRUKTUR TABEL: KimTabungADC ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- DataHex char 2 NO - NO DatammH2O varchar 7 NO - NO Tabung varchar 5 NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- DataHex DatammH2O Tabung ------------------------------------------------ 2E 250.48 5120 2F 287.65 5120 30 324.81 5120 ================================================================================ 2. STRUKTUR TABEL: KimTelemetry ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- TID bigint - NO - NO Lat float - NO - NO Lng float - NO - NO Tabung int - YES - NO Zoom int - YES - NO Label nchar 50 YES - NO Description ntext 1073741823 YES - NO IconUrl nchar 255 YES - NO CustomerID int - NO - NO StartTime datetime - NO (((2012)-(1))-(1)) NO EndTime datetime - NO (((2012)-(1))-(1)) NO SAMPLE DATA (3 rows): -------------------------------------------------- TID Lat Lng Tabung Zoom Label Description IconUrl CustomerID StartTime EndTime -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 35958501383242 -7.69919599999 112.6978 5120 15 PT HM Sampoern NULL NULL 56820001 2012-01-01 00: 2015-01-01 00: 35152501726462 -7.51543700000 112.4266619999 6400 16 PT Sunrise Ste NULL NULL 56820001 2012-01-01 00: 2015-01-01 00: ================================================================================ 2. STRUKTUR TABEL: KimTelemetryUsers ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- UserName varchar 20 NO - NO PassWord varchar 200 NO - NO CompanyName varchar 200 NO - NO Lat float - NO ((0)) NO Lng float - NO ((0)) NO TID bigint - NO ((0)) NO Tabung int - NO ((0)) NO zoom int - NO ((16)) NO SAMPLE DATA (3 rows): -------------------------------------------------- UserName PassWord CompanyName Lat Lng TID Tabung zoom -------------------------------------------------------------------------------------------------------------------------------- anekagas 10470c3b4b1fed PT HM Sampoern -7.69919599999 112.6978 35958501383242 5120 15 bambe 10470c3b4b1fed PT Sunrise Ste -7.51543700000 112.4266619999 35152501726462 6400 16 dukim 10470c3b4b1fed - -7.0 110.0 0 0 15 ================================================================================ 2. STRUKTUR TABEL: KimTelemetryUsersGroup ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- id int - NO - YES UserName varchar 20 NO - NO des varchar 100 NO - NO minNo int - NO - NO maxNo int - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- id UserName des minNo maxNo -------------------------------------------------------------------------------- 18 dukim Super Administ 1 2147483646 19 anekagas PT HM Sampoern 56820001 56824000 21 bambe PT Sunrise Ste 56820001 56824000 ================================================================================ 2. STRUKTUR TABEL: NewDevice ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- tid bigint - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- tid ---------------- 35185604060381 35185604061327 35185604061342 ================================================================================ 2. STRUKTUR TABEL: POI ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- lat float - NO - NO lon float - NO - NO nama char 255 NO - NO alamat char 255 YES - NO region char 255 YES - NO kota char 255 YES - NO propinsi char 255 YES - NO telp1 char 50 YES - NO telp2 char 50 YES - NO tipe char 50 YES - NO lainlain char 250 YES - NO diskripsi char 1000 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- lat lon nama alamat region kota propinsi telp1 telp2 tipe lainlain diskripsi ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -8.70152833333 115.18512 ASMO BALI NULL NULL NULL NULL 0361-48360 NULL ASMO NULL ASMO Area Bali -8.18025333333 113.710595 ASMO JEMBER NULL NULL NULL NULL NULL ASMO NULL ASMO Area Jemb -7.752535 113.2272849999 ASMO PROBOLING NULL NULL NULL NULL 0335-427119 NULL ASMO NULL ASMO Area Prob ================================================================================ 2. STRUKTUR TABEL: RawKimTelemetry ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- TID bigint - NO - NO lat float - YES - NO lon float - YES - NO date float - YES - NO hex1 float - YES - NO hex2 float - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: samator ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- id_samator int - NO - YES lat float - NO - NO lng float - NO - NO nama varchar 50 NO - NO tipe varchar 50 NO - NO minCapacity float - NO - NO maxCapacity float - NO - NO latestValue float - YES - NO latestDateTime datetime - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- id_samator lat lng nama tipe minCapacity maxCapacity latestValue latestDateTime ------------------------------------------------------------------------------------------------------------------------------------------------ 1 -6.39991890000 107.460022 Cikampek lin 0.0 100.0 10.0 2011-01-17 12: 2 -6.47088009999 108.2977295 Jatibarang lox 0.0 100.0 54.0 2011-01-17 12: 3 -6.86234889999 109.1326904 Tegal co2 0.0 100.0 33.0 2011-01-17 12: ================================================================================ 2. STRUKTUR TABEL: sysdiagrams ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- name nvarchar 128 NO - NO principal_id int - NO - NO diagram_id int - NO - YES version int - YES - NO definition varbinary -1 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: tbADC ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- DC char 2 NO - NO AC varchar 25 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- DC AC -------------------------------- 97 5.0 98 5.0 99 5.0 ================================================================================ 2. STRUKTUR TABEL: tbAlarm ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- TID bigint - NO - NO license varchar 10 NO ('SB 23568') NO AlarmTypeID tinyint - NO - NO Ack bit - NO - NO Lat float - NO - NO Lon float - NO - NO Speed float - NO - NO Course smallint - NO - NO alarmTime datetime - NO - NO remark varchar 50 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- TID license AlarmTypeID Ack Lat Lon Speed Course alarmTime remark ---------------------------------------------------------------------------------------------------------------------------------------------------------------- 35889905943662 DM 8153 BE 27 0 0.750268333333 122.8515466669 36.0 45 2026-07-07 12: NULL 35889905943662 DM 8153 BE 28 0 0.750268333333 122.8515466669 36.0 45 2026-07-07 12: NULL 35250309062626 L 8020 KY 27 0 -7.47610166667 112.688577778 38.0 18 2026-07-07 12: NULL ================================================================================ 2. STRUKTUR TABEL: tbAlarmType ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- AlarmTypeID tinyint - NO - NO Des varchar 50 NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- AlarmTypeID Des -------------------------------- 1 Door Open 2 Power Failure 3 Brakes ================================================================================ 2. STRUKTUR TABEL: tbAlertGeofence ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- id bigint - NO - YES tid bigint - NO - NO geoID int - NO - NO geoName varchar 100 YES - NO userID int - NO - NO userName varchar 50 YES - NO alertStatus varchar 10 NO - NO alertTime datetime - YES (getdate()) NO lat float - YES - NO lon float - YES - NO speed float - YES - NO speedLimit int - YES - NO license varchar 20 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: tbCommand ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- tid bigint - NO - NO commandID varchar 8 NO - NO parameter varchar 25 NO - NO commandTime datetime - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- tid commandID parameter commandTime ---------------------------------------------------------------- 9697734 69 B2,FF,00,0 2007-05-10 01: 35534100083273 47 0 2009-07-21 01: 35534100083273 74 0 2009-07-18 10: ================================================================================ 2. STRUKTUR TABEL: tbCustomer ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- customerID varchar 30 NO - NO Address varchar 50 YES - NO ContactPerson1 varchar 20 YES - NO ContactPerson2 varchar 20 YES - NO OfficePhone varchar 20 YES - NO HP1 varchar 20 YES - NO HP2 varchar 20 YES - NO userGroupID int - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- customerID Address ContactPerson1 ContactPerson2 OfficePhone HP1 HP2 userGroupID -------------------------------------------------------------------------------------------------------------------------------- 1 001 xxx abc yyy 999 555 777 256 01 aaa aabb ccdd 555 123 456 474 ================================================================================ 2. STRUKTUR TABEL: tbDriver ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- driver varchar 20 NO - NO address varchar 50 YES - NO remark varchar 50 YES - NO userGroupID int - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- driver address remark userGroupID ---------------------------------------------------------------- Pak Mo Bambe Sopir Lawas 539 Soleh Surabaya Driver1 520 Wak Kaji Driyorejo 539 ================================================================================ 2. STRUKTUR TABEL: tbEnterLocationHistory ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- tid bigint - NO - NO EnterTime datetime - NO - NO ExitTime datetime - YES - NO customerLoc varchar 50 NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: tbFirmware ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- tid bigint - NO - NO firmware varchar 10 NO - NO updatetime datetime - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- tid firmware updatetime ------------------------------------------------ 35152501719588 9.45 2010-01-22 02: 35152501720645 9.54 2008-09-26 01: 35152501722028 9.39 2008-03-27 01: ================================================================================ 2. STRUKTUR TABEL: tbHMSampoerna ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- DataHEX char 2 NO - NO DatammH2O varchar 7 NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- DataHEX DatammH2O -------------------------------- 2E 250.48 2F 287.65 30 324.81 ================================================================================ 2. STRUKTUR TABEL: tbJob ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- PE varchar 10 NO - NO license varchar 25 NO - NO IMEI bigint - NO - NO bCompleted bit - NO ((0)) NO userGroupID int - NO - NO remark varchar 50 NO - NO Driver varchar 20 NO - NO planStartTime datetime - NO - NO planEndTime datetime - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- PE license IMEI bCompleted userGroupID remark Driver planStartTime planEndTime ------------------------------------------------------------------------------------------------------------------------------------------------ 0001 W 8629 UN 35152501943904 0 474 deliver oil Soleh 2008-10-23 13: 2008-10-23 13: 0003 TRACK 35152501995336 0 474 Deliver Gas Soleh 2008-10-24 06: 2008-10-24 13: 001 AD 1387 SF 35152501843465 0 537 Wak Kaji 2009-02-04 06: 2009-02-04 09: ================================================================================ 2. STRUKTUR TABEL: tbLatestAlarm ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- TID bigint - NO - NO license varchar 25 NO - NO AlarmTypeID tinyint - NO - NO ACK bit - NO - NO Lat float - NO - NO Lon float - NO - NO Speed float - NO - NO Course float - NO - NO alarmTime datetime - NO - NO remark varchar 15 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- TID license AlarmTypeID ACK Lat Lon Speed Course alarmTime remark ---------------------------------------------------------------------------------------------------------------------------------------------------------------- 0 N.A. 27 0 2.957166666670 99.58148500000 0.0 301.0 2026-08-12 08: NULL 0 N.A. 28 0 2.957166666670 99.58148500000 0.0 301.0 2026-08-12 08: NULL 30 N.A. 27 0 -6.81680166667 107.479685 62.0 137.0 2026-07-02 04: NULL ================================================================================ 2. STRUKTUR TABEL: tblatestlocation ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- license varchar 25 NO - NO TID bigint - NO - NO driver varchar 20 NO - NO driverHP varchar 20 NO - NO latitude float - NO - NO longitude float - NO - NO speed float - NO - NO course smallint - NO - NO time datetime - NO - NO groupID tinyint - NO - NO Alarm bit - YES - NO Panic bit - YES - NO Ignition On bit - YES - NO oilLevel float - NO ((3.3)) NO Input Power char 2 YES - NO receiveTime datetime - NO - NO customerID int - YES - NO lastRcvTime datetime - YES - NO process bit - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- license TID driver driverHP latitude longitude speed course time groupID Alarm Panic Ignition On oilLevel Input Power receiveTime customerID lastRcvTime process ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- N.A. 0 N.A. N.A. 2.957166666670 99.58148500000 0.0 301 2026-08-12 08: 1 0 0 1 1.0 D7 2026-08-12 08: NULL 2026-08-12 08: NULL N.A. 30 N.A. N.A. -7.39330499999 112.639976667 19.0 67 2026-06-08 09: 1 0 0 1 0.0 F7 2026-06-08 04: NULL 2026-06-12 05: NULL N.A. 3030 N.A. N.A. -4.78035166666 119.544005 40.0 182 2026-07-15 15: 1 0 0 1 0.0 F7 2026-07-15 19: NULL 2026-07-15 19: NULL ================================================================================ 2. STRUKTUR TABEL: tbLatestLockLog ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- licenseNo varchar 25 NO - NO lockStatus tinyint - NO - NO doorStatus tinyint - NO - NO eventTime datetime - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- licenseNo lockStatus doorStatus eventTime ---------------------------------------------------------------- AB 9285 DH 0 6 2007-03-30 13: E-Seal 7 0 2008-03-13 04: H 1448 YW 0 7 2007-05-15 05: ================================================================================ 2. STRUKTUR TABEL: tbLatestLockStatus ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- licenseNo varchar 25 NO - NO lockID tinyint - NO - NO block bit - NO - NO lockTime datetime - NO (((2000)-(1))-(1)) NO unlockTime datetime - NO (((2000)-(1))-(1)) NO SAMPLE DATA (3 rows): -------------------------------------------------- licenseNo lockID block lockTime unlockTime -------------------------------------------------------------------------------- Test 1 1 2007-08-23 11: 2007-08-23 11: Test 2 1 2007-08-23 11: 2007-08-23 11: Test 3 1 2007-08-23 11: 2007-08-23 11: ================================================================================ 2. STRUKTUR TABEL: tbLicensePIC ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- license varchar 25 NO - NO PICID int - NO - NO startTime datetime - NO - NO endTime datetime - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- license PICID startTime endTime ---------------------------------------------------------------- E-Seal 78 2008-03-13 00: 2099-12-31 00: H 9315 KW 31 2007-08-20 00: 2009-12-31 00: H 9316 KW 32 2007-08-20 00: 2009-12-31 00: ================================================================================ 2. STRUKTUR TABEL: tbLicenseTran ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- license varchar 25 NO - NO tid bigint - NO - NO driver varchar 20 YES - NO driverHP varchar 20 YES - NO groupID tinyint - NO - NO startTime datetime - NO - NO endTime datetime - NO - NO customerID int - NO - NO phoneno varchar 15 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- license tid driver driverHP groupID startTime endTime customerID phoneno ------------------------------------------------------------------------------------------------------------------------------------------------ W 8930 CA 35152501996349 5 2008-10-29 04: 2020-02-04 17: 42400001 K 8775 CT 35889905090031 5 2014-12-30 17: 2030-12-31 17: 42620021 B 9102 FU 35152501843599 5 2013-06-13 13: 2015-10-05 18: 42408001 ================================================================================ 2. STRUKTUR TABEL: tbLicenseTran_20231221 ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- license varchar 25 NO - NO tid bigint - NO - NO driver varchar 20 YES - NO driverHP varchar 20 YES - NO groupID tinyint - NO - NO startTime datetime - NO - NO endTime datetime - NO - NO customerID int - NO - NO phoneno varchar 15 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- license tid driver driverHP groupID startTime endTime customerID phoneno ------------------------------------------------------------------------------------------------------------------------------------------------ W 8930 CA 35152501996349 5 2008-10-29 04: 2020-02-04 17: 42400001 L 8022 GQ 35152501843511 5 2008-10-21 04: 2017-08-01 17: 42400001 B 9102 FU 35152501843599 5 2013-06-13 13: 2015-10-05 18: 42408001 ================================================================================ 2. STRUKTUR TABEL: tblocationName ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- loc_name varchar 30 NO - NO lat float - NO - NO lon float - NO - NO shapecolor int - NO (1000) NO company varchar 100 NO ('Super Admin') NO Contact Person varchar 50 YES - NO Contact Num char 10 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- loc_name lat lon shapecolor company Contact Person Contact Num ---------------------------------------------------------------------------------------------------------------- 44.595.10 -6.94247000000 110.6854199999 1000 Super Admin NULL NULL abadi_alfamart -7.31084300000 112.684736 -8323200 Abadi Rent Car NULL NULL abadi_amri -7.30635399999 112.725731 -16776961 Abadi Rent Car NULL NULL ================================================================================ 2. STRUKTUR TABEL: tblocations ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- tid bigint - NO - NO lat float - NO - NO lon float - NO - NO speed float - NO - NO course smallint - NO - NO sleepMode bit - NO - NO time datetime - NO - NO status int - NO - NO receiveTime datetime - YES - NO fixGPS bit - NO - NO oilLevel float - NO (3.3) NO input power char 2 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- tid lat lon speed course sleepMode time status receiveTime fixGPS oilLevel input power ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 0 3.669731666670 98.67489666669 0.0 0 0 2026-01-31 04: 0 2026-01-31 04: 1 1.0 D7 0 3.669731666670 98.67489666669 0.0 0 0 2026-01-31 04: 0 2026-01-31 04: 1 1.0 D7 0 3.669731666670 98.67489666669 0.0 0 0 2026-01-31 04: 0 2026-01-31 04: 1 1.0 D7 ================================================================================ 2. STRUKTUR TABEL: tbLock ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- license varchar 25 NO - NO PICID int - NO - NO loc_name varchar 30 NO - NO lockID tinyint - NO - NO dist float - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- license PICID loc_name lockID dist -------------------------------------------------------------------------------- E-Seal 78 bizpoint_Kanto 1 250.0 E-Seal 78 bizpoint_Kanto 2 250.0 E-Seal 78 bizpoint_Kanto 3 250.0 ================================================================================ 2. STRUKTUR TABEL: tbLockAlarm ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- ID int - NO - YES licenseNo varchar 25 NO - NO picID int - NO - NO lockID tinyint - NO - NO curTime datetime - NO - NO remark varchar 50 YES - NO lat float - YES - NO lon float - YES - NO loc_name varchar 50 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- ID licenseNo picID lockID curTime remark lat lon loc_name ------------------------------------------------------------------------------------------------------------------------------------------------ 1 H 1448 YW 16 1 2007-03-09 11: NULL NULL NULL NULL 7 H 1448 YW 16 1 2007-03-09 11: NULL NULL NULL NULL 8 H 1448 YW 16 1 2007-03-09 12: NULL NULL NULL NULL ================================================================================ 2. STRUKTUR TABEL: tbLockHistory ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- ID int - NO - YES licenseNo varchar 25 NO - NO lockID tinyint - NO - NO unLockTime datetime - YES - NO LockTime datetime - YES - NO loc_name varchar 50 YES - NO lat float - YES - NO lon float - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- ID licenseNo lockID unLockTime LockTime loc_name lat lon -------------------------------------------------------------------------------------------------------------------------------- 1 H 1448 YW 2 NULL 2007-03-09 08: NULL NULL NULL 2 H 1448 YW 2 2007-03-09 08: 2007-03-09 08: NULL NULL NULL 3 H 1448 YW 2 2007-03-09 08: 2007-03-09 08: NULL NULL NULL ================================================================================ 2. STRUKTUR TABEL: tbLockLog ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- ID int - NO - YES licenseNo varchar 25 NO - NO lockStatus tinyint - NO - NO doorStatus tinyint - NO - NO eventTime datetime - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- ID licenseNo lockStatus doorStatus eventTime -------------------------------------------------------------------------------- 1 H 1448 YW 2 0 2007-03-09 08: 2 H 1448 YW 0 0 2007-03-09 08: 3 H 1448 YW 2 0 2007-03-09 08: ================================================================================ 2. STRUKTUR TABEL: tbLockMatrix ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- id int - NO - NO matrix binary 16 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- id matrix -------------------------------- 1 2B28AB0977ADF7 2 914257F223402A 16 2B28AB097EAEF7 ================================================================================ 2. STRUKTUR TABEL: tbLockStatus ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- licenseNo varchar 25 NO - NO lockStatus tinyint - NO - NO updateTime datetime - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- licenseNo lockStatus updateTime ------------------------------------------------ SDG 8888 S 0 2007-02-09 14: DR 8741 A 0 2007-02-10 16: L168U 7 2007-02-15 07: ================================================================================ 2. STRUKTUR TABEL: tbMilotech ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- time datetime - NO - NO tid bigint - NO - NO analog0 int - NO - NO analog1 int - NO - NO analog2 int - NO - NO analog3 int - NO - NO analog4 int - NO - NO analog5 int - NO - NO analog6 int - NO - NO analog7 int - NO - NO digital0 bit - NO - NO digital1 bit - NO - NO digital2 bit - NO - NO digital3 bit - NO - NO digital4 bit - NO - NO digital5 bit - NO - NO digital6 bit - NO - NO digital7 bit - NO - NO GPS_Time datetime - YES - NO GPS_Ign int - YES - NO GPS_S_Ign varchar 3 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: tbOrder ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- PE varchar 10 NO - NO CustomerID varchar 30 NO - NO DeliveryTime datetime - NO - NO Remark varchar 50 YES - NO UserGroupID int - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- PE CustomerID DeliveryTime Remark UserGroupID -------------------------------------------------------------------------------- 0001 01 2008-10-23 14: deliver oil 474 0002 01 2008-10-24 14: Deliver tml 474 0003 01 2008-10-24 13: Deliver Gas 474 ================================================================================ 2. STRUKTUR TABEL: tbOrderDetail ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- PE varchar 25 NO - NO ID int - NO - YES PetrolID tinyint - NO - NO Quantity float - NO - NO Remark varchar 50 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- PE ID PetrolID Quantity Remark -------------------------------------------------------------------------------- 2345676 1 1 5000.0 Fuel Delivery 547890 2 5 16000.0 Urgent 01 3 3 8000.0 deliver oil ================================================================================ 2. STRUKTUR TABEL: tbPetrol ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- PetrolId tinyint - NO - YES Des varchar 30 NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- PetrolId Des -------------------------------- 1 kerosene 2 Petrol 98 3 Petrol 95 ================================================================================ 2. STRUKTUR TABEL: tbPoints ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- seqNo int - NO - NO orderNo smallint - NO - NO lat float - NO - NO lon float - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: tbSamatorSms ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- license varchar 20 YES - NO tid varchar 20 YES - NO phoneno varchar 20 YES - NO custno varchar 20 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: tbSAP ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- id bigint - NO - YES no_pol nchar 10 YES - NO driver varchar 50 YES - NO no_surat_jalan nchar 10 YES - NO customer varchar 35 YES - NO muatan varchar 50 YES - NO delivery_date date - YES - NO delivery_time time - YES - NO entry_date date - YES - NO entry_time time - YES - NO DeliveryDateTime datetime - YES - NO EntryDateTime datetime - YES - NO plant varchar 4 YES - NO quantity float - YES - NO satuan varchar 10 YES - NO quantity_dasar float - YES - NO satuan_dasar varchar 10 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: tbSAP1 ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- no_pol nchar 10 YES - NO driver varchar 50 YES - NO no_surat_jalan nchar 10 YES - NO customer varchar 35 YES - NO muatan varchar 50 YES - NO delivery_date date - YES - NO delivery_time time - YES - NO entry_date date - YES - NO entry_time time - YES - NO DeliveryDateTime datetime - YES - NO EntryDateTime datetime - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: tbSAPPlant ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- plant varchar 4 NO - NO nama varchar 100 NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- plant nama -------------------------------- 1000 PT. SAMATOR (H 1010 PT. SAMATOR - 1020 PT. SAMATOR - ================================================================================ 2. STRUKTUR TABEL: tbSelectedAlarm ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- customerID int - NO - NO maskID int - YES - NO alarmtypeID tinyint - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- customerID maskID alarmtypeID ------------------------------------------------ 16800001 256 5 16800001 1 39 1 1 39 ================================================================================ 2. STRUKTUR TABEL: tbSendCommand ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- tid bigint - NO - NO commandID varchar 8 NO - NO parameter varchar 25 NO - NO commandTime datetime - NO - NO confirmTime datetime - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- tid commandID parameter commandTime confirmTime -------------------------------------------------------------------------------- 35152501842988 69 B2,FF,00,0 2007-05-10 01: 2007-05-10 01: 35152501843425 69 B2,FF,00,0 2007-05-10 01: 2007-05-10 01: 35152501843843 69 B2,FF,00,0 2007-05-10 01: 2007-05-10 01: ================================================================================ 2. STRUKTUR TABEL: tbsmsauto ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- license varchar 20 YES - NO tid varchar 20 YES - NO phoneno varchar 20 YES - NO custno varchar 20 YES - NO sms_code varchar 25 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- license tid phoneno custno sms_code -------------------------------------------------------------------------------- AD 1387 SF 35152501944022 081330997319 08123450901 05*827,0123456 B 9001 TFA 35152501996817 081330997343 08123450901 05*827,0123456 B 9002 TFA 35152501844380 081330997332 08123450901 05*827,0123456 ================================================================================ 2. STRUKTUR TABEL: tbSystems ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- systemEnable bit - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: tbTelemetry ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- tid bigint - NO - NO time datetime - NO - NO latitude float - NO - NO longitude float - NO - NO advalue int - NO - NO voltagevalue float - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: tbTelemetryName ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- tid bigint - NO - NO name varchar 256 NO - NO active bit - YES - NO latitude float - YES - NO longitude float - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- No data found in table. ================================================================================ 2. STRUKTUR TABEL: tbTempHum ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- imei varchar 20 YES - NO suhu float - YES - NO hum float - YES - NO waktu datetime - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- imei suhu hum waktu ---------------------------------------------------------------- 35152501995662 24.80000000000 46.39999999999 2008-04-08 16: 35152501995662 24.69999999999 46.79999999999 2008-04-08 16: 35152501995662 24.60000000000 46.60000000000 2008-04-08 16: ================================================================================ 2. STRUKTUR TABEL: tbTransponder ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- IMEI bigint - NO - NO starttime datetime - YES - NO endtime datetime - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- IMEI starttime endtime ------------------------------------------------ 35534100083273 2007-06-05 06: 2009-12-31 00: 35873507701824 2021-07-07 00: 2099-01-01 00: 35958501387967 2008-04-02 10: 2008-04-03 08: ================================================================================ 2. STRUKTUR TABEL: tbTruckType ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- license varchar 25 NO - NO type varchar 20 NO - NO username char 15 NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- license type username ------------------------------------------------ W 8097 A Head Trailer bambe W 8085 A Head Trailer bambe L 8023 MT Head Trailer bambe ================================================================================ 2. STRUKTUR TABEL: tbUserGroup ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- userGroupID int - NO - YES des varchar 100 NO - NO minNo int - NO - NO maxNo int - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- userGroupID des minNo maxNo ---------------------------------------------------------------- 1 Super Admin 1 2147483646 537 PT. Samator (G 42400001 43200000 538 Samator Inti P 42400001 42404000 ================================================================================ 2. STRUKTUR TABEL: tbUserGroupMulti ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- userGroupID int - NO - NO userName varchar 15 YES - NO id int - NO - YES SAMPLE DATA (3 rows): -------------------------------------------------- userGroupID userName id ------------------------------------------------ 603 agi_surabaya 1 539 bambe 3 611 agimedan 4 ================================================================================ 2. STRUKTUR TABEL: tbUsers ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- userName varchar 15 NO - NO password varchar 50 NO - NO userGroupID int - NO - NO alertDisplayList varchar 50 YES - NO newpass varchar 150 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- userName password userGroupID alertDisplayList newpass -------------------------------------------------------------------------------- adminsamator 1KJbHbZn+2s6Se 0 1a81e51eb059f6 admsulawesi 1KJbHbZn+2s6Se 0 10470c3b4b1fed agi_semarang 1KJbHbZn+2s6Se 549 NULL 10470c3b4b1fed ================================================================================ 2. STRUKTUR TABEL: tbUserShapes ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- seqNo int - NO - YES shapeTypeID tinyint - NO - NO minLat float - NO - NO minLon float - NO - NO maxLat float - NO - NO maxLon float - NO - NO alarmTypeID tinyint - NO - NO labelText varchar 20 NO - NO pencolor int - NO - NO brcolor int - NO - NO penWidth tinyint - NO - NO minNo int - NO - NO maxNo int - NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- seqNo shapeTypeID minLat minLon maxLat maxLon alarmTypeID labelText pencolor brcolor penWidth minNo maxNo ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 540 1 -10.1627696569 123.6346309639 -10.1625392177 123.6349211465 38 Rumah Nelis -16776961 1283457279 1 16040 16061 592 2 -10.1680443484 123.6575448841 -10.1567445386 123.6654547509 38 Kupang Tengah -16776961 1426063615 1 4900 4921 654 2 -8.47795169657 118.7109719381 -8.47687433079 118.7123715241 38 PERTAMINA BIM -16776961 1426063615 1 9600000 10400001 ================================================================================ 2. STRUKTUR TABEL: tbVehicleType ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- groupid smallint - NO - NO grouptype varchar 20 NO - NO SAMPLE DATA (3 rows): -------------------------------------------------- groupid grouptype -------------------------------- 0 Kerosene 1 Diesel 2 Pertamax ================================================================================ 2. STRUKTUR TABEL: ttxx ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- xxx int - YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- xxx ---------------- 918528 917506 917504 ================================================================================ 2. STRUKTUR TABEL: ViewMap ================================================== COLUMN TYPE LENGTH NULLABLE DEFAULT IDENTITY -------------------------------------------------------------------------------- userGroupID int - YES - NO userName varchar 15 NO - NO latitude float - YES - NO longitude float - YES - NO zoom int - YES - NO GMT varchar 5 YES - NO SAMPLE DATA (3 rows): -------------------------------------------------- userGroupID userName latitude longitude zoom GMT ------------------------------------------------------------------------------------------------ NULL agibaturaja -5.25201999999 105.8628680000 7 7 NULL agibitung 1.149999999999 124.92 8 8 NULL agigorontalo 0.650000000000 122.9000000000 10 8 ================================================================================ 3. DATABASE INFO: ================= Database Name: Samator_System SQL Server Version: Microsoft SQL Server 2014 - 12.0.2000.8 (X64) Feb 20 2014 20:04:26 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.3 (Build 9600: ) === END OF DATABASE STRUCTURE ===