Datadictionary OpenWave 3.1.11 |
|
Table: tbbadextupload
Datadictionary OpenWave 3.1.11 |
|
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
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)
)
WITH (oids = false);
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 22-2-2017 10:50 |
|