PCOMMUNICATEPUSH

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PSCHEDULEMESSAGESLOGPUSH.CODCOLIGADA FKPSCHEDULELOG_PCOMMUNIPUSHR
PFUNC.CODCOLIGADA FKPCOMMUNICATEPUSH_PFUNCR
GCOLIGADA.CODCOLIGADA FKPCOMMUNICATEPUSH_GCOLIGADAR
PFILTERPUSHNOTIFICATION.CODCOLIGADA FKPCOMMUNICATEPUSH_PFILTERPUSHR
PEXTERNO.CODCOLIGADA FKPCOMMUNICATEPUSH_PEXTERNOR
MESSAGETITLEPUSH varchar 30 √ null
MESSAGESUBTITLEPUSH varchar 100 √ null
MESSAGETITLECOMMUNICATE varchar 50 √ null
MESSAGETEXTOCOMMUNICATE varchar 1000 √ null
TYPEIMAGE int 4 √ null
IDIMAGE int 4 √ null
GIMAGEM.ID FKPCOMMUNICATEPUSH_GIMAGEMR
STATUS int 4 null
DATECREATION datetime 16,3 null
DATEPUBLICATION datetime 16,3 √ null
CHAPARESPONSIBLE DCHAPANULL 16 √ null
PFUNC.CHAPA FKPCOMMUNICATEPUSH_PFUNCR
CODEXTERNORESPONSIBLE DCHAPANULL 16 √ null
PEXTERNO.CODEXTERNO FKPCOMMUNICATEPUSH_PEXTERNOR
CODCOLIGADARESPONSIBLE DCODCOLIGADA 2 null
GCOLIGADA.CODCOLIGADA FKCOLIGADARESPON_GCOLIGADA_2R
EXTERNOPUSH DLOGICO 2 ((0))
SENDNOW DLOGICO 2 ((0))
IDFILTER int 4 √ null
PFILTERPUSHNOTIFICATION.ID FKPCOMMUNICATEPUSH_PFILTERPUSHR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
ID int identity 4 √ null
PSCHEDULEMESSAGESLOGPUSH.MESSAGEIDCOMMUNICATE FKPSCHEDULELOG_PCOMMUNIPUSHR

Indexes

Constraint Name Type Sort Column(s)
PKPCOMMUNICATEPUSH Primary key Asc/Asc ID + CODCOLIGADA

Relationships

Close relationships within degrees of separation