UDOCCUR

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
ETABDOC.CODCOLIGADA FKUDOCCUR_ETABDOCR
UCURSOS.CODCOLIGADA FKUDOCCUR_UCURSOSR
UPERIODOS.CODCOLIGADA FKUDOCCUR_UPERIODOSR
CODCUR int 4 null
UCURSOS.CODCUR FKUDOCCUR_UCURSOSR
UPERIODOS.CODCUR FKUDOCCUR_UPERIODOSR
CODPER int 4 null
UPERIODOS.CODPER FKUDOCCUR_UPERIODOSR
CODDOC varchar 6 null
ETABDOC.CODCLIENTE FKUDOCCUR_ETABDOCR
OBRIGATORIO varchar 1 √ null
QUANTIDADE 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)
PKUDOCCUR Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CODCUR + CODPER + CODDOC

Relationships

Close relationships within degrees of separation