ARELOGIO

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
AHSTIMPORTACAO.CODCOLIGADA FKAHSTIMPORTACAO_ARELOGIOR
GCOLIGADA.CODCOLIGADA FKARELOGIO_GCOLIGADAR
CODIGO varchar 4 null
AHSTIMPORTACAO.CODLAYOUT FKAHSTIMPORTACAO_ARELOGIOR
DESCRICAO varchar 20 null
POSCHAPA smallint 2 √ null
TAMCHAPA smallint 2 √ null
POSRELOGIO smallint 2 √ null
TAMRELOGIO smallint 2 √ null
POSHORA smallint 2 √ null
TAMHORA smallint 2 √ null
POSDIA smallint 2 √ null
TAMDIA smallint 2 √ null
POSMES smallint 2 √ null
TAMMES smallint 2 √ null
POSANO smallint 2 √ null
TAMANO smallint 2 √ null
POSFUNCAO smallint 2 √ null
TAMFUNCAO smallint 2 √ null
POSCOLIGADA smallint 2 √ null
TAMCOLIGADA smallint 2 √ null
ID int identity 4 √ null
UTILIZALAYOUTAFD smallint 2 √ (0)
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
POSDESCRICAO smallint 2 √ null
TAMDESCRICAO smallint 2 √ null
LAYOUTAFD671 smallint 2 √ null

Indexes

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

Relationships

Close relationships within degrees of separation