| id |
int(10)
|
|
|
|
| items_id |
int(10)
|
|
|
|
| itemtype |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| devicesimcards_id |
int(10)
|
|
|
|
| is_deleted |
tinyint(4)
|
|
|
|
| is_dynamic |
tinyint(4)
|
|
|
|
| entities_id |
int(10)
|
|
|
|
| is_recursive |
tinyint(4)
|
|
|
|
| serial |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| otherserial |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| states_id |
int(10)
|
|
|
|
| locations_id |
int(10)
|
|
|
|
| lines_id |
int(10)
|
|
|
|
| users_id |
int(10)
|
|
|
|
| groups_id |
int(10)
|
|
|
|
| pin |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| pin2 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| puk |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| puk2 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| msin |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| comment |
text
|
utf8mb4_unicode_ci
|
|
|
