SPSHORARIOETAPAAREAOFERTADA

12 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SPSPROVAETAPAAREA.CODCOLIGADA FKSPSETAREOF_SPSHORETAREAOFR
SPSETAPAAREAOFERTADA.CODCOLIGADA FKSPSHETAPAREAOF_SPSETAPAREAOFR
IDPS int 4 null
SPSPROVAETAPAAREA.IDPS FKSPSETAREOF_SPSHORETAREAOFR
SPSETAPAAREAOFERTADA.IDPS FKSPSHETAPAREAOF_SPSETAPAREAOFR
IDAREAINTERESSE int 4 null
SPSPROVAETAPAAREA.IDAREAINTERESSE FKSPSETAREOF_SPSHORETAREAOFR
SPSETAPAAREAOFERTADA.IDAREAINTERESSE FKSPSHETAPAREAOF_SPSETAPAREAOFR
IDETAPA int 4 null
SPSPROVAETAPAAREA.IDETAPA FKSPSETAREOF_SPSHORETAREAOFR
SPSETAPAAREAOFERTADA.IDETAPA FKSPSHETAPAREAOF_SPSETAPAREAOFR
IDHORARIO int 4 null
SPSPROVAETAPAAREA.IDHORARIO FKSPSETAREOF_SPSHORETAREAOFR
DATAETAPA datetime 16,3 null
HORAINICIO int 4 null
HORAFIM int 4 null
DATAETAPAFIM datetime 16,3 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
PROVAFACILKEY varchar 40 √ null
PROVAFACILTEMPTEST varchar 40 √ null
PROVAFACILTEMPTESTKEY varchar 40 √ null
PROVAFACILTESTNAME varchar 255 √ null
DATALIMITEEXECPROVA smallint 2 √ null
DURACAOEXECPROVA smallint 2 √ null
NOTAMINIMA RMDVALOR4 17,4 √ null
DESCPROVAZERADA BOOLEAN 1 √ null
DESCNOTAABAIXOMINIMA BOOLEAN 1 √ null

Indexes

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

Relationships

Close relationships within degrees of separation