create table r_order_states (
  id char(1) not null constraints rordsta_id_pk primary key;
  name varchar2(100) not null
);

create table r_orders (
  id number(12) not null constraints rord_id_pk primary key;
  state char(1) not null,
  generation_correctness char(1) not null,
  compressed_available char(1) not null,
  generation_file_name_timestamp char(1),
  generate_compressed char(1),
  creation_date date not null,
  generation_start date,
  generation_end date,
  generation_progress_timestamp date,
  type_id number(6) not null,
  creation_user_id number(6) not null,
  generation_priority number(12),
  file_size number(30),
  compressed_file_size number(30),
  report_params varchar2(4000),
  report_description varchar2(4000),
  generation_method varchar2(20),
  generation_progress varchar2(100),
  generation_comment varchar2(4000),
  file_name varchar2(250),
  mime_type varchar2(50),
  compressed_file_name varchar2(250),
  compressed_mime_type varchar2(50),
  content blob,
  compressed_content blob
);

create table r_type_categories (
  id varchar2(20) not null constraints rtypcat_id_pk primary key;
  name varchar2(100) not null
);

create table r_types (
  id number(6) not null constraints rtyp_id_pk primary key;
  active char(1) not null,
  default_file_name_timestamp char(1) not null,
  default_compressed char(1) not null,
  can_immediate_execute char(1) not null,
  defult_generation_priority number(12) not null,
  param_form_init_object number(6),
  param_form_display_object number(6),
  param_form_check_object number(6),
  param_form_save_object number(6),
  generation_object number(6),
  category_id varchar2(20) not null,
  name varchar2(200) not null,
  default_file_name varchar2(200) not null,
  default_mime_type varchar2(50) not null,
  default_generation_method varchar2(20) not null,
  description varchar2(4000)
);

alter table r_orders add (constraint rord_typid_fk foreign key(type_id) references r_types(id));
alter table r_orders add (constraint rord_sta_fk foreign key(state) references r_order_states(id));
alter table r_types add (constraint rtyp_catid_fk foreign key(category_id) references r_type_categories(id));

create index rord_typid on r_orders(type_id);
create index rord_sta on r_orders(state);
create index rtyp_catid on r_types(category_id);

create sequence r_orders_s start with 1;
create sequence r_type_categories_s start with 1;
create sequence r_order_states_s start with 1;
create sequence r_types_s start with 1;