create table asimple_bean (
  id                            bigint not null,
  name                          varchar(255),
  constraint pk_asimple_bean primary key (id)
);
create sequence asimple_bean_seq;

create table bar (
  bar_type                      varchar(31) not null,
  bar_id                        integer not null,
  foo_id                        integer not null,
  version                       integer not null,
  constraint pk_bar primary key (bar_id)
);
create sequence bar_seq;

create table oto_account (
  id                            bigint not null,
  name                          varchar(255),
  version                       bigint not null,
  when_created                  timestamp not null,
  when_modified                 timestamp not null,
  constraint pk_oto_account primary key (id)
);
create sequence oto_account_seq;

create table o_address (
  id                            smallint not null,
  line_1                        varchar(100),
  line_2                        varchar(100),
  city                          varchar(100),
  cretime                       timestamp,
  country_code                  varchar(2),
  updtime                       timestamp not null,
  constraint pk_o_address primary key (id)
);
create sequence o_address_seq;

create table address (
  oid                           bigint not null,
  street                        varchar(255),
  version                       integer not null,
  constraint pk_address primary key (oid)
);
create sequence address_seq;

create table animals (
  species                       varchar(31) not null,
  id                            bigint not null,
  shelter_id                    bigint,
  version                       bigint not null,
  name                          varchar(255),
  registration_number           varchar(255),
  date_of_birth                 date,
  constraint pk_animals primary key (id)
);
create sequence animals_seq;

create table animal_shelter (
  id                            bigint not null,
  name                          varchar(255),
  version                       bigint not null,
  constraint pk_animal_shelter primary key (id)
);
create sequence animal_shelter_seq;

create table article (
  id                            integer not null,
  name                          varchar(255),
  author                        varchar(255),
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint pk_article primary key (id)
);
create sequence article_seq;

create table attribute (
  option_type                   integer(31) not null,
  id                            integer not null,
  attribute_holder_id           integer,
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint pk_attribute primary key (id)
);
create sequence attribute_seq;

create table attribute_holder (
  id                            integer not null,
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint pk_attribute_holder primary key (id)
);
create sequence attribute_holder_seq;

create table audit_log (
  id                            bigint not null,
  description                   varchar(255),
  modified_description          varchar(255),
  constraint pk_audit_log primary key (id)
);
create sequence audit_log_seq;

create table bbookmark (
  id                            integer not null,
  bookmark_reference            varchar(255),
  user_id                       integer,
  constraint pk_bbookmark primary key (id)
);
create sequence bbookmark_seq;

create table bbookmark_user (
  id                            integer not null,
  name                          varchar(255),
  password                      varchar(255),
  email_address                 varchar(255),
  country                       varchar(255),
  constraint pk_bbookmark_user primary key (id)
);
create sequence bbookmark_user_seq;

create table bsimple_with_gen (
  id                            integer not null,
  name                          varchar(255),
  constraint pk_bsimple_with_gen primary key (id)
);
create sequence bsimple_with_gen_seq;

create table bwith_qident (
  id                            integer not null,
  "Name"                        varchar(255),
  last_updated                  timestamp not null,
  constraint uq_bwith_qident_name unique ("Name"),
  constraint pk_bwith_qident primary key (id)
);
create sequence bwith_qident_seq;

create table basic_joda_entity (
  id                            bigint not null,
  name                          varchar(255),
  created                       timestamp not null,
  updated                       timestamp not null,
  version                       timestamp not null,
  constraint pk_basic_joda_entity primary key (id)
);
create sequence basic_joda_entity_seq;

create table bean_with_time_zone (
  id                            bigint not null,
  name                          varchar(255),
  timezone                      varchar(20),
  constraint pk_bean_with_time_zone primary key (id)
);
create sequence bean_with_time_zone_seq;

create table drel_booking (
  id                            bigint not null,
  agent_invoice                 bigint,
  client_invoice                bigint,
  version                       integer not null,
  constraint uq_drel_booking_agent_invoice unique (agent_invoice),
  constraint uq_drel_booking_client_invoice unique (client_invoice),
  constraint pk_drel_booking primary key (id)
);
create sequence drel_booking_seq;

create table ckey_assoc (
  id                            integer not null,
  assoc_one                     varchar(255),
  constraint pk_ckey_assoc primary key (id)
);
create sequence ckey_assoc_seq;

create table ckey_detail (
  id                            integer not null,
  something                     varchar(255),
  one_key                       integer,
  two_key                       varchar(127),
  constraint pk_ckey_detail primary key (id)
);
create sequence ckey_detail_seq;

create table ckey_parent (
  one_key                       integer not null,
  two_key                       varchar(127) not null,
  name                          varchar(255),
  assoc_id                      integer,
  version                       integer not null,
  constraint pk_ckey_parent primary key (one_key,two_key)
);

create table calculation_result (
  id                            integer not null,
  charge                        double,
  product_configuration_id      integer,
  group_configuration_id        integer,
  constraint pk_calculation_result primary key (id)
);
create sequence calculation_result_seq;

create table cao_bean (
  x_cust_id                     integer not null,
  x_type_id                     integer not null,
  description                   varchar(255),
  version                       bigint not null,
  constraint pk_cao_bean primary key (x_cust_id,x_type_id)
);

create table sa_car (
  id                            bigint not null,
  version                       integer not null,
  constraint pk_sa_car primary key (id)
);
create sequence sa_car_seq;

create table sp_car_car (
  id                            bigint not null,
  version                       integer not null,
  constraint pk_sp_car_car primary key (id)
);
create sequence sp_car_car_seq;

create table sp_car_car_wheels (
  car                           bigint not null,
  wheel                         bigint not null,
  constraint pk_sp_car_car_wheels primary key (car,wheel)
);

create table car_accessory (
  id                            integer not null,
  name                          varchar(255),
  car_id                        integer,
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint pk_car_accessory primary key (id)
);
create sequence car_accessory_seq;

create table configuration (
  type                          varchar(31) not null,
  id                            integer not null,
  name                          varchar(255),
  configurations_id             integer,
  group_name                    varchar(255),
  product_name                  varchar(255),
  constraint pk_configuration primary key (id)
);
create sequence configuration_seq;

