GCONSIST

273 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VEXAMESPRONTINFCLINICA.CODCOLIGADA FKVEXAMESPRONTINFCLI_GCONSISTR
GDINAM.CODCOLIGADA FKGCONSIST_GDINAMR
APLICACAO varchar 1 null
VEXAMESPRONTINFCLINICA.APLICACAO FKVEXAMESPRONTINFCLI_GCONSISTR
GDINAM.APLICACAO FKGCONSIST_GDINAMR
CODTABELA varchar 10 null
VEXAMESPRONTINFCLINICA.CODTABELA FKVEXAMESPRONTINFCLI_GCONSISTR
GDINAM.CODIGO FKGCONSIST_GDINAMR
CODCLIENTE varchar 10 null
VEXAMESPRONTINFCLINICA.CODCLIENTE FKVEXAMESPRONTINFCLI_GCONSISTR
CODINTERNO varchar 10 null
XMOTIVO.CODINTERNO Implied ConstraintR
DESCRICAO varchar 70 √ null
PODEALTERAR 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)
PKGCONSIST Primary key Asc/Asc/Asc/Asc CODCOLIGADA + APLICACAO + CODTABELA + CODCLIENTE

Relationships

Close relationships within degrees of separation