Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
CODCOLIGADA | DCODCOLIGADA | 2 | null |
|
|
|||
MASCARACLIFOR | varchar | 25 | √ | null |
|
|
||
USARTIPOCLIFOR | smallint | 2 | √ | null |
|
|
||
USAROPCLIFOR | smallint | 2 | √ | null |
|
|
||
USARALFACLIFOR1 | smallint | 2 | √ | null |
|
|
||
NOMEALFACLIFOR1 | varchar | 20 | √ | null |
|
|
||
USARALFACLIFOR2 | smallint | 2 | √ | null |
|
|
||
NOMEALFACLIFOR2 | varchar | 20 | √ | null |
|
|
||
USARALFACLIFOR3 | smallint | 2 | √ | null |
|
|
||
NOMEALFACLIFOR3 | varchar | 20 | √ | null |
|
|
||
USARVALORCLIFOR1 | smallint | 2 | √ | null |
|
|
||
NOMEVALORCLIFOR1 | varchar | 20 | √ | null |
|
|
||
USARVALORCLIFOR2 | smallint | 2 | √ | null |
|
|
||
NOMEVALORCLIFOR2 | varchar | 20 | √ | null |
|
|
||
USARVALORCLIFOR3 | smallint | 2 | √ | null |
|
|
||
NOMEVALORCLIFOR3 | varchar | 20 | √ | null |
|
|
||
USARDATACLIFOR1 | smallint | 2 | √ | null |
|
|
||
NOMEDATACLIFOR1 | varchar | 20 | √ | null |
|
|
||
USARDATACLIFOR2 | smallint | 2 | √ | null |
|
|
||
NOMEDATACLIFOR2 | varchar | 20 | √ | null |
|
|
||
USARDATACLIFOR3 | smallint | 2 | √ | null |
|
|
||
NOMEDATACLIFOR3 | varchar | 20 | √ | null |
|
|
||
ULTIMOCLI | varchar | 25 | √ | null |
|
|
||
ULTIMOFOR | varchar | 25 | √ | null |
|
|
||
LIMITECREDEFAULT | RMDVALOR2 | 17,2 | √ | null |
|
|
||
CGCOBRIGATORIO | smallint | 2 | √ | null |
|
|
||
ESTADOOBRIG | smallint | 2 | √ | null |
|
|
||
USARAUTOINC | DLOGICONULL | 2 | √ | CREATE DEFAULT DEF_DLOGICONULL AS 0 |
|
|
||
TCFOBRIGATORIO | varchar | 10 | √ | null |
|
|
||
BANCOCARTEIRAOBRIG | smallint | 2 | √ | 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) |
---|---|---|---|
PKFPARCFO | Primary key | Asc | CODCOLIGADA |
Diagram producer might be missing
No diagrams were produced please see application output for any errors