temp_input_params.sql 547 B

1234567891011121314151617
  1. create sequence temp_input_params_seq;
  2. create table temp_input_params
  3. (
  4. id integer not null primary key default nextval('public.temp_input_params_seq'),
  5. emploee_name varchar(100),
  6. measurment_type_id integer NOT NULL,
  7. height numeric(8,2) DEFAULT 0,
  8. temperature numeric(8,2) DEFAULT 0,
  9. pressure numeric(8,2) DEFAULT 0,
  10. wind_direction numeric(8,2) DEFAULT 0,
  11. wind_speed numeric(8,2) DEFAULT 0,
  12. bullet_demolition_range numeric(8,2) DEFAULT 0,
  13. measurment_input_params_id integer,
  14. error_message text,
  15. calc_result jsonb
  16. );