Abbreviations for material table about qgep HOT 6 CLOSED

also for other value list tables
take abbreviations from SIA 405

from qgep.

need to be put into the Metadata database for export into the data model

from qgep.

Stephan - can you please deal with this issue and add the abbr_en, abbr_de, abbr_fr in the table "vl_reach_material" and fill in the abbreviations for german and french? Translating the englisch abbreviations would probably be hard for us. Maybe we should fill in the german version for now?

from qgep.

I will then deal with updating the view.

from qgep.

I have a first release for this - for all vl_classes.

from qgep.

Here the example for reach.material (Haltung.Material). I have added it the same way for all other value list (vl_) tables

CREATE TABLE qgep.vl_reach_material
(
code integer NOT NULL,
value_en character varying(50),
value_de character varying(50),
value_fr character varying(50),
abbr_en character varying(3),
abbr_de character varying(3),
abbr_fr character varying(3),
active boolean,
CONSTRAINT pkey_qgep_vl_reach_material_code PRIMARY KEY (code)
)
WITH (
OIDS = False
);
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (5381,'other','andere','autre', 'O', 'A', 'AU', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (2754,'asbestos_cement','Asbestzement','amiante_ciment', 'AC', 'AZ', 'AC', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (3638,'concrete_normal','Beton_Normalbeton','beton_normal', 'CN', 'NB', 'BN', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (3639,'concrete_insitu','Beton_Ortsbeton','beton_coule_sur_place', 'CI', 'OB', 'BCP', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (3640,'concrete_presspipe','Beton_Pressrohrbeton','beton_pousse_tube', 'CP', 'PRB', 'BPT', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (3641,'concrete_special','Beton_Spezialbeton','beton_special', 'CS', 'SB', 'BS', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (3256,'concrete_unknown','Beton_unbekannt','beton_inconnu', 'CU', 'BU', 'BI', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (147,'fiber_cement','Faserzement','fibrociment', 'FC', 'FZ', 'FC', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (2755,'bricks','Gebrannte_Steine','terre_cuite', '', 'SG', 'TC', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (148,'cast_ductile_iron','Guss_duktil','fonte_ductile', 'ID', 'GD', 'FD', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (3648,'cast_gray_iron','Guss_Grauguss','fonte_grise', '', 'GG', 'FG', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (5076,'plastic_epoxy_resin','Kunststoff_Epoxydharz','matiere_synthetique_resine_d_epoxy', '', 'EP', 'EP', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (5077,'plastic_highdensity_polyethylene','Kunststoff_Hartpolyethylen','matiere_synthetique_polyethylene_dur', '', 'HPE', 'PD', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (5078,'plastic_polyester_GUP','Kunststoff_Polyester_GUP','matiere_synthetique_polyester_GUP', '', 'GUP', 'GUP', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (5079,'plastic_polyethylene','Kunststoff_Polyethylen','matiere_synthetique_polyethylene', '', 'PE', 'PE', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (5080,'plastic_polypropylene','Kunststoff_Polypropylen','matiere_synthetique_polypropylene', '', 'PP', 'PP', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (5081,'plastic_PVC','Kunststoff_Polyvinilchlorid','matiere_synthetique_PVC', '', 'PVC', 'PVC', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (5382,'plastic_unknown','Kunststoff_unbekannt','matiere_synthetique_inconnue', '', 'KUU', 'MSI', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (153,'steel','Stahl','acier', 'ST', 'ST', 'AC', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (3654,'steel_stainless','Stahl_rostfrei','acier_inoxydable', '', 'STI', 'ACI', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (154,'stoneware','Steinzeug','gres', 'SW', 'STZ', 'GR', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (2761,'clay','Ton','argile', '', 'T', 'AR', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (3016,'unknown','unbekannt','inconnu', '', 'U', 'I', 'true');
INSERT INTO qgep.vl_reach_material (code, value_en, value_de, value_fr, abbr_de, abbr_fr, abbr_en, active) VALUES (2762,'cement','Zement','ciment', '', 'Z', 'C', 'true');
ALTER TABLE qgep.od_reach ADD CONSTRAINT fkey_vl_reach_material FOREIGN KEY (material)
REFERENCES qgep.vl_reach_material (code) MATCH SIMPLE
ON UPDATE RESTRICT ON DELETE RESTRICT;

from qgep.