GDINAM

403 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
CDIMENSAO.COLIGADATABELADINAMICA FKCDIMENSAO_GDINAMR
GCONSIST.CODCOLIGADA FKGCONSIST_GDINAMR
GDEFCOMPL.CODCOLTABDINAM FKGDEFCOMPL_GDINAMR
PBCOSERV.CODCOLIGADA FKPBCOSERV_GDINAMR
PSERVBANCO.CODCOLIGADA FKPSERVBANCO_GDINAMR
VINFCLINICA.CODCOLIGADA FKVINFCLINICA_GDINAMR
GCOLIGADA.CODCOLIGADA FKGDINAM_GCOLIGADAR
APLICACAO varchar 1 null
CDIMENSAO.APLICACAOTABELADINAMICA FKCDIMENSAO_GDINAMR
GCONSIST.APLICACAO FKGCONSIST_GDINAMR
GDEFCOMPL.APLICTABDINAM FKGDEFCOMPL_GDINAMR
PBCOSERV.APLICACAO FKPBCOSERV_GDINAMR
PSERVBANCO.APLICACAO FKPSERVBANCO_GDINAMR
VINFCLINICA.APLICACAO FKVINFCLINICA_GDINAMR
CODIGO varchar 10 null
CDIMENSAO.CODIGOTABELADINAMICA FKCDIMENSAO_GDINAMR
GCONSIST.CODTABELA FKGCONSIST_GDINAMR
GDEFCOMPL.CODTABDINAM FKGDEFCOMPL_GDINAMR
PBCOSERV.CODSERVICO FKPBCOSERV_GDINAMR
PSERVBANCO.CODTABELA FKPSERVBANCO_GDINAMR
VINFCLINICA.CODTABDINAM FKVINFCLINICA_GDINAMR
FINALIDADE smallint 2 √ null
DESCRICAO varchar 50 √ null
NOMETABELA varchar 15 √ 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)
PKGDINAM Primary key Asc/Asc/Asc CODCOLIGADA + APLICACAO + CODIGO

Relationships

Close relationships within degrees of separation