Datadictionary OpenWave 3.1.25 |
|
Table: tbexportcontainer
Datadictionary OpenWave 3.1.25 |
|
Table: tbexportcontainer
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Moedertabel van tbexportscript. De output documenten van tbexportscript worden hierin verzameld onder een outputnaam en een endpoint
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbexportcontainer_dnkey_seq'::regclass) |
Primary key |
|
|
dvcode |
varchar(40) |
|
|
|
|
Undiek codering waarmee container bijv. via taskscheduler kan worden aangeroepen |
|
|
dvoutputnaam |
varchar(200) |
|
|
|
|
De naam waaronder de outputfiles van tbexportscript worden ingepakt in zipfile |
|
|
dvomschrijving |
varchar(2000) |
|
|
|
|
Omschrjving van de container |
|
|
dvendpointadres |
varchar(200) |
|
|
|
|
Endpoint waarnaar de zip-file dvoutputnaam naar toe wordt verplaatst (indien leeg dan in tboperations) |
|
|
dvendpointtype |
varchar(10) |
|
|
|
|
Type van endpoint bij gevuld dvenpointadres bijv FTP, SFTP of SMTP |
|
|
dvendpointlogin |
varchar(200) |
|
|
|
|
Loginaan voor endpointadres |
|
|
dvendpointpass |
varchar(200) |
|
|
|
|
password voor endpointadres |
Foreign Keys
There are no foreign keys for table tbexportcontainer
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbexportcontainer_dvoutputnaam |
dvoutputnaam IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbexportcontainer |
btree |
|
dnkey |
|
|
|
idu_tbexportcontainer_dvcode |
btree |
|
dvcode |
|
|
|
Triggers
There are no triggers for table tbexportcontainer
Rules
There are no rules for table tbexportcontainer
Policies
There are no policies for table tbexportcontainer
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_tbexportscript_keyexportcont |
dnkeyexportcontainer |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvcode VARCHAR(40),
dvoutputnaam VARCHAR(200),
dvomschrijving VARCHAR(2000),
dvendpointadres VARCHAR(200),
dvendpointtype VARCHAR(10),
dvendpointlogin VARCHAR(200),
dvendpointpass VARCHAR(200),
CONSTRAINT cpk_tbexportcontainer PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbexportcontainer_dvoutputnaam CHECK (dvoutputnaam IS NOT NULL)
) ;
COMMENT ON TABLE public.tbexportcontainer
IS 'Moedertabel van tbexportscript. De output documenten van tbexportscript worden hierin verzameld onder een outputnaam en een endpoint';
COMMENT ON COLUMN public.tbexportcontainer.dnkey
IS 'Primary key';
COMMENT ON COLUMN public.tbexportcontainer.dvcode
IS 'Undiek codering waarmee container bijv. via taskscheduler kan worden aangeroepen';
COMMENT ON COLUMN public.tbexportcontainer.dvoutputnaam
IS 'De naam waaronder de outputfiles van tbexportscript worden ingepakt in zipfile';
COMMENT ON COLUMN public.tbexportcontainer.dvomschrijving
IS 'Omschrjving van de container';
COMMENT ON COLUMN public.tbexportcontainer.dvendpointadres
IS 'Endpoint waarnaar de zip-file dvoutputnaam naar toe wordt verplaatst (indien leeg dan in tboperations)';
COMMENT ON COLUMN public.tbexportcontainer.dvendpointtype
IS 'Type van endpoint bij gevuld dvenpointadres bijv FTP, SFTP of SMTP';
COMMENT ON COLUMN public.tbexportcontainer.dvendpointlogin
IS 'Loginaan voor endpointadres';
COMMENT ON COLUMN public.tbexportcontainer.dvendpointpass
IS 'password voor endpointadres';
CREATE UNIQUE INDEX idu_tbexportcontainer_dvcode ON public.tbexportcontainer
USING btree (dvcode COLLATE pg_catalog."default");
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|