Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| CD_CLIENTE | DOUBLE PRECISION | 15 | null |
|
|
||||||
| NR_CPF | DOUBLE PRECISION | 15 | null |
|
|
||||||
| NR_RG | VARCHAR | 14 | null |
|
|
||||||
| NM_ORGAO_EXPEDITOR | VARCHAR | 10 | √ | null |
|
|
|||||
| DT_NASCIMENTO | TIMESTAMP | 24 | √ | null |
|
|
|||||
| NR_CPF_BKP | VARCHAR | 14 | √ | null |
|
|
|||||
| NR_CPF_AUX | VARCHAR | 20 | √ | null |
|
|
|||||
| NM_UF_ORGAO_EXPEDIDOR | VARCHAR | 2 | √ | null |
|
|
|||||
| CD_CLIENTE_ANT | DOUBLE PRECISION | 15 | √ | null |
|
|
|||||
| NR_CPF_ANT | DOUBLE PRECISION | 15 | √ | null |
|
|
|||||
| NR_RG_ANT | DOUBLE PRECISION | 15 | √ | null |
|
|
|||||
| DS_VALOR_CHAVE | VARCHAR | 256 | √ | null |
|
|
|||||
| NR_CPF_CHAR | VARCHAR | 20 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| FK_CLI_CLI_PES_FIS | Performance | Asc | CD_CLIENTE |
| RDB$PRIMARY10 | Must be unique | Asc | CD_CLIENTE |
Relationships
Close relationships within degrees of separation
