-- ----------------------------
-- create data structure
-- ----------------------------
/**
  * configuration_basis
*/
CREATE TABLE configuration_basis (config_id           int8 not null primary key,
                                  product_group_code varchar(20),
                                  material_code      varchar(20),
                                  operator     varchar(50),
                                  create_time   timestamp(0)

);

/**
  * configuration_characteristic_and_value
*/
CREATE TABLE configuration_characteristic_and_value (
                                                        id           int8 not null primary key,
                                                        config_id           int8 not null,
                                                        characteristic_name      varchar(255),
                                                        characteristic_value_name     varchar(255),
                                                        characteristic_value_quantity     int4,
                                                        characteristic_value_desc		text
);


/**
  * business_log
*/
CREATE TABLE business_log (
                              id           int8 not null primary key,
                              contents      text
);