Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
CODCOLIGADA | DCODCOLIGADA | 2 | null |
|
|
|||
ID | int | 4 | null |
|
|
|||
DESCRICAO | varchar | 100 | √ | null |
|
|
||
INSTITUICAORESP | varchar | 3 | √ | null |
|
|
||
CODEMPRESARIO | varchar | 50 | √ | null |
|
|
||
DATADIARIO | datetime | 16,3 | √ | null |
|
|
||
NUMORDDIARIO | int | 4 | √ | null |
|
|
||
DATADIARIORESUMIDO | datetime | 16,3 | √ | null |
|
|
||
NUMORDDIARIORESUMIDO | int | 4 | √ | null |
|
|
||
DATADIARIOAUXILIAR | datetime | 16,3 | √ | null |
|
|
||
NUMORDDIARIOAUXILIAR | int | 4 | √ | null |
|
|
||
DATARAZAO | datetime | 16,3 | √ | null |
|
|
||
NUMORDRAZAO | int | 4 | √ | null |
|
|
||
DATABALANCO | datetime | 16,3 | √ | null |
|
|
||
NUMORDBALANCO | int | 4 | √ | null |
|
|
||
HASH | varchar | 50 | √ | null |
|
|
||
NATUREZALIVRO | varchar | 250 | √ | null |
|
|
||
DATAINIDEM | datetime | 16,3 | √ | null |
|
|
||
DATAFIMDEM | datetime | 16,3 | √ | null |
|
|
||
IDDEM | int | 4 | √ | null |
|
|
||
CABECDEM | MEMO | 2147483647 | √ | null |
|
|
||
NOMESIGNATARIO | varchar | 250 | √ | null |
|
|
||
CPFSIGNATARIO | varchar | 11 | √ | null |
|
|
||
QUALIFICACAO | varchar | 250 | √ | null |
|
|
||
CODQUALIFICACAO | varchar | 4 | √ | null |
|
|
||
CRC | varchar | 11 | √ | null |
|
|
||
RECCREATEDBY | varchar | 50 | √ | null |
|
|
||
RECCREATEDON | datetime | 16,3 | √ | null |
|
|
||
RECMODIFIEDBY | varchar | 50 | √ | null |
|
|
||
RECMODIFIEDON | datetime | 16,3 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PKCSPED | Primary key | Asc/Asc | CODCOLIGADA + ID |
Diagram producer might be missing
No diagrams were produced please see application output for any errors