Datadictionary OpenWave 3.1.25 |
|
Table: tbmilasbest
Datadictionary OpenWave 3.1.25 |
|
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
Policies
There are no policies 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
) ;
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 5-1-2022 14:13 |
|