Datadictionary OpenWave 3.1.25 |
|
Table: tbovafwnwbpl
Datadictionary OpenWave 3.1.25 |
|
Table: tbovafwnwbpl
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met afwijkingen op het nieuwe bestemmmingsplan gekoppeld aan een overige vergunning
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbovafwnwbpl_dnkey_seq'::regclass) |
Primary key. |
|
|
dvafwijking |
varchar(100) |
|
|
|
|
De afwijking die van toepassing is op het nieuwe bestemmingsplan. |
|
|
dnkeyovvergunningen |
integer |
|
|
|
|
Foreign key naar TbOvVergunningen.dnkey |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_ovafwnwbpl_ovvergun |
dnkeyovvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_ovafwnwbpl_ovverg |
dnkeyovvergunningen IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbovafwnwbpl |
btree |
|
dnkey |
|
|
|
idx_ovafwnwbpl_keyovverg |
btree |
|
dnkeyovvergunningen |
|
|
|
Triggers
There are no triggers for table tbovafwnwbpl
Rules
There are no rules for table tbovafwnwbpl
Policies
There are no policies for table tbovafwnwbpl
Referenced
There are no tables referenced by table tbovafwnwbpl
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvafwijking VARCHAR(100),
dnkeyovvergunningen INTEGER,
CONSTRAINT cpk_tbovafwnwbpl PRIMARY KEY(dnkey),
CONSTRAINT cnn_ovafwnwbpl_ovverg CHECK (dnkeyovvergunningen IS NOT NULL),
CONSTRAINT cfk_ovafwnwbpl_ovvergun FOREIGN KEY (dnkeyovvergunningen)
REFERENCES public.tbovvergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbovafwnwbpl
IS 'Tabel met afwijkingen op het nieuwe bestemmmingsplan gekoppeld aan een overige vergunning';
COMMENT ON COLUMN public.tbovafwnwbpl.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbovafwnwbpl.dvafwijking
IS 'De afwijking die van toepassing is op het nieuwe bestemmingsplan.';
COMMENT ON COLUMN public.tbovafwnwbpl.dnkeyovvergunningen
IS 'Foreign key naar TbOvVergunningen.dnkey';
CREATE INDEX idx_ovafwnwbpl_keyovverg ON public.tbovafwnwbpl
USING btree (dnkeyovvergunningen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|