Datadictionary OpenWave 3.1.25 |
|
Table: tbadvieswelstand
Datadictionary OpenWave 3.1.25 |
|
Table: tbadvieswelstand
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met adviseringsdata t.b.v. welstandscommissie
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbadvieswelstand_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyadviezen |
integer |
|
|
|
|
Foreign key naar TbAdviezen Unieke index: dus 1:1 relatie met tbadviezen. |
|
|
ddvergadering |
timestamp |
|
|
|
|
Vergaderdatum van welstandcommissie. |
|
|
dnkeywelcommissie |
integer |
|
|
|
|
Foreign key naar TbWelstandcommissie. |
|
|
dnconclusie |
integer |
|
|
|
|
0 = welstandnota positief 1 = welstandnota negatief 2 = beeldkwaliteitplan positief 3 = beeldkwaliteitplan negatief 4 = niet ontvankelijk. |
|
|
dvconclusietekst |
varchar(2000) |
|
|
|
|
Krijgt per dnconclusie default waarde uit tabel TbInstellingen (sectie welstand, item dnconclusie) in de kolom tekst. |
|
|
dvverslag |
varchar(4000) |
|
|
|
|
Uiteindelijke welstandverslag. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbadvieswelst_tbadviezen |
dnkeyadviezen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbadvieswelst_tbwelstcie |
dnkeywelcommissie |
dnkey |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbadvieswel_dnkeyadviezen |
dnkeyadviezen IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbadvieswelstand |
btree |
|
dnkey |
|
|
|
idu_advieswelst_dnkeyadviezen |
btree |
|
dnkeyadviezen |
|
|
|
idx_advieswelst_ddvergadering |
btree |
|
ddvergadering |
|
|
|
idx_advieswelstand_dnkeywelcie |
btree |
|
dnkeywelcommissie |
|
|
|
Triggers
There are no triggers for table tbadvieswelstand
Rules
There are no rules for table tbadvieswelstand
Policies
There are no policies for table tbadvieswelstand
Referenced
There are no tables referenced by table tbadvieswelstand
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyadviezen INTEGER,
ddvergadering TIMESTAMP WITHOUT TIME ZONE,
dnkeywelcommissie INTEGER,
dnconclusie INTEGER,
dvconclusietekst VARCHAR(2000),
dvverslag VARCHAR(4000),
CONSTRAINT cpk_tbadvieswelstand PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbadvieswel_dnkeyadviezen CHECK (dnkeyadviezen IS NOT NULL),
CONSTRAINT cfk_tbadvieswelst_tbadviezen FOREIGN KEY (dnkeyadviezen)
REFERENCES public.tbadviezen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbadvieswelst_tbwelstcie FOREIGN KEY (dnkeywelcommissie)
REFERENCES public.tbwelstandcommissie(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbadvieswelstand
IS 'Tabel met adviseringsdata t.b.v. welstandscommissie';
COMMENT ON COLUMN public.tbadvieswelstand.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbadvieswelstand.dnkeyadviezen
IS 'Foreign key naar TbAdviezen Unieke index: dus 1:1 relatie met tbadviezen.';
COMMENT ON COLUMN public.tbadvieswelstand.ddvergadering
IS 'Vergaderdatum van welstandcommissie.';
COMMENT ON COLUMN public.tbadvieswelstand.dnkeywelcommissie
IS 'Foreign key naar TbWelstandcommissie.';
COMMENT ON COLUMN public.tbadvieswelstand.dnconclusie
IS '0 = welstandnota positief 1 = welstandnota negatief 2 = beeldkwaliteitplan positief 3 = beeldkwaliteitplan negatief 4 = niet ontvankelijk.';
COMMENT ON COLUMN public.tbadvieswelstand.dvconclusietekst
IS 'Krijgt per dnconclusie default waarde uit tabel TbInstellingen (sectie welstand, item dnconclusie) in de kolom tekst.';
COMMENT ON COLUMN public.tbadvieswelstand.dvverslag
IS 'Uiteindelijke welstandverslag.';
CREATE UNIQUE INDEX idu_advieswelst_dnkeyadviezen ON public.tbadvieswelstand
USING btree (dnkeyadviezen);
CREATE INDEX idx_advieswelst_ddvergadering ON public.tbadvieswelstand
USING btree (ddvergadering);
CREATE INDEX idx_advieswelstand_dnkeywelcie ON public.tbadvieswelstand
USING btree (dnkeywelcommissie);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|