CREATE TABLE {schema}.mission_reports
(
  otn_mission_id character varying,
  host_mission_id character varying,
  vessel_name character varying,
  mission_end_date_time timestamp without time zone,
  chief_scientist character varying,
  data_collection_personnel character varying,
  other_personnel character varying,
  destination character varying,
  weather_conditions character varying,
  sea_state character varying,
  mission_objectives character varying,
  deployment_count integer,
  download_count integer,
  recovery_count integer,
  mission_summary character varying,
  CONSTRAINT mission_reports_otn_mission_id_key UNIQUE (otn_mission_id)
)
WITH (
  OIDS=FALSE
);