root/trunk/matml/webselector/parser/data.sql

--
-- PostgreSQL database dump
--

\connect - el_oso

SET search_path = public, pg_catalog;

--
-- TOC entry 2 (OID 17656)
-- Name: materials; Type: TABLE; Schema: public; Owner: el_oso
--

CREATE TABLE materials (
    matid serial NOT NULL,
    xmlfile character varying(100),
    matname character varying(100)
);


--
-- TOC entry 3 (OID 17659)
-- Name: properties; Type: TABLE; Schema: public; Owner: el_oso
--

CREATE TABLE properties (
    matid integer,
    propid character varying(10),
    propname character varying(100),
    value text,
    format character varying(20),
    units character varying(50)
);


--
-- Data for TOC entry 6 (OID 17656)
-- Name: materials; Type: TABLE DATA; Schema: public; Owner: el_oso
--

COPY materials (matid, xmlfile, matname) FROM stdin;
6       Aluminum_31.xml Aluminum Alloy 1350
7       copper_81100_31.xml     Copper C81100
14      Titanium_Ti_out.xml     Titanium, Ti
13      Magnesium_HM21A-T8_Sheet_and_Plate_out.xml      Magnesium HM21A-T8
\.


--
-- Data for TOC entry 7 (OID 17659)
-- Name: properties; Type: TABLE DATA; Schema: public; Owner: el_oso
--

COPY properties (matid, propid, propname, value, format, units) FROM stdin;
6       pr2     Specific gravity        2.705   float   
6       pr3     Melting range   1195-1215       string  degree Fahrenheit
6       pr4     Melting range   646-657 string  degree Celsius
6       pr5     Thermal coeficient of expansion 13.2E-6 exponential     scale per degree Fahrenheit
6       pr6     Thermal coeficient of expansion 23.8E-6 exponential     scale per degree Celsius
6       pr8     Electrical conductivity 62      integer 
6       pr9     Electrical conductivity 204     integer 
6       pr10    electrical resistivity  17      integer ohm-cir mil/ft
6       pr15    Edgewise bend radii for rolled 1350-H12 .5      float   in
7       pr2     Specific gravity        8.94    float   
7       pr3     Melting point   1948-1981       string  degree Fahrenheit
7       pr4     Melting point   1065-1083       string  degree Celsius
7       pr6     Thermal coeficient of expansion 9.4E-6  exponential     scale per degree Fahrenheit
7       pr7     Thermal coeficient of expansion 16.9E-6 exponential     scale per degree Celsius
7       pr10    Electrical conductivity 92      integer 
7       ts2     Tensile strength        131     integer MPa
7       ys2     Yield strength  45      integer MPa
7       pr14    Elongation      20      integer %
7       pr15    Brinell hardness        44      integer 
7       pr16a   Fatigue Strength        62      integer MPa
13      pr1     Density 1.78    float   g/cc
13      pr2     Tensile Strength, Ultimate      235     integer MPa
13      pr3     Tensile Strength, Yield 170     integer MPa
13      pr4     Elongation at Break     11      integer 
13      pr6     Compressive Yield Strength      130     integer MPa
13      pr7     Notched Tensile Strength        230     integer MPa
13      pr8     Ultimate Bearing Strength       415     integer MPa
13      pr9     Bearing Yield Strength  270     integer MPa
13      pr10    Poisson's Ratio 0.35    float   
13      pr11    Machinability   100     integer 
13      pr13    Shear Strength  125     integer MPa
13      pr14    Electrical Resistivity  5       integer ohm-cm
13      pr15    Heat of Fusion  343     integer J/g
13      pr16    CTE, linear 20°C       26.8    float   µm/m-°C
13      pr17    CTE, linear 100°C      27      integer µm/m-°C
13      pr18    Heat Capacity   1       integer J/g-°C
13      pr19    Thermal Conductivity    135     integer W/m-K
13      pr20    Melting Point   605     integer °C
13      pr21    Solidus 605     integer °C
13      pr22    Liquidus        650     integer °C
13      pr23    Processing Temperature  455     integer °C
13      pr24    Processing Temperature  455     integer °C
14      pr1     Density 4.5     float   g/cc
14      pr2     Hardness, Brinell       70      integer 
14      pr3     Hardness, Vickers       60      integer 
14      pr4     Tensile Strength, Ultimate      220     integer MPa
14      pr5     Tensile Strength, Yield 140     integer MPa
14      pr6     Elongation at Break     54      integer 
14      pr8     Poisson's Ratio 0.34    float   
14      pr9     Electrical Resistivity  5.54E-005       exponential     ohm-cm
14      pr10    Magnetic Susceptibility 1.25E-006       exponential     
14      pr11    Critical Magnetic Field Strength, Oersted       56      integer 
14      pr12    Critical Superconducting Temperature    0.36    float   K
14      pr13    Heat of Fusion  435.4   float   J/g
14      pr14    CTE, linear 20°C       8.9     float   µm/m-°C
14      pr15    CTE, linear 1000°C     10.1    float   µm/m-°C
14      pr16    Heat Capacity   0.528   float   J/g-°C
14      pr17    Thermal Conductivity    17      integer W/m-K
14      pr18    Melting Point   1650    integer °C
14      pr19    Emissivity (0-1)        0.63    float   
13      pr5     Modulus of Elasticity   45000   integer MPa
13      pr12    Shear Modulus   17000   integer MPa
14      pr7     Modulus of Elasticity   116000  integer MPa
6       pr11    Modulus of elasticity   68947.571852677793      exponential     MPa
7       pr11    Modulus of elasticity   117210.872149552248     exponential     MPa
7       ts      Tensile strength        131.000386520087806     integer MPa
7       pr16    Fatigue Strength        62.052814667410013      integer MPa
6       pr1     Density 2.69879070924450        float   g/cc
7       pr1     Density 8.9406092213946 float   g/cc
6       pr12    Tensile strength        96.5266022      integer MPa
6       pr13    Yield strength  82.7370876      integer MPa
6       pr14    Ultimate shear strength 62.0528157      integer MPa
7       pr8     Thermal conductivity    28.845577772800 integer W/m-K
7       pr5     Specific heat   0.3768120       float   J/g-°C
6       pr7     Thermal conductivity    1625    integer W/m-K
\.


--
-- TOC entry 5 (OID 17743)
-- Name: materials_pkey; Type: CONSTRAINT; Schema: public; Owner: el_oso
--

ALTER TABLE ONLY materials
    ADD CONSTRAINT materials_pkey PRIMARY KEY (matid);


--
-- TOC entry 8 (OID 17745)
-- Name: $1; Type: CONSTRAINT; Schema: public; Owner: el_oso
--

ALTER TABLE ONLY properties
    ADD CONSTRAINT "$1" FOREIGN KEY (matid) REFERENCES materials(matid) ON UPDATE NO ACTION ON DELETE CASCADE;


--
-- TOC entry 4 (OID 17654)
-- Name: materials_matid_seq; Type: SEQUENCE SET; Schema: public; Owner: el_oso
--

SELECT pg_catalog.setval ('materials_matid_seq', 14, true);