SPSINSCRICAOANONIMA

10 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SPSPROCESSOSELETIVO.CODCOLIGADA FKSPSINSCANONIMA_SPSPROCSELR
SPSFORMAINSCRICAOPS.CODCOLIGADA FKSPSINSCANONIMA_SPSFORMAINSCR
SPSINSCRICAOAREAOFERTADA.CODCOLIGADA FKSPSINSCRICAOANONIMA_SPSINSCRR
IDPS int 4 null
SPSFORMAINSCRICAOPS.IDPS FKSPSINSCANONIMA_SPSFORMAINSCR
SPSINSCRICAOAREAOFERTADA.IDPS FKSPSINSCRICAOANONIMA_SPSINSCRR
SPSPROCESSOSELETIVO.IDPS FKSPSINSCANONIMA_SPSPROCSELR
NUMINSCANONIMA int 4 null
IDFORMAINSCRICAO smallint 2 null
SPSFORMAINSCRICAOPS.IDFORMAINSCRICAO FKSPSINSCANONIMA_SPSFORMAINSCR
NUMEROLOTE int 4 null
CODCOLIGADAFUNC DCODCOLIGADANULL 2 √ null
PFUNC.CODCOLIGADA FKSPSINSCRICAOANONIMA_PFUNCR
CHAPA DCHAPANULL 16 √ null
PFUNC.CHAPA FKSPSINSCRICAOANONIMA_PFUNCR
CODCOLIGADACFO DCODCOLIGADANULL 2 √ null
FCFO.CODCOLIGADA FKSPSINSCRICAOANONIMA_FCFOR
CODCFO varchar 25 √ null
FCFO.CODCFO FKSPSINSCRICAOANONIMA_FCFOR
CODCOLIGADALAN DCODCOLIGADANULL 2 √ null
FLAN.CODCOLIGADA FKSPSINSCRICAOANONIMA_FLANR
IDLAN int 4 √ null
FLAN.IDLAN FKSPSINSCRICAOANONIMA_FLANR
VALORINSCRICAO RMDVALOR4 17,4 √ null
VALORDESCONTO RMDVALOR4 17,4 √ null
CODUSUARIO varchar 20 null
GUSUARIO.CODUSUARIO FKSPSINSCANONIMA_GUSUARIOR
DATAEMISSAO datetime 16,3 null
STATUS smallint 2 (0)
CODPESSOA int 4 √ null
PPESSOA.CODIGO FKSPSINSCRICAOANONIMA_PPESSOAR
NUMEROINSCRICAO int 4 √ null
SPSINSCRICAOAREAOFERTADA.NUMEROINSCRICAO FKSPSINSCRICAOANONIMA_SPSINSCRR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODUSUARIOPS int 4 √ null
SPSUSUARIO.CODUSUARIOPS FKSPSINSCRICAOANONIMA_SPSUSUARR

Indexes

Constraint Name Type Sort Column(s)
PKSPSINSCRICAOANONIMA Primary key Asc/Asc/Asc CODCOLIGADA + IDPS + NUMINSCANONIMA
S$SPSINSCRICAOANONIMA_FLAN Performance Asc/Asc IDLAN + CODCOLIGADALAN
SXSPSINSCRICAOANONIMA Performance Asc NUMEROLOTE

Relationships

Close relationships within degrees of separation