DVIGENCIAEVCTRB

10 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DEVCTRB.CODCOLIGADA FKDVIGENCIAEVCTRB_DEVCTRBR
GFILIAL.CODCOLIGADA FKDVIGENCIAEVCTRB_GFILIALR
IDVIGENCIAEVCTRB int 4 null
IDEVCTRB int 4 null
DEVCTRB.IDEVCTRB FKDVIGENCIAEVCTRB_DEVCTRBR
DESCRICAO varchar 200 √ null
CODFILIAL smallint 2 √ null
GFILIAL.CODFILIAL FKDVIGENCIAEVCTRB_GFILIALR
DATAINICIAL datetime 16,3 √ null
DATAFINAL datetime 16,3 √ 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)
PKDVIGENCIAEVCTRB Primary key Asc/Asc CODCOLIGADA + IDVIGENCIAEVCTRB

Relationships

Close relationships within degrees of separation