create table configurations (
  id                            integer not null,
  name                          varchar(255),
  constraint pk_configurations primary key (id)
);
create sequence configurations_seq;

create table contact (
  id                            integer not null,
  first_name                    varchar(255),
  last_name                     varchar(255),
  phone                         varchar(255),
  mobile                        varchar(255),
  email                         varchar(255),
  customer_id                   integer not null,
  group_id                      integer,
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  constraint pk_contact primary key (id)
);
create sequence contact_seq;

create table contact_group (
  id                            integer not null,
  name                          varchar(255),
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint pk_contact_group primary key (id)
);
create sequence contact_group_seq;

create table contact_note (
  id                            integer not null,
  contact_id                    integer,
  title                         varchar(255),
  note                          clob,
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint pk_contact_note primary key (id)
);
create sequence contact_note_seq;

create table c_conversation (
  id                            bigint not null,
  title                         varchar(255),
  isopen                        boolean,
  group_id                      bigint,
  version                       bigint not null,
  when_created                  timestamp not null,
  when_modified                 timestamp not null,
  constraint pk_c_conversation primary key (id)
);
create sequence c_conversation_seq;

create table o_country (
  code                          varchar(2) not null,
  name                          varchar(60),
  constraint pk_o_country primary key (code)
);
create sequence o_country_seq;

create table o_customer (
  id                            integer not null,
  status                        varchar(1),
  name                          varchar(40) not null,
  smallnote                     varchar(100),
  anniversary                   date,
  billing_address_id            smallint,
  shipping_address_id           smallint,
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint ck_o_customer_status check (status in ('N','A','I')),
  constraint pk_o_customer primary key (id)
);
create sequence o_customer_seq;

create table dexh_entity (
  oid                           bigint not null,
  exhange_rate                  decimal(38),
  exhange_cmoney_amount         decimal(38),
  exhange_cmoney_currency       varchar(3),
  last_updated                  timestamp not null,
  constraint pk_dexh_entity primary key (oid)
);
create sequence dexh_entity_seq;

create table dperson (
  id                            bigint not null,
  first_name                    varchar(255),
  last_name                     varchar(255),
  salary                        decimal(38),
  a_amt                         decimal(38),
  a_curr                        varchar(3),
  i_start                       timestamp,
  i_end                         timestamp,
  constraint pk_dperson primary key (id)
);
create sequence dperson_seq;

create table rawinherit_data (
  id                            bigint not null,
  number                        integer,
  constraint pk_rawinherit_data primary key (id)
);
create sequence rawinherit_data_seq;

create table e_basic (
  id                            integer not null,
  status                        varchar(1),
  name                          varchar(255),
  description                   varchar(255),
  some_date                     timestamp,
  constraint ck_e_basic_status check (status in ('N','A','I')),
  constraint pk_e_basic primary key (id)
);
create sequence e_basic_seq;

create table ebasic_clob (
  id                            bigint not null,
  name                          varchar(255),
  title                         varchar(255),
  description                   clob,
  last_update                   timestamp not null,
  constraint pk_ebasic_clob primary key (id)
);
create sequence ebasic_clob_seq;

create table ebasic_clob_fetch_eager (
  id                            bigint not null,
  name                          varchar(255),
  title                         varchar(255),
  description                   clob,
  last_update                   timestamp not null,
  constraint pk_ebasic_clob_fetch_eager primary key (id)
);
create sequence ebasic_clob_fetch_eager_seq;

create table ebasic_clob_no_ver (
  id                            bigint not null,
  name                          varchar(255),
  description                   clob,
  constraint pk_ebasic_clob_no_ver primary key (id)
);
create sequence ebasic_clob_no_ver_seq;

create table e_basicenc (
  id                            integer not null,
  name                          varchar(255),
  description                   varbinary(80),
  dob                           varbinary(20),
  last_update                   timestamp,
  constraint pk_e_basicenc primary key (id)
);
create sequence e_basicenc_seq;

create table e_basicenc_bin (
  id                            integer not null,
  name                          varchar(255),
  description                   varchar(255),
  data                          longvarbinary,
  some_time                     varbinary(255),
  last_update                   timestamp not null,
  constraint pk_e_basicenc_bin primary key (id)
);
create sequence e_basicenc_bin_seq;

create table e_basic_enum_id (
  status                        varchar(1) not null,
  name                          varchar(255),
  description                   varchar(255),
  constraint ck_e_basic_enum_id_status check (status in ('N','A','I')),
  constraint pk_e_basic_enum_id primary key (status)
);
create sequence e_basic_enum_id_seq;

create table ebasic_json_map (
  id                            bigint not null,
  name                          varchar(255),
  content                       clob,
  version                       bigint not null,
  constraint pk_ebasic_json_map primary key (id)
);
create sequence ebasic_json_map_seq;

create table ebasic_json_map_blob (
  id                            bigint not null,
  name                          varchar(255),
  content                       blob,
  version                       bigint not null,
  constraint pk_ebasic_json_map_blob primary key (id)
);
create sequence ebasic_json_map_blob_seq;

create table ebasic_json_map_clob (
  id                            bigint not null,
  name                          varchar(255),
  content                       clob,
  version                       bigint not null,
  constraint pk_ebasic_json_map_clob primary key (id)
);
create sequence ebasic_json_map_clob_seq;

create table ebasic_json_map_json_b (
  id                            bigint not null,
  name                          varchar(255),
  content                       clob,
  version                       bigint not null,
  constraint pk_ebasic_json_map_json_b primary key (id)
);
create sequence ebasic_json_map_json_b_seq;

create table ebasic_json_map_varchar (
  id                            bigint not null,
  name                          varchar(255),
  content                       varchar(3000),
  version                       bigint not null,
  constraint pk_ebasic_json_map_varchar primary key (id)
);
create sequence ebasic_json_map_varchar_seq;

create table ebasic_json_node (
  id                            bigint not null,
  name                          varchar(255),
  content                       clob,
  version                       bigint not null,
  constraint pk_ebasic_json_node primary key (id)
);
create sequence ebasic_json_node_seq;

