absen_jbv
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| SM | varchar(50) | Yes | NULL | |||
| From | varchar(50) | Yes | NULL | |||
| phone | varchar(20) | Yes | NULL | |||
| Lokasi | text | Yes | NULL | |||
| latitude | varchar(25) | Yes | NULL | |||
| longitude | varchar(20) | Yes | NULL | |||
| maps_url | varchar(100) | Yes | NULL | |||
| Hari_Jam_Shareloc_Proyek | varchar(50) | Yes | NULL | |||
| Lokasi_Proyek_By_Project_CO | varchar(10) | Yes | NULL | |||
| Nama_Proyek | varchar(100) | Yes | NULL | |||
| log_range | text | Yes | NULL | |||
| status_sync | varchar(10) | Yes | NULL | |||
| provinsi | varchar(50) | Yes | NULL | |||
| time_zone | varchar(10) | Yes | NULL | |||
| createdAt | datetime | Yes | NULL | |||
| updatedAt | datetime | Yes | NULL | |||
| key | varchar(100) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1159 | A | No | |
| unique_key | BTREE | Yes | No | key | 1159 | A | Yes |
log_absen
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| log_team | varchar(100) | Yes | NULL | |||
| log_time | varchar(100) | Yes | NULL | |||
| log_from | varchar(100) | Yes | NULL | |||
| log_phone | varchar(20) | Yes | NULL | |||
| log_loc | varchar(255) | Yes | NULL | |||
| log_lat | decimal(10,8) | Yes | NULL | |||
| log_long | decimal(11,8) | Yes | NULL | |||
| log_mapsurl | mediumtext | Yes | NULL | |||
| compare_key | varchar(255) | No | ||||
| created_at | timestamp | No | CURRENT_TIMESTAMP | |||
| updated_at | timestamp | No | CURRENT_TIMESTAMP |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 8110 | A | No |
table 1
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| COL 1 | varchar(6) | Yes | NULL | |||
| COL 2 | varchar(19) | Yes | NULL | |||
| COL 3 | varchar(20) | Yes | NULL | |||
| COL 4 | varchar(14) | Yes | NULL | |||
| COL 5 | varchar(173) | Yes | NULL | |||
| COL 6 | varchar(21) | Yes | NULL | |||
| COL 7 | varchar(15) | Yes | NULL | |||
| COL 8 | varchar(63) | Yes | NULL | |||
| COL 9 | varchar(43) | Yes | NULL | |||
| COL 10 | varchar(27) | Yes | NULL | |||
| COL 11 | varchar(61) | Yes | NULL | |||
| COL 12 | varchar(167) | Yes | NULL | |||
| COL 13 | varchar(11) | Yes | NULL | |||
| COL 14 | varchar(19) | Yes | NULL | |||
| COL 15 | varchar(9) | Yes | NULL | |||
| COL 16 | varchar(24) | Yes | NULL | |||
| COL 17 | varchar(24) | Yes | NULL |