Datadictionary OpenWave 3.1.25 |
|
Table: tbmiltrefwoord
Datadictionary OpenWave 3.1.25 |
|
Table: tbmiltrefwoord
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Wordt niet gebruikt sinds browserversie 1.13 (database 3.1.16) Koppeltabel tussen milieu-inrichtingstrefwoorden (tbmilcodetrefw) en een inrichting
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmiltrefwoord_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilcodetrefw |
integer |
|
|
|
|
Foreign key naar TbMilCodeTrefw.dnkey. |
|
|
dnkeymilinrichtingen |
integer |
|
|
|
|
Foreign key naar TbMilInrichtingen.dnkey. |
|
|
dvopmerking |
varchar(60) |
|
|
|
|
Extra opmerking. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_miltrefwoord_milcodetrefw |
dnkeymilcodetrefw |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_miltrefwoord_milinricht |
dnkeymilinrichtingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_miltrefw_keycodetrefw |
dnkeymilcodetrefw IS NOT NULL |
|
cnn_miltrefw_keyinricht |
dnkeymilinrichtingen IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmiltrefwoord |
btree |
|
dnkey |
|
|
|
idx_miltrefw_milcodetrefw |
btree |
|
dnkeymilcodetrefw |
|
|
|
idx_miltrefw_milinricht |
btree |
|
dnkeymilinrichtingen |
|
|
|
Triggers
There are no triggers for table tbmiltrefwoord
Rules
There are no rules for table tbmiltrefwoord
Policies
There are no policies for table tbmiltrefwoord
Referenced
There are no tables referenced by table tbmiltrefwoord
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilcodetrefw INTEGER,
dnkeymilinrichtingen INTEGER,
dvopmerking VARCHAR(60),
CONSTRAINT cpk_tbmiltrefwoord PRIMARY KEY(dnkey),
CONSTRAINT cnn_miltrefw_keycodetrefw CHECK (dnkeymilcodetrefw IS NOT NULL),
CONSTRAINT cnn_miltrefw_keyinricht CHECK (dnkeymilinrichtingen IS NOT NULL),
CONSTRAINT cfk_miltrefwoord_milcodetrefw FOREIGN KEY (dnkeymilcodetrefw)
REFERENCES public.tbmilcodetrefw(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_miltrefwoord_milinricht FOREIGN KEY (dnkeymilinrichtingen)
REFERENCES public.tbmilinrichtingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmiltrefwoord
IS 'Wordt niet gebruikt sinds browserversie 1.13 (database 3.1.16) Koppeltabel tussen milieu-inrichtingstrefwoorden (tbmilcodetrefw) en een inrichting';
COMMENT ON COLUMN public.tbmiltrefwoord.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmiltrefwoord.dnkeymilcodetrefw
IS 'Foreign key naar TbMilCodeTrefw.dnkey.';
COMMENT ON COLUMN public.tbmiltrefwoord.dnkeymilinrichtingen
IS 'Foreign key naar TbMilInrichtingen.dnkey.';
COMMENT ON COLUMN public.tbmiltrefwoord.dvopmerking
IS 'Extra opmerking.';
CREATE INDEX idx_miltrefw_milcodetrefw ON public.tbmiltrefwoord
USING btree (dnkeymilcodetrefw);
CREATE INDEX idx_miltrefw_milinricht ON public.tbmiltrefwoord
USING btree (dnkeymilinrichtingen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|