create table ebasic_json_node_blob (
  id                            bigint not null,
  name                          varchar(255),
  content                       blob,
  version                       bigint not null,
  constraint pk_ebasic_json_node_blob primary key (id)
);
create sequence ebasic_json_node_blob_seq;

create table ebasic_json_node_json_b (
  id                            bigint not null,
  name                          varchar(255),
  content                       clob,
  version                       bigint not null,
  constraint pk_ebasic_json_node_json_b primary key (id)
);
create sequence ebasic_json_node_json_b_seq;

create table ebasic_json_node_varchar (
  id                            bigint not null,
  name                          varchar(255),
  content                       varchar(1000),
  version                       bigint not null,
  constraint pk_ebasic_json_node_varchar primary key (id)
);
create sequence ebasic_json_node_varchar_seq;

create table e_basic_ndc (
  id                            integer not null,
  name                          varchar(255),
  constraint pk_e_basic_ndc primary key (id)
);
create sequence e_basic_ndc_seq;

create table e_basicver (
  id                            integer not null,
  name                          varchar(255),
  description                   varchar(255),
  other                         varchar(255),
  last_update                   timestamp not null,
  constraint pk_e_basicver primary key (id)
);
create sequence e_basicver_seq;

create table e_basic_withlife (
  id                            bigint not null,
  name                          varchar(255),
  version                       bigint not null,
  constraint pk_e_basic_withlife primary key (id)
);
create sequence e_basic_withlife_seq;

create table e_basicverucon (
  id                            integer not null,
  name                          varchar(255),
  other                         varchar(255),
  other_one                     varchar(255),
  description                   varchar(255),
  last_update                   timestamp not null,
  constraint uq_e_basicverucon_name unique (name),
  constraint pk_e_basicverucon primary key (id)
);
create sequence e_basicverucon_seq;

create table eemb_inner (
  id                            integer not null,
  nome_inner                    varchar(255),
  outer_id                      integer,
  update_count                  integer not null,
  constraint pk_eemb_inner primary key (id)
);
create sequence eemb_inner_seq;

create table eemb_outer (
  id                            integer not null,
  nome_outer                    varchar(255),
  date1                         timestamp,
  date2                         timestamp,
  update_count                  integer not null,
  constraint pk_eemb_outer primary key (id)
);
create sequence eemb_outer_seq;

create table egen_props (
  id                            bigint not null,
  name                          varchar(255),
  version                       bigint not null,
  when_created                  timestamp not null,
  when_modified                 timestamp not null,
  ts_created                    timestamp not null,
  ts_updated                    timestamp not null,
  ldt_created                   timestamp not null,
  ldt_updated                   timestamp not null,
  odt_created                   timestamp not null,
  odt_updated                   timestamp not null,
  zdt_created                   timestamp not null,
  zdt_updated                   timestamp not null,
  long_created                  bigint not null,
  long_updated                  bigint not null,
  constraint pk_egen_props primary key (id)
);
create sequence egen_props_seq;

create table einvoice (
  id                            bigint not null,
  date                          timestamp,
  state                         integer,
  person_id                     bigint,
  ship_street                   varchar(255),
  ship_suburb                   varchar(255),
  ship_city                     varchar(255),
  street                        varchar(255),
  suburb                        varchar(255),
  city                          varchar(255),
  version                       bigint not null,
  constraint ck_einvoice_state check (state in (0,1,2)),
  constraint pk_einvoice primary key (id)
);
create sequence einvoice_seq;

create table e_main (
  id                            integer not null,
  name                          varchar(255),
  description                   varchar(255),
  version                       bigint not null,
  constraint pk_e_main primary key (id)
);
create sequence e_main_seq;

create table enull_collection (
  id                            integer not null,
  name                          varchar(255),
  constraint pk_enull_collection primary key (id)
);
create sequence enull_collection_seq;

create table enull_collection_detail (
  id                            integer not null,
  enull_collection_id           integer not null,
  something                     varchar(255),
  constraint pk_enull_collection_detail primary key (id)
);
create sequence enull_collection_detail_seq;

create table eopt_one_a (
  id                            integer not null,
  name_for_a                    varchar(255),
  b_id                          integer,
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint pk_eopt_one_a primary key (id)
);
create sequence eopt_one_a_seq;

create table eopt_one_b (
  id                            integer not null,
  name_for_b                    varchar(255),
  c_id                          integer not null,
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint pk_eopt_one_b primary key (id)
);
create sequence eopt_one_b_seq;

create table eopt_one_c (
  id                            integer not null,
  name_for_c                    varchar(255),
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint pk_eopt_one_c primary key (id)
);
create sequence eopt_one_c_seq;

create table eperson (
  id                            bigint not null,
  name                          varchar(255),
  notes                         varchar(255),
  street                        varchar(255),
  suburb                        varchar(255),
  city                          varchar(255),
  version                       bigint not null,
  constraint pk_eperson primary key (id)
);
create sequence eperson_seq;

create table esimple (
  usertypeid                    integer auto not null,
  name                          varchar(255),
  constraint pk_esimple primary key (usertypeid)
);
create sequence esimple_seq;

create table esome_type (
  id                            integer not null,
  currency                      varchar(3),
  locale                        varchar(20),
  time_zone                     varchar(20),
  constraint pk_esome_type primary key (id)
);
create sequence esome_type_seq;

create table etrans_many (
  id                            integer not null,
  name                          varchar(255),
  constraint pk_etrans_many primary key (id)
);
create sequence etrans_many_seq;

create table evanilla_collection (
  id                            integer not null,
  name                          varchar(255),
  constraint pk_evanilla_collection primary key (id)
);
create sequence evanilla_collection_seq;

create table evanilla_collection_detail (
  id                            integer not null,
  evanilla_collection_id        integer not null,
  something                     varchar(255),
  constraint pk_evanilla_collection_detail primary key (id)
);
create sequence evanilla_collection_detail_seq;

