SPSHISTLANINSCRICAO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDHISTORICOLAN int 4 null
CODCOLIGADA DCODCOLIGADA 2 null
SPSFORMAINSCRICAOPS.CODCOLIGADA FKSPSHISTLANINSC_FORMAINSCPSR
SPSINSCRICAOAREAOFERTADA.CODCOLIGADA FKSPSHISTLANINSCRICAO_SPSINSCRR
IDPS int 4 null
SPSFORMAINSCRICAOPS.IDPS FKSPSHISTLANINSC_FORMAINSCPSR
SPSINSCRICAOAREAOFERTADA.IDPS FKSPSHISTLANINSCRICAO_SPSINSCRR
CODPESSOA int 4 √ null
PPESSOA.CODIGO FKSPSHISTLANINSCRICAO_PPESSOAR
NUMEROINSCRICAO int 4 null
SPSINSCRICAOAREAOFERTADA.NUMEROINSCRICAO FKSPSHISTLANINSCRICAO_SPSINSCRR
IDFORMAINSCRICAO smallint 2 null
SPSFORMAINSCRICAOPS.IDFORMAINSCRICAO FKSPSHISTLANINSC_FORMAINSCPSR
VALORORIGINAL RMDVALOR4 17,4 null
VALORDESCONTO RMDVALOR4 17,4 null
CODCOLIGADALAN DCODCOLIGADANULL 2 √ null
IDLAN int 4 null
CODUSUARIO varchar 20 null
GUSUARIO.CODUSUARIO FKSPSHISTLANINSC_GUSUARIOR
DATAHISTORICO datetime 16,3 null
MOTIVO varchar 1000 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 FKSPSHISTLANINSCRICAO_SPSUSUARR

Indexes

Constraint Name Type Sort Column(s)
PKSPSHISTLANINSCRICAO Primary key Asc/Asc IDHISTORICOLAN + CODCOLIGADA
SXSPSHISTLANINSCRICAO Performance Asc/Asc/Asc CODCOLIGADA + IDPS + NUMEROINSCRICAO

Relationships

Close relationships within degrees of separation