Datadictionary OpenWave 3.1.21 |
|
Table: tbimages
Datadictionary OpenWave 3.1.21 |
|
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
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)
)
WITH (oids = false);
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 2-10-2020 12:10 |
|