create table ewho_props (
  id                            bigint not null,
  name                          varchar(255),
  who_created                   varchar(255) not null,
  who_modified                  varchar(255) not null,
  version                       bigint not null,
  when_created                  timestamp not null,
  when_modified                 timestamp not null,
  constraint pk_ewho_props primary key (id)
);
create sequence ewho_props_seq;

create table e_withinet (
  id                            bigint not null,
  name                          varchar(255),
  inet_address                  varchar(50),
  version                       bigint not null,
  constraint pk_e_withinet primary key (id)
);
create sequence e_withinet_seq;

create table td_child (
  child_id                      integer not null,
  child_name                    varchar(255),
  parent_id                     integer not null,
  constraint pk_td_child primary key (child_id)
);
create sequence td_child_seq;

create table td_parent (
  parent_type                   varchar(31) not null,
  parent_id                     integer not null,
  parent_name                   varchar(255),
  extended_name                 varchar(255),
  constraint pk_td_parent primary key (parent_id)
);
create sequence td_parent_seq;

create table feature_desc (
  id                            integer not null,
  name                          varchar(255),
  description                   varchar(255),
  constraint pk_feature_desc primary key (id)
);
create sequence feature_desc_seq;

create table f_first (
  id                            bigint not null,
  name                          varchar(255),
  constraint pk_f_first primary key (id)
);
create sequence f_first_seq;

create table foo (
  foo_id                        integer not null,
  important_text                varchar(255),
  version                       integer not null,
  constraint pk_foo primary key (foo_id)
);
create sequence foo_seq;

create table gen_key_identity (
  id                            bigint not null,
  description                   varchar(255),
  constraint pk_gen_key_identity primary key (id)
);
create sequence gen_key_identity_seq;

create table gen_key_sequence (
  id                            bigint not null,
  description                   varchar(255),
  constraint pk_gen_key_sequence primary key (id)
);
create sequence SEQ;

create table gen_key_table (
  id                            bigint not null,
  description                   varchar(255),
  constraint pk_gen_key_table primary key (id)
);
create sequence gen_key_table_seq;

create table c_group (
  id                            bigint not null,
  inactive                      boolean,
  name                          varchar(255),
  version                       bigint not null,
  when_created                  timestamp not null,
  when_modified                 timestamp not null,
  constraint pk_c_group primary key (id)
);
create sequence c_group_seq;

create table imrelated (
  id                            bigint not null,
  name                          varchar(255),
  owner_id                      bigint not null,
  constraint pk_imrelated primary key (id)
);
create sequence imrelated_seq;

create table imroot (
  dtype                         varchar(10) not null,
  id                            bigint not null,
  title                         varchar(255),
  when_title                    timestamp,
  name                          varchar(255),
  constraint pk_imroot primary key (id)
);
create sequence imroot_seq;

create table ixresource (
  dtype                         varchar(255),
  id                            binary(16) not null,
  name                          varchar(255),
  constraint pk_ixresource primary key (id)
);

create table info_company (
  id                            bigint not null,
  name                          varchar(255),
  version                       bigint not null,
  constraint pk_info_company primary key (id)
);
create sequence info_company_seq;

create table info_contact (
  id                            bigint not null,
  name                          varchar(255),
  company_id                    bigint not null,
  version                       bigint not null,
  constraint pk_info_contact primary key (id)
);
create sequence info_contact_seq;

create table info_customer (
  id                            bigint not null,
  name                          varchar(255),
  company_id                    bigint,
  version                       bigint not null,
  constraint uq_info_customer_company_id unique (company_id),
  constraint pk_info_customer primary key (id)
);
create sequence info_customer_seq;

create table inner_report (
  id                            bigint not null,
  name                          varchar(255),
  forecast_id                   bigint,
  constraint uq_inner_report_forecast_id unique (forecast_id),
  constraint pk_inner_report primary key (id)
);
create sequence inner_report_seq;

create table drel_invoice (
  id                            bigint not null,
  booking                       bigint,
  version                       integer not null,
  constraint pk_drel_invoice primary key (id)
);
create sequence drel_invoice_seq;

create table item (
  customer                      integer not null,
  itemNumber                    varchar(255) not null,
  description                   varchar(255),
  units                         varchar(255),
  type                          integer,
  region                        integer,
  date_modified                 timestamp,
  date_created                  timestamp,
  modified_by                   varchar(255),
  created_by                    varchar(255),
  version                       bigint not null,
  constraint pk_item primary key (customer,itemNumber)
);

create table level1 (
  id                            bigint not null,
  name                          varchar(255),
  constraint pk_level1 primary key (id)
);
create sequence level1_seq;

create table level1_level4 (
  level1_id                     bigint not null,
  level4_id                     bigint not null,
  constraint pk_level1_level4 primary key (level1_id,level4_id)
);

create table level1_level2 (
  level1_id                     bigint not null,
  level2_id                     bigint not null,
  constraint pk_level1_level2 primary key (level1_id,level2_id)
);

create table level2 (
  id                            bigint not null,
  name                          varchar(255),
  constraint pk_level2 primary key (id)
);
create sequence level2_seq;

create table level2_level3 (
  level2_id                     bigint not null,
  level3_id                     bigint not null,
  constraint pk_level2_level3 primary key (level2_id,level3_id)
);

create table level3 (
  id                            bigint not null,
  name                          varchar(255),
  constraint pk_level3 primary key (id)
);
create sequence level3_seq;

create table level4 (
  id                            bigint not null,
  name                          varchar(255),
  constraint pk_level4 primary key (id)
);
create sequence level4_seq;

create table la_attr_value (
  id                            integer not null,
  name                          varchar(255),
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint pk_la_attr_value primary key (id)
);
create sequence la_attr_value_seq;

create table la_attr_value_attribute (
  la_attr_value_id              integer not null,
  attribute_id                  integer not null,
  constraint pk_la_attr_value_attribute primary key (la_attr_value_id,attribute_id)
);

create table mmedia (
  type                          varchar(31) not null,
  id                            bigint not null,
  url                           varchar(255),
  note                          varchar(255),
  constraint pk_mmedia primary key (id)
);
create sequence mmedia_seq;

