SPSLOGALTERACAOSTATUS

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SPSINSCRICAOAREAOFERTADA.CODCOLIGADA FKSPSLOGALTERACAOSTATUS_SPSINSR
IDPS int 4 null
SPSINSCRICAOAREAOFERTADA.IDPS FKSPSLOGALTERACAOSTATUS_SPSINSR
CODPESSOA int 4 √ null
PPESSOA.CODIGO FKSPSLOGALTERACAOSTATUS_PPESSOR
NUMEROINSCRICAO int 4 null
SPSINSCRICAOAREAOFERTADA.NUMEROINSCRICAO FKSPSLOGALTERACAOSTATUS_SPSINSR
IDAREAINTERESSE int 4 null
DATA DDATETIME 16,3 null
NUMEROOPCAO smallint 2 null
NOMEAREAINTERESSE varchar 120 null
STATUSORIGINAL varchar 100 null
STATUSPERSONALIZADO varchar 100 null
CODUSUARIO varchar 20 null
NOMESERVICO varchar 150 null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODUSUARIOPS int 4 √ null
SPSUSUARIO.CODUSUARIOPS FKSPSLOGALTERACAOSTATUS_SPSUSUR
IDLOG int 4 null

Indexes

Constraint Name Type Sort Column(s)
PKSPSLOGALTERACAOSTATUS Primary key Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + IDPS + NUMEROINSCRICAO + IDAREAINTERESSE + DATA + IDLOG

Relationships

Close relationships within degrees of separation