| id_fornecedor |
int(11)
|
|
|
|
| nome_do_representante |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| razao_social |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| nome_fantasia |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| cnpj |
varchar(14)
|
utf8mb4_general_ci
|
|
|
| ie |
varchar(32)
|
utf8mb4_general_ci
|
|
|
| isento |
tinyint(1)
|
|
|
|
| status |
enum('ATIVO', 'INATIVO')
|
utf8mb4_general_ci
|
|
|
| cep |
varchar(8)
|
utf8mb4_general_ci
|
|
|
| logradouro |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| numero |
varchar(16)
|
utf8mb4_general_ci
|
|
|
| complemento |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| bairro |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| comercial |
varchar(11)
|
utf8mb4_general_ci
|
|
|
| celular_1 |
varchar(11)
|
utf8mb4_general_ci
|
|
|
| celular_2 |
varchar(11)
|
utf8mb4_general_ci
|
|
|
| email |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| id_uf |
int(11)
|
|
|
|
| id_municipio |
int(11)
|
|
|
 Visualizar valores estrangeiros
|
| id_empresa |
int(11)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| deleted_at |
datetime
|
|
|
|