create table non_updateprop (
  id                            integer not null,
  non_enum                      varchar(5),
  name                          varchar(255),
  note                          varchar(255),
  constraint ck_non_updateprop_non_enum check (non_enum in ('BEGIN','END')),
  constraint pk_non_updateprop primary key (id)
);
create sequence non_updateprop_seq;

create table mprinter (
  id                            bigint not null,
  name                          varchar(255),
  flags                         bigint not null,
  current_state_id              bigint,
  last_swap_cyan_id             bigint,
  last_swap_magenta_id          bigint,
  last_swap_yellow_id           bigint,
  last_swap_black_id            bigint,
  version                       bigint not null,
  constraint uq_mprinter_last_swap_cyan_id unique (last_swap_cyan_id),
  constraint uq_mprinter_last_swap_magenta_id unique (last_swap_magenta_id),
  constraint uq_mprinter_last_swap_yellow_id unique (last_swap_yellow_id),
  constraint uq_mprinter_last_swap_black_id unique (last_swap_black_id),
  constraint pk_mprinter primary key (id)
);
create sequence mprinter_seq;

create table mprinter_state (
  id                            bigint not null,
  flags                         bigint,
  printer_id                    bigint,
  version                       bigint not null,
  constraint pk_mprinter_state primary key (id)
);
create sequence mprinter_state_seq;

create table mprofile (
  id                            bigint not null,
  picture_id                    bigint,
  name                          varchar(255),
  constraint pk_mprofile primary key (id)
);
create sequence mprofile_seq;

create table mprotected_construct_bean (
  id                            bigint not null,
  name                          varchar(255),
  constraint pk_mprotected_construct_bean primary key (id)
);
create sequence mprotected_construct_bean_seq;

create table mrole (
  roleid                        integer not null,
  role_name                     varchar(255),
  constraint pk_mrole primary key (roleid)
);
create sequence mrole_seq;

create table mrole_muser (
  mrole_roleid                  integer not null,
  muser_userid                  integer not null,
  constraint pk_mrole_muser primary key (mrole_roleid,muser_userid)
);

create table msome_other (
  id                            bigint not null,
  name                          varchar(255),
  constraint pk_msome_other primary key (id)
);
create sequence msome_other_seq;

create table muser (
  userid                        integer not null,
  user_name                     varchar(255),
  user_type_id                  integer,
  constraint pk_muser primary key (userid)
);
create sequence muser_seq;

create table muser_type (
  id                            integer not null,
  name                          varchar(255),
  constraint pk_muser_type primary key (id)
);
create sequence muser_type_seq;

create table map_super_actual (
  id                            bigint not null,
  name                          varchar(255),
  when_created                  timestamp not null,
  when_updated                  timestamp not null,
  constraint pk_map_super_actual primary key (id)
);
create sequence map_super_actual_seq;

create table c_message (
  id                            bigint not null,
  title                         varchar(255),
  body                          varchar(255),
  conversation_id               bigint,
  user_id                       bigint,
  version                       bigint not null,
  when_created                  timestamp not null,
  when_modified                 timestamp not null,
  constraint pk_c_message primary key (id)
);
create sequence c_message_seq;

create table mnoc_role (
  role_id                       integer not null,
  role_name                     varchar(255),
  version                       integer not null,
  constraint pk_mnoc_role primary key (role_id)
);
create sequence mnoc_role_seq;

create table mnoc_user (
  user_id                       integer not null,
  user_name                     varchar(255),
  version                       integer not null,
  constraint pk_mnoc_user primary key (user_id)
);
create sequence mnoc_user_seq;

create table mnoc_user_mnoc_role (
  mnoc_user_user_id             integer not null,
  mnoc_role_role_id             integer not null,
  constraint pk_mnoc_user_mnoc_role primary key (mnoc_user_user_id,mnoc_role_role_id)
);

create table mp_role (
  id                            bigint not null,
  mp_user_id                    bigint not null,
  code                          varchar(255),
  organization_id               bigint,
  constraint pk_mp_role primary key (id)
);
create sequence mp_role_seq;

create table mp_user (
  id                            bigint not null,
  name                          varchar(255),
  constraint pk_mp_user primary key (id)
);
create sequence mp_user_seq;

create table my_lob_size (
  id                            integer not null,
  name                          varchar(255),
  my_count                      integer,
  my_lob                        clob,
  constraint pk_my_lob_size primary key (id)
);
create sequence my_lob_size_seq;

create table my_lob_size_join_many (
  id                            integer not null,
  something                     varchar(255),
  other                         varchar(255),
  parent_id                     integer,
  constraint pk_my_lob_size_join_many primary key (id)
);
create sequence my_lob_size_join_many_seq;

create table noidbean (
  name                          varchar(255),
  subject                       varchar(255),
  when_created                  timestamp not null
);

create table o_cached_bean (
  id                            bigint not null,
  name                          varchar(255),
  constraint pk_o_cached_bean primary key (id)
);
create sequence o_cached_bean_seq;

create table o_cached_bean_country (
  o_cached_bean_id              bigint not null,
  o_country_code                varchar(2) not null,
  constraint pk_o_cached_bean_country primary key (o_cached_bean_id,o_country_code)
);

create table o_cached_bean_child (
  id                            bigint not null,
  cached_bean_id                bigint,
  constraint pk_o_cached_bean_child primary key (id)
);
create sequence o_cached_bean_child_seq;

create table ocar (
  id                            integer not null,
  vin                           varchar(255),
  name                          varchar(255),
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint pk_ocar primary key (id)
);
create sequence ocar_seq;

create table oengine (
  engine_id                     binary(16) not null,
  short_desc                    varchar(255),
  car_id                        integer,
  version                       integer not null,
  constraint uq_oengine_car_id unique (car_id),
  constraint pk_oengine primary key (engine_id)
);

create table ogear_box (
  id                            binary(16) not null,
  box_desc                      varchar(255),
  box_size                      integer,
  car_id                        integer,
  version                       integer not null,
  constraint uq_ogear_box_car_id unique (car_id),
  constraint pk_ogear_box primary key (id)
);

