Datadictionary OpenWave 3.1.25 |
|
Table: tbtaskscheduler
Datadictionary OpenWave 3.1.25 |
|
Table: tbtaskscheduler
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met taken (action-aanroepen) die vanaf een bepaalde datum/tijd om een interval in minuten aangeroepen worden.
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbtaskscheduler_dnkey_seq'::regclass) |
Primary key |
|
|
dvtaskcodering |
varchar(40) |
|
|
|
|
Unieke codering van de taak |
|
|
dvtaskaction |
varchar(2000) |
|
|
|
|
Action (een callable = Open-Wave API zonder userinterface) die uitgeveord moet worden |
|
|
dltaskenabled |
char(1) |
|
|
|
'F'::bpchar |
T of F. Default F. Indien T dan mag de taak uitgevoerd worden |
|
|
dninterval |
integer |
|
|
|
|
Aantal minuten dat bij ddexecutionstarttime moet worden opgeteld na uitvoering van de taak. Minimaal 5 |
|
|
ddexecutionstarttime |
timestamp |
|
|
|
|
Eerstvolgende datum/tijd dat taak gestart dient te worden |
|
|
ddexecutionstoptime |
timestamp |
|
|
|
|
Laatste datum/tijd dat taak is uitgevoerd |
|
|
dvstatus |
char(1) |
|
|
|
'0'::bpchar |
De status van de taak: 0 = goed afgerond, 1 = gestart / bezig, 2 = afgerond, maar mislukt |
|
|
dvtoelichting |
varchar(2000) |
|
|
|
|
Vrije toelichting op taak |
|
|
dlmessagelog |
char(1) |
|
|
|
'T'::bpchar |
T of F. Inien true wordt de messagelog gevuld (indien onderdelen van de taak daaarop van toepassing zijn) |
|
|
dloperationslog |
char(1) |
|
|
|
'T'::bpchar |
T of F. Inien true wordt de operationslog gevuld (indien onderdelen van de taak daaarop van toepassing zijn) |
Foreign Keys
There are no foreign keys for table tbtaskscheduler
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_dltaskenabled |
dltaskenabled = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_dvstatus |
dvstatus = ANY (ARRAY['0'::bpchar, '1'::bpchar, '2'::bpchar]) |
|
chk_taskscheduler_dlmessagelog |
dlmessagelog = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
chk_taskscheduler_dloperationslog |
dloperationslog = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
cnn_dltaskenabled |
dltaskenabled IS NOT NULL |
|
cnn_taskscheduler_dlmessagelog |
dlmessagelog IS NOT NULL |
|
cnn_taskscheduler_dloperationslog |
dloperationslog IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbtaskscheduler |
btree |
|
dnkey |
|
|
|
idu_taskscheduler_taskcod |
btree |
|
dvtaskcodering |
|
|
|
Triggers
There are no triggers for table tbtaskscheduler
Rules
There are no rules for table tbtaskscheduler
Policies
There are no policies for table tbtaskscheduler
Referenced
There are no tables referenced by table tbtaskscheduler
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvtaskcodering VARCHAR(40),
dvtaskaction VARCHAR(2000),
dltaskenabled CHAR(1) DEFAULT 'F'::bpchar,
dninterval INTEGER,
ddexecutionstarttime TIMESTAMP WITHOUT TIME ZONE,
ddexecutionstoptime TIMESTAMP WITHOUT TIME ZONE,
dvstatus CHAR(1) DEFAULT '0'::bpchar,
dvtoelichting VARCHAR(2000),
dlmessagelog CHAR(1) DEFAULT 'T'::bpchar,
dloperationslog CHAR(1) DEFAULT 'T'::bpchar,
CONSTRAINT cpk_tbtaskscheduler PRIMARY KEY(dnkey),
CONSTRAINT chk_dltaskenabled CHECK (dltaskenabled = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_dvstatus CHECK (dvstatus = ANY (ARRAY['0'::bpchar, '1'::bpchar, '2'::bpchar])),
CONSTRAINT chk_taskscheduler_dlmessagelog CHECK (dlmessagelog = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
CONSTRAINT chk_taskscheduler_dloperationslog CHECK (dloperationslog = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
CONSTRAINT cnn_dltaskenabled CHECK (dltaskenabled IS NOT NULL),
CONSTRAINT cnn_taskscheduler_dlmessagelog CHECK (dlmessagelog IS NOT NULL),
CONSTRAINT cnn_taskscheduler_dloperationslog CHECK (dloperationslog IS NOT NULL)
) ;
COMMENT ON TABLE public.tbtaskscheduler
IS 'Tabel met taken (action-aanroepen) die vanaf een bepaalde datum/tijd om een interval in minuten aangeroepen worden.';
COMMENT ON COLUMN public.tbtaskscheduler.dnkey
IS 'Primary key';
COMMENT ON COLUMN public.tbtaskscheduler.dvtaskcodering
IS 'Unieke codering van de taak';
COMMENT ON COLUMN public.tbtaskscheduler.dvtaskaction
IS 'Action (een callable = Open-Wave API zonder userinterface) die uitgeveord moet worden';
COMMENT ON COLUMN public.tbtaskscheduler.dltaskenabled
IS 'T of F. Default F. Indien T dan mag de taak uitgevoerd worden';
COMMENT ON COLUMN public.tbtaskscheduler.dninterval
IS 'Aantal minuten dat bij ddexecutionstarttime moet worden opgeteld na uitvoering van de taak. Minimaal 5';
COMMENT ON COLUMN public.tbtaskscheduler.ddexecutionstarttime
IS 'Eerstvolgende datum/tijd dat taak gestart dient te worden';
COMMENT ON COLUMN public.tbtaskscheduler.ddexecutionstoptime
IS 'Laatste datum/tijd dat taak is uitgevoerd';
COMMENT ON COLUMN public.tbtaskscheduler.dvstatus
IS 'De status van de taak: 0 = goed afgerond, 1 = gestart / bezig, 2 = afgerond, maar mislukt';
COMMENT ON COLUMN public.tbtaskscheduler.dvtoelichting
IS 'Vrije toelichting op taak';
COMMENT ON COLUMN public.tbtaskscheduler.dlmessagelog
IS 'T of F. Inien true wordt de messagelog gevuld (indien onderdelen van de taak daaarop van toepassing zijn) ';
COMMENT ON COLUMN public.tbtaskscheduler.dloperationslog
IS 'T of F. Inien true wordt de operationslog gevuld (indien onderdelen van de taak daaarop van toepassing zijn) ';
CREATE UNIQUE INDEX idu_taskscheduler_taskcod ON public.tbtaskscheduler
USING btree (dvtaskcodering COLLATE pg_catalog."default");
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|