Datadictionary OpenWave 3.1.25 |
|
Table: tbbadextupload
Datadictionary OpenWave 3.1.25 |
|
Table: tbbadextupload
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met mislukte automatisch door een extern systeem getriggerde uploads
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbbadextupload_dnkey_seq'::regclass) |
Primary key. |
|
|
dvsource |
varchar(20) |
|
|
|
|
Bron bijvoorbeeld OLO |
|
|
ddtimestamp |
timestamp |
|
|
|
|
Moment van mislukte plaatsing extern document |
|
|
dvfilename |
varchar(500) |
|
|
|
|
Filenaam die geplaatst had moeten worden |
|
|
dvidentifier |
varchar(40) |
|
|
|
|
Identifier met behulp waarvan het document op de juiste map/zaak gekoppeld kan worden |
|
|
dverror |
varchar(500) |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table tbbadextupload
Check Constraints
There are no check constraints for table tbbadextupload
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbbadextupload |
btree |
|
dnkey |
|
|
|
idx_badextupload_ddtimestamp |
btree |
|
ddtimestamp |
|
|
|
idx_badextupload_dvidentifier |
btree |
|
dvidentifier |
|
|
|
Triggers
There are no triggers for table tbbadextupload
Rules
There are no rules for table tbbadextupload
Policies
There are no policies for table tbbadextupload
Referenced
There are no tables referenced by table tbbadextupload
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvsource VARCHAR(20),
ddtimestamp TIMESTAMP WITHOUT TIME ZONE,
dvfilename VARCHAR(500),
dvidentifier VARCHAR(40),
dverror VARCHAR(500),
CONSTRAINT cpk_tbbadextupload PRIMARY KEY(dnkey)
) ;
COMMENT ON TABLE public.tbbadextupload
IS 'Tabel met mislukte automatisch door een extern systeem getriggerde uploads';
COMMENT ON COLUMN public.tbbadextupload.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbbadextupload.dvsource
IS 'Bron bijvoorbeeld OLO';
COMMENT ON COLUMN public.tbbadextupload.ddtimestamp
IS 'Moment van mislukte plaatsing extern document';
COMMENT ON COLUMN public.tbbadextupload.dvfilename
IS 'Filenaam die geplaatst had moeten worden';
COMMENT ON COLUMN public.tbbadextupload.dvidentifier
IS 'Identifier met behulp waarvan het document op de juiste map/zaak gekoppeld kan worden';
CREATE INDEX idx_badextupload_ddtimestamp ON public.tbbadextupload
USING btree (ddtimestamp);
CREATE INDEX idx_badextupload_dvidentifier ON public.tbbadextupload
USING btree (dvidentifier COLLATE pg_catalog."default");
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|