Datadictionary OpenWave 3.1.25 |
|
Table: tbimages
Datadictionary OpenWave 3.1.25 |
|
Table: tbimages
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met plaatjes
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbimages_dnkey_seq'::regclass) |
Primary key. |
|
|
dvcode |
varchar(40) |
|
|
|
|
Unieke - niet lege - codering. |
|
|
dvimagebase64 |
text |
|
|
|
|
Het plaatje uitgedrukt als base64 string. |
|
|
dvimagefilenaam |
varchar(200) |
|
|
|
|
|
|
|
dnimagepixelhoogte |
integer |
|
|
|
|
Hoogte in pixels |
|
|
dnimagepixelbreedte |
integer |
|
|
|
|
Breedte in pixels. |
|
|
dfimagembgrootte |
double precision |
|
|
|
|
Grootte van dvimagebase64 in megabytes. |
|
|
dvimagetype |
varchar(5) |
|
|
|
|
type van image bijv png, ico, jpeg |
Foreign Keys
There are no foreign keys for table tbimages
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_images_dvcode |
dvcode IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbimages |
btree |
|
dnkey |
|
|
|
idu_images_dvcode |
btree |
|
dvcode |
|
|
|
Triggers
There are no triggers for table tbimages
Rules
There are no rules for table tbimages
Policies
There are no policies for table tbimages
Referenced
There are no tables referenced by table tbimages
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvcode VARCHAR(40),
dvimagebase64 TEXT,
dvimagefilenaam VARCHAR(200),
dnimagepixelhoogte INTEGER,
dnimagepixelbreedte INTEGER,
dfimagembgrootte DOUBLE PRECISION,
dvimagetype VARCHAR(5),
CONSTRAINT cpk_tbimages PRIMARY KEY(dnkey),
CONSTRAINT cnn_images_dvcode CHECK (dvcode IS NOT NULL)
) ;
COMMENT ON TABLE public.tbimages
IS 'Tabel met plaatjes';
COMMENT ON COLUMN public.tbimages.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbimages.dvcode
IS 'Unieke - niet lege - codering.';
COMMENT ON COLUMN public.tbimages.dvimagebase64
IS 'Het plaatje uitgedrukt als base64 string.';
COMMENT ON COLUMN public.tbimages.dnimagepixelhoogte
IS 'Hoogte in pixels';
COMMENT ON COLUMN public.tbimages.dnimagepixelbreedte
IS 'Breedte in pixels.';
COMMENT ON COLUMN public.tbimages.dfimagembgrootte
IS 'Grootte van dvimagebase64 in megabytes.';
COMMENT ON COLUMN public.tbimages.dvimagetype
IS 'type van image bijv png, ico, jpeg';
CREATE UNIQUE INDEX idu_images_dvcode ON public.tbimages
USING btree (dvcode COLLATE pg_catalog."default");
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|