Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
IDTIPOTAREFA | int | 4 | null |
|
|
|||||||
CODTIPOTAREFA | varchar | 100 | null |
|
|
|||||||
DSCTIPOTAREFA | varchar | 2147483647 | ((200)) |
|
|
|||||||
IDAPARENCIAINICIAL | int | 4 | √ | null |
|
|
||||||
IDAPARENCIAFINAL | int | 4 | √ | null |
|
|
||||||
IDAPARENCIAADIANTADA | int | 4 | √ | null |
|
|
||||||
IDAPARENCIAATRASADA | int | 4 | √ | null |
|
|
||||||
IDAPARENCIASIMULACAOINICIAL | int | 4 | √ | 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) |
---|---|---|---|
PKMTIPOTAREFA | Primary key | Asc | IDTIPOTAREFA |
IXMTIPOTAREFACODTIPOTAREFA | Must be unique | Asc | CODTIPOTAREFA |