Datadictionary OpenWave 3.1.25 |
|
Table: tbhhbestmaatregnn
Datadictionary OpenWave 3.1.25 |
|
Table: tbhhbestmaatregnn
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Depricated sinds versie 3.1.15. Zie tbsrtbestmaatr en tbbestmaatreg. Koppeltabel tussen tbhandhavingen en tbhandhbestmaatr: welke bestuurlijke maatregelen bij welke handhavingszaak
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkeyhandhaving |
integer |
|
|
|
|
Foreign key naar TbHandhaving.dnkey en tezamen met de kolom DnKeyHandhBestMr de primary key. |
|
|
dnkeyhandhbestmr |
integer |
|
|
|
|
Foreign key naar TbHandhBestMaatr.dnkey en tezamen met de kolom DnKeyHandhaving de primary key. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_hhbestmtregnn_handh |
dnkeyhandhaving |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_hhbestmtregnn_hhbestmr |
dnkeyhandhbestmr |
dnkey |
No Action |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table tbhhbestmaatregnn
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbhhbestmaatregnn |
btree |
|
dnkeyhandhaving, dnkeyhandhbestmr |
|
|
|
idx_hhbmaatregnn_keybestmr |
btree |
|
dnkeyhandhbestmr |
|
|
|
idx_hhbmaatregnn_keyhandhaving |
btree |
|
dnkeyhandhaving |
|
|
|
Triggers
There are no triggers for table tbhhbestmaatregnn
Rules
There are no rules for table tbhhbestmaatregnn
Policies
There are no policies for table tbhhbestmaatregnn
Referenced
There are no tables referenced by table tbhhbestmaatregnn
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkeyhandhaving INTEGER NOT NULL,
dnkeyhandhbestmr INTEGER NOT NULL,
CONSTRAINT cpk_tbhhbestmaatregnn PRIMARY KEY(dnkeyhandhaving, dnkeyhandhbestmr),
CONSTRAINT cfk_hhbestmtregnn_handh FOREIGN KEY (dnkeyhandhaving)
REFERENCES public.tbhandhavingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_hhbestmtregnn_hhbestmr FOREIGN KEY (dnkeyhandhbestmr)
REFERENCES public.tbhandhbestmaatr(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbhhbestmaatregnn
IS 'Depricated sinds versie 3.1.15. Zie tbsrtbestmaatr en tbbestmaatreg. Koppeltabel tussen tbhandhavingen en tbhandhbestmaatr: welke bestuurlijke maatregelen bij welke handhavingszaak';
COMMENT ON COLUMN public.tbhhbestmaatregnn.dnkeyhandhaving
IS 'Foreign key naar TbHandhaving.dnkey en tezamen met de kolom DnKeyHandhBestMr de primary key.';
COMMENT ON COLUMN public.tbhhbestmaatregnn.dnkeyhandhbestmr
IS 'Foreign key naar TbHandhBestMaatr.dnkey en tezamen met de kolom DnKeyHandhaving de primary key.';
CREATE INDEX idx_hhbmaatregnn_keybestmr ON public.tbhhbestmaatregnn
USING btree (dnkeyhandhbestmr);
CREATE INDEX idx_hhbmaatregnn_keyhandhaving ON public.tbhhbestmaatregnn
USING btree (dnkeyhandhaving);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|