ARELCOL

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
ABATFUN.CODCOLIGADA FKABATFUN_ARELCOLR
ACCONEXAOREDE.CODCOLIGADA FKACCONEXAOREDE_ARELCOLR
ACHSTACESSO.CODCOLIGADA FKACHSTACESSO_ARELCOLR
ACRELGRUPOTERM.CODCOLIGADA FKACRELGRUPOTERM_ARELCOLR
ACUSUARIOTERMINAL.CODCOLIGADA FKACUSUARIOTERMINAL_ARELCOLR
AHSTIMPORTACAO.CODCOLIGADA FKAHSTIMPORTACAO_ARELCOLR
ARELVIS.CODCOLIGADA FKARELVIS_ARELCOLR
PSECAO.CODCOLIGADA FKARELCOL_PSECAOR
GCOLIGADA.CODCOLIGADA FKARELCOL_GCOLIGADAR
CODIGO varchar 10 null
ABATFUN.CODIGOTERMCOL FKABATFUN_ARELCOLR
ACCONEXAOREDE.CODTERM FKACCONEXAOREDE_ARELCOLR
ACHSTACESSO.CODTERMINAL FKACHSTACESSO_ARELCOLR
ACRELGRUPOTERM.CODTERM FKACRELGRUPOTERM_ARELCOLR
ACUSUARIOTERMINAL.TERMINAL FKACUSUARIOTERMINAL_ARELCOLR
AHSTIMPORTACAO.CODIGOTERMCOL FKAHSTIMPORTACAO_ARELCOLR
ARELVIS.CODRELOGIO FKARELVIS_ARELCOLR
DESCRICAO varchar 30 √ null
LOCALIZACAO varchar 30 √ null
COMPLEMENTO varchar 30 √ null
ERELOGIOREF smallint 2 √ null
DIFERENCIANATUREZA smallint 2 √ null
NATUREZA smallint 2 √ null
CODRELOGIO varchar 4 √ null
PATHARQBAT varchar 100 √ null
SITUACAO smallint 2 √ null
SENTLEITORA1 smallint 2 √ null
SENTLEITORA2 smallint 2 √ null
GRAVAHISTORICO smallint 2 √ null
TIPODATAHORA smallint 2 √ null
CADASTRO smallint 2 √ null
UTILIZADISPLAY smallint 2 √ null
CONFIGRELOGIO smallint 2 √ null
FORMATODISPLAY smallint 2 √ null
MENSFORMATODISPLAY varchar 30 √ null
SCROLLDISPLAY smallint 2 √ null
COFRE smallint 2 √ null
TEMPORESPOSTA smallint 2 √ null
SENTLEITORA3 smallint 2 √ (2)
NIVELTERM smallint 2 √ (0)
ID int identity 4 √ null
NUMEROREP bigint 8 √ null
CODIGOSECAO varchar 35 √ null
PSECAO.CODIGO FKARELCOL_PSECAOR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
TIPOREP smallint 2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKARELCOL Primary key Asc/Asc CODCOLIGADA + CODIGO
AXRELCOLID Must be unique Asc ID

Relationships

Close relationships within degrees of separation