NNOTICIA

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODIGO int 4 null
NARQUIVONOTICIA.CODNOTICIA FKNARQUIVONOTICIA_NNOTICIAR
NNOTICIALOCALIDADE.CODNOTICIA FKNNOTICIALOCALIDADE_NNOTICIAR
NNOTICIAPERFIL.CODNOTICIA FKNNOTICIAPERFIL_NNOTICIAR
NNOTICIAUSUARIO.CODNOTICIA FKNNOTICIAUSUARIO_NNOTICIAR
CODUSUARIOCRIADOR varchar 20 √ null
CODUSUARIOAPROV varchar 20 √ null
TITULO varchar 210 √ null
CHAMADA varchar 210 √ null
CORPO MEMO 2147483647 √ null
DTNOTICIAINI datetime 16,3 √ null
DTNOTICIAFIM datetime 16,3 √ null
APROVADA smallint 2 √ null
IMGCHAMADA varchar 255 √ null
DTPUBLICACAO datetime 16,3 √ null
DESTAQUE 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)
PKNNOTICIA Primary key Asc CODIGO

Relationships

Close relationships within degrees of separation