Datadictionary OpenWave 3.1.33 |
|
Table: tbinspbesturingsmodel
Datadictionary OpenWave 3.1.33 |
|
Table: tbinspbesturingsmodel
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel van branches met milieueffect- en nalevingsfactor t.b.v. planning inspectietrajecten bij inrichtingen
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbinspbesturingsmodel_dnkey_seq'::regclass) |
Primary key |
|
|
dvcodebranche |
varchar(10) |
|
|
|
|
Branchecodering conform (antea)-model |
|
|
dvomsbranche |
varchar(150) |
|
|
|
|
Omschrijving van de branche |
|
|
dvhoortbij |
char(1) |
|
|
|
|
null of (B)ouw of (M)ilieu |
|
|
dfeffectfactor |
double precision |
|
|
|
|
Factor invloed milieudelict bij branche |
|
|
dfnalevingfactor |
double precision |
|
|
|
|
Factor naleving milieuregels van branche |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Datum dat branche is komen te vervallen |
|
|
dnkeymilurgentie |
integer |
|
|
|
|
Foreign key naar tbmilurgentie.dnkey |
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_inspbestmodel_keymilurg |
dnkeymilurgentie |
dnkey |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_tbinspbestmod_dvhoortbij |
dvhoortbij = ANY (ARRAY['B'::bpchar, 'M'::bpchar]) |
|
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbinspbesturingsmodel |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbinspbesturingsmodel
Rules
There are no rules for table tbinspbesturingsmodel
Policies
There are no policies for table tbinspbesturingsmodel
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_tbmilcodesbi_keyinspbstmod |
dnkeyinspbesturingsmodel |
dnkey |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvcodebranche VARCHAR(10),
dvomsbranche VARCHAR(150),
dvhoortbij CHAR(1),
dfeffectfactor DOUBLE PRECISION STORAGE PLAIN,
dfnalevingfactor DOUBLE PRECISION STORAGE PLAIN,
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE STORAGE PLAIN,
dnkeymilurgentie INTEGER STORAGE PLAIN,
CONSTRAINT cpk_tbinspbesturingsmodel PRIMARY KEY(dnkey),
CONSTRAINT chk_tbinspbestmod_dvhoortbij CHECK (dvhoortbij = ANY (ARRAY['B'::bpchar, 'M'::bpchar])),
CONSTRAINT cfk_inspbestmodel_keymilurg FOREIGN KEY (dnkeymilurgentie)
REFERENCES public.tbmilurgentie(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbinspbesturingsmodel
IS 'Tabel van branches met milieueffect- en nalevingsfactor t.b.v. planning inspectietrajecten bij inrichtingen';
COMMENT ON COLUMN public.tbinspbesturingsmodel.dnkey
IS 'Primary key';
COMMENT ON COLUMN public.tbinspbesturingsmodel.dvcodebranche
IS 'Branchecodering conform (antea)-model';
COMMENT ON COLUMN public.tbinspbesturingsmodel.dvomsbranche
IS 'Omschrijving van de branche';
COMMENT ON COLUMN public.tbinspbesturingsmodel.dvhoortbij
IS 'null of (B)ouw of (M)ilieu';
COMMENT ON COLUMN public.tbinspbesturingsmodel.dfeffectfactor
IS 'Factor invloed milieudelict bij branche';
COMMENT ON COLUMN public.tbinspbesturingsmodel.dfnalevingfactor
IS 'Factor naleving milieuregels van branche';
COMMENT ON COLUMN public.tbinspbesturingsmodel.ddvervaldatum
IS 'Datum dat branche is komen te vervallen';
COMMENT ON COLUMN public.tbinspbesturingsmodel.dnkeymilurgentie
IS 'Foreign key naar tbmilurgentie.dnkey';
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 21-10-2025 10:22 |
|