create table o_order (
  id                            integer not null,
  status                        integer,
  order_date                    date,
  ship_date                     date,
  kcustomer_id                  integer not null,
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  constraint ck_o_order_status check (status in (0,1,2,3)),
  constraint pk_o_order primary key (id)
);
create sequence o_order_seq;

create table o_order_detail (
  id                            integer not null,
  order_id                      integer,
  order_qty                     integer,
  ship_qty                      integer,
  unit_price                    double,
  product_id                    integer,
  cretime                       timestamp,
  updtime                       timestamp not null,
  constraint pk_o_order_detail primary key (id)
);
create sequence o_order_detail_seq;

create table s_orders (
  uuid                          varchar(255) not null,
  constraint pk_s_orders primary key (uuid)
);
create sequence s_orders_seq;

create table s_order_items (
  uuid                          varchar(255) not null,
  product_variant_uuid          varchar(255),
  order_uuid                    varchar(255),
  quantity                      integer,
  amount                        decimal(38),
  constraint pk_s_order_items primary key (uuid)
);
create sequence s_order_items_seq;

create table or_order_ship (
  id                            integer not null,
  order_id                      integer,
  ship_time                     timestamp,
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint pk_or_order_ship primary key (id)
);
create sequence or_order_ship_seq;

create table oto_child (
  id                            integer not null,
  name                          varchar(255),
  master_id                     bigint,
  constraint uq_oto_child_master_id unique (master_id),
  constraint pk_oto_child primary key (id)
);
create sequence oto_child_seq;

create table oto_master (
  id                            bigint not null,
  name                          varchar(255),
  constraint pk_oto_master primary key (id)
);
create sequence oto_master_seq;

create table pfile (
  id                            integer not null,
  name                          varchar(255),
  file_content_id               integer,
  file_content2_id              integer,
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint uq_pfile_file_content_id unique (file_content_id),
  constraint uq_pfile_file_content2_id unique (file_content2_id),
  constraint pk_pfile primary key (id)
);
create sequence pfile_seq;

create table pfile_content (
  id                            integer not null,
  content                       blob,
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint pk_pfile_content primary key (id)
);
create sequence pfile_content_seq;

create table paggview (
  pview_id                      binary(16),
  amount                        integer not null,
  constraint uq_paggview_pview_id unique (pview_id)
);

create table pallet_location (
  type                          varchar(31) not null,
  id                            integer not null,
  ZONE_SID                      integer not null,
  attribute                     varchar(255),
  constraint pk_pallet_location primary key (id)
);
create sequence pallet_location_seq;

create table parcel (
  parcelId                      bigint not null,
  description                   varchar(255),
  constraint pk_parcel primary key (parcelId)
);
create sequence parcel_seq;

create table parcel_location (
  parcelLocId                   bigint not null,
  location                      varchar(255),
  parcelId                      bigint,
  constraint uq_parcel_location_parcelid unique (parcelId),
  constraint pk_parcel_location primary key (parcelLocId)
);
create sequence parcel_location_seq;

create table rawinherit_parent (
  type                          varchar(31) not null,
  id                            bigint not null,
  number                        integer,
  constraint pk_rawinherit_parent primary key (id)
);
create sequence rawinherit_parent_seq;

create table rawinherit_parent_rawinherit_dat (
  rawinherit_parent_id          bigint not null,
  rawinherit_data_id            bigint not null,
  constraint pk_rawinherit_parent_rawinherit_dat primary key (rawinherit_parent_id,rawinherit_data_id)
);

create table c_participation (
  id                            bigint not null,
  rating                        integer,
  type                          integer,
  conversation_id               bigint not null,
  user_id                       bigint not null,
  version                       bigint not null,
  when_created                  timestamp not null,
  when_modified                 timestamp not null,
  constraint ck_c_participation_type check (type in (0,1)),
  constraint pk_c_participation primary key (id)
);
create sequence c_participation_seq;

create table mt_permission (
  id                            binary(16) not null,
  name                          varchar(255),
  constraint pk_mt_permission primary key (id)
);

create table persistent_file (
  id                            integer not null,
  name                          varchar(255),
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint pk_persistent_file primary key (id)
);
create sequence persistent_file_seq;

create table persistent_file_content (
  id                            integer not null,
  persistent_file_id            integer,
  content                       blob,
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint uq_persistent_file_content_persistent_file_id unique (persistent_file_id),
  constraint pk_persistent_file_content primary key (id)
);
create sequence persistent_file_content_seq;

create table PERSONS (
  ID                            bigint not null,
  SURNAME                       varchar(64) not null,
  NAME                          varchar(64) not null,
  constraint pk_persons primary key (ID)
);
create seq;

create table person (
  oid                           bigint not null,
  default_address_oid           bigint,
  version                       integer not null,
  constraint pk_person primary key (oid)
);
create sequence person_seq;

create table PHONES (
  ID                            bigint not null,
  PHONE_NUMBER                  varchar(7) not null,
  PERSON_ID                     bigint not null,
  constraint uq_phones_phone_number unique (PHONE_NUMBER),
  constraint pk_phones primary key (ID)
);
create sequence phones_seq;

create table o_product (
  id                            integer not null,
  sku                           varchar(20),
  name                          varchar(255),
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  constraint pk_o_product primary key (id)
);
create sequence o_product_seq;

create table pp (
  id                            binary(16) not null,
  name                          varchar(255),
  value                         varchar(100) not null,
  constraint pk_pp primary key (id)
);

create table pp_to_ww (
  pp_id                         binary(16) not null,
  ww_id                         binary(16) not null,
  constraint pk_pp_to_ww primary key (pp_id,ww_id)
);

create table rcustomer (
  company                       varchar(255) not null,
  name                          varchar(255) not null,
  description                   varchar(255),
  constraint pk_rcustomer primary key (company,name)
);

create table r_orders (
  company                       varchar(255) not null,
  order_number                  integer not null,
  customerName                  varchar(255),
  item                          varchar(255),
  constraint pk_r_orders primary key (company,order_number)
);

create table region (
  customer                      integer not null,
  type                          integer not null,
  description                   varchar(255),
  version                       bigint not null,
  constraint pk_region primary key (customer,type)
);

