Datadictionary OpenWave 3.1.11 |
|
Table: tbmilasbest
Datadictionary OpenWave 3.1.11 |
|
Table: tbmilasbest
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met asbestsaneringen per inrichting
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilasbest_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeygebouwspec |
integer |
|
|
|
|
Foreign key naar tbgebouwspec.dnkey. Gebruiksdoel van gebouw |
|
|
dnkeygebouwgebruik |
integer |
|
|
|
|
Foreign key naar tbgebouwgebruik.dnkey. Feitelijk gebruiks van gebouw |
|
|
dnkeymilinrichtingen |
integer |
|
|
|
|
Not null. Foreign key naar tbmilinrichtingen.dnkey |
|
|
dnkeyasbesttoegepast |
integer |
|
|
|
|
Foreign key naar tbasbesttoegepast.dnkey. Waar zit de asbest in gebouw (dak, wand e.d.) |
|
|
dldakgotenaanwezig |
char(1) |
|
|
|
'N'::bpchar |
Not null. (T)rue, (F)alse of o(N)bekend. Zijn er dakgoten aanwezig |
|
|
dlondergrondverhard |
char(1) |
|
|
|
'N'::bpchar |
Not null. (T)rue, F)alse of o(N)bekend. Is ondergrond van dak verhard? |
|
|
dlzonpaneelpotentie |
char(1) |
|
|
|
'N'::bpchar |
Not null. (T)rue, F)alse of o(N)bekend. Is potentieel voor zonnepanelen aanwezig? |
|
|
dvnaamasbestplek |
varchar(60) |
|
|
|
|
Naam of duiding van de plek waar asbest is aangetroffen |
|
|
dvstaatvandak |
char(1) |
|
|
|
'O'::bpchar |
Not Null. (G)oed, (M)atig of (S)lecht of (O)nbekend |
|
|
dvxcrd |
varchar(20) |
|
|
|
|
X-coordinaat |
|
|
dvycrd |
varchar(20) |
|
|
|
|
Y-coordinaat |
|
|
dvzcrd |
varchar(20) |
|
|
|
|
Z-coordinaat |
|
|
dvgmlpolygoon |
varchar(4000) |
|
|
|
|
Contour van de oasbestplek conform een gml polygoon |
|
|
dfgmlradius |
double precision |
|
|
|
|
Radius in meters rondom het punt dvxcrd, dvycrd |
|
|
dnkeyomsradius |
integer |
|
|
|
|
Foreign key naar tbmilomsradius.dnkey (tabel met betekenis van de cirkel die getrokken kan worden met dfgmlradius: 1 = stank, 2 = gevaar, 3 = stof, 4 = geluid, 5 = explosie, 6 = overig, 7 = tril, 8 = onbekend |
|
|
dfdakoppervlak |
double precision |
|
|
|
|
Oppervlakte van dak |
|
|
dvopmerking |
varchar(1000) |
|
|
|
|
Toelichting |
|
|
ddsanering |
timestamp |
|
|
|
|
Datum dat asbestplek gesaneerd is |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmilasbest_dnkeyasbtoe |
dnkeyasbesttoegepast |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbmilasbest_dnkeygebgeb |
dnkeygebouwgebruik |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbmilasbest_dnkeygebspec |
dnkeygebouwspec |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbmilasbest_dnkeymilinr |
dnkeymilinrichtingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbmilasbest_dnkeyomsradius |
dnkeyomsradius |
dnkey |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_tbmilasbest_dakgoot |
dldakgotenaanwezig = ANY (ARRAY['T'::bpchar, 'F'::bpchar, 'N'::bpchar]) |
|
chk_tbmilasbest_ogverh |
dlondergrondverhard = ANY (ARRAY['T'::bpchar, 'F'::bpchar, 'N'::bpchar]) |
|
chk_tbmilasbest_sttdak |
dvstaatvandak = ANY (ARRAY['G'::bpchar, 'M'::bpchar, 'S'::bpchar, 'O'::bpchar]) |
|
chk_tbmilasbest_zonpnl |
dlzonpaneelpotentie = ANY (ARRAY['T'::bpchar, 'F'::bpchar, 'N'::bpchar]) |
|
cnn_tbmilasbest_dakgoot |
dldakgotenaanwezig IS NOT NULL |
|
cnn_tbmilasbest_dnkeymilinr |
dnkeymilinrichtingen IS NOT NULL |
|
cnn_tbmilasbest_ogverh |
dlondergrondverhard IS NOT NULL |
|
cnn_tbmilasbest_sttdak |
dvstaatvandak IS NOT NULL |
|
cnn_tbmilasbest_zonpnl |
dlzonpaneelpotentie IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilasbest |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbmilasbest
Rules
There are no rules for table tbmilasbest
Referenced
There are no tables referenced by table tbmilasbest
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeygebouwspec INTEGER,
dnkeygebouwgebruik INTEGER,
dnkeymilinrichtingen INTEGER,
dnkeyasbesttoegepast INTEGER,
dldakgotenaanwezig CHAR(1) DEFAULT 'N'::bpchar,
dlondergrondverhard CHAR(1) DEFAULT 'N'::bpchar,
dlzonpaneelpotentie CHAR(1) DEFAULT 'N'::bpchar,
dvnaamasbestplek VARCHAR(60),
dvstaatvandak CHAR(1) DEFAULT 'O'::bpchar,
dvxcrd VARCHAR(20),
dvycrd VARCHAR(20),
dvzcrd VARCHAR(20),
dvgmlpolygoon VARCHAR(4000),
dfgmlradius DOUBLE PRECISION,
dnkeyomsradius INTEGER,
dfdakoppervlak DOUBLE PRECISION,
dvopmerking VARCHAR(1000),
ddsanering TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbmilasbest PRIMARY KEY(dnkey),
CONSTRAINT chk_tbmilasbest_dakgoot CHECK (dldakgotenaanwezig = ANY (ARRAY['T'::bpchar, 'F'::bpchar, 'N'::bpchar])),
CONSTRAINT chk_tbmilasbest_ogverh CHECK (dlondergrondverhard = ANY (ARRAY['T'::bpchar, 'F'::bpchar, 'N'::bpchar])),
CONSTRAINT chk_tbmilasbest_sttdak CHECK (dvstaatvandak = ANY (ARRAY['G'::bpchar, 'M'::bpchar, 'S'::bpchar, 'O'::bpchar])),
CONSTRAINT chk_tbmilasbest_zonpnl CHECK (dlzonpaneelpotentie = ANY (ARRAY['T'::bpchar, 'F'::bpchar, 'N'::bpchar])),
CONSTRAINT cnn_tbmilasbest_dakgoot CHECK (dldakgotenaanwezig IS NOT NULL),
CONSTRAINT cnn_tbmilasbest_dnkeymilinr CHECK (dnkeymilinrichtingen IS NOT NULL),
CONSTRAINT cnn_tbmilasbest_ogverh CHECK (dlondergrondverhard IS NOT NULL),
CONSTRAINT cnn_tbmilasbest_sttdak CHECK (dvstaatvandak IS NOT NULL),
CONSTRAINT cnn_tbmilasbest_zonpnl CHECK (dlzonpaneelpotentie IS NOT NULL),
CONSTRAINT cfk_tbmilasbest_dnkeyasbtoe FOREIGN KEY (dnkeyasbesttoegepast)
REFERENCES public.tbasbesttoegepast(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilasbest_dnkeygebgeb FOREIGN KEY (dnkeygebouwgebruik)
REFERENCES public.tbgebouwgebruik(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilasbest_dnkeygebspec FOREIGN KEY (dnkeygebouwspec)
REFERENCES public.tbgebouwspec(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilasbest_dnkeymilinr FOREIGN KEY (dnkeymilinrichtingen)
REFERENCES public.tbmilinrichtingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilasbest_dnkeyomsradius FOREIGN KEY (dnkeyomsradius)
REFERENCES public.tbmilomsradius(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tbmilasbest
IS 'Tabel met asbestsaneringen per inrichting';
COMMENT ON COLUMN public.tbmilasbest.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilasbest.dnkeygebouwspec
IS 'Foreign key naar tbgebouwspec.dnkey. Gebruiksdoel van gebouw';
COMMENT ON COLUMN public.tbmilasbest.dnkeygebouwgebruik
IS 'Foreign key naar tbgebouwgebruik.dnkey. Feitelijk gebruiks van gebouw';
COMMENT ON COLUMN public.tbmilasbest.dnkeymilinrichtingen
IS 'Not null. Foreign key naar tbmilinrichtingen.dnkey';
COMMENT ON COLUMN public.tbmilasbest.dnkeyasbesttoegepast
IS 'Foreign key naar tbasbesttoegepast.dnkey. Waar zit de asbest in gebouw (dak, wand e.d.)';
COMMENT ON COLUMN public.tbmilasbest.dldakgotenaanwezig
IS 'Not null. (T)rue, (F)alse of o(N)bekend. Zijn er dakgoten aanwezig';
COMMENT ON COLUMN public.tbmilasbest.dlondergrondverhard
IS 'Not null. (T)rue, F)alse of o(N)bekend. Is ondergrond van dak verhard?';
COMMENT ON COLUMN public.tbmilasbest.dlzonpaneelpotentie
IS 'Not null. (T)rue, F)alse of o(N)bekend. Is potentieel voor zonnepanelen aanwezig?';
COMMENT ON COLUMN public.tbmilasbest.dvnaamasbestplek
IS 'Naam of duiding van de plek waar asbest is aangetroffen';
COMMENT ON COLUMN public.tbmilasbest.dvstaatvandak
IS 'Not Null. (G)oed, (M)atig of (S)lecht of (O)nbekend';
COMMENT ON COLUMN public.tbmilasbest.dvxcrd
IS 'X-coordinaat';
COMMENT ON COLUMN public.tbmilasbest.dvycrd
IS 'Y-coordinaat';
COMMENT ON COLUMN public.tbmilasbest.dvzcrd
IS 'Z-coordinaat';
COMMENT ON COLUMN public.tbmilasbest.dvgmlpolygoon
IS 'Contour van de oasbestplek conform een gml polygoon';
COMMENT ON COLUMN public.tbmilasbest.dfgmlradius
IS 'Radius in meters rondom het punt dvxcrd, dvycrd';
COMMENT ON COLUMN public.tbmilasbest.dnkeyomsradius
IS 'Foreign key naar tbmilomsradius.dnkey (tabel met betekenis van de cirkel die getrokken kan worden met dfgmlradius: 1 = stank, 2 = gevaar, 3 = stof, 4 = geluid, 5 = explosie, 6 = overig, 7 = tril, 8 = onbekend';
COMMENT ON COLUMN public.tbmilasbest.dfdakoppervlak
IS 'Oppervlakte van dak';
COMMENT ON COLUMN public.tbmilasbest.dvopmerking
IS 'Toelichting';
COMMENT ON COLUMN public.tbmilasbest.ddsanering
IS 'Datum dat asbestplek gesaneerd is';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|