Datadictionary OpenWave 3.1.11 |
|
Table: tbadvieswelstand
Datadictionary OpenWave 3.1.11 |
|
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 |
|
cnn_tbadvieswel_dnkeywelcie |
dnkeywelcommissie 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
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 cnn_tbadvieswel_dnkeywelcie CHECK (dnkeywelcommissie 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
)
WITH (oids = false);
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 22-2-2017 10:50 |
|