GJOBX

2754 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDJOB int 4 null
GCOPIACOLIGADAEXECUCAO.IDJOBTEMPLATEPAI FKGCOPIACOLIGADAEXECUCAO_GJOBXR
GJOBLOG.IDJOBX FKGJOBLOG_GJOBXR
GJOBXEXECUCAO.IDJOB FKGJOBXEXECUCAO_GJOBXR
GJOBXEXECUCAOHST.IDJOB FKGJOBXEXECUCAOHST_GJOBXR
GRELBATCH.IDJOBX FKGRELBATCH_GJOBXR
PSCHEDULEMESSAGESLOGPUSH.JOBID FKPSCHEDULELOGPUSH_GJOBXR
NOME varchar 100 null
EPLANILHASEXP.NOME Implied ConstraintR
CODSISTEMA varchar 1 null
GSISTEMA.CODSISTEMA FKGJOBX_GSISTEMAR
CODCOLIGADA DCODCOLIGADA 2 null
GCOLIGADA.CODCOLIGADA FKGJOBX_GCILIGADAR
CLASSEPROCESSO varchar 128 null
CLASSEPARAMETROS varchar 1000 √ null
CODUSUARIO varchar 20 √ null
GUSUARIO.CODUSUARIO FKGJOBX_GUSUARIOR
DATACRIACAO datetime 16,3 null
TIPORECORRENCIA smallint 2 √ null
HORARECORRENCIA smallint 2 √ null
MINUTORECORRENCIA smallint 2 √ null
DIASDASEMANA smallint 2 √ null
DIADOMES smallint 2 √ null
INTERVALOHORAS smallint 2 √ null
INTERVALOMINUTOS smallint 2 √ null
VALORPARAMETROS DIMAGEM 2147483647 √ null
TIPOJOB int 4 (0)
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DISABLEISOLATEPROCESS DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
ISOLATEPROCESS DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
APPSERVER varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PKGJOBX Primary key Asc IDJOB
IDX_GJOBX_CLASSEPROCESSO Performance Asc CLASSEPROCESSO
IDX_GJOBX_GCOLIGADA Performance Asc CODCOLIGADA
IDX_GJOBX_GSISTEMA Performance Asc CODSISTEMA
IDX_GJOBX_GUSUARIO Performance Asc CODUSUARIO

Relationships

Close relationships within degrees of separation