Datadictionary OpenWave 3.1.11 |
|
Table: tbupload
Datadictionary OpenWave 3.1.11 |
|
Table: tbupload
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met verwijzingen naar up te loaden of upgeloade files van device naar tempmap op javaserver
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbupload_dnkey_seq'::regclass) |
Primary key. |
|
|
dvcodemedewerker |
char(5) |
|
|
|
|
Code van de medewerker die file heeft aangwezen om te worden geupload |
|
|
dvuuid |
varchar(40) |
|
|
|
|
Unieke uuid-code die aan de up te loaden file is toegekend |
|
|
dvfilenaam |
varchar(500) |
|
|
|
|
Filenaam van up te loaden file |
|
|
ddfiledatum |
timestamp |
|
|
|
|
Filedatum van up te loaden file |
|
|
dvfilegrootte |
varchar(20) |
|
|
|
|
Filegrootte van up te loaden file |
|
|
dvdocumenttype |
varchar(40) |
|
|
|
|
Documenttype van up te loaden file (brief, verslag) |
|
|
dvtitel |
varchar(500) |
|
|
|
|
Toelichting op bestandsnaam |
|
|
dvdocstatus |
varchar(40) |
|
|
|
|
Concept, proef, definitief etc. |
|
|
dvvertrouwelijkheid |
varchar(40) |
|
|
|
|
Geheim, Openbaar etcetera. |
|
|
dvtransporttype |
varchar(40) |
|
|
|
|
fileshare, cmis, stuf |
|
|
dvbestemming |
varchar(500) |
|
|
|
|
mapnaam indien dvtransporttype is cmis of fileshare |
|
|
dvtransportstatus |
varchar(40) |
|
|
|
|
Staat klaar, Ben bezig, Verzonden, Mislukt |
|
|
ddtimestamp |
timestamp |
|
|
|
|
Timestamp dat tbuploadkaart is aangemaakt. |
|
|
dvherkomsttabel |
varchar(25) |
|
|
|
|
Tabelnaam van openwave waarvanuit upload is gedaan. |
|
|
dnherkomstkey |
integer |
|
|
|
|
Dnkey van Tabelnaam van openwave waarvanuit upload is gedaan. |
|
|
dvendpoint |
varchar(500) |
|
|
|
|
Endpoint indien dvtransporttype is cmis of stuf, rootmap indien fileshare |
|
|
dvomsendpoint |
varchar(50) |
|
|
|
|
Omschrijving van endpoint indien dvtransporttype is cmis of stuf, anders het woord fileshare |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbupload_dvcodemedewerker |
dvcodemedewerker |
dvcode |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbupload_dvcodemedewerker |
dvcodemedewerker IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbupload |
btree |
|
dnkey |
|
|
|
idx_tbupload_dddtimestamp |
btree |
|
ddtimestamp |
|
|
|
idx_tbupload_dnkerkomstkey |
btree |
|
dnherkomstkey |
|
|
|
idx_tbupload_dvcodemedewerker |
btree |
|
dvcodemedewerker |
|
|
|
idx_tbupload_dvuuid |
btree |
|
dvuuid |
|
|
|
Triggers
There are no triggers for table tbupload
Rules
There are no rules for table tbupload
Referenced
There are no tables referenced by table tbupload
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvcodemedewerker CHAR(5),
dvuuid VARCHAR(40),
dvfilenaam VARCHAR(500),
ddfiledatum TIMESTAMP WITHOUT TIME ZONE,
dvfilegrootte VARCHAR(20),
dvdocumenttype VARCHAR(40),
dvtitel VARCHAR(500),
dvdocstatus VARCHAR(40),
dvvertrouwelijkheid VARCHAR(40),
dvtransporttype VARCHAR(40),
dvbestemming VARCHAR(500),
dvtransportstatus VARCHAR(40),
ddtimestamp TIMESTAMP WITHOUT TIME ZONE,
dvherkomsttabel VARCHAR(25),
dnherkomstkey INTEGER,
dvendpoint VARCHAR(500),
dvomsendpoint VARCHAR(50),
CONSTRAINT cpk_tbupload PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbupload_dvcodemedewerker CHECK (dvcodemedewerker IS NOT NULL),
CONSTRAINT cfk_tbupload_dvcodemedewerker FOREIGN KEY (dvcodemedewerker)
REFERENCES public.tbmedewerkers(dvcode)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tbupload
IS 'Tabel met verwijzingen naar up te loaden of upgeloade files van device naar tempmap op javaserver';
COMMENT ON COLUMN public.tbupload.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbupload.dvcodemedewerker
IS 'Code van de medewerker die file heeft aangwezen om te worden geupload';
COMMENT ON COLUMN public.tbupload.dvuuid
IS 'Unieke uuid-code die aan de up te loaden file is toegekend';
COMMENT ON COLUMN public.tbupload.dvfilenaam
IS 'Filenaam van up te loaden file';
COMMENT ON COLUMN public.tbupload.ddfiledatum
IS 'Filedatum van up te loaden file';
COMMENT ON COLUMN public.tbupload.dvfilegrootte
IS 'Filegrootte van up te loaden file';
COMMENT ON COLUMN public.tbupload.dvdocumenttype
IS 'Documenttype van up te loaden file (brief, verslag)';
COMMENT ON COLUMN public.tbupload.dvtitel
IS 'Toelichting op bestandsnaam';
COMMENT ON COLUMN public.tbupload.dvdocstatus
IS 'Concept, proef, definitief etc. ';
COMMENT ON COLUMN public.tbupload.dvvertrouwelijkheid
IS 'Geheim, Openbaar etcetera.';
COMMENT ON COLUMN public.tbupload.dvtransporttype
IS 'fileshare, cmis, stuf';
COMMENT ON COLUMN public.tbupload.dvbestemming
IS 'mapnaam indien dvtransporttype is cmis of fileshare';
COMMENT ON COLUMN public.tbupload.dvtransportstatus
IS 'Staat klaar, Ben bezig, Verzonden, Mislukt';
COMMENT ON COLUMN public.tbupload.ddtimestamp
IS 'Timestamp dat tbuploadkaart is aangemaakt.';
COMMENT ON COLUMN public.tbupload.dvherkomsttabel
IS 'Tabelnaam van openwave waarvanuit upload is gedaan.';
COMMENT ON COLUMN public.tbupload.dnherkomstkey
IS 'Dnkey van Tabelnaam van openwave waarvanuit upload is gedaan.';
COMMENT ON COLUMN public.tbupload.dvendpoint
IS 'Endpoint indien dvtransporttype is cmis of stuf, rootmap indien fileshare';
COMMENT ON COLUMN public.tbupload.dvomsendpoint
IS 'Omschrijving van endpoint indien dvtransporttype is cmis of stuf, anders het woord fileshare';
CREATE INDEX idx_tbupload_dddtimestamp ON public.tbupload
USING btree (ddtimestamp);
CREATE INDEX idx_tbupload_dnkerkomstkey ON public.tbupload
USING btree (dnherkomstkey);
CREATE INDEX idx_tbupload_dvcodemedewerker ON public.tbupload
USING btree (dvcodemedewerker COLLATE pg_catalog."default");
CREATE INDEX idx_tbupload_dvuuid ON public.tbupload
USING btree (dvuuid COLLATE pg_catalog."default");
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|