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 (Open-Wave API) die uitgeveord moet worden inclusief de nodige parameters, waaronder de tbtaskscheduler.dnkey zelf |
|
|
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 |
|
|
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 |
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]) |
|
cnn_dltaskenabled |
dltaskenabled 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
Referenced
There are no tables referenced by table tbtaskscheduler
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
CREATE TABLE public.tbtaskscheduler (
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),
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 cnn_dltaskenabled CHECK (dltaskenabled IS NOT NULL)
)
WITH (oids = false);
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 (Open-Wave API) die uitgeveord moet worden inclusief de nodige parameters, waaronder de tbtaskscheduler.dnkey zelf';
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';
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';
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 2-9-2021 14:10 |
![]() ![]() ![]() |