company
| # | Имя | Тип | Null | Описание |
|---|---|---|---|---|
| 1 | id | bigint(20) | UNSIGNED | |
| 2 | title | varchar(255) | COLLATE | |
| 3 | address | varchar(255) | COLLATE | |
| 4 | logo | varchar(255) | COLLATE | |
| 5 | year | int(11) | DEFAULT | |
| 6 | site | varchar(255) | COLLATE | |
| 7 | capital | int(11) | DEFAULT | |
| 8 | built_object | int(11) | DEFAULT | |
| 9 | description | text | COLLATE | |
| 10 | created_at | timestamp | NULL | |
| 11 | updated_at | timestamp | NULL | |
| 12 | createdby | int(11) | DEFAULT | |
| 13 | coordinates | longtext | CHARACTER | |
| 14 | phone | varchar(255) | COLLATE | |
| 15 | deleted_at | timestamp | NULL | |
| 16 | city_id | longtext | COLLATE | |
| 17 | ogrn | varchar(255) | COLLATE | |
| 18 | inn | varchar(255) | COLLATE | |
| 19 | kpp | varchar(255) | COLLATE | |
| 20 | active | tinyint(1) | NOT NULL | |
| 21 | priority | tinyint(1) | NOT NULL | |
| 22 | region_id | longtext | COLLATE | |
| 23 | has_role | bigint(20) | NOT NULL |