| id_cliente |
int(11)
|
|
|
|
| tipo |
enum('PESSOA_FISICA', 'PESSOA_JURIDICA')
|
utf8mb4_general_ci
|
|
|
| nome |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| cpf |
varchar(11)
|
utf8mb4_general_ci
|
|
|
| nome_fantasia |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| razao_social |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| cnpj |
varchar(14)
|
utf8mb4_general_ci
|
|
|
| isento |
int(11)
|
|
|
|
| ie |
varchar(32)
|
utf8mb4_general_ci
|
|
|
| cep |
varchar(12)
|
utf8mb4_general_ci
|
|
|
| logradouro |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| numero |
varchar(5)
|
utf8mb4_general_ci
|
|
|
| complemento |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| bairro |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| fixo |
varchar(12)
|
utf8mb4_general_ci
|
|
|
| celular_1 |
varchar(12)
|
utf8mb4_general_ci
|
|
|
| celular_2 |
varchar(12)
|
utf8mb4_general_ci
|
|
|
| email |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| data_de_nascimento |
date
|
|
|
|
| id_uf |
int(11)
|
|
|
|
| id_municipio |
int(11)
|
|
|
 Visualizar valores estrangeiros
|
| id_empresa |
int(11)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| deleted_at |
datetime
|
|
|
|
