AFLUXOSOBREAV

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
AEESPFUN.CODCOLIGADA FKAEESPFUN_AFLUXOSOBREAVR
ARECORSOBREAV.CODCOLIGADA FKARECORSOBREAV_AFLUXOSOBREAVR
PFUNC.CODCOLIGADA FKAFLUXOSOBREAV_PFUNCR
CHAPA DCHAPA 16 null
PFUNC.CHAPA FKAFLUXOSOBREAV_PFUNCR
IDFLUXO int 4 null
AEESPFUN.IDFLUXO FKAEESPFUN_AFLUXOSOBREAVR
ARECORSOBREAV.IDFLUXO FKARECORSOBREAV_AFLUXOSOBREAVR
COLIGADASOLICITANTE DCODCOLIGADANULL 2 √ null
PFUNC.CODCOLIGADA FKAFSASOLIC_PFUNCR
CHAPASOLICITANTE DCHAPANULL 16 √ null
PFUNC.CHAPA FKAFSASOLIC_PFUNCR
COLIGADAAPROVADOR DCODCOLIGADANULL 2 √ null
PFUNC.CODCOLIGADA FKAFSAAPROV_PFUNCR
CHAPAAPROVADOR DCHAPANULL 16 √ null
PFUNC.CHAPA FKAFSAAPROV_PFUNCR
STATUS int 4 ((0))
DATAAPROVACAO datetime 16,3 √ null
ORIGEM int 4 √ null
JUSTIFICATIVAREPROVACAO varchar 100 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DTINICIO datetime 16,3 null
DTFIM datetime 16,3 null
HORPLANEJ int 4 ((0))
HORCOMP int 4 ((0))
HORDESCANSO int 4 ((0))
FERIADO int 4 ((0))
HORAINICIO int 4 null
HORAFIM int 4 null
JUSTIFICATIVASOLICITACAO varchar 100 √ null

Indexes

Constraint Name Type Sort Column(s)
PKAFLUXOSOBREAV Primary key Asc/Asc CODCOLIGADA + IDFLUXO

Relationships

Close relationships within degrees of separation