| id |
int(11)
|
|
|
|
| user_id |
int(11)
|
|
|
|
| cnpj |
varchar(18)
|
utf8mb4_general_ci
|
|
|
| razao_social |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| nome_fantasia |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| telefone |
text
|
utf8mb4_general_ci
|
|
|
| celular |
text
|
utf8mb4_general_ci
|
|
|
| email |
text
|
utf8mb4_general_ci
|
|
|
| site |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| cep |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| logradouro |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| numero |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| complemento |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| bairro |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| cidade |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| estado |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| cnae_principal |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| cnaes_secundarios |
text
|
utf8mb4_general_ci
|
|
|
| natureza_juridica |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| porte |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| capital_social |
decimal(18,2)
|
|
|
|
| situacao_cadastral |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| data_abertura |
date
|
|
|
|
| socios |
longtext
|
utf8mb4_general_ci
|
|
|
| origem |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| raw_payload_json |
longtext
|
utf8mb4_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
