SPSETAPAAREAOFERTADA

12 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SPSHORARIOETAPAAREAOFERTADA.CODCOLIGADA FKSPSHETAPAREAOF_SPSETAPAREAOFR
SPSAREAOFERTADA.CODCOLIGADA FKSPSETAPAAREAOFER_SPSAREAOFERR
IDPS int 4 null
SPSHORARIOETAPAAREAOFERTADA.IDPS FKSPSHETAPAREAOF_SPSETAPAREAOFR
SPSAREAOFERTADA.IDPS FKSPSETAPAAREAOFER_SPSAREAOFERR
IDAREAINTERESSE int 4 null
SPSHORARIOETAPAAREAOFERTADA.IDAREAINTERESSE FKSPSHETAPAREAOF_SPSETAPAREAOFR
SPSAREAOFERTADA.IDAREAINTERESSE FKSPSETAPAAREAOFER_SPSAREAOFERR
IDETAPA int 4 null
SPSHORARIOETAPAAREAOFERTADA.IDETAPA FKSPSHETAPAREAOF_SPSETAPAREAOFR
NOME varchar 20 null
TIPOETAPA smallint 2 √ null
ORDEMETAPA int 4 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

Indexes

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

Relationships

Close relationships within degrees of separation