Datadictionary OpenWave 3.1.25 |
|
Table: tbkadastralegem
Datadictionary OpenWave 3.1.25 |
|
Table: tbkadastralegem
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met kadastrale gemeentecodes en kadastralegemeentenamen alsmede de gemeentetabel33 coderingen en namen
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbkadastralegem_dnkey_seq'::regclass) |
Primary key. |
|
|
dvgemeentecode |
varchar(4) |
|
|
|
|
Codering van gemeente volgens gemeentetabel 33 (tevens CBS-code) |
|
|
dvgemeentenaam |
varchar(80) |
|
|
|
|
Gemeentenaam volgens gemeentetabel 33 |
|
|
dvkadastralegemcode |
varchar(5) |
|
|
|
|
De kadastrale gemeeentecode (formaat AAA99) |
|
|
dvkadastralegemnaam |
varchar(80) |
|
|
|
|
De kadastrale gemeentenaam |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Datum waarop de kadastrale gemeentecode niet meer gebruikt wordt |
Foreign Keys
There are no foreign keys for table tbkadastralegem
Check Constraints
There are no check constraints for table tbkadastralegem
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbkadastralegem |
btree |
|
dnkey |
|
|
|
idx_kadastralegem_gemcode |
btree |
|
dvgemeentecode |
|
|
|
idx_kadastralegem_kadgemcode |
btree |
|
dvkadastralegemcode |
|
|
|
Triggers
There are no triggers for table tbkadastralegem
Rules
There are no rules for table tbkadastralegem
Policies
There are no policies for table tbkadastralegem
Referenced
There are no tables referenced by table tbkadastralegem
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvgemeentecode VARCHAR(4),
dvgemeentenaam VARCHAR(80),
dvkadastralegemcode VARCHAR(5),
dvkadastralegemnaam VARCHAR(80),
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbkadastralegem PRIMARY KEY(dnkey)
) ;
COMMENT ON TABLE public.tbkadastralegem
IS 'Tabel met kadastrale gemeentecodes en kadastralegemeentenamen alsmede de gemeentetabel33 coderingen en namen';
COMMENT ON COLUMN public.tbkadastralegem.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbkadastralegem.dvgemeentecode
IS 'Codering van gemeente volgens gemeentetabel 33 (tevens CBS-code)';
COMMENT ON COLUMN public.tbkadastralegem.dvgemeentenaam
IS 'Gemeentenaam volgens gemeentetabel 33';
COMMENT ON COLUMN public.tbkadastralegem.dvkadastralegemcode
IS 'De kadastrale gemeeentecode (formaat AAA99)';
COMMENT ON COLUMN public.tbkadastralegem.dvkadastralegemnaam
IS 'De kadastrale gemeentenaam';
COMMENT ON COLUMN public.tbkadastralegem.ddvervaldatum
IS 'Datum waarop de kadastrale gemeentecode niet meer gebruikt wordt';
CREATE INDEX idx_kadastralegem_gemcode ON public.tbkadastralegem
USING btree (dvgemeentecode COLLATE pg_catalog."default");
CREATE INDEX idx_kadastralegem_kadgemcode ON public.tbkadastralegem
USING btree (dvkadastralegemcode COLLATE pg_catalog."default");
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|