openwave 3.1.2
Previous topic Chapter index Next topic

Table: tbmilcodeivb

 

 

Schema

public

 

Owner

waveuser002

 

Tablespace

(default)

 

Descriptions

Tabel met ROB-coderingen (voorheen IVB: categorieën van het inrichtingen en vergunningenbesluit milieubeheer)

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tbmilcodeivb_dnkey_seq'::regclass)

Primary key.

 

 

dvivbcode

varchar(15)

 

 

 

 

ROB-codering bijv 1.203.234.C.

 

 

dvivboms

varchar(256)

 

 

 

 

Omschrijving ROB-nummer bijv. vervoeren en bewerken van koolstofdisulfide.

 

 

ddvervaldatum

timestamp

 

 

 

 

 

 

 

dvbevoegdgezag

char(1)

 

 

 

 

Alleen (G)emeente , (R)ijk of (P)rovincie.

 

Foreign Keys

There are no foreign keys for table tbmilcodeivb

 

Checks

Name

Condition

Description

chk_milcodeivb_bevoegdgezag

dvbevoegdgezag = ANY (ARRAY['R'::bpchar, 'P'::bpchar, 'G'::bpchar])

 

cnn_milcodeivb_ivbcode

dvivbcode IS NOT NULL

 

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

cpk_tbmilcodeivb

btree

 

dnkey

 

idx_milcodeivb_ivbcode

btree

 

dvivbcode

 

 

 

idx_milcodeivb_vervaldatum

btree

 

ddvervaldatum

 

 

 

 

Triggers

There are no triggers for table tbmilcodeivb

 

Rules

There are no rules for table tbmilcodeivb

 

Referenced

Table

Schema

Foreign Key

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

tbmilivb

public

cfk_milivb_milcodeivb

dnkeymilcodeivb

public.tbmilcodeivb

dnkey

No Action

No Action

 

Immediate

 

 

Options

Option

Value

Inherited From

 

Rows

227

Pages

6

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE public.tbmilcodeivb (
 dnkey SERIAL,
 dvivbcode VARCHAR(15),
 dvivboms VARCHAR(256),
 ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
 dvbevoegdgezag CHAR(1),
 CONSTRAINT cpk_tbmilcodeivb PRIMARY KEY(dnkey),
 CONSTRAINT chk_milcodeivb_bevoegdgezag CHECK (dvbevoegdgezag = ANY (ARRAY['R'::bpchar, 'P'::bpchar, 'G'::bpchar])),
 CONSTRAINT cnn_milcodeivb_ivbcode CHECK (dvivbcode IS NOT NULL)
)
WITH (oids = false);

COMMENT ON TABLE public.tbmilcodeivb
IS 'Tabel met ROB-coderingen (voorheen IVB: categorieën van het inrichtingen en vergunningenbesluit milieubeheer)';

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

COMMENT ON COLUMN public.tbmilcodeivb.dvivbcode
IS 'ROB-codering  bijv 1.203.234.C.';

COMMENT ON COLUMN public.tbmilcodeivb.dvivboms
IS 'Omschrijving ROB-nummer bijv. vervoeren en bewerken van koolstofdisulfide.';

COMMENT ON COLUMN public.tbmilcodeivb.dvbevoegdgezag
IS 'Alleen (G)emeente , (R)ijk  of (P)rovincie.';

CREATE INDEX idx_milcodeivb_ivbcode ON public.tbmilcodeivb
 USING btree (dvivbcode COLLATE pg_catalog."default");

CREATE INDEX idx_milcodeivb_vervaldatum ON public.tbmilcodeivb
 USING btree (ddvervaldatum);

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-01-2013 17:28
Previous topic Chapter index Next topic