LSUBAREACON

1316 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODAREA int 4 null
LPUBAREACON.CODAREA FKLPUBAREACON_LSUBAREACONR
LUSUAREAINTERESSE.CODAREA FKLUSUAREAINTERES_LSUBAREACONR
SPESGRUPOPESQUISA.CODAREA FKSPESGRUPOPESQUISA_LSUBAREACOR
SPROJPROJETO.CODAREA FKSPROJPROJETO_LSUBAREACONR
LAREACON.CODAREA FKLSUBAREACON_LAREACONR
CODGRUPO varchar 30 null
LPUBAREACON.CODGRUPO FKLPUBAREACON_LSUBAREACONR
LUSUAREAINTERESSE.CODGRUPO FKLUSUAREAINTERES_LSUBAREACONR
SPESGRUPOPESQUISA.CODGRUPO FKSPESGRUPOPESQUISA_LSUBAREACOR
SPROJPROJETO.CODGRUPOPRINCIPAL FKSPROJPROJETO_LSUBAREACONR
SPROJPROJETO.CODGRUPOSECUNDARIO FKLSUBAREACON_SUBAREASECUNDAR
DESCGRUPO varchar 255 √ 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)
PKLSUBAREACON Primary key Asc/Asc CODAREA + CODGRUPO
LXLSUBAREACON_01 Performance Asc/Asc CODAREA + CODGRUPO

Relationships

Close relationships within degrees of separation