create table ResourceFile (
  id                            varchar(64) not null,
  parentResourceFileId          varchar(64),
  name                          varchar(128) not null,
  constraint pk_resourcefile primary key (id)
);
create sequence resourcefile_seq;

create table mt_role (
  id                            binary(16) not null,
  name                          varchar(50),
  tenant_id                     binary(16),
  version                       bigint not null,
  constraint pk_mt_role primary key (id)
);

create table mt_role_permission (
  mt_role_id                    binary(16) not null,
  mt_permission_id              binary(16) not null,
  constraint pk_mt_role_permission primary key (mt_role_id,mt_permission_id)
);

create table em_role (
  id                            bigint not null,
  name                          varchar(255),
  constraint pk_em_role primary key (id)
);
create sequence em_role_seq;

create table f_second (
  id                            bigint not null,
  first                         bigint,
  title                         varchar(255),
  constraint uq_f_second_first unique (first),
  constraint pk_f_second primary key (id)
);
create sequence f_second_seq;

create table section (
  id                            integer not null,
  article_id                    integer,
  type                          integer,
  content                       clob,
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint ck_section_type check (type in (0,1)),
  constraint pk_section primary key (id)
);
create sequence section_seq;

create table self_parent (
  id                            bigint not null,
  name                          varchar(255),
  parent_id                     bigint,
  version                       bigint not null,
  constraint pk_self_parent primary key (id)
);
create sequence self_parent_seq;

create table self_ref_customer (
  id                            bigint not null,
  name                          varchar(255),
  referred_by_id                bigint,
  constraint pk_self_ref_customer primary key (id)
);
create sequence self_ref_customer_seq;

create table self_ref_example (
  id                            bigint not null,
  name                          varchar(255) not null,
  parent_id                     bigint,
  constraint pk_self_ref_example primary key (id)
);
create sequence self_ref_example_seq;

create table some_enum_bean (
  id                            bigint not null,
  some_enum                     integer,
  name                          varchar(255),
  constraint ck_some_enum_bean_some_enum check (some_enum in (0,1)),
  constraint pk_some_enum_bean primary key (id)
);
create sequence some_enum_bean_seq;

create table some_file_bean (
  id                            bigint not null,
  name                          varchar(255),
  content                       blob,
  version                       bigint not null,
  constraint pk_some_file_bean primary key (id)
);
create sequence some_file_bean_seq;

create table some_new_types_bean (
  id                            bigint not null,
  dow                           integer(1),
  mth                           integer(1),
  yr                            integer,
  yr_mth                        date,
  local_date                    date,
  local_date_time               timestamp,
  offset_date_time              timestamp,
  zoned_date_time               timestamp,
  instant                       timestamp,
  zone_id                       varchar(60),
  zone_offset                   varchar(60),
  version                       bigint not null,
  constraint ck_some_new_types_bean_dow check (dow in ('1','2','3','4','5','6','7')),
  constraint ck_some_new_types_bean_mth check (mth in ('1','2','3','4','5','6','7','8','9','10','11','12')),
  constraint pk_some_new_types_bean primary key (id)
);
create sequence some_new_types_bean_seq;

create table some_period_bean (
  id                            bigint not null,
  period_years                  integer,
  period_months                 integer,
  period_days                   integer,
  anniversary                   date,
  version                       bigint not null,
  constraint pk_some_period_bean primary key (id)
);
create sequence some_period_bean_seq;

create table stockforecast (
  type                          varchar(31) not null,
  id                            bigint not null,
  inner_report_id               bigint,
  constraint pk_stockforecast primary key (id)
);
create sequence stockforecast_seq;

create table sub_section (
  id                            integer not null,
  section_id                    integer,
  title                         varchar(255),
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint pk_sub_section primary key (id)
);
create sequence sub_section_seq;

create table sub_type (
  sub_type_id                   integer not null,
  description                   varchar(255),
  version                       bigint not null,
  constraint pk_sub_type primary key (sub_type_id)
);
create sequence sub_type_seq;

create table tbytes_only (
  id                            integer not null,
  content                       blob,
  constraint pk_tbytes_only primary key (id)
);
create sequence tbytes_only_seq;

create table tcar (
  type                          varchar(31) not null,
  plate_no                      varchar(255) not null,
  truckLoad                     bigint,
  constraint pk_tcar primary key (plate_no)
);
create sequence tcar_seq;

create table tint_root (
  my_type                       integer(3) not null,
  id                            integer not null,
  name                          varchar(255),
  child_property                varchar(255),
  constraint pk_tint_root primary key (id)
);
create sequence tint_root_seq;

create table tjoda_entity (
  id                            integer not null,
  local_time                    time,
  constraint pk_tjoda_entity primary key (id)
);
create sequence tjoda_entity_seq;

create table t_mapsuper1 (
  id                            integer not null,
  something                     varchar(255),
  name                          varchar(255),
  version                       integer not null,
  constraint pk_t_mapsuper1 primary key (id)
);
create sequence t_mapsuper1_seq;

create table t_oneb (
  id                            integer not null,
  name                          varchar(255),
  description                   varchar(255),
  active                        boolean,
  constraint pk_t_oneb primary key (id)
);
create sequence t_oneb_seq;

create table t_detail_with_other_namexxxyy (
  id                            integer not null,
  name                          varchar(255),
  description                   varchar(255),
  active                        boolean,
  master_id                     integer,
  constraint pk_t_detail_with_other_namexxxyy primary key (id)
);
create sequence t_atable_detail_seq;

create table ts_detail_two (
  id                            integer not null,
  name                          varchar(255),
  description                   varchar(255),
  active                        boolean,
  master_id                     integer,
  constraint pk_ts_detail_two primary key (id)
);
create sequence ts_detail_two_seq;

create table t_atable_thatisrelatively (
  id                            integer not null,
  name                          varchar(255),
  description                   varchar(255),
  active                        boolean,
  constraint pk_t_atable_thatisrelatively primary key (id)
);
create sequence t_atable_master_seq;

