PSUBSTCHEFE

17 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PSECAO.CODCOLIGADA FKPSUBSTCHEFE_PSECAOR
CODSECAO varchar 35 null
PSECAO.CODIGO FKPSUBSTCHEFE_PSECAOR
CHAPASUBST DCHAPA 16 null
PFUNC.CHAPA FKPSUBSTCHEFE_PFUNCR
DATAINICIO datetime 16,3 null
DATAFIM datetime 16,3 √ null
MASTER DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CODCOLSUBST DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKPSUBSTCHEFE_PFUNCR
CHEFIAAPROVBAT 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 FKPSUBSTCHEFE_PFUNC_2R
PEXTERNO.CODCOLIGADA FKPSUBSTCHEFE_PEXTERNO_2R
CHAPASOLICITANTE DCHAPANULL 16 √ null
PFUNC.CHAPA FKPSUBSTCHEFE_PFUNC_2R
CODEXTERNOSOLICITANTE DCHAPANULL 16 √ null
PEXTERNO.CODEXTERNO FKPSUBSTCHEFE_PEXTERNO_2R

Indexes

Constraint Name Type Sort Column(s)
PKPSUBSTCHEFE Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODSECAO + CODCOLSUBST + CHAPASUBST + DATAINICIO
IXPSUBSTCHEFE1 Performance Asc/Asc CODCOLIGADASOLICITANTE + CHAPASOLICITANTE
IXPSUBSTCHEFE2 Performance Asc/Asc CODCOLIGADASOLICITANTE + CODEXTERNOSOLICITANTE
PXPSUBSTCHEFE Performance Asc/Asc CODCOLSUBST + CHAPASUBST

Relationships

Close relationships within degrees of separation