Datadictionary OpenWave 3.1.24
Previous topic Chapter index Next topic

Table: tboin

 

 

Schema

public

 

Owner

waveuser005

 

Tablespace

(default)

 

Descriptions

Tabel met OIN-nummers en organisatienamen

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tboin_dnkey_seq'::regclass)

Primary key.

 

 

dvorganisatie

varchar(200)

 

 

 

 

Organisatie-naam

 

 

dvoin

varchar(50)

 

 

 

OIN-nummer.

 

 

ddvervaldatum

timestamp

 

 

 

 

Datum waarvanaf het OIN is komen te vervallen.

 

 

dvgemeenteid

varchar(4)

 

 

 

Gemeenteid tabel 33 van organisatie indien van toepassing

 

 

dlvernietigingslijst

char(1)

 

 

 

'F'::bpchar

F of T. Indien T dan is organisatie te kiezen voor vernietigslijst

 

 

dllegesexportlijst

char(1)

 

 

 

'F'::bpchar

 

 

 

dlswf

char(1)

 

 

 

'F'::bpchar

 

 

Foreign Keys

There are no foreign keys for table tboin

 

Check Constraints

Name

Condition

Description

chk_oin_dllegesexportlijst

dllegesexportlijst = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_oin_dlvernietigingslijst

dlvernietigingslijst = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_tboin_dlswf

dlswf = ANY (ARRAY['F'::bpchar, 'T'::bpchar])

 

cnn_oin_dllegesexportlijst

dllegesexportlijst IS NOT NULL

 

cnn_oin_dlvernietigingslijst

dlvernietigingslijst IS NOT NULL

 

cnn_tboin_dlswf

dlswf IS NOT NULL

 

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

cpk_tboin

btree

 

dnkey

 

idu_oin_dvgemeenteid

btree

 

dvgemeenteid

 

 

idu_tboin_dvoin

btree

 

dvoin

 

 

 

Triggers

There are no triggers for table tboin

 

Rules

There are no rules for table tboin

 

Referenced

Table

Schema

Foreign Key

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

tbbouwvergunningen

public

cfk_bouwverg_keyoinbevgez

dnkeyoinbevgez

public.tboin

dnkey

Set Null

No Action

 

Immediate

 

tbhandhavingen

public

cfk_handh_keyoinbevgez

dnkeyoinbevgez

public.tboin

dnkey

Set Null

No Action

 

Immediate

 

tbhandhavingen

public

cfk_handh_keyoinuitvinst

dnkeyoinuitvinst

public.tboin

dnkey

Set Null

No Action

 

Immediate

 

tbhorecavergunningen

public

cfk_horeca_keyoinbevgez

dnkeyoinbevgez

public.tboin

dnkey

Set Null

No Action

 

Immediate

 

tbhorecavergunningen

public

cfk_horeca_keyoinuitvinst

dnkeyoinuitvinst

public.tboin

dnkey

Set Null

No Action

 

Immediate

 

tbinfoaanvragen

public

cfk_infoaanvragen_keyoinbevgez

dnkeyoinbevgez

public.tboin

dnkey

Set Null

No Action

 

Immediate

 

tbmilinrichtingen

public

cfk_inricht_keyoinbevgez

dnkeyoinbevgez

public.tboin

dnkey

Set Null

No Action

 

Immediate

 

tbmilinrichtingen

public

cfk_inricht_keyoinuitvinst

dnkeyoinuitvinst

public.tboin

dnkey

Set Null

No Action

 

Immediate

 

tbmilvergunningen

public

cfk_milverg_keyoinbevgez

dnkeyoinbevgez

public.tboin

dnkey

Set Null

No Action

 

Immediate

 

tbmilvergunningen

public

cfk_milverg_keyoinuitvinst

dnkeyoinuitvinst

public.tboin

dnkey

Set Null

No Action

 

Immediate

 

tbomgbevgezhistorie

public

cfk_omgbghist_keyoin

dnkeyoin

public.tboin

dnkey

No Action

No Action

 

Immediate

 

tbomguitvinsthistorie

public

cfk_omguihist_keyoin

dnkeyoin

public.tboin

dnkey

No Action

No Action

 

Immediate

 

tbomgvergunning

public

cfk_omgverg_keyoinbevgez

dnkeyoinbevgez

public.tboin

dnkey

Set Null

No Action

 

Immediate

 

tbomgvergunning

public

cfk_omgverg_keyoinuitvinst

dnkeyoinuitvinst

public.tboin

dnkey

Set Null

No Action

 

Immediate

 

tbovvergunningen

public

cfk_ovverg_keyoinbevgez

dnkeyoinbevgez

public.tboin

dnkey

Set Null

No Action

 

Immediate

 

tbovvergunningen

public

cfk_ovverg_keyoinuitvinst

dnkeyoinuitvinst

public.tboin

dnkey

Set Null

No Action

 

Immediate

 

tbswfoinpartners

public

cfk_tbswfoinpartners_keyoin

dnkeyoin

public.tboin

dnkey

Cascade

No Action

 

Immediate

 

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE public.tboin (
 dnkey SERIAL,
 dvorganisatie VARCHAR(200),
 dvoin VARCHAR(50),
 ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
 dvgemeenteid VARCHAR(4),
 dlvernietigingslijst CHAR(1) DEFAULT 'F'::bpchar,
 dllegesexportlijst CHAR(1) DEFAULT 'F'::bpchar,
 dlswf CHAR(1) DEFAULT 'F'::bpchar,
 CONSTRAINT cpk_tboin PRIMARY KEY(dnkey),
 CONSTRAINT chk_oin_dllegesexportlijst CHECK (dllegesexportlijst = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_oin_dlvernietigingslijst CHECK (dlvernietigingslijst = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tboin_dlswf CHECK (dlswf = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT cnn_oin_dllegesexportlijst CHECK (dllegesexportlijst IS NOT NULL),
 CONSTRAINT cnn_oin_dlvernietigingslijst CHECK (dlvernietigingslijst IS NOT NULL),
 CONSTRAINT cnn_tboin_dlswf CHECK (dlswf IS NOT NULL)
)
WITH (oids = false);

COMMENT ON TABLE public.tboin
IS 'Tabel met OIN-nummers en organisatienamen';

COMMENT ON COLUMN public.tboin.dnkey
IS 'Primary key.';

COMMENT ON COLUMN public.tboin.dvorganisatie
IS 'Organisatie-naam';

COMMENT ON COLUMN public.tboin.dvoin
IS 'OIN-nummer.';

COMMENT ON COLUMN public.tboin.ddvervaldatum
IS 'Datum waarvanaf het OIN is komen te vervallen.';

COMMENT ON COLUMN public.tboin.dvgemeenteid
IS 'Gemeenteid tabel 33 van organisatie indien van toepassing';

COMMENT ON COLUMN public.tboin.dlvernietigingslijst
IS 'F of T. Indien T dan is organisatie te kiezen voor vernietigslijst';

CREATE UNIQUE INDEX idu_oin_dvgemeenteid ON public.tboin
 USING btree (dvgemeenteid COLLATE pg_catalog."default")
 WHERE (dvgemeenteid IS NOT NULL);

CREATE UNIQUE INDEX idu_tboin_dvoin ON public.tboin
 USING btree (dvoin COLLATE pg_catalog."default");

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-9-2021 14:10
Previous topic Chapter index Next topic