Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
IDINFOVINC | int | 4 | null |
|
|
|||||
TPREGTRAB | int | 4 | √ | null |
|
|
||||
TPREGPREV | int | 4 | √ | null |
|
|
||||
DTADM | datetime | 16,3 | √ | null |
|
|
||||
TMPPARC | int | 4 | √ | null |
|
|
||||
NRINSC | varchar | 14 | √ | null |
|
|
||||
TPINSC | int | 4 | √ | null |
|
|
||||
MATRICANT | varchar | 30 | √ | null |
|
|
||||
DTTRANSF | datetime | 16,3 | √ | null |
|
|
||||
DTPROJFIMAPI | datetime | 16,3 | √ | null |
|
|
||||
MTVDESLIG | varchar | 2 | √ | null |
|
|
||||
DTDESLIG | datetime | 16,3 | √ | null |
|
|
||||
OBJDET | varchar | 255 | √ | null |
|
|
||||
CLAUASSEC | char | 1 | √ | null |
|
|
||||
DTTERM | datetime | 16,3 | √ | null |
|
|
||||
TPCONTR | int | 4 | √ | null |
|
|
||||
IDINFOCONTRATOCOMPL | int | 4 | √ | null |
|
|
||||
RECCREATEDBY | varchar | 50 | √ | null |
|
|
||||
RECCREATEDON | datetime | 16,3 | √ | null |
|
|
||||
RECMODIFIEDBY | varchar | 50 | √ | null |
|
|
||||
RECMODIFIEDON | datetime | 16,3 | √ | null |
|
|
||||
PENSALIM | int | 4 | √ | null |
|
|
||||
PERCALIMENT | numeric | 7,2 | √ | null |
|
|
||||
VRALIM | numeric | 16,2 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PKVPROCTRABINFOVINC | Primary key | Asc | IDINFOVINC |