Datadictionary OpenWave 3.1.32 |
|
Table: tbdownload
Datadictionary OpenWave 3.1.32 |
|
Table: tbdownload
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met verwijzingen naar te downloaden files vanuit OpenWave naar tempmap op JAVA server
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbdownload_dnkey_seq'::regclass) |
Primary key |
|
|
dvuuid |
varchar(40) |
|
|
|
|
Unieke uuid-code die aan de down te loaden file is toegekend |
|
|
dvfilenaam |
varchar(500) |
|
|
|
|
Naam van de te downloaden file |
|
|
dvcodemedewerker |
char(5) |
|
|
|
|
Code van de medewerker (tbmedewerkers.dvcode) die file heeft aangwezen om te worden gedownload |
|
|
ddaanvraagdatum |
timestamp |
|
|
|
|
Datum van aanvraag |
|
|
dvstatuscode |
varchar(40) |
|
|
|
|
Status van de te down loaden file zoals: Staat klaar, Ben bezig, Verzonden, Mislukt |
|
|
dvstatusmessage |
varchar(1000) |
|
|
|
|
Error code/text |
|
|
dvendpoint |
varchar(500) |
|
|
|
|
Endpoint van de down te loaden file: geeft aan waar het bestand vandaan komt |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbdownload_dvcodemew |
dvcodemedewerker |
dvcode |
Set Null |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbdownload_ddaanvraagdatum |
ddaanvraagdatum IS NOT NULL |
|
cnn_tbdownload_dvcodemew |
dvcodemedewerker IS NOT NULL |
|
cnn_tbdownload_dvfilenaam |
dvfilenaam IS NOT NULL |
|
cnn_tbdownload_dvuuid |
dvuuid IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbdownload |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbdownload
Rules
There are no rules for table tbdownload
Policies
There are no policies for table tbdownload
Referenced
There are no tables referenced by table tbdownload
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvuuid VARCHAR(40),
dvfilenaam VARCHAR(500),
dvcodemedewerker CHAR(5),
ddaanvraagdatum TIMESTAMP WITHOUT TIME ZONE,
dvstatuscode VARCHAR(40),
dvstatusmessage VARCHAR(1000),
dvendpoint VARCHAR(500),
CONSTRAINT cpk_tbdownload PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbdownload_ddaanvraagdatum CHECK (ddaanvraagdatum IS NOT NULL),
CONSTRAINT cnn_tbdownload_dvcodemew CHECK (dvcodemedewerker IS NOT NULL),
CONSTRAINT cnn_tbdownload_dvfilenaam CHECK (dvfilenaam IS NOT NULL),
CONSTRAINT cnn_tbdownload_dvuuid CHECK (dvuuid IS NOT NULL),
CONSTRAINT cfk_tbdownload_dvcodemew FOREIGN KEY (dvcodemedewerker)
REFERENCES public.tbmedewerkers(dvcode)
ON DELETE SET NULL
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbdownload
IS 'Tabel met verwijzingen naar te downloaden files vanuit OpenWave naar tempmap op JAVA server';
COMMENT ON COLUMN public.tbdownload.dnkey
IS 'Primary key';
COMMENT ON COLUMN public.tbdownload.dvuuid
IS 'Unieke uuid-code die aan de down te loaden file is toegekend';
COMMENT ON COLUMN public.tbdownload.dvfilenaam
IS 'Naam van de te downloaden file';
COMMENT ON COLUMN public.tbdownload.dvcodemedewerker
IS 'Code van de medewerker (tbmedewerkers.dvcode) die file heeft aangwezen om te worden gedownload';
COMMENT ON COLUMN public.tbdownload.ddaanvraagdatum
IS 'Datum van aanvraag';
COMMENT ON COLUMN public.tbdownload.dvstatuscode
IS 'Status van de te down loaden file zoals: Staat klaar, Ben bezig, Verzonden, Mislukt';
COMMENT ON COLUMN public.tbdownload.dvstatusmessage
IS 'Error code/text';
COMMENT ON COLUMN public.tbdownload.dvendpoint
IS 'Endpoint van de down te loaden file: geeft aan waar het bestand vandaan komt';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49 |
|