Datadictionary OpenWave 3.1.25 |
|
Table: tbhorbeperkingen
Datadictionary OpenWave 3.1.25 |
|
Table: tbhorbeperkingen
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel van opgelegde beperkingen per inrichting
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbhorbeperkingen_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyhorvergunning |
integer |
|
|
|
|
Wordt niet meer gebruikt sinds versie 3.1.13. De beperking is sedertdien gekoppeld aan de inrichting |
|
|
dvbeperking |
varchar(200) |
|
|
|
|
Omschrijving van de beperking. |
|
|
dnkeymilinrichtingen |
integer |
|
|
|
|
Foreign key naar TbMilinrichtingen.dnkey. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_horbeperking_keymilinricht |
dnkeymilinrichtingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_horbeperk_keymilinricht |
dnkeymilinrichtingen IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbhorbeperkingen |
btree |
|
dnkey |
|
|
|
idx_horbeperking_keymilinr |
btree |
|
dnkeymilinrichtingen |
|
|
|
Triggers
There are no triggers for table tbhorbeperkingen
Rules
There are no rules for table tbhorbeperkingen
Policies
There are no policies for table tbhorbeperkingen
Referenced
There are no tables referenced by table tbhorbeperkingen
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyhorvergunning INTEGER,
dvbeperking VARCHAR(200),
dnkeymilinrichtingen INTEGER,
CONSTRAINT cpk_tbhorbeperkingen PRIMARY KEY(dnkey),
CONSTRAINT cnn_horbeperk_keymilinricht CHECK (dnkeymilinrichtingen IS NOT NULL),
CONSTRAINT cfk_horbeperking_keymilinricht FOREIGN KEY (dnkeymilinrichtingen)
REFERENCES public.tbmilinrichtingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbhorbeperkingen
IS 'Tabel van opgelegde beperkingen per inrichting';
COMMENT ON COLUMN public.tbhorbeperkingen.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbhorbeperkingen.dnkeyhorvergunning
IS 'Wordt niet meer gebruikt sinds versie 3.1.13. De beperking is sedertdien gekoppeld aan de inrichting';
COMMENT ON COLUMN public.tbhorbeperkingen.dvbeperking
IS 'Omschrijving van de beperking.';
COMMENT ON COLUMN public.tbhorbeperkingen.dnkeymilinrichtingen
IS 'Foreign key naar TbMilinrichtingen.dnkey.';
CREATE INDEX idx_horbeperking_keymilinr ON public.tbhorbeperkingen
USING btree (dnkeymilinrichtingen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|