Datadictionary OpenWave 3.1.11 |
|
Table: tbmilvergwetgrond
Datadictionary OpenWave 3.1.11 |
|
Table: tbmilvergwetgrond
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel van wettelijke grondslagen (tbmilcodewetgrond) en milieu/gebruiksvergunningen
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilvergwetgrond_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilcodewetgrond |
integer |
|
|
|
|
Foreign key naar TbMilCodeWetGrond.dnkey. |
|
|
dnkeymilvergunningen |
integer |
|
|
|
|
Foreign key naar TbMilVergunningen.dnkey. |
|
|
dvopmerking |
varchar(60) |
|
|
|
|
Extra opmerking. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmilvergwg_tbmilcodewg |
dnkeymilcodewetgrond |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbmilvergwg_tbmilverg |
dnkeymilvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_milvergwg_keymilcodewg |
dnkeymilcodewetgrond IS NOT NULL |
|
cnn_milvergwg_keymilverg |
dnkeymilvergunningen IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilvergwetgrond |
btree |
|
dnkey |
|
|
|
idx_milvergwg_milcodewg |
btree |
|
dnkeymilcodewetgrond |
|
|
|
idx_milvergwg_milverg |
btree |
|
dnkeymilvergunningen |
|
|
|
Triggers
There are no triggers for table tbmilvergwetgrond
Rules
There are no rules for table tbmilvergwetgrond
Referenced
There are no tables referenced by table tbmilvergwetgrond
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilcodewetgrond INTEGER,
dnkeymilvergunningen INTEGER,
dvopmerking VARCHAR(60),
CONSTRAINT cpk_tbmilvergwetgrond PRIMARY KEY(dnkey),
CONSTRAINT cnn_milvergwg_keymilcodewg CHECK (dnkeymilcodewetgrond IS NOT NULL),
CONSTRAINT cnn_milvergwg_keymilverg CHECK (dnkeymilvergunningen IS NOT NULL),
CONSTRAINT cfk_tbmilvergwg_tbmilcodewg FOREIGN KEY (dnkeymilcodewetgrond)
REFERENCES public.tbmilcodewetgrond(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilvergwg_tbmilverg FOREIGN KEY (dnkeymilvergunningen)
REFERENCES public.tbmilvergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tbmilvergwetgrond
IS 'Koppeltabel van wettelijke grondslagen (tbmilcodewetgrond) en milieu/gebruiksvergunningen';
COMMENT ON COLUMN public.tbmilvergwetgrond.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilvergwetgrond.dnkeymilcodewetgrond
IS 'Foreign key naar TbMilCodeWetGrond.dnkey.';
COMMENT ON COLUMN public.tbmilvergwetgrond.dnkeymilvergunningen
IS 'Foreign key naar TbMilVergunningen.dnkey.';
COMMENT ON COLUMN public.tbmilvergwetgrond.dvopmerking
IS 'Extra opmerking.';
CREATE INDEX idx_milvergwg_milcodewg ON public.tbmilvergwetgrond
USING btree (dnkeymilcodewetgrond);
CREATE INDEX idx_milvergwg_milverg ON public.tbmilvergwetgrond
USING btree (dnkeymilvergunningen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|