Datadictionary OpenWave 3.1.25 |
|
View: vwfrmimages
Datadictionary OpenWave 3.1.25 |
|
View: vwfrmimages
Schema
public
Owner
waveuser005
Descriptions
View van de tabel tbimages (tabel met plaatjes)
Fields
Name | Data type | Description |
|---|---|---|
dnkey |
integer |
Primary key (tbimages.dnkey). |
dvcode |
varchar(40) |
Unieke - niet lege - codering. |
dvimagefilenaam |
varchar(200) |
|
dnimagepixelhoogte |
integer |
Hoogte in pixels |
dnimagepixelbreedte |
integer |
Breedte in pixels. |
dlimageisupgeload |
char(1) |
T of F. Berekende kolom: indien dvimagebase64 niet leeg is dan krigt deze kolom de waarde T |
dfimagembgrootte |
double precision |
Grootte van dvimagebase64 in megabytes. |
dvimagetype |
varchar(5) |
type van image bijv png, ico, jpeg |
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwfrmimages
Definition
dnkey,
dvcode,
dvimagefilenaam,
dnimagepixelhoogte,
dnimagepixelbreedte,
dlimageisupgeload,
dfimagembgrootte,
dvimagetype)
AS
SELECT a.dnkey,
a.dvcode,
a.dvimagefilenaam,
a.dnimagepixelhoogte,
a.dnimagepixelbreedte,
CASE
WHEN a.dvimagebase64 IS NULL THEN 'F'::text
ELSE 'T'::text
END::character(1) AS dlimageisupgeload,
a.dfimagembgrootte,
a.dvimagetype
FROM tbimages a;
COMMENT ON VIEW public.vwfrmimages
IS 'View van de tabel tbimages (tabel met plaatjes)';
COMMENT ON COLUMN public.vwfrmimages.dnkey
IS 'Primary key (tbimages.dnkey).';
COMMENT ON COLUMN public.vwfrmimages.dvcode
IS 'Unieke - niet lege - codering.';
COMMENT ON COLUMN public.vwfrmimages.dnimagepixelhoogte
IS 'Hoogte in pixels';
COMMENT ON COLUMN public.vwfrmimages.dnimagepixelbreedte
IS 'Breedte in pixels.';
COMMENT ON COLUMN public.vwfrmimages.dlimageisupgeload
IS 'T of F. Berekende kolom: indien dvimagebase64 niet leeg is dan krigt deze kolom de waarde T';
COMMENT ON COLUMN public.vwfrmimages.dfimagembgrootte
IS 'Grootte van dvimagebase64 in megabytes.';
COMMENT ON COLUMN public.vwfrmimages.dvimagetype
IS 'type van image bijv png, ico, jpeg';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|