PSUBSTSUP

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKPSUBSTSUP_PFUNCR
PSECAO.CODCOLIGADA FKPSUBSTSUP_PSECAOR
CODSECAO varchar 35 null
PSECAO.CODIGO FKPSUBSTSUP_PSECAOR
CODEQUIPE varchar 20 null
PEQUIPE.CODCLIENTE FKPSUBSTSUP_PEQUIPER
CHAPASUBST DCHAPA 16 null
PFUNC.CHAPA FKPSUBSTSUP_PFUNCR
DATAINICIO datetime 16,3 null
DATAFIM datetime 16,3 √ null
MASTER DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
SUPAPROVBAT smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
RECEBEEMAIL smallint 2 ((1))
CODCOLIGADASOLICITANTE DCODCOLIGADANULL 2 √ null
PFUNC.CODCOLIGADA FKPSUBSTSUP_PFUNC_2R
PEXTERNO.CODCOLIGADA FKPSUBSTSUP_PEXTERNO_2R
CHAPASOLICITANTE DCHAPANULL 16 √ null
PFUNC.CHAPA FKPSUBSTSUP_PFUNC_2R
CODEXTERNOSOLICITANTE DCHAPANULL 16 √ null
PEXTERNO.CODEXTERNO FKPSUBSTSUP_PEXTERNO_2R

Indexes

Constraint Name Type Sort Column(s)
PKPSUBSTSUP Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODSECAO + CODEQUIPE + CHAPASUBST + DATAINICIO
IXPSUBSTSUP1 Performance Asc/Asc CODCOLIGADASOLICITANTE + CHAPASOLICITANTE
IXPSUBSTSUP2 Performance Asc/Asc CHAPASOLICITANTE + CODEXTERNOSOLICITANTE
PXPSUBSTSUP Performance Asc/Asc CODCOLIGADA + CHAPASUBST

Relationships

Close relationships within degrees of separation