SPSPROVAETAPAAREA

16 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SPSCONTROLEDISTRIBUICAOPROVA.CODCOLIGADA FKSPSCONTDISTPRV_SPSPRVETAREAR
SPSHORARIOETAPAAREAOFERTADA.CODCOLIGADA FKSPSETAREOF_SPSHORETAREAOFR
SPSIDIOMAAREAOFERTADA.CODCOLIGADA FKSPSETAREAOF_SPSIDIOMAAREAOFR
IDPS int 4 null
SPSCONTROLEDISTRIBUICAOPROVA.IDPS FKSPSCONTDISTPRV_SPSPRVETAREAR
SPSHORARIOETAPAAREAOFERTADA.IDPS FKSPSETAREOF_SPSHORETAREAOFR
SPSIDIOMAAREAOFERTADA.IDPS FKSPSETAREAOF_SPSIDIOMAAREAOFR
IDAREAINTERESSE int 4 null
SPSCONTROLEDISTRIBUICAOPROVA.IDAREAINTERESSE FKSPSCONTDISTPRV_SPSPRVETAREAR
SPSHORARIOETAPAAREAOFERTADA.IDAREAINTERESSE FKSPSETAREOF_SPSHORETAREAOFR
SPSIDIOMAAREAOFERTADA.IDAREAINTERESSE FKSPSETAREAOF_SPSIDIOMAAREAOFR
IDETAPA int 4 null
SPSCONTROLEDISTRIBUICAOPROVA.IDETAPA FKSPSCONTDISTPRV_SPSPRVETAREAR
SPSHORARIOETAPAAREAOFERTADA.IDETAPA FKSPSETAREOF_SPSHORETAREAOFR
CODCOLIGADAPROVA DCODCOLIGADA 2 null
SPSCONTROLEDISTRIBUICAOPROVA.CODCOLIGADAPROVA FKSPSCONTDISTPRV_SPSPRVETAREAR
BPROVA.CODCOLIGADA FKSPSETAPAAREOFER_BPROVAR
CODPROVA varchar 16 null
SPSCONTROLEDISTRIBUICAOPROVA.CODPROVA FKSPSCONTDISTPRV_SPSPRVETAREAR
BPROVA.CODPROVA FKSPSETAPAAREOFER_BPROVAR
IDHORARIO int 4 null
SPSCONTROLEDISTRIBUICAOPROVA.IDHORARIO FKSPSCONTDISTPRV_SPSPRVETAREAR
SPSHORARIOETAPAAREAOFERTADA.IDHORARIO FKSPSETAREOF_SPSHORETAREAOFR
PESO smallint 2 null
PRIORIDADEDESEMPATE smallint 2 null
ORDEMCADERNO smallint 2 null
CODIDIOMA smallint 2 √ null
SPSIDIOMAAREAOFERTADA.CODIDIOMA FKSPSETAREAOF_SPSIDIOMAAREAOFR
PROVAREDACAO BOOLEAN 1 ('F')
DESCPROVAZERADA BOOLEAN 1 ('F')
DESCNOTAABAIXOMINIMA BOOLEAN 1 ('F')
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DATALIMITEEXECPROVA smallint 2 √ null
DURACAOEXECPROVA smallint 2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSPSPROVAETAPAAREA Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + IDPS + IDAREAINTERESSE + IDETAPA + CODCOLIGADAPROVA + CODPROVA + IDHORARIO

Relationships

Close relationships within degrees of separation