--  Licensed to the Apache Software Foundation (ASF) under one or more
--  contributor license agreements.  See the NOTICE file distributed with
--  this work for additional information regarding copyright ownership.
--  The ASF licenses this file to You under the Apache License, Version 2.0
--  (the "License"); you may not use this file except in compliance with
--  the License.  You may obtain a copy of the License at
--
--      http://www.apache.org/licenses/LICENSE-2.0
--
--  Unless required by applicable law or agreed to in writing, software
--  distributed under the License is distributed on an "AS IS" BASIS,
--  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--  See the License for the specific language governing permissions and
--  limitations under the License.


SET ECHO ON;
ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD hh24:mi:ss';

CREATE TABLE ELEMENTS (
  ELEMENT_ID number(11) NOT NULL ,
  ELEMENT_NAME VARCHAR(255)  DEFAULT  ''NOT NULL, 
  DATA_TYPE_ID number(11)  DEFAULT  '0'NOT NULL, 
  DC_ELEMENT VARCHAR(100) DEFAULT '',
  ELEMENT_DESCRIPTION VARCHAR(255)  DEFAULT  ''NOT NULL, 
  PRIMARY KEY  (ELEMENT_ID)
);

CREATE TABLE PRODUCT_TYPE_ELEMENT_MAP (
  PRODUCT_TYPE_ELEMENT_MAP_ID number(11) NOT NULL ,
  PRODUCT_TYPE_ID number(11)  DEFAULT  '0'NOT NULL, 
  ELEMENT_ID number(11)  DEFAULT  '0'NOT NULL, 
  PRIMARY KEY  (PRODUCT_TYPE_ELEMENT_MAP_ID)
);

CREATE TABLE SUB_TO_SUPER_MAP (
  PRODUCT_TYPE_ID number(11) DEFAULT '0'NOT NULL,
  PARENT_ID number(11) DEFAULT '0'NOT NULL,
  PRIMARY KEY (PRODUCT_TYPE_ID)
);	

CREATE INDEX ELEMENTS_IDX  ON  ELEMENTS(seqno);  
CREATE INDEX PRDCT_TYP_LMNT_MP_DX  ON  PRODUCT_TYPE_ELEMENT_MAP(seqno);  
CREATE INDEX SUB_TO_SUPER_MP_DX ON SUB_TO_SUPER_MAP(seqno);
EXIT;