Datadictionary OpenWave 3.1.25 |
|
Table: tbtekstblokken
Datadictionary OpenWave 3.1.25 |
|
Table: tbtekstblokken
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met tekstblokken ten behoeve van overname in sjablonen (via tbqueries).
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbtekstblokken_dnkey_seq'::regclass) |
Primary key. |
|
|
dvcode |
varchar(40) |
|
|
|
|
Unieke codering voor het tekstblok. Not null. |
|
|
dvtekstblok |
varchar(4000) |
|
|
|
|
Het tekstblok zelf. |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Datum waarvanaf tekstblok eigenlijk is komen te vervallen. |
Foreign Keys
There are no foreign keys for table tbtekstblokken
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tekstblokken_dvcode |
dvcode IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbtekstblokken |
btree |
|
dnkey |
|
|
|
idu_tekstblokken_dvcode |
btree |
|
dvcode |
|
|
|
Triggers
There are no triggers for table tbtekstblokken
Rules
There are no rules for table tbtekstblokken
Policies
There are no policies for table tbtekstblokken
Referenced
There are no tables referenced by table tbtekstblokken
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvcode VARCHAR(40),
dvtekstblok VARCHAR(4000),
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbtekstblokken PRIMARY KEY(dnkey),
CONSTRAINT cnn_tekstblokken_dvcode CHECK (dvcode IS NOT NULL)
) ;
COMMENT ON TABLE public.tbtekstblokken
IS 'Tabel met tekstblokken ten behoeve van overname in sjablonen (via tbqueries).';
COMMENT ON COLUMN public.tbtekstblokken.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbtekstblokken.dvcode
IS 'Unieke codering voor het tekstblok. Not null.';
COMMENT ON COLUMN public.tbtekstblokken.dvtekstblok
IS 'Het tekstblok zelf.';
COMMENT ON COLUMN public.tbtekstblokken.ddvervaldatum
IS 'Datum waarvanaf tekstblok eigenlijk is komen te vervallen.';
CREATE UNIQUE INDEX idu_tekstblokken_dvcode ON public.tbtekstblokken
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 |
|