Datadictionary OpenWave 3.1.11 |
|
Table: tbmilcodesbi
Datadictionary OpenWave 3.1.11 |
|
Table: tbmilcodesbi
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met SBI-coderingen (standaard bedrijfsindeling: een classificatie van economische activiteiten)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilcodesbi_dnkey_seq'::regclass) |
Primary key. |
|
|
dvsbinummer |
varchar(11) |
|
|
|
|
Sbi-nummer. |
|
|
dvsbilijst |
varchar(20) |
|
|
|
|
Lijstcode sbi. |
|
|
dvsbioms |
varchar(1000) |
|
|
|
|
Omschrijving sbi-nummer. |
|
|
dvurgkls |
char(1) |
|
|
|
|
Default urgentieklasse. |
|
|
dvspreiding |
char(1) |
|
|
|
|
Spreiding. |
|
|
dvcontinue |
char(1) |
|
|
|
|
Continue. |
|
|
dnafstgeur |
integer |
|
|
|
|
Afstand geur. |
|
|
dnafststof |
integer |
|
|
|
|
Afstand stof. |
|
|
dnafstgeluid |
integer |
|
|
|
|
Afstand Geluid. |
|
|
dnafsttril |
integer |
|
|
|
|
Afstand Tril. |
|
|
dnafstgevaar |
integer |
|
|
|
|
Afstand gevaar. |
|
|
dnindlucht |
integer |
|
|
|
|
Index Lucht. |
|
|
dnindgeluid |
integer |
|
|
|
|
Index Geluid. |
|
|
dnindwater |
integer |
|
|
|
|
Index Water. |
|
|
dnindgevafv |
integer |
|
|
|
|
Index Gevaarlijk Afval. |
|
|
dnindbodem |
integer |
|
|
|
|
Index Bodem. |
|
|
dnindgevaar |
integer |
|
|
|
|
Index Gevaar. |
|
|
dnindverkeer |
integer |
|
|
|
|
Index Verkeer. |
|
|
dnindvisueel |
integer |
|
|
|
|
Index Visueel. |
|
|
dnindonged |
integer |
|
|
|
|
Index Ongedierte. |
|
|
dnmilcat |
double precision |
|
|
|
|
MilieuCategorie. |
|
|
dlintvee |
char(1) |
|
|
|
'F'::bpchar |
Intensieve veehouderij T of F. |
|
|
dvbdrtakcd |
char(1) |
|
|
|
|
BOSS bedrijfstakcode. |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Datum Sbi code vervallen. |
|
|
dnkeyinspbesturingsmodel |
integer |
|
|
|
|
Foreign key naar tbinspbesturingsmodel.dnkey. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmilcodesbi_keyinspbstmod |
dnkeyinspbesturingsmodel |
dnkey |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_milcodesbi_intvee |
dlintvee = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
cnn_milcodesbi_sbilijst |
dvsbilijst IS NOT NULL |
|
cnn_milcodesbi_sbinr |
dvsbinummer IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilcodesbi |
btree |
|
dnkey |
|
|
|
idx_milcodesbi_sbilijst |
btree |
|
dvsbilijst |
|
|
|
idx_milcodesbi_sbinummer |
btree |
|
dvsbinummer |
|
|
|
idx_milcodesbi_vervaldatum |
btree |
|
ddvervaldatum |
|
|
|
Triggers
There are no triggers for table tbmilcodesbi
Rules
There are no rules for table tbmilcodesbi
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_milsbi_milcodesbi |
dnkeymilcodesbi |
dnkey |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvsbinummer VARCHAR(11),
dvsbilijst VARCHAR(20),
dvsbioms VARCHAR(1000),
dvurgkls CHAR(1),
dvspreiding CHAR(1),
dvcontinue CHAR(1),
dnafstgeur INTEGER,
dnafststof INTEGER,
dnafstgeluid INTEGER,
dnafsttril INTEGER,
dnafstgevaar INTEGER,
dnindlucht INTEGER,
dnindgeluid INTEGER,
dnindwater INTEGER,
dnindgevafv INTEGER,
dnindbodem INTEGER,
dnindgevaar INTEGER,
dnindverkeer INTEGER,
dnindvisueel INTEGER,
dnindonged INTEGER,
dnmilcat DOUBLE PRECISION,
dlintvee CHAR(1) DEFAULT 'F'::bpchar,
dvbdrtakcd CHAR(1),
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
dnkeyinspbesturingsmodel INTEGER,
CONSTRAINT cpk_tbmilcodesbi PRIMARY KEY(dnkey),
CONSTRAINT chk_milcodesbi_intvee CHECK (dlintvee = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT cnn_milcodesbi_sbilijst CHECK (dvsbilijst IS NOT NULL),
CONSTRAINT cnn_milcodesbi_sbinr CHECK (dvsbinummer IS NOT NULL),
CONSTRAINT cfk_tbmilcodesbi_keyinspbstmod FOREIGN KEY (dnkeyinspbesturingsmodel)
REFERENCES public.tbinspbesturingsmodel(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tbmilcodesbi
IS 'Tabel met SBI-coderingen (standaard bedrijfsindeling: een classificatie van economische activiteiten)';
COMMENT ON COLUMN public.tbmilcodesbi.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilcodesbi.dvsbinummer
IS 'Sbi-nummer.';
COMMENT ON COLUMN public.tbmilcodesbi.dvsbilijst
IS 'Lijstcode sbi.';
COMMENT ON COLUMN public.tbmilcodesbi.dvsbioms
IS 'Omschrijving sbi-nummer.';
COMMENT ON COLUMN public.tbmilcodesbi.dvurgkls
IS 'Default urgentieklasse.';
COMMENT ON COLUMN public.tbmilcodesbi.dvspreiding
IS 'Spreiding.';
COMMENT ON COLUMN public.tbmilcodesbi.dvcontinue
IS 'Continue.';
COMMENT ON COLUMN public.tbmilcodesbi.dnafstgeur
IS 'Afstand geur.';
COMMENT ON COLUMN public.tbmilcodesbi.dnafststof
IS 'Afstand stof.';
COMMENT ON COLUMN public.tbmilcodesbi.dnafstgeluid
IS 'Afstand Geluid.';
COMMENT ON COLUMN public.tbmilcodesbi.dnafsttril
IS 'Afstand Tril.';
COMMENT ON COLUMN public.tbmilcodesbi.dnafstgevaar
IS 'Afstand gevaar.';
COMMENT ON COLUMN public.tbmilcodesbi.dnindlucht
IS 'Index Lucht.';
COMMENT ON COLUMN public.tbmilcodesbi.dnindgeluid
IS 'Index Geluid.';
COMMENT ON COLUMN public.tbmilcodesbi.dnindwater
IS 'Index Water.';
COMMENT ON COLUMN public.tbmilcodesbi.dnindgevafv
IS 'Index Gevaarlijk Afval.';
COMMENT ON COLUMN public.tbmilcodesbi.dnindbodem
IS 'Index Bodem.';
COMMENT ON COLUMN public.tbmilcodesbi.dnindgevaar
IS 'Index Gevaar.';
COMMENT ON COLUMN public.tbmilcodesbi.dnindverkeer
IS 'Index Verkeer.';
COMMENT ON COLUMN public.tbmilcodesbi.dnindvisueel
IS 'Index Visueel.';
COMMENT ON COLUMN public.tbmilcodesbi.dnindonged
IS 'Index Ongedierte.';
COMMENT ON COLUMN public.tbmilcodesbi.dnmilcat
IS 'MilieuCategorie.';
COMMENT ON COLUMN public.tbmilcodesbi.dlintvee
IS 'Intensieve veehouderij T of F.';
COMMENT ON COLUMN public.tbmilcodesbi.dvbdrtakcd
IS 'BOSS bedrijfstakcode.';
COMMENT ON COLUMN public.tbmilcodesbi.ddvervaldatum
IS 'Datum Sbi code vervallen.';
COMMENT ON COLUMN public.tbmilcodesbi.dnkeyinspbesturingsmodel
IS 'Foreign key naar tbinspbesturingsmodel.dnkey.';
CREATE INDEX idx_milcodesbi_sbilijst ON public.tbmilcodesbi
USING btree (dvsbilijst COLLATE pg_catalog."default");
CREATE INDEX idx_milcodesbi_sbinummer ON public.tbmilcodesbi
USING btree (dvsbinummer COLLATE pg_catalog."default");
CREATE INDEX idx_milcodesbi_vervaldatum ON public.tbmilcodesbi
USING btree (ddvervaldatum);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|