Datadictionary OpenWave 3.1.16 |
|
Table: tbzaakkadperc
Datadictionary OpenWave 3.1.16 |
|
Table: tbzaakkadperc
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met kadastrale informatie peromgevingzaak
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbzaakkadperc_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyomgvergunningen |
integer |
|
|
|
|
Foreign key naar tbomgvergunning.dnkey. |
|
|
dvkadgemcode |
varchar(5) |
|
|
|
|
Kadastrale gemeentecode (masker : AAA99). Zie ook tbkadastralegem.dvkadastralegemcode |
|
|
dvsectie |
varchar(2) |
|
|
|
|
Kadastrale sectie (A-ZZ). |
|
|
dvperceelnummer |
varchar(5) |
|
|
|
|
Kasdastrale nummer van perceel. |
|
|
dvpercindicatie |
char(1) |
|
|
|
|
Alleen G of D of A of leeg (geheel, gedeeltelijk, appartementsrecht of leeg). |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_zaakkadperc_keyomg |
dnkeyomgvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_tbzaakkadperc_dvpercind |
dvpercindicatie = ANY (ARRAY['G'::bpchar, 'D'::bpchar, 'A'::bpchar]) |
|
cnn_tbzaakkadperc_dnkeyomg |
dnkeyomgvergunningen IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbzaakkadperc |
btree |
|
dnkey |
|
|
|
idx_zaakkadperc_keyomg |
btree |
|
dnkeyomgvergunningen |
|
|
|
Triggers
There are no triggers for table tbzaakkadperc
Rules
There are no rules for table tbzaakkadperc
Referenced
There are no tables referenced by table tbzaakkadperc
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyomgvergunningen INTEGER,
dvkadgemcode VARCHAR(5),
dvsectie VARCHAR(2),
dvperceelnummer VARCHAR(5),
dvpercindicatie CHAR(1),
CONSTRAINT cpk_tbzaakkadperc PRIMARY KEY(dnkey),
CONSTRAINT chk_tbzaakkadperc_dvpercind CHECK (dvpercindicatie = ANY (ARRAY['G'::bpchar, 'D'::bpchar, 'A'::bpchar])),
CONSTRAINT cnn_tbzaakkadperc_dnkeyomg CHECK (dnkeyomgvergunningen IS NOT NULL),
CONSTRAINT cfk_zaakkadperc_keyomg FOREIGN KEY (dnkeyomgvergunningen)
REFERENCES public.tbomgvergunning(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tbzaakkadperc
IS 'Tabel met kadastrale informatie peromgevingzaak';
COMMENT ON COLUMN public.tbzaakkadperc.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbzaakkadperc.dnkeyomgvergunningen
IS 'Foreign key naar tbomgvergunning.dnkey.';
COMMENT ON COLUMN public.tbzaakkadperc.dvkadgemcode
IS 'Kadastrale gemeentecode (masker : AAA99). Zie ook tbkadastralegem.dvkadastralegemcode';
COMMENT ON COLUMN public.tbzaakkadperc.dvsectie
IS 'Kadastrale sectie (A-ZZ).';
COMMENT ON COLUMN public.tbzaakkadperc.dvperceelnummer
IS 'Kasdastrale nummer van perceel.';
COMMENT ON COLUMN public.tbzaakkadperc.dvpercindicatie
IS 'Alleen G of D of A of leeg (geheel, gedeeltelijk, appartementsrecht of leeg).';
CREATE INDEX idx_zaakkadperc_keyomg ON public.tbzaakkadperc
USING btree (dnkeyomgvergunningen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 19-3-2019 13:43 |
|