create table ts_master_two (
  id                            integer not null,
  name                          varchar(255),
  description                   varchar(255),
  active                        boolean,
  constraint pk_ts_master_two primary key (id)
);
create sequence ts_master_two_seq;

create table tuuid_entity (
  id                            binary(16) not null,
  name                          varchar(255),
  constraint pk_tuuid_entity primary key (id)
);

create table twheel (
  id                            bigint not null,
  owner_plate_no                varchar(255) not null,
  constraint pk_twheel primary key (id)
);
create sequence twheel_seq;

create table twith_pre_insert (
  id                            integer not null,
  name                          varchar(255) not null,
  title                         varchar(255),
  constraint pk_twith_pre_insert primary key (id)
);
create sequence twith_pre_insert_seq;

create table mt_tenant (
  id                            binary(16) not null,
  name                          varchar(255),
  version                       bigint not null,
  constraint pk_mt_tenant primary key (id)
);

create table sa_tire (
  id                            bigint not null,
  version                       integer not null,
  constraint pk_sa_tire primary key (id)
);
create sequence sa_tire_seq;

create table tire (
  id                            bigint not null,
  wheel                         bigint,
  version                       integer not null,
  constraint uq_tire_wheel unique (wheel),
  constraint pk_tire primary key (id)
);
create sequence tire_seq;

create table trip (
  id                            integer not null,
  vehicle_driver_id             integer,
  destination                   varchar(255),
  address_id                    smallint,
  star_date                     timestamp,
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint pk_trip primary key (id)
);
create sequence trip_seq;

create table truck_ref (
  id                            integer not null,
  something                     varchar(255),
  constraint pk_truck_ref primary key (id)
);
create sequence truck_ref_seq;

create table type (
  customer                      integer not null,
  type                          integer not null,
  description                   varchar(255),
  sub_type_id                   integer,
  version                       bigint not null,
  constraint pk_type primary key (customer,type)
);

create table ut_detail (
  id                            integer not null,
  utmaster_id                   integer not null,
  name                          varchar(255),
  qty                           integer,
  amount                        double,
  version                       integer not null,
  constraint pk_ut_detail primary key (id)
);
create sequence ut_detail_seq;

create table ut_master (
  id                            integer not null,
  name                          varchar(255),
  description                   varchar(255),
  version                       integer not null,
  constraint pk_ut_master primary key (id)
);
create sequence ut_master_seq;

create table uuone (
  id                            binary(16) not null,
  name                          varchar(255),
  constraint pk_uuone primary key (id)
);

create table uutwo (
  id                            binary(16) not null,
  name                          varchar(255),
  master_id                     binary(16),
  constraint pk_uutwo primary key (id)
);

create table em_user (
  id                            bigint not null,
  name                          varchar(255),
  constraint pk_em_user primary key (id)
);
create sequence em_user_seq;

create table tx_user (
  id                            bigint not null,
  name                          varchar(255),
  constraint pk_tx_user primary key (id)
);
create sequence tx_user_seq;

create table c_user (
  id                            bigint not null,
  inactive                      boolean,
  name                          varchar(255),
  email                         varchar(255),
  group_id                      bigint,
  version                       bigint not null,
  when_created                  timestamp not null,
  when_modified                 timestamp not null,
  constraint pk_c_user primary key (id)
);
create sequence c_user_seq;

create table oto_user (
  id                            bigint not null,
  name                          varchar(255),
  account_id                    bigint not null,
  version                       bigint not null,
  when_created                  timestamp not null,
  when_modified                 timestamp not null,
  constraint uq_oto_user_account_id unique (account_id),
  constraint pk_oto_user primary key (id)
);
create sequence oto_user_seq;

create table em_user_role (
  user_id                       bigint not null,
  role_id                       bigint not null,
  constraint pk_em_user_role primary key (user_id,role_id)
);

create table vehicle (
  dtype                         varchar(3) not null,
  id                            integer not null,
  license_number                varchar(255),
  registration_date             timestamp,
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  truck_ref_id                  integer,
  capacity                      double,
  driver                        varchar(255),
  car_ref_id                    integer,
  constraint pk_vehicle primary key (id)
);
create sequence vehicle_seq;

create table vehicle_driver (
  id                            integer not null,
  name                          varchar(255),
  vehicle_id                    integer,
  address_id                    smallint,
  license_issued_on             timestamp,
  cretime                       timestamp not null,
  updtime                       timestamp not null,
  version                       bigint not null,
  constraint pk_vehicle_driver primary key (id)
);
create sequence vehicle_driver_seq;

create table warehouses (
  id                            integer not null,
  officeZoneId                  integer,
  constraint pk_warehouses primary key (id)
);
create sequence warehouses_seq;

create table WarehousesShippingZones (
  warehouseId                   integer not null,
  shippingZoneId                integer not null,
  constraint pk_warehousesshippingzones primary key (warehouseId,shippingZoneId)
);

create table sa_wheel (
  id                            bigint not null,
  tire                          bigint,
  car                           bigint,
  version                       integer not null,
  constraint pk_sa_wheel primary key (id)
);
create sequence sa_wheel_seq;

create table sp_car_wheel (
  id                            bigint not null,
  version                       integer not null,
  constraint pk_sp_car_wheel primary key (id)
);
create sequence sp_car_wheel_seq;

create table wheel (
  id                            bigint not null,
  version                       integer not null,
  constraint pk_wheel primary key (id)
);
create sequence wheel_seq;

create table with_zero (
  id                            bigint not null,
  name                          varchar(255),
  parent_id                     integer,
  version                       bigint not null,
  constraint pk_with_zero primary key (id)
);
create sequence with_zero_seq;

create table parent (
  id                            integer not null,
  name                          varchar(255),
  constraint pk_parent primary key (id)
);
create sequence parent_seq;

create table wview (
  id                            binary(16) not null,
  name                          varchar(255) not null,
  constraint uq_wview_name unique (name),
  constraint pk_wview primary key (id)
);

create table zones (
  type                          varchar(31) not null,
  id                            integer not null,
  attribute                     varchar(255),
  constraint pk_zones primary key (id)
);
create sequence zones_seq;

