schema.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 10.5
-- Dumped by pg_dump version 10.5

-- Started on 2019-03-12 11:14:06

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;

--
-- TOC entry 6 (class 2615 OID 30909)
-- Name: filter; Type: SCHEMA; Schema: -; Owner: -
--

CREATE SCHEMA filter;


--
-- TOC entry 11 (class 2615 OID 30910)
-- Name: project; Type: SCHEMA; Schema: -; Owner: -
--

CREATE SCHEMA project;


--
-- TOC entry 12 (class 2615 OID 30911)
-- Name: reference; Type: SCHEMA; Schema: -; Owner: -
--

CREATE SCHEMA reference;


--
-- TOC entry 1 (class 3079 OID 12924)
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- TOC entry 5578 (class 0 OID 0)
-- Dependencies: 1
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: -
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


--
-- TOC entry 3 (class 3079 OID 29364)
-- Name: fuzzystrmatch; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS fuzzystrmatch WITH SCHEMA public;


--
-- TOC entry 5579 (class 0 OID 0)
-- Dependencies: 3
-- Name: EXTENSION fuzzystrmatch; Type: COMMENT; Schema: -; Owner: -
--

COMMENT ON EXTENSION fuzzystrmatch IS 'determine similarities and distance between strings';


--
-- TOC entry 2 (class 3079 OID 29375)
-- Name: postgis; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public;


--
-- TOC entry 5580 (class 0 OID 0)
-- Dependencies: 2
-- Name: EXTENSION postgis; Type: COMMENT; Schema: -; Owner: -
--

COMMENT ON EXTENSION postgis IS 'PostGIS geometry, geography, and raster spatial types and functions';


--
-- TOC entry 1674 (class 1255 OID 30912)
-- Name: sp_build_tables(); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_build_tables() RETURNS void
    LANGUAGE plpgsql
    AS $$

DECLARE
   arr varchar[] := array['bathymetry',
			  'bathymetry_layer',
			  'cable_corridor_bathymetry',
			  'cable_corridor_bathymetry_layer',
			  'cable_corridor_constraint',
			  'constraint',
			  'device_shared',
			  'device_floating',
			  'device_tidal',
			  'device_tidal_power_performance',
			  'device_wave',
			  'lease_area',
			  'sub_systems_access',
			  'sub_systems_economic',
			  'sub_systems_install',
			  'sub_systems_inspection',
			  'sub_systems_maintenance',
			  'sub_systems_operation_weightings',
			  'sub_systems_replace',
			  'time_series_energy_tidal',
			  'time_series_energy_wave',
			  'time_series_om_tidal',
			  'time_series_om_wave',
			  'time_series_om_wind'
			  ];
   y TEXT;
   x TEXT;
   r RECORD;
BEGIN
   FOREACH x IN ARRAY arr
   LOOP
      y := 'DROP TABLE filter.' || x;
      RAISE NOTICE '%', y;
      BEGIN
        EXECUTE y;
      EXCEPTION
        WHEN SQLSTATE '42P01' THEN NULL;
      END;
      y := 'CREATE TABLE filter.' || x || ' (LIKE project.' || x || ')';
      RAISE NOTICE '%', y;
      EXECUTE y;
   END LOOP;
END

$$;


--
-- TOC entry 1675 (class 1255 OID 30913)
-- Name: sp_build_view_bathymetry_layer(); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_build_view_bathymetry_layer() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW filter.view_bathymetry_layer AS 
 SELECT 
    bathymetry.utm_point,
    bathymetry.depth,
    bathymetry.mannings_no,
    bathymetry_layer.layer_order,
    bathymetry_layer.initial_depth,
    soil_type.description AS sediment_type
   FROM filter.bathymetry
     LEFT JOIN filter.bathymetry_layer
         ON bathymetry.id = bathymetry_layer.fk_bathymetry_id
     LEFT JOIN reference.soil_type
         ON bathymetry_layer.fk_soil_type_id = soil_type.id;
$$;


--
-- TOC entry 1676 (class 1255 OID 30914)
-- Name: sp_build_view_cable_corridor_bathymetry_layer(); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_build_view_cable_corridor_bathymetry_layer() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW filter.view_cable_corridor_bathymetry_layer AS 
 SELECT cable_corridor_bathymetry.utm_point,
    cable_corridor_bathymetry.depth,
    cable_corridor_bathymetry_layer.layer_order,
    cable_corridor_bathymetry_layer.initial_depth,
    soil_type.description AS sediment_type
   FROM filter.cable_corridor_bathymetry
     LEFT JOIN filter.cable_corridor_bathymetry_layer
         ON cable_corridor_bathymetry.id = cable_corridor_bathymetry_layer.fk_bathymetry_id
     LEFT JOIN reference.soil_type
         ON cable_corridor_bathymetry_layer.fk_soil_type_id = soil_type.id;
$$;


--
-- TOC entry 1677 (class 1255 OID 30915)
-- Name: sp_build_view_control_system_access(); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_build_view_control_system_access() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW filter.view_control_system_access AS 
  SELECT 
    sub_system,
    operation_duration,
    max_hs,
    max_tp,
    max_ws,
    max_cs
  FROM
    "filter"."sub_systems_access" INNER JOIN "project"."sub_systems"
    ON ("filter"."sub_systems_access"."fk_sub_system_id" = "project"."sub_systems"."id")
  WHERE sub_system in ('Control System');
$$;


--
-- TOC entry 1678 (class 1255 OID 30916)
-- Name: sp_build_view_control_system_economic(); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_build_view_control_system_economic() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW filter.view_control_system_economic AS 
  SELECT 
    sub_system,
    cost,
    failure_rate
  FROM
    "filter"."sub_systems_economic" INNER JOIN "project"."sub_systems"
    ON ("filter"."sub_systems_economic"."fk_sub_system_id" = "project"."sub_systems"."id")
  WHERE sub_system in ('Control System');
$$;


--
-- TOC entry 1679 (class 1255 OID 30917)
-- Name: sp_build_view_control_system_inspection(); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_build_view_control_system_inspection() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW filter.view_control_system_inspection AS 
  SELECT 
    sub_system,
    sub_systems_inspection.operation_duration,
    sub_systems_inspection.crew_lead_time,
    sub_systems_inspection.other_lead_time,
    sub_systems_inspection.n_specialists,
    sub_systems_inspection.n_technicians,
    sub_systems_inspection.max_hs,
    sub_systems_inspection.max_tp,
    sub_systems_inspection.max_ws,
    sub_systems_inspection.max_cs
  FROM
    filter.sub_systems_inspection INNER JOIN "project"."sub_systems"
    ON ("filter"."sub_systems_inspection"."fk_sub_system_id" = "project"."sub_systems"."id")
  WHERE sub_system in ('Control System');
$$;


--
-- TOC entry 1680 (class 1255 OID 30918)
-- Name: sp_build_view_control_system_installation(); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_build_view_control_system_installation() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW filter.view_control_system_installation AS 
  SELECT 
    sub_system,
    length,
    width,
    height,
    dry_mass,
    max_hs,
    max_tp,
    max_ws,
    max_cs
  FROM
    filter.sub_systems_install INNER JOIN "project"."sub_systems"
    ON ("filter"."sub_systems_install"."fk_sub_system_id" = "project"."sub_systems"."id")
    WHERE sub_system in ('Control System');
$$;


--
-- TOC entry 1681 (class 1255 OID 30919)
-- Name: sp_build_view_control_system_maintenance(); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_build_view_control_system_maintenance() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW filter.view_control_system_maintenance AS 
  SELECT
    sub_system,
    operation_duration,
    interruptible,
    parts_length,
    parts_width,
    parts_height,
    parts_dry_mass,
    assembly_lead_time,
    crew_lead_time,
    other_lead_time,
    n_specialists,
    n_technicians,
    max_hs,
    max_tp,
    max_ws,
    max_cs
  FROM
    filter.sub_systems_maintenance INNER JOIN "project"."sub_systems"
    ON ("filter"."sub_systems_maintenance"."fk_sub_system_id" = "project"."sub_systems"."id")
  WHERE sub_system in ('Control System');
$$;


--
-- TOC entry 1682 (class 1255 OID 30920)
-- Name: sp_build_view_control_system_operation_weightings(); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_build_view_control_system_operation_weightings() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW filter.view_control_system_operation_weightings AS 
  SELECT
    sub_system,
    maintenance,
    replacement,
    inspection
  FROM
    filter.sub_systems_operation_weightings INNER JOIN "project"."sub_systems"
    ON ("filter"."sub_systems_operation_weightings"."fk_sub_system_id" = "project"."sub_systems"."id")
  WHERE sub_system in ('Control System');
$$;


--
-- TOC entry 1654 (class 1255 OID 30921)
-- Name: sp_build_view_control_system_replace(); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_build_view_control_system_replace() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW filter.view_control_system_replace AS 
  SELECT
    sub_system,
    operation_duration,
    interruptible,
    assembly_lead_time,
    crew_lead_time,
    other_lead_time,
    n_specialists,
    n_technicians
  FROM
    filter.sub_systems_replace INNER JOIN "project"."sub_systems"
    ON ("filter"."sub_systems_replace"."fk_sub_system_id" = "project"."sub_systems"."id")
  WHERE sub_system in ('Control System');
$$;


--
-- TOC entry 1663 (class 1255 OID 30922)
-- Name: sp_build_view_sub_systems_access(); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_build_view_sub_systems_access() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW filter.view_sub_systems_access AS 
  SELECT 
    sub_system,
    operation_duration,
    max_hs,
    max_tp,
    max_ws,
    max_cs
  FROM
    "filter"."sub_systems_access" INNER JOIN "project"."sub_systems"
    ON ("filter"."sub_systems_access"."fk_sub_system_id" = "project"."sub_systems"."id")
  WHERE sub_system in ('Prime Mover', 'PTO', 'Support Structure');
$$;


--
-- TOC entry 1671 (class 1255 OID 30923)
-- Name: sp_build_view_sub_systems_economic(); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_build_view_sub_systems_economic() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW filter.view_sub_systems_economic AS 
  SELECT 
    sub_system,
    cost,
    failure_rate
  FROM
    "filter"."sub_systems_economic" INNER JOIN "project"."sub_systems"
    ON ("filter"."sub_systems_economic"."fk_sub_system_id" = "project"."sub_systems"."id")
  WHERE sub_system in ('Prime Mover', 'PTO', 'Support Structure');
$$;


--
-- TOC entry 1683 (class 1255 OID 30924)
-- Name: sp_build_view_sub_systems_inspection(); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_build_view_sub_systems_inspection() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW filter.view_sub_systems_inspection AS 
  SELECT 
    sub_system,
    sub_systems_inspection.operation_duration,
    sub_systems_inspection.crew_lead_time,
    sub_systems_inspection.other_lead_time,
    sub_systems_inspection.n_specialists,
    sub_systems_inspection.n_technicians,
    sub_systems_inspection.max_hs,
    sub_systems_inspection.max_tp,
    sub_systems_inspection.max_ws,
    sub_systems_inspection.max_cs
  FROM
    filter.sub_systems_inspection INNER JOIN "project"."sub_systems"
    ON ("filter"."sub_systems_inspection"."fk_sub_system_id" = "project"."sub_systems"."id")
  WHERE sub_system in ('Prime Mover', 'PTO', 'Support Structure');
$$;


--
-- TOC entry 1684 (class 1255 OID 30925)
-- Name: sp_build_view_sub_systems_installation(); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_build_view_sub_systems_installation() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW filter.view_sub_systems_installation AS 
  SELECT 
    sub_system,
    length,
    width,
    height,
    dry_mass,
    max_hs,
    max_tp,
    max_ws,
    max_cs
  FROM
    filter.sub_systems_install INNER JOIN "project"."sub_systems"
    ON ("filter"."sub_systems_install"."fk_sub_system_id" = "project"."sub_systems"."id")
    WHERE sub_system in ('Prime Mover', 'PTO', 'Support Structure');
$$;


--
-- TOC entry 1685 (class 1255 OID 30926)
-- Name: sp_build_view_sub_systems_maintenance(); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_build_view_sub_systems_maintenance() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW filter.view_sub_systems_maintenance AS 
  SELECT
    sub_system,
    operation_duration,
    interruptible,
    parts_length,
    parts_width,
    parts_height,
    parts_dry_mass,
    assembly_lead_time,
    crew_lead_time,
    other_lead_time,
    n_specialists,
    n_technicians,
    max_hs,
    max_tp,
    max_ws,
    max_cs
  FROM
    filter.sub_systems_maintenance INNER JOIN "project"."sub_systems"
    ON ("filter"."sub_systems_maintenance"."fk_sub_system_id" = "project"."sub_systems"."id")
  WHERE sub_system in ('Prime Mover', 'PTO', 'Support Structure');
$$;


--
-- TOC entry 1686 (class 1255 OID 30927)
-- Name: sp_build_view_sub_systems_operation_weightings(); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_build_view_sub_systems_operation_weightings() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW filter.view_sub_systems_operation_weightings AS 
  SELECT
    sub_system,
    maintenance,
    replacement,
    inspection
  FROM
    filter.sub_systems_operation_weightings INNER JOIN "project"."sub_systems"
    ON ("filter"."sub_systems_operation_weightings"."fk_sub_system_id" = "project"."sub_systems"."id")
  WHERE sub_system in ('Prime Mover', 'PTO', 'Support Structure');
$$;


--
-- TOC entry 1687 (class 1255 OID 30928)
-- Name: sp_build_view_sub_systems_replace(); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_build_view_sub_systems_replace() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW filter.view_sub_systems_replace AS 
  SELECT
    sub_system,
    operation_duration,
    interruptible,
    assembly_lead_time,
    crew_lead_time,
    other_lead_time,
    n_specialists,
    n_technicians
  FROM
    filter.sub_systems_replace INNER JOIN "project"."sub_systems"
    ON ("filter"."sub_systems_replace"."fk_sub_system_id" = "project"."sub_systems"."id")
  WHERE sub_system in ('Prime Mover', 'PTO', 'Support Structure');
$$;


--
-- TOC entry 1688 (class 1255 OID 30929)
-- Name: sp_build_view_time_series_energy_tidal(); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_build_view_time_series_energy_tidal() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW filter.view_time_series_energy_tidal AS 
 SELECT bathymetry.utm_point,
    time_series_energy_tidal.measure_date,
    time_series_energy_tidal.measure_time,
    time_series_energy_tidal.u,
    time_series_energy_tidal.v,
    time_series_energy_tidal.turbulence_intensity,
    time_series_energy_tidal.ssh
   FROM filter.bathymetry
     JOIN filter.time_series_energy_tidal ON bathymetry.id = time_series_energy_tidal.fk_bathymetry_id;
$$;


--
-- TOC entry 1689 (class 1255 OID 30930)
-- Name: sp_build_views(); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_build_views() RETURNS void
    LANGUAGE sql
    AS $$
SELECT filter.sp_build_view_bathymetry_layer();
SELECT filter.sp_build_view_cable_corridor_bathymetry_layer();
SELECT filter.sp_build_view_time_series_energy_tidal();
SELECT filter.sp_build_view_sub_systems_installation();
SELECT filter.sp_build_view_sub_systems_access();
SELECT filter.sp_build_view_sub_systems_inspection();
SELECT filter.sp_build_view_sub_systems_maintenance();
SELECT filter.sp_build_view_sub_systems_replace();
SELECT filter.sp_build_view_sub_systems_economic();
SELECT filter.sp_build_view_sub_systems_operation_weightings();
SELECT filter.sp_build_view_control_system_installation();
SELECT filter.sp_build_view_control_system_access();
SELECT filter.sp_build_view_control_system_economic();
SELECT filter.sp_build_view_control_system_inspection();
SELECT filter.sp_build_view_control_system_maintenance();
SELECT filter.sp_build_view_control_system_operation_weightings();
SELECT filter.sp_build_view_control_system_replace();
$$;


--
-- TOC entry 1690 (class 1255 OID 30931)
-- Name: sp_drop_views(); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_drop_views() RETURNS void
    LANGUAGE sql
    AS $$
DROP VIEW filter.view_bathymetry_layer;
DROP VIEW filter.view_cable_corridor_bathymetry_layer;
DROP VIEW filter.view_time_series_energy_tidal;
DROP VIEW filter.view_sub_systems_installation;
DROP VIEW filter.view_control_system_installation;
DROP VIEW filter.view_sub_systems_access;
DROP VIEW filter.view_sub_systems_inspection;
DROP VIEW filter.view_sub_systems_maintenance;
DROP VIEW filter.view_sub_systems_replace;
DROP VIEW filter.view_sub_systems_economic;
DROP VIEW filter.view_sub_systems_operation_weightings;
DROP VIEW filter.view_control_system_access;
DROP VIEW filter.view_control_system_economic;
DROP VIEW filter.view_control_system_inspection;
DROP VIEW filter.view_control_system_maintenance;
DROP VIEW filter.view_control_system_operation_weightings;
DROP VIEW filter.view_control_system_replace;
$$;


--
-- TOC entry 1691 (class 1255 OID 30932)
-- Name: sp_filter_cable_corridor_constraint(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_cable_corridor_constraint(site_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."cable_corridor_constraint" 
  SELECT * FROM "project"."cable_corridor_constraint"
  WHERE "project"."cable_corridor_constraint".fk_site_id = "site_id"; 
END;
$$;


--
-- TOC entry 1692 (class 1255 OID 30933)
-- Name: sp_filter_cable_corridor_site_bathymetry(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_cable_corridor_site_bathymetry(site_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."cable_corridor_bathymetry" 
  SELECT * FROM "project"."cable_corridor_bathymetry"
  WHERE "project"."cable_corridor_bathymetry".fk_site_id = "site_id";  
END;
$$;


--
-- TOC entry 1693 (class 1255 OID 30934)
-- Name: sp_filter_cable_corridor_site_bathymetry_layer(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_cable_corridor_site_bathymetry_layer(site_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."cable_corridor_bathymetry_layer" 
  SELECT "cable_corridor_bathymetry_layer".*
  FROM
     "project"."cable_corridor_bathymetry"
     INNER JOIN "project"."cable_corridor_bathymetry_layer"
     ON ("project"."cable_corridor_bathymetry_layer"."fk_bathymetry_id" = "project"."cable_corridor_bathymetry"."id")
     WHERE 
       "project"."cable_corridor_bathymetry"."fk_site_id" = site_id;
 END;
$$;


--
-- TOC entry 1694 (class 1255 OID 30935)
-- Name: sp_filter_constraint(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_constraint(site_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."constraint" 
  SELECT * FROM "project"."constraint"
  WHERE "project"."constraint".fk_site_id = "site_id"; 
END;
$$;


--
-- TOC entry 1695 (class 1255 OID 30936)
-- Name: sp_filter_device_data(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_device_data(device_id integer) RETURNS void
    LANGUAGE sql
    AS $$
TRUNCATE filter.device_shared;
SELECT * FROM filter.sp_filter_device_shared(device_id);

TRUNCATE filter.device_floating;
SELECT * FROM filter.sp_filter_device_floating(device_id);

TRUNCATE filter.device_tidal;
SELECT * FROM filter.sp_filter_device_tidal(device_id);

TRUNCATE filter.device_tidal_power_performance;
SELECT * FROM filter.sp_filter_device_tidal_power_performance(device_id);

TRUNCATE filter.device_wave;
SELECT * FROM filter.sp_filter_device_wave(device_id);

TRUNCATE filter.sub_systems_install;
SELECT * FROM filter.sp_filter_sub_systems_install(device_id);

TRUNCATE filter.sub_systems_access;
SELECT * FROM filter.sp_filter_sub_systems_access(device_id);

TRUNCATE filter.sub_systems_economic;
SELECT * FROM filter.sp_filter_sub_systems_economic(device_id);

TRUNCATE filter.sub_systems_inspection;
SELECT * FROM filter.sp_filter_sub_systems_inspection(device_id);

TRUNCATE filter.sub_systems_maintenance;
SELECT * FROM filter.sp_filter_sub_systems_maintenance(device_id);

TRUNCATE filter.sub_systems_operation_weightings;
SELECT * FROM filter.sp_filter_sub_systems_operation_weightings(device_id);

TRUNCATE filter.sub_systems_replace;
SELECT * FROM filter.sp_filter_sub_systems_replace(device_id);
$$;


--
-- TOC entry 1696 (class 1255 OID 30937)
-- Name: sp_filter_device_floating(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_device_floating(device_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."device_floating" 
  SELECT * FROM "project"."device_floating"
  WHERE "project"."device_floating".fk_device_id = "device_id"; 
END;
$$;


--
-- TOC entry 1697 (class 1255 OID 30938)
-- Name: sp_filter_device_shared(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_device_shared(device_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."device_shared" 
  SELECT * FROM "project"."device_shared"
  WHERE "project"."device_shared".fk_device_id = "device_id"; 
END;
$$;


--
-- TOC entry 1698 (class 1255 OID 30939)
-- Name: sp_filter_device_tidal(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_device_tidal(device_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."device_tidal" 
  SELECT * FROM "project"."device_tidal"
  WHERE "project"."device_tidal".fk_device_id = "device_id"; 
END;
$$;


--
-- TOC entry 1699 (class 1255 OID 30940)
-- Name: sp_filter_device_tidal_power_performance(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_device_tidal_power_performance(device_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."device_tidal_power_performance" 
  SELECT * FROM "project"."device_tidal_power_performance"
  WHERE "project"."device_tidal_power_performance".fk_device_id = "device_id"; 
END;
$$;


--
-- TOC entry 1700 (class 1255 OID 30941)
-- Name: sp_filter_device_wave(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_device_wave(device_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."device_wave" 
  SELECT * FROM "project"."device_wave"
  WHERE "project"."device_wave".fk_device_id = "device_id"; 
END;
$$;


--
-- TOC entry 1701 (class 1255 OID 30942)
-- Name: sp_filter_lease_area(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_lease_area(site_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."lease_area" 
  SELECT * FROM "project"."lease_area"
  WHERE "project"."lease_area".fk_site_id = "site_id"; 
END;
$$;


--
-- TOC entry 1702 (class 1255 OID 30943)
-- Name: sp_filter_site_bathymetry(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_site_bathymetry(site_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."bathymetry" 
  SELECT * FROM "project"."bathymetry"
  WHERE "project"."bathymetry".fk_site_id = "site_id"; 
END;
$$;


--
-- TOC entry 1703 (class 1255 OID 30944)
-- Name: sp_filter_site_bathymetry_layer(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_site_bathymetry_layer(site_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."bathymetry_layer" 
  SELECT "bathymetry_layer".*
  FROM
     "project"."bathymetry"
     INNER JOIN "project"."bathymetry_layer"
     ON ("project"."bathymetry_layer"."fk_bathymetry_id" = "project"."bathymetry"."id")
     WHERE 
       "project"."bathymetry"."fk_site_id" = site_id; 
END;
$$;


--
-- TOC entry 1704 (class 1255 OID 30945)
-- Name: sp_filter_site_data(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_site_data(site_id integer) RETURNS void
    LANGUAGE sql
    AS $$
TRUNCATE filter.lease_area;
SELECT * FROM filter.sp_filter_lease_area(site_id);

TRUNCATE filter.constraint;
SELECT * FROM filter.sp_filter_constraint(site_id);

TRUNCATE filter.cable_corridor_constraint;
SELECT * FROM filter.sp_filter_cable_corridor_constraint(site_id);

TRUNCATE filter.bathymetry;
SELECT * FROM filter.sp_filter_site_bathymetry(site_id);

TRUNCATE filter.bathymetry_layer;
SELECT * FROM filter.sp_filter_site_bathymetry_layer(site_id);

TRUNCATE filter.cable_corridor_bathymetry;
SELECT * FROM filter.sp_filter_cable_corridor_site_bathymetry(site_id);

TRUNCATE filter.cable_corridor_bathymetry_layer;
SELECT * FROM filter.sp_filter_cable_corridor_site_bathymetry_layer(site_id);

-- Time Series Data
TRUNCATE filter.time_series_energy_tidal;
SELECT * FROM filter.sp_filter_site_time_series_energy_tidal(site_id);

TRUNCATE filter.time_series_energy_wave;
SELECT * FROM filter.sp_filter_site_time_series_energy_wave(site_id);

TRUNCATE filter.time_series_om_tidal;
SELECT * FROM filter.sp_filter_site_time_series_om_tidal(site_id);

TRUNCATE filter.time_series_om_wave;
SELECT * FROM filter.sp_filter_site_time_series_om_wave(site_id);

TRUNCATE filter.time_series_om_wind;
SELECT * FROM filter.sp_filter_site_time_series_om_wind(site_id);
$$;


--
-- TOC entry 1705 (class 1255 OID 30946)
-- Name: sp_filter_site_time_series_energy_tidal(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_site_time_series_energy_tidal(site_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO filter.time_series_energy_tidal 
  SELECT project.time_series_energy_tidal.*
  FROM
     project.bathymetry
     INNER JOIN project.time_series_energy_tidal 
     ON (project.time_series_energy_tidal.fk_bathymetry_id = project.bathymetry.id)
     WHERE 
       project.bathymetry.fk_site_id = site_id; 
  
END;
$$;


--
-- TOC entry 1706 (class 1255 OID 30947)
-- Name: sp_filter_site_time_series_energy_wave(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_site_time_series_energy_wave(site_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."time_series_energy_wave" 
  SELECT * FROM "project"."time_series_energy_wave"
  WHERE "project"."time_series_energy_wave"."fk_site_id" = "site_id"; 
END;
$$;


--
-- TOC entry 1707 (class 1255 OID 30948)
-- Name: sp_filter_site_time_series_om_tidal(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_site_time_series_om_tidal(site_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."time_series_om_tidal" 
  SELECT * FROM "project"."time_series_om_tidal"
  WHERE "project"."time_series_om_tidal"."fk_site_id" = "site_id"; 
END;
$$;


--
-- TOC entry 1708 (class 1255 OID 30949)
-- Name: sp_filter_site_time_series_om_wave(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_site_time_series_om_wave(site_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."time_series_om_wave" 
  SELECT * FROM "project"."time_series_om_wave"
  WHERE "project"."time_series_om_wave"."fk_site_id" = "site_id";
END;
$$;


--
-- TOC entry 1613 (class 1255 OID 30950)
-- Name: sp_filter_site_time_series_om_wind(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_site_time_series_om_wind(site_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."time_series_om_wind" 
  SELECT * FROM "project"."time_series_om_wind"
  WHERE "project"."time_series_om_wind"."fk_site_id" = "site_id"; 
END;
$$;


--
-- TOC entry 1709 (class 1255 OID 30951)
-- Name: sp_filter_sub_systems_access(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_sub_systems_access(device_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."sub_systems_access" 
  SELECT
     "sub_systems_access".*
  FROM
     "project"."sub_systems"
     INNER JOIN "project"."sub_systems_access"
     ON ("project"."sub_systems_access"."fk_sub_system_id" = "project"."sub_systems"."id")
     WHERE 
       "project"."sub_systems"."fk_device_id" = device_id; 
END;
$$;


--
-- TOC entry 1710 (class 1255 OID 30952)
-- Name: sp_filter_sub_systems_economic(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_sub_systems_economic(device_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."sub_systems_economic" 
  SELECT
     "sub_systems_economic".*
  FROM
     "project"."sub_systems"
     INNER JOIN "project"."sub_systems_economic"
     ON ("project"."sub_systems_economic"."fk_sub_system_id" = "project"."sub_systems"."id")
     WHERE 
       "project"."sub_systems"."fk_device_id" = device_id; 
END;
$$;


--
-- TOC entry 1711 (class 1255 OID 30953)
-- Name: sp_filter_sub_systems_inspection(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_sub_systems_inspection(device_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."sub_systems_inspection" 
  SELECT
     "sub_systems_inspection".*
  FROM
     "project"."sub_systems"
     INNER JOIN "project"."sub_systems_inspection"
     ON ("project"."sub_systems_inspection"."fk_sub_system_id" = "project"."sub_systems"."id")
     WHERE 
       "project"."sub_systems"."fk_device_id" = device_id; 
END;
$$;


--
-- TOC entry 1712 (class 1255 OID 30954)
-- Name: sp_filter_sub_systems_install(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_sub_systems_install(device_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."sub_systems_install" 
  SELECT
     "sub_systems_install".*
  FROM
     "project"."sub_systems"
     INNER JOIN "project"."sub_systems_install"
     ON ("project"."sub_systems_install"."fk_sub_system_id" = "project"."sub_systems"."id")
     WHERE 
       "project"."sub_systems"."fk_device_id" = device_id; 
END;
$$;


--
-- TOC entry 1713 (class 1255 OID 30955)
-- Name: sp_filter_sub_systems_maintenance(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_sub_systems_maintenance(device_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."sub_systems_maintenance" 
  SELECT
     "sub_systems_maintenance".*
  FROM
     "project"."sub_systems"
     INNER JOIN "project"."sub_systems_maintenance"
     ON ("project"."sub_systems_maintenance"."fk_sub_system_id" = "project"."sub_systems"."id")
     WHERE 
       "project"."sub_systems"."fk_device_id" = device_id; 
END;
$$;


--
-- TOC entry 1714 (class 1255 OID 30956)
-- Name: sp_filter_sub_systems_operation_weightings(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_sub_systems_operation_weightings(device_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."sub_systems_operation_weightings" 
  SELECT
     "sub_systems_operation_weightings".*
  FROM
     "project"."sub_systems"
     INNER JOIN "project"."sub_systems_operation_weightings"
     ON ("project"."sub_systems_operation_weightings"."fk_sub_system_id" = "project"."sub_systems"."id")
     WHERE 
       "project"."sub_systems"."fk_device_id" = device_id; 
END;
$$;


--
-- TOC entry 1715 (class 1255 OID 30957)
-- Name: sp_filter_sub_systems_replace(integer); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_filter_sub_systems_replace(device_id integer) RETURNS void
    LANGUAGE plpgsql
    AS $$
BEGIN
  INSERT INTO "filter"."sub_systems_replace" 
  SELECT
     "sub_systems_replace".*
  FROM
     "project"."sub_systems"
     INNER JOIN "project"."sub_systems_replace"
     ON ("project"."sub_systems_replace"."fk_sub_system_id" = "project"."sub_systems"."id")
     WHERE 
       "project"."sub_systems"."fk_device_id" = device_id; 
END;
$$;


--
-- TOC entry 1716 (class 1255 OID 30958)
-- Name: sp_select_bathymetry_by_polygon(text); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_select_bathymetry_by_polygon(polystring text) RETURNS TABLE(utm_point public.geometry, depth double precision, mannings_no double precision, layer_order smallint, initial_depth double precision, sediment_type character varying)
    LANGUAGE sql ROWS 100000
    AS $$
SELECT 
  utm_point,
  depth,
  mannings_no,
  layer_order,
  initial_depth,
  sediment_type
FROM filter.view_bathymetry_layer
WHERE 
(ST_Covers(ST_GeomFromText('POLYGON(('|| polystring || '))', 0), filter.view_bathymetry_layer.utm_point));
$$;


--
-- TOC entry 1717 (class 1255 OID 30959)
-- Name: sp_select_cable_corridor_bathymetry_by_polygon(text); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_select_cable_corridor_bathymetry_by_polygon(polystring text) RETURNS TABLE(utm_point public.geometry, depth double precision, layer_order smallint, initial_depth double precision, sediment_type character varying)
    LANGUAGE sql ROWS 100000
    AS $$
SELECT 
  utm_point,
  depth,
  layer_order,
  initial_depth,
  sediment_type
FROM filter.view_cable_corridor_bathymetry_layer
WHERE 
(ST_Covers(ST_GeomFromText('POLYGON(('|| polystring || '))', -1), filter.view_cable_corridor_bathymetry_layer.utm_point));
$$;


--
-- TOC entry 1718 (class 1255 OID 30960)
-- Name: sp_select_tidal_energy_time_series_by_polygon(text); Type: FUNCTION; Schema: filter; Owner: -
--

CREATE FUNCTION filter.sp_select_tidal_energy_time_series_by_polygon(polystring text) RETURNS TABLE(utm_point public.geometry, measure_date date, measure_time time without time zone, u double precision, v double precision, turbulence_intensity double precision, ssh double precision)
    LANGUAGE sql ROWS 5
    AS $$
SELECT
  utm_point,
  measure_date,
  measure_time,
  u,
  v,
  turbulence_intensity,
  ssh
FROM filter.view_time_series_energy_tidal
WHERE 
(ST_Covers(ST_GeomFromText('POLYGON(('|| polystring || '))', 0), filter.view_time_series_energy_tidal.utm_point));
$$;


--
-- TOC entry 1719 (class 1255 OID 30961)
-- Name: sp_build_view_component_cable_dynamic(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_component_cable_dynamic() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_component_cable_dynamic AS 
 SELECT component.id AS component_id,
    component.description,
    component_continuous.diameter,
    component_continuous.dry_mass_per_unit_length,
    component_continuous.wet_mass_per_unit_length,
    minimum_breaking_load,
    minimum_bend_radius,
    number_conductors,
    number_fibre_channels,
    resistance_dc_20,
    resistance_ac_90,
    inductive_reactance,
    capacitance,
    rated_current_air,
    rated_current_buried,
    rated_current_jtube,
    rated_voltage_u0,
    operational_temp_max,
    component_continuous.cost_per_unit_length,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM reference.component_cable
   JOIN reference.component_continuous ON component_cable.fk_component_continuous_id = component_continuous.id
   JOIN reference.component_shared ON component_continuous.fk_component_id = component_shared.fk_component_id
   JOIN reference.component ON component_continuous.fk_component_id = component.id
   JOIN reference.component_type ON component_cable.fk_component_type_id = component_type.id
   WHERE component_type.description::text = 'cable dynamic'::text;
  $$;


--
-- TOC entry 1720 (class 1255 OID 30962)
-- Name: sp_build_view_component_cable_static(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_component_cable_static() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_component_cable_static AS 
 SELECT component.id AS component_id,
    component.description,
    component_continuous.diameter,
    component_continuous.dry_mass_per_unit_length,
    component_continuous.wet_mass_per_unit_length,
    minimum_breaking_load,
    minimum_bend_radius,
    number_conductors,
    number_fibre_channels,
    resistance_dc_20,
    resistance_ac_90,
    inductive_reactance,
    capacitance,
    rated_current_air,
    rated_current_buried,
    rated_current_jtube,
    rated_voltage_u0,
    operational_temp_max,
    component_continuous.cost_per_unit_length,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM reference.component_cable
   JOIN reference.component_continuous ON component_cable.fk_component_continuous_id = component_continuous.id
   JOIN reference.component_shared ON component_continuous.fk_component_id = component_shared.fk_component_id
   JOIN reference.component ON component_continuous.fk_component_id = component.id
   JOIN reference.component_type ON component_cable.fk_component_type_id = component_type.id
   WHERE component_type.description::text = 'cable static'::text;
$$;


--
-- TOC entry 1721 (class 1255 OID 30963)
-- Name: sp_build_view_component_collection_point(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_component_collection_point() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_component_collection_point AS 
 SELECT component.id AS component_id,
    component.description,
    component_discrete.width,
    component_discrete.length AS depth,
    component_discrete.height,
    component_discrete.dry_mass,
    component_discrete.wet_mass,
    wet_frontal_area,
    dry_frontal_area,
    wet_beam_area,
    dry_beam_area,
    maximum_water_depth,
    orientation_angle,
    input_lines,
    output_lines,
    input_connector_type,
    output_connector_type,
    number_fibre_channels,
    voltage_primary_winding,
    voltage_secondary_winding,
    rated_operating_current,
    operational_temp_min,
    operational_temp_max,
    foundation_locations,
    centre_of_gravity,
    component_discrete.cost,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM reference.component_collection_point
   JOIN reference.component_discrete ON component_collection_point.fk_component_discrete_id = component_discrete.id
   JOIN reference.component_shared ON component_discrete.fk_component_id = component_shared.fk_component_id
   JOIN reference.component ON component_discrete.fk_component_id = component.id;
$$;


--
-- TOC entry 1722 (class 1255 OID 30964)
-- Name: sp_build_view_component_connector_drymate(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_component_connector_drymate() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_component_connector_drymate AS 
 SELECT component.id AS component_id,
    component.description,
    component_discrete.width,
    component_discrete.length AS depth,
    component_discrete.height,
    component_discrete.dry_mass,
    component_discrete.wet_mass,
    maximum_water_depth,
    number_contacts,
    number_fibre_channels,
    mating_force,
    demating_force,
    rated_voltage_u0,
    rated_current,
    cable_area_min,
    cable_area_max,
    operational_temp_min,
    operational_temp_max,
    component_discrete.cost,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM reference.component_connector
   JOIN reference.component_discrete ON component_connector.fk_component_discrete_id = component_discrete.id
   JOIN reference.component_shared ON component_discrete.fk_component_id = component_shared.fk_component_id
   JOIN reference.component ON component_discrete.fk_component_id = component.id
   JOIN reference.component_type ON component_connector.fk_component_type_id = component_type.id
   WHERE component_type.description::text = 'connector dry-mate'::text;
$$;


--
-- TOC entry 1723 (class 1255 OID 30965)
-- Name: sp_build_view_component_connector_wetmate(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_component_connector_wetmate() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_component_connector_wetmate AS 
 SELECT component.id AS component_id,
    component.description,
    component_discrete.width,
    component_discrete.length AS depth,
    component_discrete.height,
    component_discrete.dry_mass,
    component_discrete.wet_mass,
    maximum_water_depth,
    number_contacts,
    number_fibre_channels,
    mating_force,
    demating_force,
    rated_voltage_u0,
    rated_current,
    cable_area_min,
    cable_area_max,
    operational_temp_min,
    operational_temp_max,
    component_discrete.cost,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM reference.component_connector
   JOIN reference.component_discrete ON component_connector.fk_component_discrete_id = component_discrete.id
   JOIN reference.component_shared ON component_discrete.fk_component_id = component_shared.fk_component_id
   JOIN reference.component ON component_discrete.fk_component_id = component.id
   JOIN reference.component_type ON component_connector.fk_component_type_id = component_type.id
   WHERE component_type.description::text = 'connector wet-mate'::text;
$$;


--
-- TOC entry 1725 (class 1255 OID 30966)
-- Name: sp_build_view_component_foundations_anchor(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_component_foundations_anchor() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_component_foundations_anchor AS 
 SELECT component.id AS component_id,
    component.description,
    component_discrete.width,
    component_discrete.length AS depth,
    component_discrete.height,
    component_discrete.dry_mass,
    component_discrete.wet_mass,
    connecting_size,
    minimum_breaking_load,
    axial_stiffness,
    component_discrete.cost,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM reference.component_anchor
   JOIN reference.component_discrete ON component_anchor.fk_component_discrete_id = component_discrete.id
   JOIN reference.component_shared ON component_discrete.fk_component_id = component_shared.fk_component_id
   JOIN reference.component ON component_discrete.fk_component_id = component.id;
$$;


--
-- TOC entry 1726 (class 1255 OID 30967)
-- Name: sp_build_view_component_foundations_anchor_coefs(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_component_foundations_anchor_coefs() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_component_foundations_anchor_coefs AS 
 SELECT component.id AS component_id,
    soft_holding_cap_coef_1,
    soft_holding_cap_coef_2,
    soft_penetration_coef_1,
    soft_penetration_coef_2,
    sand_holding_cap_coef_1,
    sand_holding_cap_coef_2,
    sand_penetration_coef_1,
    sand_penetration_coef_2
   FROM reference.component_anchor
   JOIN reference.component_discrete ON component_anchor.fk_component_discrete_id = component_discrete.id
   JOIN reference.component ON component_discrete.fk_component_id = component.id;
$$;


--
-- TOC entry 1727 (class 1255 OID 30968)
-- Name: sp_build_view_component_foundations_pile(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_component_foundations_pile() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_component_foundations_pile AS 
 SELECT component.id AS component_id,
    component.description,
    component_continuous.diameter,
    component_continuous.dry_mass_per_unit_length,
    component_continuous.wet_mass_per_unit_length,
    wall_thickness,
    yield_stress,
    youngs_modulus,
    component_continuous.cost_per_unit_length,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM reference.component_pile
   JOIN reference.component_continuous ON component_pile.fk_component_continuous_id = component_continuous.id
   JOIN reference.component_shared ON component_continuous.fk_component_id = component_shared.fk_component_id
   JOIN reference.component ON component_continuous.fk_component_id = component.id;
$$;


--
-- TOC entry 1728 (class 1255 OID 30969)
-- Name: sp_build_view_component_moorings_chain(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_component_moorings_chain() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_component_moorings_chain AS 
 SELECT component.id AS component_id,
    component.description,
    component_continuous.diameter,
    component_continuous.dry_mass_per_unit_length,
    component_continuous.wet_mass_per_unit_length,
    connecting_length,
    minimum_breaking_load,
    axial_stiffness,
    component_continuous.cost_per_unit_length,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM reference.component_mooring_continuous
   JOIN reference.component_continuous ON component_mooring_continuous.fk_component_continuous_id = component_continuous.id
   JOIN reference.component_shared ON component_continuous.fk_component_id = component_shared.fk_component_id
   JOIN reference.component ON component_continuous.fk_component_id = component.id
   JOIN reference.component_type ON component_mooring_continuous.fk_component_type_id = component_type.id
   WHERE component_type.description::text = 'chain'::text;
$$;


--
-- TOC entry 1729 (class 1255 OID 30970)
-- Name: sp_build_view_component_moorings_forerunner(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_component_moorings_forerunner() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_component_moorings_forerunner AS 
 SELECT component.id AS component_id,
    component.description,
    component_continuous.diameter,
    component_continuous.dry_mass_per_unit_length,
    component_continuous.wet_mass_per_unit_length,
    connecting_length,
    minimum_breaking_load,
    axial_stiffness,
    component_continuous.cost_per_unit_length,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM reference.component_mooring_continuous
   JOIN reference.component_continuous ON component_mooring_continuous.fk_component_continuous_id = component_continuous.id
   JOIN reference.component_shared ON component_continuous.fk_component_id = component_shared.fk_component_id
   JOIN reference.component ON component_continuous.fk_component_id = component.id
   JOIN reference.component_type ON component_mooring_continuous.fk_component_type_id = component_type.id
   WHERE component_type.description::text = 'forerunner'::text;
$$;


--
-- TOC entry 1730 (class 1255 OID 30971)
-- Name: sp_build_view_component_moorings_rope(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_component_moorings_rope() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_component_moorings_rope AS 
 SELECT component.id AS component_id,
    component.description,
    component_continuous.diameter,
    component_continuous.dry_mass_per_unit_length,
    component_continuous.wet_mass_per_unit_length,
    material,
    minimum_breaking_load,
    rope_stiffness_curve,
    component_continuous.cost_per_unit_length,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM reference.component_rope
   JOIN reference.component_continuous ON component_rope.fk_component_continuous_id = component_continuous.id
   JOIN reference.component_shared ON component_continuous.fk_component_id = component_shared.fk_component_id
   JOIN reference.component ON component_continuous.fk_component_id = component.id;
$$;


--
-- TOC entry 1731 (class 1255 OID 30972)
-- Name: sp_build_view_component_moorings_shackle(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_component_moorings_shackle() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_component_moorings_shackle AS 
 SELECT component.id AS component_id,
    component.description,
    component_discrete.width,
    component_discrete.length AS depth,
    component_discrete.height,
    component_discrete.dry_mass,
    component_discrete.wet_mass,
    nominal_diameter,
    connecting_length,
    minimum_breaking_load,
    axial_stiffness,
    component_discrete.cost,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM reference.component_mooring_discrete
   JOIN reference.component_discrete ON component_mooring_discrete.fk_component_discrete_id = component_discrete.id
   JOIN reference.component_shared ON component_discrete.fk_component_id = component_shared.fk_component_id
   JOIN reference.component ON component_discrete.fk_component_id = component.id
   JOIN reference.component_type ON component_mooring_discrete.fk_component_type_id = component_type.id
   WHERE component_type.description::text = 'shackle'::text;
$$;


--
-- TOC entry 1732 (class 1255 OID 30973)
-- Name: sp_build_view_component_moorings_swivel(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_component_moorings_swivel() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_component_moorings_swivel AS 
 SELECT component.id AS component_id,
    component.description,
    component_discrete.width,
    component_discrete.length AS depth,
    component_discrete.height,
    component_discrete.dry_mass,
    component_discrete.wet_mass,
    nominal_diameter,
    connecting_length,
    minimum_breaking_load,
    axial_stiffness,
    component_discrete.cost,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM reference.component_mooring_discrete
   JOIN reference.component_discrete ON component_mooring_discrete.fk_component_discrete_id = component_discrete.id
   JOIN reference.component_shared ON component_discrete.fk_component_id = component_shared.fk_component_id
   JOIN reference.component ON component_discrete.fk_component_id = component.id
   JOIN reference.component_type ON component_mooring_discrete.fk_component_type_id = component_type.id
   WHERE component_type.description::text = 'swivel'::text;
$$;


--
-- TOC entry 1733 (class 1255 OID 30974)
-- Name: sp_build_view_component_transformer(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_component_transformer() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_component_transformer AS 
 SELECT component.id AS component_id,
    component.description,
    component_discrete.width,
    component_discrete.length AS depth,
    component_discrete.height,
    component_discrete.dry_mass,
    component_discrete.wet_mass,
    maximum_water_depth,
    power_rating,
    impedance,
    windings,
    voltage_primary_winding,
    voltage_secondary_winding,
    voltage_tertiary_winding,
    operational_temp_min,
    operational_temp_max,
    component_discrete.cost,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM reference.component_transformer
   JOIN reference.component_discrete ON component_transformer.fk_component_discrete_id = component_discrete.id
   JOIN reference.component_shared ON component_discrete.fk_component_id = component_shared.fk_component_id
   JOIN reference.component ON component_discrete.fk_component_id = component.id;
$$;


--
-- TOC entry 1734 (class 1255 OID 30975)
-- Name: sp_build_view_operations_limit_cs(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_operations_limit_cs() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_operations_limit_cs AS 
  SELECT
    operations_type.description AS operations_type,
    cs_limit
  FROM reference.operations_limit_cs
  JOIN reference.operations_type ON operations_limit_cs.fk_operations_id = operations_type.id;
$$;


--
-- TOC entry 1735 (class 1255 OID 30976)
-- Name: sp_build_view_operations_limit_hs(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_operations_limit_hs() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_operations_limit_hs AS 
  SELECT
    operations_type.description AS operations_type,
    hs_limit
  FROM reference.operations_limit_hs
  JOIN reference.operations_type ON operations_limit_hs.fk_operations_id = operations_type.id;
$$;


--
-- TOC entry 1736 (class 1255 OID 30977)
-- Name: sp_build_view_operations_limit_tp(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_operations_limit_tp() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_operations_limit_tp AS 
  SELECT
    operations_type.description AS operations_type,
    tp_limit
  FROM reference.operations_limit_tp
  JOIN reference.operations_type ON operations_limit_tp.fk_operations_id = operations_type.id;
$$;


--
-- TOC entry 1737 (class 1255 OID 30978)
-- Name: sp_build_view_operations_limit_ws(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_operations_limit_ws() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_operations_limit_ws AS 
  SELECT
    operations_type.description AS operations_type,
    ws_limit
  FROM reference.operations_limit_ws
  JOIN reference.operations_type ON operations_limit_ws.fk_operations_id = operations_type.id;
$$;


--
-- TOC entry 1738 (class 1255 OID 30979)
-- Name: sp_build_view_soil_type_geotechnical_properties(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_soil_type_geotechnical_properties() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_soil_type_geotechnical_properties AS 
  SELECT
    soil_type.description AS soil_type,
    drained_soil_friction_angle,
    relative_soil_density,
    buoyant_unit_weight_of_soil,
    undrained_soil_shear_strength_constant_term,
    undrained_soil_shear_strength_depth_dependent_term,
    effective_drained_cohesion,
    seafloor_friction_coefficient,
    soil_sensitivity,
    rock_compressive_strength
  FROM reference.soil_type_geotechnical_properties
  JOIN reference.soil_type ON soil_type_geotechnical_properties.fk_soil_type_id = soil_type.id;
$$;


--
-- TOC entry 1724 (class 1255 OID 30980)
-- Name: sp_build_view_vehicle_helicopter(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_vehicle_helicopter() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_vehicle_helicopter AS 
 SELECT
    vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    vehicle_shared.consumption,
    vehicle_shared.transit_speed,
    deck_space,
    max_deck_load_pressure,
    max_cargo_mass,
    crane_max_load_mass,
    external_personel,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM reference.vehicle_helicopter
   JOIN reference.vehicle_shared ON vehicle_helicopter.fk_vehicle_id = vehicle_shared.fk_vehicle_id
   JOIN reference.vehicle ON vehicle_shared.fk_vehicle_id = vehicle.id;
$$;


--
-- TOC entry 1740 (class 1255 OID 30981)
-- Name: sp_build_view_vehicle_vessel_ahts(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_vehicle_vessel_ahts() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_vehicle_vessel_ahts AS 
 SELECT
    vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    beam,
    max_draft,
    vehicle_shared.consumption,
    consumption_towing,
    vehicle_shared.transit_speed,
    deck_space,
    max_deck_load_pressure,
    max_cargo_mass,
    crane_max_load_mass,
    bollard_pull,
    anchor_handling_drum_capacity,
    anchor_handling_winch_rated_pull,
    external_personel,
    towing_max_hs,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM reference.vehicle_vessel_anchor_handling
   JOIN reference.vehicle_shared ON vehicle_vessel_anchor_handling.fk_vehicle_id = vehicle_shared.fk_vehicle_id
   JOIN reference.vehicle ON vehicle_shared.fk_vehicle_id = vehicle.id
   JOIN reference.vehicle_type ON vehicle_vessel_anchor_handling.fk_vehicle_type_id = vehicle_type.id
   WHERE vehicle_type.description::text = 'anchor handling tug supply vessel'::text;
$$;


--
-- TOC entry 1741 (class 1255 OID 30982)
-- Name: sp_build_view_vehicle_vessel_barge(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_vehicle_vessel_barge() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_vehicle_vessel_barge AS 
 SELECT
    vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    beam,
    max_draft,
    vehicle_shared.consumption,
    vehicle_shared.transit_speed,
    deck_space,
    max_deck_load_pressure,
    max_cargo_mass,
    crane_max_load_mass,
    dynamic_positioning_capabilities,
    external_personel,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM reference.vehicle_vessel_cargo
   JOIN reference.vehicle_shared ON vehicle_vessel_cargo.fk_vehicle_id = vehicle_shared.fk_vehicle_id
   JOIN reference.vehicle ON vehicle_shared.fk_vehicle_id = vehicle.id
   JOIN reference.vehicle_type ON vehicle_vessel_cargo.fk_vehicle_type_id = vehicle_type.id
   WHERE vehicle_type.description::text = 'barge'::text;
$$;


--
-- TOC entry 1742 (class 1255 OID 30983)
-- Name: sp_build_view_vehicle_vessel_clb(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_vehicle_vessel_clb() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_vehicle_vessel_clb AS 
 SELECT
    vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    beam,
    max_draft,
    vehicle_shared.consumption,
    vehicle_shared.transit_speed,
    deck_space,
    max_deck_load_pressure,
    max_cargo_mass,
    crane_max_load_mass,
    number_turntables,
    turntable_max_load_mass,
    turntable_inner_diameter,
    cable_splice_capabilities,
    dynamic_positioning_capabilities,
    external_personel,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM reference.vehicle_vessel_cable_laying
   JOIN reference.vehicle_shared ON vehicle_vessel_cable_laying.fk_vehicle_id = vehicle_shared.fk_vehicle_id
   JOIN reference.vehicle ON vehicle_shared.fk_vehicle_id = vehicle.id
   JOIN reference.vehicle_type ON vehicle_vessel_cable_laying.fk_vehicle_type_id = vehicle_type.id
   WHERE vehicle_type.description::text = 'cable laying barge'::text;
$$;


--
-- TOC entry 1743 (class 1255 OID 30984)
-- Name: sp_build_view_vehicle_vessel_clv(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_vehicle_vessel_clv() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_vehicle_vessel_clv AS 
 SELECT
    vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    beam,
    max_draft,
    vehicle_shared.consumption,
    vehicle_shared.transit_speed,
    deck_space,
    max_deck_load_pressure,
    max_cargo_mass,
    crane_max_load_mass,
    bollard_pull,
    number_turntables,
    turntable_max_load_mass,
    turntable_inner_diameter,
    cable_splice_capabilities,
    dynamic_positioning_capabilities,
    external_personel,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM reference.vehicle_vessel_cable_laying
   JOIN reference.vehicle_shared ON vehicle_vessel_cable_laying.fk_vehicle_id = vehicle_shared.fk_vehicle_id
   JOIN reference.vehicle ON vehicle_shared.fk_vehicle_id = vehicle.id
   JOIN reference.vehicle_type ON vehicle_vessel_cable_laying.fk_vehicle_type_id = vehicle_type.id
   WHERE vehicle_type.description::text = 'cable laying vessel'::text;
$$;


--
-- TOC entry 1744 (class 1255 OID 30985)
-- Name: sp_build_view_vehicle_vessel_crane_barge(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_vehicle_vessel_crane_barge() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_vehicle_vessel_crane_barge AS 
 SELECT
    vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    beam,
    max_draft,
    vehicle_shared.consumption,
    vehicle_shared.transit_speed,
    deck_space,
    max_deck_load_pressure,
    max_cargo_mass,
    crane_max_load_mass,
    dynamic_positioning_capabilities,
    external_personel,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM reference.vehicle_vessel_cargo
   JOIN reference.vehicle_shared ON vehicle_vessel_cargo.fk_vehicle_id = vehicle_shared.fk_vehicle_id
   JOIN reference.vehicle ON vehicle_shared.fk_vehicle_id = vehicle.id
   JOIN reference.vehicle_type ON vehicle_vessel_cargo.fk_vehicle_type_id = vehicle_type.id
   WHERE vehicle_type.description::text = 'crane barge'::text;
$$;


--
-- TOC entry 1745 (class 1255 OID 30986)
-- Name: sp_build_view_vehicle_vessel_crane_vessel(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_vehicle_vessel_crane_vessel() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_vehicle_vessel_crane_vessel AS 
 SELECT
    vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    beam,
    max_draft,
    vehicle_shared.consumption,
    vehicle_shared.transit_speed,
    deck_space,
    max_deck_load_pressure,
    max_cargo_mass,
    crane_max_load_mass,
    dynamic_positioning_capabilities,
    external_personel,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM reference.vehicle_vessel_cargo
   JOIN reference.vehicle_shared ON vehicle_vessel_cargo.fk_vehicle_id = vehicle_shared.fk_vehicle_id
   JOIN reference.vehicle ON vehicle_shared.fk_vehicle_id = vehicle.id
   JOIN reference.vehicle_type ON vehicle_vessel_cargo.fk_vehicle_type_id = vehicle_type.id
   WHERE vehicle_type.description::text = 'crane vessel'::text;
$$;


--
-- TOC entry 1746 (class 1255 OID 30987)
-- Name: sp_build_view_vehicle_vessel_csv(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_vehicle_vessel_csv() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_vehicle_vessel_csv AS 
 SELECT
    vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    beam,
    max_draft,
    vehicle_shared.consumption,
    vehicle_shared.transit_speed,
    deck_space,
    max_deck_load_pressure,
    max_cargo_mass,
    crane_max_load_mass,
    dynamic_positioning_capabilities,
    external_personel,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM reference.vehicle_vessel_cargo
   JOIN reference.vehicle_shared ON vehicle_vessel_cargo.fk_vehicle_id = vehicle_shared.fk_vehicle_id
   JOIN reference.vehicle ON vehicle_shared.fk_vehicle_id = vehicle.id
   JOIN reference.vehicle_type ON vehicle_vessel_cargo.fk_vehicle_type_id = vehicle_type.id
   WHERE vehicle_type.description::text = 'construction support vessel'::text;
$$;


--
-- TOC entry 1747 (class 1255 OID 30988)
-- Name: sp_build_view_vehicle_vessel_ctv(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_vehicle_vessel_ctv() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_vehicle_vessel_ctv AS 
 SELECT
    vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    beam,
    max_draft,
    vehicle_shared.consumption,
    vehicle_shared.transit_speed,
    deck_space,
    max_deck_load_pressure,
    max_cargo_mass,
    crane_max_load_mass,
    dynamic_positioning_capabilities,
    external_personel,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM reference.vehicle_vessel_cargo
   JOIN reference.vehicle_shared ON vehicle_vessel_cargo.fk_vehicle_id = vehicle_shared.fk_vehicle_id
   JOIN reference.vehicle ON vehicle_shared.fk_vehicle_id = vehicle.id
   JOIN reference.vehicle_type ON vehicle_vessel_cargo.fk_vehicle_type_id = vehicle_type.id
   WHERE vehicle_type.description::text = 'crew transfer vessel'::text;
$$;


--
-- TOC entry 1748 (class 1255 OID 30989)
-- Name: sp_build_view_vehicle_vessel_jackup_barge(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_vehicle_vessel_jackup_barge() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_vehicle_vessel_jackup_barge AS 
 SELECT
    vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    beam,
    max_draft,
    vehicle_shared.consumption,
    vehicle_shared.transit_speed,
    deck_space,
    max_deck_load_pressure,
    max_cargo_mass,
    crane_max_load_mass,
    dynamic_positioning_capabilities,
    external_personel,
    jackup_max_water_depth,
    jackup_speed_down,
    jackup_max_payload_mass,
    jacking_max_hs,
    jacking_max_tp,
    jacking_max_cs,
    jacking_max_ws,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM reference.vehicle_vessel_jackup
   JOIN reference.vehicle_shared ON vehicle_vessel_jackup.fk_vehicle_id = vehicle_shared.fk_vehicle_id
   JOIN reference.vehicle ON vehicle_shared.fk_vehicle_id = vehicle.id
   JOIN reference.vehicle_type ON vehicle_vessel_jackup.fk_vehicle_type_id = vehicle_type.id
   WHERE vehicle_type.description::text = 'jackup barge'::text;
$$;


--
-- TOC entry 1749 (class 1255 OID 30990)
-- Name: sp_build_view_vehicle_vessel_jackup_vessel(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_vehicle_vessel_jackup_vessel() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_vehicle_vessel_jackup_vessel AS 
 SELECT
    vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    beam,
    max_draft,
    vehicle_shared.consumption,
    vehicle_shared.transit_speed,
    deck_space,
    max_deck_load_pressure,
    max_cargo_mass,
    crane_max_load_mass,
    dynamic_positioning_capabilities,
    external_personel,
    jackup_max_water_depth,
    jackup_speed_down,
    jackup_max_payload_mass,
    jacking_max_hs,
    jacking_max_tp,
    jacking_max_cs,
    jacking_max_ws,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM reference.vehicle_vessel_jackup
   JOIN reference.vehicle_shared ON vehicle_vessel_jackup.fk_vehicle_id = vehicle_shared.fk_vehicle_id
   JOIN reference.vehicle ON vehicle_shared.fk_vehicle_id = vehicle.id
   JOIN reference.vehicle_type ON vehicle_vessel_jackup.fk_vehicle_type_id = vehicle_type.id
   WHERE vehicle_type.description::text = 'jackup vessel'::text;
$$;


--
-- TOC entry 1750 (class 1255 OID 30991)
-- Name: sp_build_view_vehicle_vessel_multicat(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_vehicle_vessel_multicat() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_vehicle_vessel_multicat AS 
 SELECT
    vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    beam,
    max_draft,
    vehicle_shared.consumption,
    consumption_towing,
    vehicle_shared.transit_speed,
    deck_space,
    max_deck_load_pressure,
    max_cargo_mass,
    crane_max_load_mass,
    bollard_pull,
    anchor_handling_drum_capacity,
    anchor_handling_winch_rated_pull,
    external_personel,
    towing_max_hs,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM reference.vehicle_vessel_anchor_handling
   JOIN reference.vehicle_shared ON vehicle_vessel_anchor_handling.fk_vehicle_id = vehicle_shared.fk_vehicle_id
   JOIN reference.vehicle ON vehicle_shared.fk_vehicle_id = vehicle.id
   JOIN reference.vehicle_type ON vehicle_vessel_anchor_handling.fk_vehicle_type_id = vehicle_type.id
   WHERE vehicle_type.description::text = 'multicat'::text;
$$;


--
-- TOC entry 1751 (class 1255 OID 30992)
-- Name: sp_build_view_vehicle_vessel_tugboat(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_view_vehicle_vessel_tugboat() RETURNS void
    LANGUAGE sql
    AS $$
CREATE OR REPLACE VIEW reference.view_vehicle_vessel_tugboat AS 
 SELECT
    vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    beam,
    max_draft,
    vehicle_shared.consumption,
    consumption_towing,
    vehicle_shared.transit_speed,
    bollard_pull,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM reference.vehicle_vessel_tugboat
   JOIN reference.vehicle_shared ON vehicle_vessel_tugboat.fk_vehicle_id = vehicle_shared.fk_vehicle_id
   JOIN reference.vehicle ON vehicle_shared.fk_vehicle_id = vehicle.id;
$$;


--
-- TOC entry 1739 (class 1255 OID 30993)
-- Name: sp_build_views(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_build_views() RETURNS void
    LANGUAGE sql
    AS $$
SELECT reference.sp_build_view_component_cable_dynamic();
SELECT reference.sp_build_view_component_cable_static();
SELECT reference.sp_build_view_component_collection_point();
SELECT reference.sp_build_view_component_connector_drymate();
SELECT reference.sp_build_view_component_connector_wetmate();
SELECT reference.sp_build_view_component_foundations_anchor();
SELECT reference.sp_build_view_component_foundations_anchor_coefs();
SELECT reference.sp_build_view_component_foundations_pile();
SELECT reference.sp_build_view_component_moorings_chain();
SELECT reference.sp_build_view_component_moorings_forerunner();
SELECT reference.sp_build_view_component_moorings_rope();
SELECT reference.sp_build_view_component_moorings_shackle();
SELECT reference.sp_build_view_component_moorings_swivel();
SELECT reference.sp_build_view_component_transformer();
SELECT reference.sp_build_view_operations_limit_hs();
SELECT reference.sp_build_view_operations_limit_tp();
SELECT reference.sp_build_view_operations_limit_ws();
SELECT reference.sp_build_view_operations_limit_cs();
SELECT reference.sp_build_view_soil_type_geotechnical_properties();
SELECT reference.sp_build_view_vehicle_helicopter();
SELECT reference.sp_build_view_vehicle_vessel_ahts();
SELECT reference.sp_build_view_vehicle_vessel_barge();
SELECT reference.sp_build_view_vehicle_vessel_clb();
SELECT reference.sp_build_view_vehicle_vessel_clv();
SELECT reference.sp_build_view_vehicle_vessel_crane_barge();
SELECT reference.sp_build_view_vehicle_vessel_crane_vessel();
SELECT reference.sp_build_view_vehicle_vessel_csv();
SELECT reference.sp_build_view_vehicle_vessel_ctv();
SELECT reference.sp_build_view_vehicle_vessel_jackup_barge();
SELECT reference.sp_build_view_vehicle_vessel_jackup_vessel();
SELECT reference.sp_build_view_vehicle_vessel_multicat();
SELECT reference.sp_build_view_vehicle_vessel_tugboat();
$$;


--
-- TOC entry 1752 (class 1255 OID 30994)
-- Name: sp_drop_views(); Type: FUNCTION; Schema: reference; Owner: -
--

CREATE FUNCTION reference.sp_drop_views() RETURNS void
    LANGUAGE sql
    AS $$
DROP VIEW reference.view_component_cable_dynamic;
DROP VIEW reference.view_component_cable_static;
DROP VIEW reference.view_component_collection_point;
DROP VIEW reference.view_component_connector_drymate;
DROP VIEW reference.view_component_connector_wetmate;
DROP VIEW reference.view_component_foundations_anchor;
DROP VIEW reference.view_component_foundations_anchor_coefs;
DROP VIEW reference.view_component_foundations_pile;
DROP VIEW reference.view_component_moorings_chain;
DROP VIEW reference.view_component_moorings_forerunner;
DROP VIEW reference.view_component_moorings_rope;
DROP VIEW reference.view_component_moorings_shackle;
DROP VIEW reference.view_component_moorings_swivel;
DROP VIEW reference.view_component_transformer;
DROP VIEW reference.view_operations_limit_hs;
DROP VIEW reference.view_operations_limit_tp;
DROP VIEW reference.view_operations_limit_ws;
DROP VIEW reference.view_operations_limit_cs;
DROP VIEW reference.view_soil_type_geotechnical_properties;
DROP VIEW reference.view_vehicle_helicopter;
DROP VIEW reference.view_vehicle_vessel_ahts;
DROP VIEW reference.view_vehicle_vessel_barge;
DROP VIEW reference.view_vehicle_vessel_clb;
DROP VIEW reference.view_vehicle_vessel_clv;
DROP VIEW reference.view_vehicle_vessel_crane_barge;
DROP VIEW reference.view_vehicle_vessel_crane_vessel;
DROP VIEW reference.view_vehicle_vessel_csv;
DROP VIEW reference.view_vehicle_vessel_ctv;
DROP VIEW reference.view_vehicle_vessel_jackup_barge;
DROP VIEW reference.view_vehicle_vessel_jackup_vessel;
DROP VIEW reference.view_vehicle_vessel_multicat;
DROP VIEW reference.view_vehicle_vessel_tugboat;
$$;


SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 216 (class 1259 OID 30995)
-- Name: bathymetry; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.bathymetry (
    id bigint NOT NULL,
    fk_site_id smallint,
    utm_point public.geometry,
    depth double precision,
    mannings_no double precision
);


--
-- TOC entry 217 (class 1259 OID 31001)
-- Name: bathymetry_layer; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.bathymetry_layer (
    id bigint NOT NULL,
    fk_bathymetry_id bigint,
    fk_soil_type_id integer,
    layer_order smallint,
    initial_depth double precision
);


--
-- TOC entry 218 (class 1259 OID 31004)
-- Name: cable_corridor_bathymetry; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.cable_corridor_bathymetry (
    id bigint NOT NULL,
    fk_site_id integer,
    utm_point public.geometry,
    depth double precision
);


--
-- TOC entry 219 (class 1259 OID 31010)
-- Name: cable_corridor_bathymetry_layer; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.cable_corridor_bathymetry_layer (
    id bigint NOT NULL,
    fk_bathymetry_id bigint,
    fk_soil_type_id integer,
    layer_order smallint,
    initial_depth double precision
);


--
-- TOC entry 220 (class 1259 OID 31013)
-- Name: cable_corridor_constraint; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.cable_corridor_constraint (
    id integer NOT NULL,
    fk_site_id integer,
    description text,
    boundary public.geometry(Polygon)
);


--
-- TOC entry 221 (class 1259 OID 31019)
-- Name: constraint; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter."constraint" (
    id integer NOT NULL,
    fk_site_id integer,
    description text,
    boundary public.geometry(Polygon)
);


--
-- TOC entry 222 (class 1259 OID 31025)
-- Name: device_floating; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.device_floating (
    id integer NOT NULL,
    fk_device_id integer,
    draft double precision,
    maximum_displacement double precision[],
    depth_variation_permitted boolean,
    fairlead_locations double precision[],
    umbilical_connection_point double precision[],
    prescribed_mooring_system character varying(50),
    prescribed_umbilical_type character varying(50)
);


--
-- TOC entry 223 (class 1259 OID 31031)
-- Name: device_shared; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.device_shared (
    id integer NOT NULL,
    fk_device_id integer,
    height double precision,
    width double precision,
    length double precision,
    displaced_volume double precision,
    wet_frontal_area double precision,
    dry_frontal_area double precision,
    wet_beam_area double precision,
    dry_beam_area double precision,
    centre_of_gravity double precision[],
    mass double precision,
    profile character varying(12),
    surface_roughness double precision,
    yaw double precision,
    prescribed_footprint_radius double precision,
    footprint_corner_coords double precision[],
    installation_depth_max double precision,
    installation_depth_min double precision,
    minimum_distance_x double precision,
    minimum_distance_y double precision,
    prescribed_foundation_system character varying(50),
    foundation_locations double precision[],
    rated_power double precision,
    rated_voltage_u0 double precision,
    connector_type character varying(8),
    constant_power_factor double precision,
    variable_power_factor double precision[],
    assembly_duration double precision,
    connect_duration double precision,
    disconnect_duration double precision,
    load_out_method character varying(10),
    transportation_method character varying(4),
    bollard_pull double precision,
    two_stage_assembly boolean,
    cost double precision
);


--
-- TOC entry 224 (class 1259 OID 31037)
-- Name: device_tidal; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.device_tidal (
    id integer NOT NULL,
    fk_device_id integer,
    cut_in_velocity double precision,
    cut_out_velocity double precision,
    hub_height double precision,
    turbine_diameter double precision,
    two_ways_flow boolean,
    turbine_interdistance double precision
);


--
-- TOC entry 225 (class 1259 OID 31040)
-- Name: device_tidal_power_performance; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.device_tidal_power_performance (
    id integer NOT NULL,
    fk_device_id integer,
    velocity double precision NOT NULL,
    thrust_coefficient double precision,
    power_coefficient double precision
);


--
-- TOC entry 226 (class 1259 OID 31043)
-- Name: device_wave; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.device_wave (
    id integer NOT NULL,
    fk_device_id integer,
    wave_data_directory character varying(200)
);


--
-- TOC entry 227 (class 1259 OID 31046)
-- Name: lease_area; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.lease_area (
    id integer NOT NULL,
    fk_site_id integer,
    blockage_ratio double precision,
    tidal_occurrence_point public.geometry(Point),
    wave_spectrum_type character varying(22),
    wave_spectrum_gamma double precision,
    wave_spectrum_spreading_parameter double precision,
    surface_current_flow_velocity double precision,
    current_flow_direction double precision,
    moor_found_current_profile character varying(20),
    significant_wave_height double precision,
    peak_wave_period double precision,
    predominant_wave_direction double precision,
    jonswap_gamma double precision,
    mean_wind_speed double precision,
    predominant_wind_direction double precision,
    max_wind_gust_speed double precision,
    wind_gust_direction double precision,
    water_level_max double precision,
    water_level_min double precision,
    soil_sensitivity double precision,
    has_helipad boolean
);


--
-- TOC entry 228 (class 1259 OID 31052)
-- Name: site_infrastructure; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.site_infrastructure (
    id integer NOT NULL,
    fk_site_id integer,
    has_helipad boolean
);


--
-- TOC entry 229 (class 1259 OID 31055)
-- Name: sub_systems_access; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.sub_systems_access (
    id integer NOT NULL,
    fk_sub_system_id integer,
    operation_duration double precision,
    max_hs double precision,
    max_tp double precision,
    max_ws double precision,
    max_cs double precision
);


--
-- TOC entry 230 (class 1259 OID 31058)
-- Name: sub_systems_economic; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.sub_systems_economic (
    id integer NOT NULL,
    fk_sub_system_id integer,
    cost double precision,
    failure_rate double precision
);


--
-- TOC entry 231 (class 1259 OID 31061)
-- Name: sub_systems_inspection; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.sub_systems_inspection (
    id integer NOT NULL,
    fk_sub_system_id integer,
    operation_duration double precision,
    crew_lead_time double precision,
    other_lead_time double precision,
    n_specialists integer,
    n_technicians integer,
    max_hs double precision,
    max_tp double precision,
    max_ws double precision,
    max_cs double precision
);


--
-- TOC entry 232 (class 1259 OID 31064)
-- Name: sub_systems_install; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.sub_systems_install (
    id integer NOT NULL,
    fk_sub_system_id integer,
    length double precision,
    width double precision,
    height double precision,
    dry_mass double precision,
    max_hs double precision,
    max_tp double precision,
    max_ws double precision,
    max_cs double precision
);


--
-- TOC entry 233 (class 1259 OID 31067)
-- Name: sub_systems_maintenance; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.sub_systems_maintenance (
    id integer NOT NULL,
    fk_sub_system_id integer,
    operation_duration double precision,
    interruptible boolean,
    parts_length double precision,
    parts_width double precision,
    parts_height double precision,
    parts_dry_mass double precision,
    assembly_lead_time double precision,
    crew_lead_time double precision,
    other_lead_time double precision,
    n_specialists integer,
    n_technicians integer,
    max_hs double precision,
    max_tp double precision,
    max_ws double precision,
    max_cs double precision
);


--
-- TOC entry 234 (class 1259 OID 31070)
-- Name: sub_systems_operation_weightings; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.sub_systems_operation_weightings (
    id integer NOT NULL,
    fk_sub_system_id integer,
    maintenance double precision,
    replacement double precision,
    inspection double precision
);


--
-- TOC entry 235 (class 1259 OID 31073)
-- Name: sub_systems_replace; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.sub_systems_replace (
    id integer NOT NULL,
    fk_sub_system_id integer,
    operation_duration double precision,
    interruptible boolean,
    assembly_lead_time double precision,
    crew_lead_time double precision,
    other_lead_time double precision,
    n_specialists integer,
    n_technicians integer
);


--
-- TOC entry 236 (class 1259 OID 31076)
-- Name: time_series_energy_tidal; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.time_series_energy_tidal (
    id bigint NOT NULL,
    fk_bathymetry_id bigint,
    measure_date date,
    measure_time time(6) without time zone,
    u double precision,
    v double precision,
    turbulence_intensity double precision,
    ssh double precision
);


--
-- TOC entry 237 (class 1259 OID 31079)
-- Name: time_series_energy_wave; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.time_series_energy_wave (
    id bigint NOT NULL,
    fk_site_id integer,
    measure_date date,
    measure_time time(6) without time zone,
    height double precision,
    te double precision,
    direction double precision
);


--
-- TOC entry 238 (class 1259 OID 31082)
-- Name: time_series_om_tidal; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.time_series_om_tidal (
    id bigint NOT NULL,
    fk_site_id bigint,
    measure_date date,
    measure_time time(6) without time zone,
    current_speed double precision
);


--
-- TOC entry 239 (class 1259 OID 31085)
-- Name: time_series_om_wave; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.time_series_om_wave (
    id bigint NOT NULL,
    fk_site_id integer,
    measure_date date,
    measure_time time(6) without time zone,
    period_tp double precision,
    height_hs double precision
);


--
-- TOC entry 240 (class 1259 OID 31088)
-- Name: time_series_om_wind; Type: TABLE; Schema: filter; Owner: -
--

CREATE TABLE filter.time_series_om_wind (
    id bigint NOT NULL,
    fk_site_id integer,
    measure_date date,
    measure_time time(6) without time zone,
    wind_speed double precision
);


--
-- TOC entry 241 (class 1259 OID 31091)
-- Name: soil_type; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.soil_type (
    id integer NOT NULL,
    description character varying(40)
);


--
-- TOC entry 242 (class 1259 OID 31094)
-- Name: view_bathymetry_layer; Type: VIEW; Schema: filter; Owner: -
--

CREATE VIEW filter.view_bathymetry_layer AS
 SELECT bathymetry.utm_point,
    bathymetry.depth,
    bathymetry.mannings_no,
    bathymetry_layer.layer_order,
    bathymetry_layer.initial_depth,
    soil_type.description AS sediment_type
   FROM ((filter.bathymetry
     LEFT JOIN filter.bathymetry_layer ON ((bathymetry.id = bathymetry_layer.fk_bathymetry_id)))
     LEFT JOIN reference.soil_type ON ((bathymetry_layer.fk_soil_type_id = soil_type.id)));


--
-- TOC entry 243 (class 1259 OID 31098)
-- Name: view_cable_corridor_bathymetry_layer; Type: VIEW; Schema: filter; Owner: -
--

CREATE VIEW filter.view_cable_corridor_bathymetry_layer AS
 SELECT cable_corridor_bathymetry.utm_point,
    cable_corridor_bathymetry.depth,
    cable_corridor_bathymetry_layer.layer_order,
    cable_corridor_bathymetry_layer.initial_depth,
    soil_type.description AS sediment_type
   FROM ((filter.cable_corridor_bathymetry
     LEFT JOIN filter.cable_corridor_bathymetry_layer ON ((cable_corridor_bathymetry.id = cable_corridor_bathymetry_layer.fk_bathymetry_id)))
     LEFT JOIN reference.soil_type ON ((cable_corridor_bathymetry_layer.fk_soil_type_id = soil_type.id)));


--
-- TOC entry 244 (class 1259 OID 31102)
-- Name: sub_systems; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.sub_systems (
    id integer NOT NULL,
    fk_device_id integer,
    sub_system character varying(20),
    CONSTRAINT sub_systems_sub_system_check CHECK (((sub_system)::text = ANY (ARRAY[('Control System'::character varying)::text, ('Prime Mover'::character varying)::text, ('PTO'::character varying)::text, ('Support Structure'::character varying)::text])))
);


--
-- TOC entry 245 (class 1259 OID 31106)
-- Name: view_control_system_access; Type: VIEW; Schema: filter; Owner: -
--

CREATE VIEW filter.view_control_system_access AS
 SELECT sub_systems.sub_system,
    sub_systems_access.operation_duration,
    sub_systems_access.max_hs,
    sub_systems_access.max_tp,
    sub_systems_access.max_ws,
    sub_systems_access.max_cs
   FROM (filter.sub_systems_access
     JOIN project.sub_systems ON ((sub_systems_access.fk_sub_system_id = sub_systems.id)))
  WHERE ((sub_systems.sub_system)::text = 'Control System'::text);


--
-- TOC entry 246 (class 1259 OID 31110)
-- Name: view_control_system_economic; Type: VIEW; Schema: filter; Owner: -
--

CREATE VIEW filter.view_control_system_economic AS
 SELECT sub_systems.sub_system,
    sub_systems_economic.cost,
    sub_systems_economic.failure_rate
   FROM (filter.sub_systems_economic
     JOIN project.sub_systems ON ((sub_systems_economic.fk_sub_system_id = sub_systems.id)))
  WHERE ((sub_systems.sub_system)::text = 'Control System'::text);


--
-- TOC entry 247 (class 1259 OID 31114)
-- Name: view_control_system_inspection; Type: VIEW; Schema: filter; Owner: -
--

CREATE VIEW filter.view_control_system_inspection AS
 SELECT sub_systems.sub_system,
    sub_systems_inspection.operation_duration,
    sub_systems_inspection.crew_lead_time,
    sub_systems_inspection.other_lead_time,
    sub_systems_inspection.n_specialists,
    sub_systems_inspection.n_technicians,
    sub_systems_inspection.max_hs,
    sub_systems_inspection.max_tp,
    sub_systems_inspection.max_ws,
    sub_systems_inspection.max_cs
   FROM (filter.sub_systems_inspection
     JOIN project.sub_systems ON ((sub_systems_inspection.fk_sub_system_id = sub_systems.id)))
  WHERE ((sub_systems.sub_system)::text = 'Control System'::text);


--
-- TOC entry 248 (class 1259 OID 31118)
-- Name: view_control_system_installation; Type: VIEW; Schema: filter; Owner: -
--

CREATE VIEW filter.view_control_system_installation AS
 SELECT sub_systems.sub_system,
    sub_systems_install.length,
    sub_systems_install.width,
    sub_systems_install.height,
    sub_systems_install.dry_mass,
    sub_systems_install.max_hs,
    sub_systems_install.max_tp,
    sub_systems_install.max_ws,
    sub_systems_install.max_cs
   FROM (filter.sub_systems_install
     JOIN project.sub_systems ON ((sub_systems_install.fk_sub_system_id = sub_systems.id)))
  WHERE ((sub_systems.sub_system)::text = 'Control System'::text);


--
-- TOC entry 249 (class 1259 OID 31122)
-- Name: view_control_system_maintenance; Type: VIEW; Schema: filter; Owner: -
--

CREATE VIEW filter.view_control_system_maintenance AS
 SELECT sub_systems.sub_system,
    sub_systems_maintenance.operation_duration,
    sub_systems_maintenance.interruptible,
    sub_systems_maintenance.parts_length,
    sub_systems_maintenance.parts_width,
    sub_systems_maintenance.parts_height,
    sub_systems_maintenance.parts_dry_mass,
    sub_systems_maintenance.assembly_lead_time,
    sub_systems_maintenance.crew_lead_time,
    sub_systems_maintenance.other_lead_time,
    sub_systems_maintenance.n_specialists,
    sub_systems_maintenance.n_technicians,
    sub_systems_maintenance.max_hs,
    sub_systems_maintenance.max_tp,
    sub_systems_maintenance.max_ws,
    sub_systems_maintenance.max_cs
   FROM (filter.sub_systems_maintenance
     JOIN project.sub_systems ON ((sub_systems_maintenance.fk_sub_system_id = sub_systems.id)))
  WHERE ((sub_systems.sub_system)::text = 'Control System'::text);


--
-- TOC entry 250 (class 1259 OID 31127)
-- Name: view_control_system_operation_weightings; Type: VIEW; Schema: filter; Owner: -
--

CREATE VIEW filter.view_control_system_operation_weightings AS
 SELECT sub_systems.sub_system,
    sub_systems_operation_weightings.maintenance,
    sub_systems_operation_weightings.replacement,
    sub_systems_operation_weightings.inspection
   FROM (filter.sub_systems_operation_weightings
     JOIN project.sub_systems ON ((sub_systems_operation_weightings.fk_sub_system_id = sub_systems.id)))
  WHERE ((sub_systems.sub_system)::text = 'Control System'::text);


--
-- TOC entry 251 (class 1259 OID 31131)
-- Name: view_control_system_replace; Type: VIEW; Schema: filter; Owner: -
--

CREATE VIEW filter.view_control_system_replace AS
 SELECT sub_systems.sub_system,
    sub_systems_replace.operation_duration,
    sub_systems_replace.interruptible,
    sub_systems_replace.assembly_lead_time,
    sub_systems_replace.crew_lead_time,
    sub_systems_replace.other_lead_time,
    sub_systems_replace.n_specialists,
    sub_systems_replace.n_technicians
   FROM (filter.sub_systems_replace
     JOIN project.sub_systems ON ((sub_systems_replace.fk_sub_system_id = sub_systems.id)))
  WHERE ((sub_systems.sub_system)::text = 'Control System'::text);


--
-- TOC entry 252 (class 1259 OID 31135)
-- Name: view_sub_systems_access; Type: VIEW; Schema: filter; Owner: -
--

CREATE VIEW filter.view_sub_systems_access AS
 SELECT sub_systems.sub_system,
    sub_systems_access.operation_duration,
    sub_systems_access.max_hs,
    sub_systems_access.max_tp,
    sub_systems_access.max_ws,
    sub_systems_access.max_cs
   FROM (filter.sub_systems_access
     JOIN project.sub_systems ON ((sub_systems_access.fk_sub_system_id = sub_systems.id)))
  WHERE ((sub_systems.sub_system)::text = ANY (ARRAY[('Prime Mover'::character varying)::text, ('PTO'::character varying)::text, ('Support Structure'::character varying)::text]));


--
-- TOC entry 253 (class 1259 OID 31139)
-- Name: view_sub_systems_economic; Type: VIEW; Schema: filter; Owner: -
--

CREATE VIEW filter.view_sub_systems_economic AS
 SELECT sub_systems.sub_system,
    sub_systems_economic.cost,
    sub_systems_economic.failure_rate
   FROM (filter.sub_systems_economic
     JOIN project.sub_systems ON ((sub_systems_economic.fk_sub_system_id = sub_systems.id)))
  WHERE ((sub_systems.sub_system)::text = ANY (ARRAY[('Prime Mover'::character varying)::text, ('PTO'::character varying)::text, ('Support Structure'::character varying)::text]));


--
-- TOC entry 254 (class 1259 OID 31143)
-- Name: view_sub_systems_inspection; Type: VIEW; Schema: filter; Owner: -
--

CREATE VIEW filter.view_sub_systems_inspection AS
 SELECT sub_systems.sub_system,
    sub_systems_inspection.operation_duration,
    sub_systems_inspection.crew_lead_time,
    sub_systems_inspection.other_lead_time,
    sub_systems_inspection.n_specialists,
    sub_systems_inspection.n_technicians,
    sub_systems_inspection.max_hs,
    sub_systems_inspection.max_tp,
    sub_systems_inspection.max_ws,
    sub_systems_inspection.max_cs
   FROM (filter.sub_systems_inspection
     JOIN project.sub_systems ON ((sub_systems_inspection.fk_sub_system_id = sub_systems.id)))
  WHERE ((sub_systems.sub_system)::text = ANY (ARRAY[('Prime Mover'::character varying)::text, ('PTO'::character varying)::text, ('Support Structure'::character varying)::text]));


--
-- TOC entry 255 (class 1259 OID 31148)
-- Name: view_sub_systems_installation; Type: VIEW; Schema: filter; Owner: -
--

CREATE VIEW filter.view_sub_systems_installation AS
 SELECT sub_systems.sub_system,
    sub_systems_install.length,
    sub_systems_install.width,
    sub_systems_install.height,
    sub_systems_install.dry_mass,
    sub_systems_install.max_hs,
    sub_systems_install.max_tp,
    sub_systems_install.max_ws,
    sub_systems_install.max_cs
   FROM (filter.sub_systems_install
     JOIN project.sub_systems ON ((sub_systems_install.fk_sub_system_id = sub_systems.id)))
  WHERE ((sub_systems.sub_system)::text = ANY (ARRAY[('Prime Mover'::character varying)::text, ('PTO'::character varying)::text, ('Support Structure'::character varying)::text]));


--
-- TOC entry 256 (class 1259 OID 31152)
-- Name: view_sub_systems_maintenance; Type: VIEW; Schema: filter; Owner: -
--

CREATE VIEW filter.view_sub_systems_maintenance AS
 SELECT sub_systems.sub_system,
    sub_systems_maintenance.operation_duration,
    sub_systems_maintenance.interruptible,
    sub_systems_maintenance.parts_length,
    sub_systems_maintenance.parts_width,
    sub_systems_maintenance.parts_height,
    sub_systems_maintenance.parts_dry_mass,
    sub_systems_maintenance.assembly_lead_time,
    sub_systems_maintenance.crew_lead_time,
    sub_systems_maintenance.other_lead_time,
    sub_systems_maintenance.n_specialists,
    sub_systems_maintenance.n_technicians,
    sub_systems_maintenance.max_hs,
    sub_systems_maintenance.max_tp,
    sub_systems_maintenance.max_ws,
    sub_systems_maintenance.max_cs
   FROM (filter.sub_systems_maintenance
     JOIN project.sub_systems ON ((sub_systems_maintenance.fk_sub_system_id = sub_systems.id)))
  WHERE ((sub_systems.sub_system)::text = ANY (ARRAY[('Prime Mover'::character varying)::text, ('PTO'::character varying)::text, ('Support Structure'::character varying)::text]));


--
-- TOC entry 257 (class 1259 OID 31157)
-- Name: view_sub_systems_operation_weightings; Type: VIEW; Schema: filter; Owner: -
--

CREATE VIEW filter.view_sub_systems_operation_weightings AS
 SELECT sub_systems.sub_system,
    sub_systems_operation_weightings.maintenance,
    sub_systems_operation_weightings.replacement,
    sub_systems_operation_weightings.inspection
   FROM (filter.sub_systems_operation_weightings
     JOIN project.sub_systems ON ((sub_systems_operation_weightings.fk_sub_system_id = sub_systems.id)))
  WHERE ((sub_systems.sub_system)::text = ANY (ARRAY[('Prime Mover'::character varying)::text, ('PTO'::character varying)::text, ('Support Structure'::character varying)::text]));


--
-- TOC entry 258 (class 1259 OID 31161)
-- Name: view_sub_systems_replace; Type: VIEW; Schema: filter; Owner: -
--

CREATE VIEW filter.view_sub_systems_replace AS
 SELECT sub_systems.sub_system,
    sub_systems_replace.operation_duration,
    sub_systems_replace.interruptible,
    sub_systems_replace.assembly_lead_time,
    sub_systems_replace.crew_lead_time,
    sub_systems_replace.other_lead_time,
    sub_systems_replace.n_specialists,
    sub_systems_replace.n_technicians
   FROM (filter.sub_systems_replace
     JOIN project.sub_systems ON ((sub_systems_replace.fk_sub_system_id = sub_systems.id)))
  WHERE ((sub_systems.sub_system)::text = ANY (ARRAY[('Prime Mover'::character varying)::text, ('PTO'::character varying)::text, ('Support Structure'::character varying)::text]));


--
-- TOC entry 259 (class 1259 OID 31166)
-- Name: view_time_series_energy_tidal; Type: VIEW; Schema: filter; Owner: -
--

CREATE VIEW filter.view_time_series_energy_tidal AS
 SELECT bathymetry.utm_point,
    time_series_energy_tidal.measure_date,
    time_series_energy_tidal.measure_time,
    time_series_energy_tidal.u,
    time_series_energy_tidal.v,
    time_series_energy_tidal.turbulence_intensity,
    time_series_energy_tidal.ssh
   FROM (filter.bathymetry
     JOIN filter.time_series_energy_tidal ON ((bathymetry.id = time_series_energy_tidal.fk_bathymetry_id)));


--
-- TOC entry 260 (class 1259 OID 31170)
-- Name: bathymetry; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.bathymetry (
    id bigint NOT NULL,
    fk_site_id smallint,
    utm_point public.geometry,
    depth double precision,
    mannings_no double precision
);


--
-- TOC entry 261 (class 1259 OID 31176)
-- Name: bathymetry_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.bathymetry_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5581 (class 0 OID 0)
-- Dependencies: 261
-- Name: bathymetry_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.bathymetry_id_seq OWNED BY project.bathymetry.id;


--
-- TOC entry 262 (class 1259 OID 31178)
-- Name: bathymetry_layer_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.bathymetry_layer_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 263 (class 1259 OID 31180)
-- Name: bathymetry_layer; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.bathymetry_layer (
    id bigint DEFAULT nextval('project.bathymetry_layer_id_seq'::regclass) NOT NULL,
    fk_bathymetry_id bigint,
    fk_soil_type_id integer,
    layer_order smallint,
    initial_depth double precision
);


--
-- TOC entry 264 (class 1259 OID 31184)
-- Name: cable_corridor_bathymetry; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.cable_corridor_bathymetry (
    id bigint NOT NULL,
    fk_site_id integer,
    utm_point public.geometry,
    depth double precision
);


--
-- TOC entry 265 (class 1259 OID 31190)
-- Name: cable_corridor_bathymetry_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.cable_corridor_bathymetry_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5582 (class 0 OID 0)
-- Dependencies: 265
-- Name: cable_corridor_bathymetry_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.cable_corridor_bathymetry_id_seq OWNED BY project.cable_corridor_bathymetry.id;


--
-- TOC entry 266 (class 1259 OID 31192)
-- Name: cable_corridor_bathymetry_layer; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.cable_corridor_bathymetry_layer (
    id bigint NOT NULL,
    fk_bathymetry_id bigint,
    fk_soil_type_id integer,
    layer_order smallint,
    initial_depth double precision
);


--
-- TOC entry 267 (class 1259 OID 31195)
-- Name: cable_corridor_bathymetry_layer_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.cable_corridor_bathymetry_layer_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5583 (class 0 OID 0)
-- Dependencies: 267
-- Name: cable_corridor_bathymetry_layer_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.cable_corridor_bathymetry_layer_id_seq OWNED BY project.cable_corridor_bathymetry_layer.id;


--
-- TOC entry 268 (class 1259 OID 31197)
-- Name: cable_corridor_constraint; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.cable_corridor_constraint (
    id integer NOT NULL,
    fk_site_id integer,
    description text,
    boundary public.geometry(Polygon)
);


--
-- TOC entry 269 (class 1259 OID 31203)
-- Name: cable_corridor_constraint_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.cable_corridor_constraint_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5584 (class 0 OID 0)
-- Dependencies: 269
-- Name: cable_corridor_constraint_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.cable_corridor_constraint_id_seq OWNED BY project.cable_corridor_constraint.id;


--
-- TOC entry 270 (class 1259 OID 31205)
-- Name: constraint; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project."constraint" (
    id integer NOT NULL,
    fk_site_id integer,
    description text,
    boundary public.geometry(Polygon)
);


--
-- TOC entry 271 (class 1259 OID 31211)
-- Name: constraint_type_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.constraint_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    MAXVALUE 32767
    CACHE 1;


--
-- TOC entry 272 (class 1259 OID 31213)
-- Name: device; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.device (
    id integer NOT NULL,
    description character varying(200),
    device_type character varying(50),
    image bytea,
    CONSTRAINT device_device_type_check CHECK (((device_type)::text = ANY (ARRAY[('Tidal Fixed'::character varying)::text, ('Tidal Floating'::character varying)::text, ('Wave Fixed'::character varying)::text, ('Wave Floating'::character varying)::text])))
);


--
-- TOC entry 273 (class 1259 OID 31220)
-- Name: device_floating; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.device_floating (
    id integer NOT NULL,
    fk_device_id integer,
    draft double precision,
    maximum_displacement double precision[],
    depth_variation_permitted boolean,
    fairlead_locations double precision[],
    umbilical_connection_point double precision[],
    prescribed_mooring_system character varying(50),
    prescribed_umbilical_type character varying(50)
);


--
-- TOC entry 274 (class 1259 OID 31226)
-- Name: device_floating_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.device_floating_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5585 (class 0 OID 0)
-- Dependencies: 274
-- Name: device_floating_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.device_floating_id_seq OWNED BY project.device_floating.id;


--
-- TOC entry 275 (class 1259 OID 31228)
-- Name: device_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.device_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5586 (class 0 OID 0)
-- Dependencies: 275
-- Name: device_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.device_id_seq OWNED BY project.device.id;


--
-- TOC entry 276 (class 1259 OID 31230)
-- Name: device_power_performance_tidal_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.device_power_performance_tidal_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    MAXVALUE 2147483647
    CACHE 1;


--
-- TOC entry 277 (class 1259 OID 31232)
-- Name: device_shared; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.device_shared (
    id integer NOT NULL,
    fk_device_id integer,
    height double precision,
    width double precision,
    length double precision,
    displaced_volume double precision,
    wet_frontal_area double precision,
    dry_frontal_area double precision,
    wet_beam_area double precision,
    dry_beam_area double precision,
    centre_of_gravity double precision[],
    mass double precision,
    profile character varying(12),
    surface_roughness double precision,
    yaw double precision,
    prescribed_footprint_radius double precision,
    footprint_corner_coords double precision[],
    installation_depth_max double precision,
    installation_depth_min double precision,
    minimum_distance_x double precision,
    minimum_distance_y double precision,
    prescribed_foundation_system character varying(50),
    foundation_locations double precision[],
    rated_power double precision,
    rated_voltage_u0 double precision,
    connector_type character varying(8),
    constant_power_factor double precision,
    variable_power_factor double precision[],
    assembly_duration double precision,
    connect_duration double precision,
    disconnect_duration double precision,
    load_out_method character varying(10),
    transportation_method character varying(4),
    bollard_pull double precision,
    two_stage_assembly boolean,
    cost double precision,
    CONSTRAINT device_shared_connector_type_check CHECK (((connector_type)::text = ANY (ARRAY[('Wet-Mate'::character varying)::text, ('Dry-Mate'::character varying)::text]))),
    CONSTRAINT device_shared_load_out_method_check CHECK (((load_out_method)::text = ANY (ARRAY[('Skidded'::character varying)::text, ('Trailer'::character varying)::text, ('Float Away'::character varying)::text, ('Lift Away'::character varying)::text]))),
    CONSTRAINT device_shared_profile_check CHECK (((profile)::text = ANY (ARRAY[('Cylindrical'::character varying)::text, ('Rectangular'::character varying)::text]))),
    CONSTRAINT device_shared_transportation_method_check CHECK (((transportation_method)::text = ANY (ARRAY[('Deck'::character varying)::text, ('Tow'::character varying)::text])))
);


--
-- TOC entry 278 (class 1259 OID 31242)
-- Name: device_shared_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.device_shared_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5587 (class 0 OID 0)
-- Dependencies: 278
-- Name: device_shared_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.device_shared_id_seq OWNED BY project.device_shared.id;


--
-- TOC entry 279 (class 1259 OID 31244)
-- Name: device_tidal; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.device_tidal (
    id integer NOT NULL,
    fk_device_id integer,
    cut_in_velocity double precision,
    cut_out_velocity double precision,
    hub_height double precision,
    turbine_diameter double precision,
    two_ways_flow boolean,
    turbine_interdistance double precision
);


--
-- TOC entry 280 (class 1259 OID 31247)
-- Name: device_tidal_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.device_tidal_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5588 (class 0 OID 0)
-- Dependencies: 280
-- Name: device_tidal_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.device_tidal_id_seq OWNED BY project.device_tidal.id;


--
-- TOC entry 281 (class 1259 OID 31249)
-- Name: device_tidal_power_performance; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.device_tidal_power_performance (
    id integer NOT NULL,
    fk_device_id integer,
    velocity double precision NOT NULL,
    thrust_coefficient double precision,
    power_coefficient double precision
);


--
-- TOC entry 282 (class 1259 OID 31252)
-- Name: device_tidal_power_performance_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.device_tidal_power_performance_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5589 (class 0 OID 0)
-- Dependencies: 282
-- Name: device_tidal_power_performance_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.device_tidal_power_performance_id_seq OWNED BY project.device_tidal_power_performance.id;


--
-- TOC entry 283 (class 1259 OID 31254)
-- Name: device_wave; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.device_wave (
    id integer NOT NULL,
    fk_device_id integer,
    wave_data_directory character varying(200)
);


--
-- TOC entry 284 (class 1259 OID 31257)
-- Name: device_wave_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.device_wave_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5590 (class 0 OID 0)
-- Dependencies: 284
-- Name: device_wave_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.device_wave_id_seq OWNED BY project.device_wave.id;


--
-- TOC entry 285 (class 1259 OID 31259)
-- Name: lease_area; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.lease_area (
    id integer NOT NULL,
    fk_site_id integer,
    blockage_ratio double precision,
    tidal_occurrence_point public.geometry(Point),
    wave_spectrum_type character varying(22),
    wave_spectrum_gamma double precision,
    wave_spectrum_spreading_parameter double precision,
    surface_current_flow_velocity double precision,
    current_flow_direction double precision,
    moor_found_current_profile character varying(20),
    significant_wave_height double precision,
    peak_wave_period double precision,
    predominant_wave_direction double precision,
    jonswap_gamma double precision,
    mean_wind_speed double precision,
    predominant_wind_direction double precision,
    max_wind_gust_speed double precision,
    wind_gust_direction double precision,
    water_level_max double precision,
    water_level_min double precision,
    soil_sensitivity double precision,
    has_helipad boolean,
    CONSTRAINT lease_area_moor_found_current_profile_check CHECK (((moor_found_current_profile)::text = ANY (ARRAY[('Uniform'::character varying)::text, ('1/7 Power Law'::character varying)::text]))),
    CONSTRAINT lease_area_wave_spectrum_type_check CHECK (((wave_spectrum_type)::text = ANY (ARRAY[('Regular'::character varying)::text, ('Pierson-Moskowitz'::character varying)::text, ('JONSWAP'::character varying)::text, ('Bretschneider'::character varying)::text, ('Modified Bretschneider'::character varying)::text])))
);


--
-- TOC entry 286 (class 1259 OID 31267)
-- Name: lease_area_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.lease_area_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5591 (class 0 OID 0)
-- Dependencies: 286
-- Name: lease_area_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.lease_area_id_seq OWNED BY project.lease_area.id;


--
-- TOC entry 287 (class 1259 OID 31269)
-- Name: site; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.site (
    id integer NOT NULL,
    site_name character varying(20),
    lease_area_proj4_string character varying(100),
    site_boundary public.geometry(Polygon,4326),
    lease_boundary public.geometry(Polygon),
    corridor_boundary public.geometry(Polygon),
    cable_landing_location public.geometry(Point)
);


--
-- TOC entry 288 (class 1259 OID 31275)
-- Name: site_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.site_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5592 (class 0 OID 0)
-- Dependencies: 288
-- Name: site_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.site_id_seq OWNED BY project.site.id;


--
-- TOC entry 289 (class 1259 OID 31277)
-- Name: sub_systems_access; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.sub_systems_access (
    id integer NOT NULL,
    fk_sub_system_id integer,
    operation_duration double precision,
    max_hs double precision,
    max_tp double precision,
    max_ws double precision,
    max_cs double precision
);


--
-- TOC entry 290 (class 1259 OID 31280)
-- Name: sub_systems_access_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.sub_systems_access_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5593 (class 0 OID 0)
-- Dependencies: 290
-- Name: sub_systems_access_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.sub_systems_access_id_seq OWNED BY project.sub_systems_access.id;


--
-- TOC entry 291 (class 1259 OID 31282)
-- Name: sub_systems_economic; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.sub_systems_economic (
    id integer NOT NULL,
    fk_sub_system_id integer,
    cost double precision,
    failure_rate double precision
);


--
-- TOC entry 292 (class 1259 OID 31285)
-- Name: sub_systems_economic_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.sub_systems_economic_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5594 (class 0 OID 0)
-- Dependencies: 292
-- Name: sub_systems_economic_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.sub_systems_economic_id_seq OWNED BY project.sub_systems_economic.id;


--
-- TOC entry 293 (class 1259 OID 31287)
-- Name: sub_systems_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.sub_systems_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5595 (class 0 OID 0)
-- Dependencies: 293
-- Name: sub_systems_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.sub_systems_id_seq OWNED BY project.sub_systems.id;


--
-- TOC entry 294 (class 1259 OID 31289)
-- Name: sub_systems_inspection; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.sub_systems_inspection (
    id integer NOT NULL,
    fk_sub_system_id integer,
    operation_duration double precision,
    crew_lead_time double precision,
    other_lead_time double precision,
    n_specialists integer,
    n_technicians integer,
    max_hs double precision,
    max_tp double precision,
    max_ws double precision,
    max_cs double precision
);


--
-- TOC entry 295 (class 1259 OID 31292)
-- Name: sub_systems_inspection_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.sub_systems_inspection_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5596 (class 0 OID 0)
-- Dependencies: 295
-- Name: sub_systems_inspection_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.sub_systems_inspection_id_seq OWNED BY project.sub_systems_inspection.id;


--
-- TOC entry 296 (class 1259 OID 31294)
-- Name: sub_systems_install; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.sub_systems_install (
    id integer NOT NULL,
    fk_sub_system_id integer,
    length double precision,
    width double precision,
    height double precision,
    dry_mass double precision,
    max_hs double precision,
    max_tp double precision,
    max_ws double precision,
    max_cs double precision
);


--
-- TOC entry 297 (class 1259 OID 31297)
-- Name: sub_systems_install_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.sub_systems_install_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5597 (class 0 OID 0)
-- Dependencies: 297
-- Name: sub_systems_install_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.sub_systems_install_id_seq OWNED BY project.sub_systems_install.id;


--
-- TOC entry 298 (class 1259 OID 31299)
-- Name: sub_systems_maintenance; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.sub_systems_maintenance (
    id integer NOT NULL,
    fk_sub_system_id integer,
    operation_duration double precision,
    interruptible boolean,
    parts_length double precision,
    parts_width double precision,
    parts_height double precision,
    parts_dry_mass double precision,
    assembly_lead_time double precision,
    crew_lead_time double precision,
    other_lead_time double precision,
    n_specialists integer,
    n_technicians integer,
    max_hs double precision,
    max_tp double precision,
    max_ws double precision,
    max_cs double precision
);


--
-- TOC entry 299 (class 1259 OID 31302)
-- Name: sub_systems_maintenance_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.sub_systems_maintenance_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5598 (class 0 OID 0)
-- Dependencies: 299
-- Name: sub_systems_maintenance_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.sub_systems_maintenance_id_seq OWNED BY project.sub_systems_maintenance.id;


--
-- TOC entry 300 (class 1259 OID 31304)
-- Name: sub_systems_operation_weightings; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.sub_systems_operation_weightings (
    id integer NOT NULL,
    fk_sub_system_id integer,
    maintenance double precision,
    replacement double precision,
    inspection double precision
);


--
-- TOC entry 301 (class 1259 OID 31307)
-- Name: sub_systems_operation_weightings_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.sub_systems_operation_weightings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5599 (class 0 OID 0)
-- Dependencies: 301
-- Name: sub_systems_operation_weightings_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.sub_systems_operation_weightings_id_seq OWNED BY project.sub_systems_operation_weightings.id;


--
-- TOC entry 302 (class 1259 OID 31309)
-- Name: sub_systems_replace; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.sub_systems_replace (
    id integer NOT NULL,
    fk_sub_system_id integer,
    operation_duration double precision,
    interruptible boolean,
    assembly_lead_time double precision,
    crew_lead_time double precision,
    other_lead_time double precision,
    n_specialists integer,
    n_technicians integer
);


--
-- TOC entry 303 (class 1259 OID 31312)
-- Name: sub_systems_replace_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.sub_systems_replace_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5600 (class 0 OID 0)
-- Dependencies: 303
-- Name: sub_systems_replace_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.sub_systems_replace_id_seq OWNED BY project.sub_systems_replace.id;


--
-- TOC entry 304 (class 1259 OID 31314)
-- Name: time_series_energy_tidal; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.time_series_energy_tidal (
    id bigint NOT NULL,
    fk_bathymetry_id bigint,
    measure_date date,
    measure_time time(6) without time zone,
    u double precision,
    v double precision,
    turbulence_intensity double precision,
    ssh double precision
);


--
-- TOC entry 305 (class 1259 OID 31317)
-- Name: time_series_energy_tidal_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.time_series_energy_tidal_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5601 (class 0 OID 0)
-- Dependencies: 305
-- Name: time_series_energy_tidal_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.time_series_energy_tidal_id_seq OWNED BY project.time_series_energy_tidal.id;


--
-- TOC entry 306 (class 1259 OID 31319)
-- Name: time_series_energy_wave; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.time_series_energy_wave (
    id bigint NOT NULL,
    fk_site_id integer,
    measure_date date,
    measure_time time(6) without time zone,
    height double precision,
    te double precision,
    direction double precision
);


--
-- TOC entry 307 (class 1259 OID 31322)
-- Name: time_series_energy_wave_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.time_series_energy_wave_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5602 (class 0 OID 0)
-- Dependencies: 307
-- Name: time_series_energy_wave_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.time_series_energy_wave_id_seq OWNED BY project.time_series_energy_wave.id;


--
-- TOC entry 308 (class 1259 OID 31324)
-- Name: time_series_om_tidal; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.time_series_om_tidal (
    id bigint NOT NULL,
    fk_site_id bigint,
    measure_date date,
    measure_time time(6) without time zone,
    current_speed double precision
);


--
-- TOC entry 309 (class 1259 OID 31327)
-- Name: time_series_om_tidal_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.time_series_om_tidal_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5603 (class 0 OID 0)
-- Dependencies: 309
-- Name: time_series_om_tidal_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.time_series_om_tidal_id_seq OWNED BY project.time_series_om_tidal.id;


--
-- TOC entry 310 (class 1259 OID 31329)
-- Name: time_series_om_wave; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.time_series_om_wave (
    id bigint NOT NULL,
    fk_site_id integer,
    measure_date date,
    measure_time time(6) without time zone,
    period_tp double precision,
    height_hs double precision
);


--
-- TOC entry 311 (class 1259 OID 31332)
-- Name: time_series_om_wave_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.time_series_om_wave_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5604 (class 0 OID 0)
-- Dependencies: 311
-- Name: time_series_om_wave_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.time_series_om_wave_id_seq OWNED BY project.time_series_om_wave.id;


--
-- TOC entry 312 (class 1259 OID 31334)
-- Name: time_series_om_wind; Type: TABLE; Schema: project; Owner: -
--

CREATE TABLE project.time_series_om_wind (
    id bigint NOT NULL,
    fk_site_id integer,
    measure_date date,
    measure_time time(6) without time zone,
    wind_speed double precision
);


--
-- TOC entry 313 (class 1259 OID 31337)
-- Name: time_series_om_wind_id_seq; Type: SEQUENCE; Schema: project; Owner: -
--

CREATE SEQUENCE project.time_series_om_wind_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5605 (class 0 OID 0)
-- Dependencies: 313
-- Name: time_series_om_wind_id_seq; Type: SEQUENCE OWNED BY; Schema: project; Owner: -
--

ALTER SEQUENCE project.time_series_om_wind_id_seq OWNED BY project.time_series_om_wind.id;


--
-- TOC entry 314 (class 1259 OID 31339)
-- Name: component; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.component (
    id bigint NOT NULL,
    description character varying(200)
);


--
-- TOC entry 315 (class 1259 OID 31342)
-- Name: component_anchor; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.component_anchor (
    id integer NOT NULL,
    fk_component_discrete_id bigint,
    fk_component_type_id smallint,
    connecting_size double precision,
    minimum_breaking_load double precision,
    axial_stiffness double precision,
    soft_holding_cap_coef_1 double precision,
    soft_holding_cap_coef_2 double precision,
    soft_penetration_coef_1 double precision,
    soft_penetration_coef_2 double precision,
    sand_holding_cap_coef_1 double precision,
    sand_holding_cap_coef_2 double precision,
    sand_penetration_coef_1 double precision,
    sand_penetration_coef_2 double precision,
    CONSTRAINT component_anchor_fk_component_type_id_check CHECK ((fk_component_type_id = 1))
);


--
-- TOC entry 316 (class 1259 OID 31346)
-- Name: component_anchor_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.component_anchor_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5606 (class 0 OID 0)
-- Dependencies: 316
-- Name: component_anchor_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.component_anchor_id_seq OWNED BY reference.component_anchor.id;


--
-- TOC entry 317 (class 1259 OID 31348)
-- Name: component_cable; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.component_cable (
    id integer NOT NULL,
    fk_component_continuous_id bigint,
    fk_component_type_id smallint,
    minimum_breaking_load double precision,
    minimum_bend_radius double precision,
    number_conductors smallint,
    number_fibre_channels smallint,
    resistance_dc_20 double precision,
    resistance_ac_90 double precision,
    inductive_reactance double precision,
    capacitance double precision,
    rated_current_air double precision,
    rated_current_buried double precision,
    rated_current_jtube double precision,
    rated_voltage_u0 double precision,
    operational_temp_max double precision,
    CONSTRAINT component_cable_fk_component_type_id_check CHECK ((fk_component_type_id = ANY (ARRAY[2, 3])))
);


--
-- TOC entry 318 (class 1259 OID 31352)
-- Name: component_cable_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.component_cable_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5607 (class 0 OID 0)
-- Dependencies: 318
-- Name: component_cable_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.component_cable_id_seq OWNED BY reference.component_cable.id;


--
-- TOC entry 319 (class 1259 OID 31354)
-- Name: component_collection_point; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.component_collection_point (
    id integer NOT NULL,
    fk_component_discrete_id bigint,
    fk_component_type_id smallint,
    wet_frontal_area double precision,
    dry_frontal_area double precision,
    wet_beam_area double precision,
    dry_beam_area double precision,
    maximum_water_depth double precision,
    orientation_angle double precision,
    input_lines integer,
    output_lines integer,
    input_connector_type character varying(8),
    output_connector_type character varying(8),
    number_fibre_channels integer,
    voltage_primary_winding double precision,
    voltage_secondary_winding double precision,
    rated_operating_current double precision,
    operational_temp_min double precision,
    operational_temp_max double precision,
    foundation_locations double precision[],
    centre_of_gravity double precision[],
    CONSTRAINT component_collection_point_fk_component_type_id_check CHECK ((fk_component_type_id = 5)),
    CONSTRAINT component_collection_point_input_connector_type_check CHECK (((input_connector_type)::text = ANY (ARRAY[('wet-mate'::character varying)::text, ('dry-mate'::character varying)::text]))),
    CONSTRAINT component_collection_point_output_connector_type_check CHECK (((output_connector_type)::text = ANY (ARRAY[('wet-mate'::character varying)::text, ('dry-mate'::character varying)::text])))
);


--
-- TOC entry 320 (class 1259 OID 31363)
-- Name: component_collection_point_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.component_collection_point_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5608 (class 0 OID 0)
-- Dependencies: 320
-- Name: component_collection_point_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.component_collection_point_id_seq OWNED BY reference.component_collection_point.id;


--
-- TOC entry 321 (class 1259 OID 31365)
-- Name: component_connector; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.component_connector (
    id integer NOT NULL,
    fk_component_discrete_id bigint,
    fk_component_type_id smallint,
    maximum_water_depth double precision,
    number_contacts integer,
    number_fibre_channels integer,
    mating_force double precision,
    demating_force double precision,
    rated_voltage_u0 double precision,
    rated_current double precision,
    cable_area_min double precision,
    cable_area_max double precision,
    operational_temp_min double precision,
    operational_temp_max double precision,
    CONSTRAINT component_connector_fk_component_type_id_check CHECK ((fk_component_type_id = ANY (ARRAY[6, 7])))
);


--
-- TOC entry 322 (class 1259 OID 31369)
-- Name: component_connector_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.component_connector_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5609 (class 0 OID 0)
-- Dependencies: 322
-- Name: component_connector_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.component_connector_id_seq OWNED BY reference.component_connector.id;


--
-- TOC entry 323 (class 1259 OID 31371)
-- Name: component_continuous; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.component_continuous (
    id bigint NOT NULL,
    fk_component_id bigint,
    diameter double precision,
    dry_mass_per_unit_length double precision,
    wet_mass_per_unit_length double precision,
    cost_per_unit_length double precision
);


--
-- TOC entry 324 (class 1259 OID 31374)
-- Name: component_continuous_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.component_continuous_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5610 (class 0 OID 0)
-- Dependencies: 324
-- Name: component_continuous_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.component_continuous_id_seq OWNED BY reference.component_continuous.id;


--
-- TOC entry 325 (class 1259 OID 31376)
-- Name: component_discrete; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.component_discrete (
    id bigint NOT NULL,
    fk_component_id bigint,
    length double precision,
    width double precision,
    height double precision,
    dry_mass double precision,
    wet_mass double precision,
    cost double precision
);


--
-- TOC entry 326 (class 1259 OID 31379)
-- Name: component_discrete_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.component_discrete_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5611 (class 0 OID 0)
-- Dependencies: 326
-- Name: component_discrete_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.component_discrete_id_seq OWNED BY reference.component_discrete.id;


--
-- TOC entry 327 (class 1259 OID 31381)
-- Name: component_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.component_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5612 (class 0 OID 0)
-- Dependencies: 327
-- Name: component_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.component_id_seq OWNED BY reference.component.id;


--
-- TOC entry 328 (class 1259 OID 31383)
-- Name: component_mooring_continuous; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.component_mooring_continuous (
    id integer NOT NULL,
    fk_component_continuous_id bigint,
    fk_component_type_id smallint,
    connecting_length double precision,
    minimum_breaking_load double precision,
    axial_stiffness double precision,
    CONSTRAINT component_mooring_continuous_fk_component_type_id_check CHECK ((fk_component_type_id = ANY (ARRAY[4, 8])))
);


--
-- TOC entry 329 (class 1259 OID 31387)
-- Name: component_mooring_continuous_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.component_mooring_continuous_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5613 (class 0 OID 0)
-- Dependencies: 329
-- Name: component_mooring_continuous_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.component_mooring_continuous_id_seq OWNED BY reference.component_mooring_continuous.id;


--
-- TOC entry 330 (class 1259 OID 31389)
-- Name: component_mooring_discrete; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.component_mooring_discrete (
    id integer NOT NULL,
    fk_component_discrete_id bigint,
    fk_component_type_id smallint,
    nominal_diameter double precision,
    connecting_length double precision,
    minimum_breaking_load double precision,
    axial_stiffness double precision,
    CONSTRAINT component_mooring_discrete_fk_component_type_id_check CHECK ((fk_component_type_id = ANY (ARRAY[11, 12])))
);


--
-- TOC entry 331 (class 1259 OID 31393)
-- Name: component_mooring_discrete_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.component_mooring_discrete_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5614 (class 0 OID 0)
-- Dependencies: 331
-- Name: component_mooring_discrete_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.component_mooring_discrete_id_seq OWNED BY reference.component_mooring_discrete.id;


--
-- TOC entry 332 (class 1259 OID 31395)
-- Name: component_pile; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.component_pile (
    id bigint NOT NULL,
    fk_component_continuous_id bigint,
    fk_component_type_id smallint,
    wall_thickness double precision,
    yield_stress double precision,
    youngs_modulus double precision,
    CONSTRAINT component_pile_fk_component_type_id_check CHECK ((fk_component_type_id = 9))
);


--
-- TOC entry 333 (class 1259 OID 31399)
-- Name: component_pile_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.component_pile_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5615 (class 0 OID 0)
-- Dependencies: 333
-- Name: component_pile_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.component_pile_id_seq OWNED BY reference.component_pile.id;


--
-- TOC entry 334 (class 1259 OID 31401)
-- Name: component_rope; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.component_rope (
    id integer NOT NULL,
    fk_component_continuous_id bigint,
    fk_component_type_id smallint,
    material character varying(10),
    minimum_breaking_load double precision,
    rope_stiffness_curve double precision[],
    CONSTRAINT component_rope_fk_component_type_id_check CHECK ((fk_component_type_id = 10)),
    CONSTRAINT component_rope_material_check CHECK (((material)::text = ANY (ARRAY[('polyester'::character varying)::text, ('nylon'::character varying)::text, ('hmpe'::character varying)::text, ('steelite'::character varying)::text])))
);


--
-- TOC entry 335 (class 1259 OID 31409)
-- Name: component_rope_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.component_rope_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5616 (class 0 OID 0)
-- Dependencies: 335
-- Name: component_rope_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.component_rope_id_seq OWNED BY reference.component_rope.id;


--
-- TOC entry 336 (class 1259 OID 31411)
-- Name: component_shared; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.component_shared (
    id bigint NOT NULL,
    fk_component_id bigint,
    preparation_person_hours double precision,
    inspection_person_hours double precision,
    maintenance_person_hours double precision,
    replacement_person_hours double precision,
    ncfr_lower_bound double precision,
    ncfr_mean double precision,
    ncfr_upper_bound double precision,
    cfr_lower_bound double precision,
    cfr_mean double precision,
    cfr_upper_bound double precision,
    environmental_impact character varying(100)
);


--
-- TOC entry 337 (class 1259 OID 31414)
-- Name: component_shared_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.component_shared_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5617 (class 0 OID 0)
-- Dependencies: 337
-- Name: component_shared_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.component_shared_id_seq OWNED BY reference.component_shared.id;


--
-- TOC entry 338 (class 1259 OID 31416)
-- Name: component_transformer; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.component_transformer (
    id integer NOT NULL,
    fk_component_discrete_id bigint,
    fk_component_type_id smallint,
    maximum_water_depth double precision,
    power_rating double precision,
    impedance double precision,
    windings integer,
    voltage_primary_winding double precision,
    voltage_secondary_winding double precision,
    voltage_tertiary_winding double precision,
    operational_temp_min double precision,
    operational_temp_max double precision,
    CONSTRAINT component_transformer_fk_component_type_id_check CHECK ((fk_component_type_id = 13))
);


--
-- TOC entry 339 (class 1259 OID 31420)
-- Name: component_transformer_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.component_transformer_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5618 (class 0 OID 0)
-- Dependencies: 339
-- Name: component_transformer_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.component_transformer_id_seq OWNED BY reference.component_transformer.id;


--
-- TOC entry 340 (class 1259 OID 31422)
-- Name: component_type; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.component_type (
    id smallint NOT NULL,
    description character varying(20)
);


--
-- TOC entry 341 (class 1259 OID 31425)
-- Name: component_type_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.component_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5619 (class 0 OID 0)
-- Dependencies: 341
-- Name: component_type_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.component_type_id_seq OWNED BY reference.component_type.id;


--
-- TOC entry 342 (class 1259 OID 31427)
-- Name: constants; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.constants (
    lock character(1) NOT NULL,
    gravity double precision,
    sea_water_density double precision,
    air_density double precision,
    steel_density double precision,
    concrete_density double precision,
    grout_density double precision,
    grout_strength double precision,
    CONSTRAINT constants_lock_check CHECK ((lock = 'X'::bpchar))
);


--
-- TOC entry 5620 (class 0 OID 0)
-- Dependencies: 342
-- Name: COLUMN constants.lock; Type: COMMENT; Schema: reference; Owner: -
--

COMMENT ON COLUMN reference.constants.lock IS 'Ensures table always has a single row. Value should be "X".';


--
-- TOC entry 343 (class 1259 OID 31431)
-- Name: constraint_type_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.constraint_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    MAXVALUE 32767
    CACHE 1;


--
-- TOC entry 344 (class 1259 OID 31433)
-- Name: equipment_cable_burial; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.equipment_cable_burial (
    id integer NOT NULL,
    description character varying(200),
    width double precision,
    length double precision,
    height double precision,
    dry_mass double precision,
    max_operating_depth double precision,
    tow_force_required double precision,
    jetting_capability boolean,
    ploughing_capability boolean,
    cutting_capability boolean,
    jetting_trench_depth double precision,
    ploughing_trench_depth double precision,
    cutting_trench_depth double precision,
    max_cable_diameter double precision,
    min_cable_bend_radius double precision,
    additional_equipment_footprint double precision,
    additional_equipment_mass double precision,
    equipment_day_rate double precision,
    personnel_day_rate double precision
);


--
-- TOC entry 345 (class 1259 OID 31436)
-- Name: equipment_cable_burial_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.equipment_cable_burial_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5621 (class 0 OID 0)
-- Dependencies: 345
-- Name: equipment_cable_burial_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.equipment_cable_burial_id_seq OWNED BY reference.equipment_cable_burial.id;


--
-- TOC entry 346 (class 1259 OID 31438)
-- Name: equipment_divers; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.equipment_divers (
    id integer NOT NULL,
    description character varying(200),
    max_operating_depth double precision,
    deployment_eq_footprint double precision,
    deployment_eq_mass double precision,
    total_day_rate double precision
);


--
-- TOC entry 347 (class 1259 OID 31441)
-- Name: equipment_divers_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.equipment_divers_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5622 (class 0 OID 0)
-- Dependencies: 347
-- Name: equipment_divers_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.equipment_divers_id_seq OWNED BY reference.equipment_divers.id;


--
-- TOC entry 348 (class 1259 OID 31443)
-- Name: equipment_drilling_rigs; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.equipment_drilling_rigs (
    id integer NOT NULL,
    description character varying(200),
    diameter double precision,
    length double precision,
    dry_mass double precision,
    max_water_depth double precision,
    max_drilling_depth double precision,
    drilling_diameter_range double precision,
    additional_equipment_footprint double precision,
    additional_equipment_mass double precision,
    equipment_day_rate double precision,
    personnel_day_rate double precision
);


--
-- TOC entry 349 (class 1259 OID 31446)
-- Name: equipment_drilling_rigs_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.equipment_drilling_rigs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5623 (class 0 OID 0)
-- Dependencies: 349
-- Name: equipment_drilling_rigs_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.equipment_drilling_rigs_id_seq OWNED BY reference.equipment_drilling_rigs.id;


--
-- TOC entry 350 (class 1259 OID 31448)
-- Name: equipment_excavating; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.equipment_excavating (
    id integer NOT NULL,
    description character varying(200),
    width double precision,
    height double precision,
    dry_mass double precision,
    depth_rating double precision,
    equipment_day_rate double precision,
    personnel_day_rate double precision
);


--
-- TOC entry 351 (class 1259 OID 31451)
-- Name: equipment_excavating_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.equipment_excavating_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5624 (class 0 OID 0)
-- Dependencies: 351
-- Name: equipment_excavating_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.equipment_excavating_id_seq OWNED BY reference.equipment_excavating.id;


--
-- TOC entry 352 (class 1259 OID 31453)
-- Name: equipment_hammer; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.equipment_hammer (
    id integer NOT NULL,
    description character varying(200),
    length double precision,
    dry_mass double precision,
    depth_rating double precision,
    min_pile_diameter double precision,
    max_pile_diameter double precision,
    additional_equipment_footprint double precision,
    additional_equipment_mass double precision,
    equipment_day_rate double precision,
    personnel_day_rate double precision
);


--
-- TOC entry 353 (class 1259 OID 31456)
-- Name: equipment_hammer_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.equipment_hammer_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5625 (class 0 OID 0)
-- Dependencies: 353
-- Name: equipment_hammer_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.equipment_hammer_id_seq OWNED BY reference.equipment_hammer.id;


--
-- TOC entry 354 (class 1259 OID 31458)
-- Name: equipment_mattress; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.equipment_mattress (
    id integer NOT NULL,
    description character varying(200),
    width double precision,
    length double precision,
    thickness double precision,
    dry_mass double precision,
    cost double precision
);


--
-- TOC entry 355 (class 1259 OID 31461)
-- Name: equipment_mattress_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.equipment_mattress_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5626 (class 0 OID 0)
-- Dependencies: 355
-- Name: equipment_mattress_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.equipment_mattress_id_seq OWNED BY reference.equipment_mattress.id;


--
-- TOC entry 356 (class 1259 OID 31463)
-- Name: equipment_rock_filter_bags; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.equipment_rock_filter_bags (
    id integer NOT NULL,
    description character varying(200),
    diameter double precision,
    height double precision,
    dry_mass double precision,
    cost double precision
);


--
-- TOC entry 357 (class 1259 OID 31466)
-- Name: equipment_rock_filter_bags_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.equipment_rock_filter_bags_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5627 (class 0 OID 0)
-- Dependencies: 357
-- Name: equipment_rock_filter_bags_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.equipment_rock_filter_bags_id_seq OWNED BY reference.equipment_rock_filter_bags.id;


--
-- TOC entry 358 (class 1259 OID 31468)
-- Name: equipment_rov; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.equipment_rov (
    id integer NOT NULL,
    description character varying(200),
    rov_class character varying(16),
    width double precision,
    length double precision,
    height double precision,
    dry_mass double precision,
    depth_rating double precision,
    payload double precision,
    manipulator_grip_force double precision,
    additional_equipment_footprint double precision,
    additional_equipment_mass double precision,
    additional_equipment_supervisors integer,
    additional_equipment_technicians integer,
    equipment_day_rate double precision,
    supervisor_day_rate double precision,
    technician_day_rate double precision,
    CONSTRAINT equipment_rov_rov_class_check CHECK (((rov_class)::text = ANY (ARRAY[('Inspection class'::character varying)::text, ('Workclass'::character varying)::text])))
);


--
-- TOC entry 359 (class 1259 OID 31472)
-- Name: equipment_rov_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.equipment_rov_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5628 (class 0 OID 0)
-- Dependencies: 359
-- Name: equipment_rov_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.equipment_rov_id_seq OWNED BY reference.equipment_rov.id;


--
-- TOC entry 360 (class 1259 OID 31474)
-- Name: equipment_soil_lay_rates; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.equipment_soil_lay_rates (
    equipment_type character varying(100) NOT NULL,
    soil_ls double precision,
    soil_ms double precision,
    soil_ds double precision,
    soil_vsc double precision,
    soil_sc double precision,
    soil_fc double precision,
    soil_stc double precision,
    soil_hgt double precision,
    soil_cm double precision,
    soil_src double precision,
    soil_hr double precision,
    soil_gc double precision
);


--
-- TOC entry 361 (class 1259 OID 31477)
-- Name: equipment_soil_penet_rates; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.equipment_soil_penet_rates (
    equipment_type character varying(100) NOT NULL,
    soil_ls double precision,
    soil_ms double precision,
    soil_ds double precision,
    soil_vsc double precision,
    soil_sc double precision,
    soil_fc double precision,
    soil_stc double precision,
    soil_hgt double precision,
    soil_cm double precision,
    soil_src double precision,
    soil_hr double precision,
    soil_gc double precision
);


--
-- TOC entry 362 (class 1259 OID 31480)
-- Name: equipment_split_pipe; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.equipment_split_pipe (
    id integer NOT NULL,
    description character varying(200),
    length double precision,
    cost double precision
);


--
-- TOC entry 363 (class 1259 OID 31483)
-- Name: equipment_split_pipe_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.equipment_split_pipe_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5629 (class 0 OID 0)
-- Dependencies: 363
-- Name: equipment_split_pipe_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.equipment_split_pipe_id_seq OWNED BY reference.equipment_split_pipe.id;


--
-- TOC entry 364 (class 1259 OID 31485)
-- Name: equipment_vibro_driver; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.equipment_vibro_driver (
    id integer NOT NULL,
    description character varying(200),
    width double precision,
    length double precision,
    height double precision,
    vibro_driver_mass double precision,
    clamp_mass double precision,
    min_pile_diameter double precision,
    max_pile_diameter double precision,
    max_pile_mass double precision,
    additional_equipment_footprint double precision,
    additional_equipment_mass double precision,
    equipment_day_rate double precision,
    personnel_day_rate double precision
);


--
-- TOC entry 365 (class 1259 OID 31488)
-- Name: equipment_vibro_driver_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.equipment_vibro_driver_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5630 (class 0 OID 0)
-- Dependencies: 365
-- Name: equipment_vibro_driver_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.equipment_vibro_driver_id_seq OWNED BY reference.equipment_vibro_driver.id;


--
-- TOC entry 366 (class 1259 OID 31490)
-- Name: operations_limit_cs; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.operations_limit_cs (
    id smallint NOT NULL,
    fk_operations_id smallint,
    cs_limit double precision
);


--
-- TOC entry 367 (class 1259 OID 31493)
-- Name: operations_limit_cs_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.operations_limit_cs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5631 (class 0 OID 0)
-- Dependencies: 367
-- Name: operations_limit_cs_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.operations_limit_cs_id_seq OWNED BY reference.operations_limit_cs.id;


--
-- TOC entry 368 (class 1259 OID 31495)
-- Name: operations_limit_hs; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.operations_limit_hs (
    id smallint NOT NULL,
    fk_operations_id smallint,
    hs_limit double precision
);


--
-- TOC entry 369 (class 1259 OID 31498)
-- Name: operations_limit_hs_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.operations_limit_hs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5632 (class 0 OID 0)
-- Dependencies: 369
-- Name: operations_limit_hs_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.operations_limit_hs_id_seq OWNED BY reference.operations_limit_hs.id;


--
-- TOC entry 370 (class 1259 OID 31500)
-- Name: operations_limit_tp; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.operations_limit_tp (
    id smallint NOT NULL,
    fk_operations_id smallint,
    tp_limit double precision
);


--
-- TOC entry 371 (class 1259 OID 31503)
-- Name: operations_limit_tp_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.operations_limit_tp_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5633 (class 0 OID 0)
-- Dependencies: 371
-- Name: operations_limit_tp_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.operations_limit_tp_id_seq OWNED BY reference.operations_limit_tp.id;


--
-- TOC entry 372 (class 1259 OID 31505)
-- Name: operations_limit_ws; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.operations_limit_ws (
    id smallint NOT NULL,
    fk_operations_id smallint,
    ws_limit double precision
);


--
-- TOC entry 373 (class 1259 OID 31508)
-- Name: operations_limit_ws_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.operations_limit_ws_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5634 (class 0 OID 0)
-- Dependencies: 373
-- Name: operations_limit_ws_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.operations_limit_ws_id_seq OWNED BY reference.operations_limit_ws.id;


--
-- TOC entry 374 (class 1259 OID 31510)
-- Name: operations_type; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.operations_type (
    id smallint NOT NULL,
    description character varying(150)
);


--
-- TOC entry 375 (class 1259 OID 31513)
-- Name: operations_type_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.operations_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5635 (class 0 OID 0)
-- Dependencies: 375
-- Name: operations_type_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.operations_type_id_seq OWNED BY reference.operations_type.id;


--
-- TOC entry 376 (class 1259 OID 31515)
-- Name: ports; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.ports (
    id integer NOT NULL,
    name character varying(100),
    country character varying(100),
    type_of_terminal character varying(8),
    entrance_width double precision,
    terminal_length double precision,
    terminal_load_bearing double precision,
    terminal_draught double precision,
    terminal_area double precision,
    max_gantry_crane_lift_capacity double precision,
    max_tower_crane_lift_capacity double precision,
    jacking_capability boolean,
    point_location public.geometry(Point,4326),
    CONSTRAINT ports_type_of_terminal_check CHECK (((type_of_terminal)::text = ANY (ARRAY[('Quay'::character varying)::text, ('Dry-dock'::character varying)::text])))
);


--
-- TOC entry 377 (class 1259 OID 31522)
-- Name: ports_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.ports_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5636 (class 0 OID 0)
-- Dependencies: 377
-- Name: ports_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.ports_id_seq OWNED BY reference.ports.id;


--
-- TOC entry 378 (class 1259 OID 31524)
-- Name: ref_current_drag_coef_rect; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.ref_current_drag_coef_rect (
    width_length double precision NOT NULL,
    thickness_width double precision
);


--
-- TOC entry 379 (class 1259 OID 31527)
-- Name: ref_drag_coef_cyl; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.ref_drag_coef_cyl (
    reynolds_number double precision NOT NULL,
    smooth double precision,
    roughness_1e_5 double precision,
    roughness_1e_2 double precision
);


--
-- TOC entry 380 (class 1259 OID 31530)
-- Name: ref_drift_coef_float_rect; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.ref_drift_coef_float_rect (
    wavenumber_draft double precision NOT NULL,
    reflection_coefficient double precision
);


--
-- TOC entry 381 (class 1259 OID 31533)
-- Name: ref_holding_capacity_factors_plate_anchors; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.ref_holding_capacity_factors_plate_anchors (
    relative_embedment_depth double precision NOT NULL,
    drained_friction_angle_20deg double precision,
    drained_friction_angle_25deg double precision,
    drained_friction_angle_30deg double precision,
    drained_friction_angle_35deg double precision,
    drained_friction_angle_40deg double precision
);


--
-- TOC entry 382 (class 1259 OID 31536)
-- Name: ref_line_bcf; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.ref_line_bcf (
    soil_friction_angle double precision NOT NULL,
    bearing_capacity_factor double precision
);


--
-- TOC entry 383 (class 1259 OID 31539)
-- Name: ref_pile_deflection_coefficients; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.ref_pile_deflection_coefficients (
    depth_coefficient double precision NOT NULL,
    coefficient_ay double precision,
    coefficient_by double precision
);


--
-- TOC entry 384 (class 1259 OID 31542)
-- Name: ref_pile_limiting_values_noncalcareous; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.ref_pile_limiting_values_noncalcareous (
    soil_friction_angle double precision NOT NULL,
    friction_angle_sand_pile double precision,
    bearing_capacity_factor double precision,
    max_unit_skin_friction double precision,
    max_end_bearing_capacity double precision
);


--
-- TOC entry 385 (class 1259 OID 31545)
-- Name: ref_pile_moment_coefficient_sam; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.ref_pile_moment_coefficient_sam (
    depth_coefficient double precision NOT NULL,
    pile_length_relative_soil_pile_stiffness_10 double precision,
    pile_length_relative_soil_pile_stiffness_5 double precision,
    pile_length_relative_soil_pile_stiffness_4 double precision,
    pile_length_relative_soil_pile_stiffness_3 double precision,
    pile_length_relative_soil_pile_stiffness_2 double precision
);


--
-- TOC entry 386 (class 1259 OID 31548)
-- Name: ref_pile_moment_coefficient_sbm; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.ref_pile_moment_coefficient_sbm (
    depth_coefficient double precision NOT NULL,
    pile_length_relative_soil_pile_stiffness_10 double precision,
    pile_length_relative_soil_pile_stiffness_5 double precision,
    pile_length_relative_soil_pile_stiffness_4 double precision,
    pile_length_relative_soil_pile_stiffness_3 double precision,
    pile_length_relative_soil_pile_stiffness_2 double precision
);


--
-- TOC entry 387 (class 1259 OID 31551)
-- Name: ref_rectangular_wave_inertia; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.ref_rectangular_wave_inertia (
    "width/length" double precision NOT NULL,
    inertia_coefficients double precision
);


--
-- TOC entry 388 (class 1259 OID 31554)
-- Name: ref_subgrade_reaction_coefficient_cohesionless; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.ref_subgrade_reaction_coefficient_cohesionless (
    allowable_deflection_diameter double precision NOT NULL,
    relative_density_35 double precision,
    relative_density_50 double precision,
    relative_density_65 double precision,
    relative_density_85 double precision
);


--
-- TOC entry 389 (class 1259 OID 31557)
-- Name: ref_subgrade_reaction_coefficient_k1_cohesive; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.ref_subgrade_reaction_coefficient_k1_cohesive (
    allowable_deflection_diameter double precision NOT NULL,
    softclay double precision,
    stiffclay double precision
);


--
-- TOC entry 390 (class 1259 OID 31560)
-- Name: ref_superline_nylon; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.ref_superline_nylon (
    extension double precision NOT NULL,
    load_mbl double precision
);


--
-- TOC entry 391 (class 1259 OID 31563)
-- Name: ref_superline_polyester; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.ref_superline_polyester (
    extension double precision NOT NULL,
    load_mbl double precision
);


--
-- TOC entry 392 (class 1259 OID 31566)
-- Name: ref_superline_steelite; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.ref_superline_steelite (
    extension double precision NOT NULL,
    load_mbl double precision
);


--
-- TOC entry 393 (class 1259 OID 31569)
-- Name: ref_wake_amplification_factor_cyl; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.ref_wake_amplification_factor_cyl (
    kc_steady_drag_coefficient double precision NOT NULL,
    amplification_factor_for_smooth_cylinders double precision,
    amplification_factor_for_rough_cylinders double precision
);


--
-- TOC entry 394 (class 1259 OID 31572)
-- Name: ref_wind_drag_coef_rect; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.ref_wind_drag_coef_rect (
    width_length double precision NOT NULL,
    height_breadth_between_0_1 double precision,
    height_breadth_less_1 double precision,
    height_breadth_less_2 double precision,
    height_breadth_less_4 double precision,
    height_breadth_less_6 double precision,
    height_breadth_less_10 double precision,
    height_breadth_less_20 double precision
);


--
-- TOC entry 395 (class 1259 OID 31575)
-- Name: soil_type_geotechnical_properties; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.soil_type_geotechnical_properties (
    fk_soil_type_id integer NOT NULL,
    drained_soil_friction_angle double precision,
    relative_soil_density double precision,
    buoyant_unit_weight_of_soil double precision,
    effective_drained_cohesion double precision,
    seafloor_friction_coefficient double precision,
    soil_sensitivity double precision,
    rock_compressive_strength double precision,
    undrained_soil_shear_strength_constant_term double precision,
    undrained_soil_shear_strength_depth_dependent_term double precision
);


--
-- TOC entry 396 (class 1259 OID 31578)
-- Name: soil_type_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.soil_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5637 (class 0 OID 0)
-- Dependencies: 396
-- Name: soil_type_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.soil_type_id_seq OWNED BY reference.soil_type.id;


--
-- TOC entry 397 (class 1259 OID 31580)
-- Name: vehicle; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.vehicle (
    id bigint NOT NULL,
    description character varying(200)
);


--
-- TOC entry 398 (class 1259 OID 31583)
-- Name: vehicle_helicopter; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.vehicle_helicopter (
    id integer NOT NULL,
    fk_vehicle_id bigint,
    fk_vehicle_type_id smallint,
    deck_space double precision,
    max_deck_load_pressure double precision,
    max_cargo_mass double precision,
    crane_max_load_mass double precision,
    external_personel integer,
    CONSTRAINT vehicle_helicopter_fk_vehicle_type_id_check CHECK ((fk_vehicle_type_id = 9))
);


--
-- TOC entry 399 (class 1259 OID 31587)
-- Name: vehicle_helicopter_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.vehicle_helicopter_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5638 (class 0 OID 0)
-- Dependencies: 399
-- Name: vehicle_helicopter_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.vehicle_helicopter_id_seq OWNED BY reference.vehicle_helicopter.id;


--
-- TOC entry 400 (class 1259 OID 31589)
-- Name: vehicle_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.vehicle_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5639 (class 0 OID 0)
-- Dependencies: 400
-- Name: vehicle_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.vehicle_id_seq OWNED BY reference.vehicle.id;


--
-- TOC entry 401 (class 1259 OID 31591)
-- Name: vehicle_shared; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.vehicle_shared (
    id bigint NOT NULL,
    fk_vehicle_id bigint,
    gross_tonnage double precision,
    length double precision,
    consumption double precision,
    transit_speed double precision,
    transit_max_hs double precision,
    transit_max_tp double precision,
    transit_max_cs double precision,
    transit_max_ws double precision,
    mobilisation_time double precision,
    mobilisation_percentage_cost double precision,
    min_day_rate double precision,
    max_day_rate double precision
);


--
-- TOC entry 402 (class 1259 OID 31594)
-- Name: vehicle_shared_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.vehicle_shared_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5640 (class 0 OID 0)
-- Dependencies: 402
-- Name: vehicle_shared_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.vehicle_shared_id_seq OWNED BY reference.vehicle_shared.id;


--
-- TOC entry 403 (class 1259 OID 31596)
-- Name: vehicle_type; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.vehicle_type (
    id smallint NOT NULL,
    description character varying(40)
);


--
-- TOC entry 404 (class 1259 OID 31599)
-- Name: vehicle_type_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.vehicle_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5641 (class 0 OID 0)
-- Dependencies: 404
-- Name: vehicle_type_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.vehicle_type_id_seq OWNED BY reference.vehicle_type.id;


--
-- TOC entry 405 (class 1259 OID 31601)
-- Name: vehicle_vessel_anchor_handling; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.vehicle_vessel_anchor_handling (
    id integer NOT NULL,
    fk_vehicle_id bigint,
    fk_vehicle_type_id smallint,
    beam double precision,
    max_draft double precision,
    consumption_towing double precision,
    deck_space double precision,
    max_deck_load_pressure double precision,
    max_cargo_mass double precision,
    crane_max_load_mass double precision,
    bollard_pull double precision,
    anchor_handling_drum_capacity double precision,
    anchor_handling_winch_rated_pull double precision,
    external_personel integer,
    towing_max_hs double precision,
    CONSTRAINT vehicle_vessel_anchor_handling_fk_vehicle_type_id_check CHECK ((fk_vehicle_type_id = ANY (ARRAY[1, 12])))
);


--
-- TOC entry 406 (class 1259 OID 31605)
-- Name: vehicle_vessel_anchor_handling_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.vehicle_vessel_anchor_handling_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5642 (class 0 OID 0)
-- Dependencies: 406
-- Name: vehicle_vessel_anchor_handling_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.vehicle_vessel_anchor_handling_id_seq OWNED BY reference.vehicle_vessel_anchor_handling.id;


--
-- TOC entry 407 (class 1259 OID 31607)
-- Name: vehicle_vessel_cable_laying; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.vehicle_vessel_cable_laying (
    id integer NOT NULL,
    fk_vehicle_id bigint,
    fk_vehicle_type_id smallint,
    beam double precision,
    max_draft double precision,
    deck_space double precision,
    max_deck_load_pressure double precision,
    max_cargo_mass double precision,
    crane_max_load_mass double precision,
    bollard_pull double precision,
    number_turntables integer,
    turntable_max_load_mass double precision,
    turntable_inner_diameter double precision,
    cable_splice_capabilities boolean,
    dynamic_positioning_capabilities boolean,
    external_personel integer,
    CONSTRAINT vehicle_vessel_cable_laying_fk_vehicle_type_id_check CHECK ((fk_vehicle_type_id = ANY (ARRAY[3, 4])))
);


--
-- TOC entry 408 (class 1259 OID 31611)
-- Name: vehicle_vessel_cable_laying_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.vehicle_vessel_cable_laying_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5643 (class 0 OID 0)
-- Dependencies: 408
-- Name: vehicle_vessel_cable_laying_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.vehicle_vessel_cable_laying_id_seq OWNED BY reference.vehicle_vessel_cable_laying.id;


--
-- TOC entry 409 (class 1259 OID 31613)
-- Name: vehicle_vessel_cargo; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.vehicle_vessel_cargo (
    id integer NOT NULL,
    fk_vehicle_id bigint,
    fk_vehicle_type_id smallint,
    beam double precision,
    max_draft double precision,
    deck_space double precision,
    max_deck_load_pressure double precision,
    max_cargo_mass double precision,
    crane_max_load_mass double precision,
    dynamic_positioning_capabilities boolean,
    external_personel integer,
    CONSTRAINT vehicle_vessel_cargo_fk_vehicle_type_id_check CHECK ((fk_vehicle_type_id = ANY (ARRAY[2, 5, 6, 7, 8])))
);


--
-- TOC entry 410 (class 1259 OID 31617)
-- Name: vehicle_vessel_cargo_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.vehicle_vessel_cargo_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5644 (class 0 OID 0)
-- Dependencies: 410
-- Name: vehicle_vessel_cargo_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.vehicle_vessel_cargo_id_seq OWNED BY reference.vehicle_vessel_cargo.id;


--
-- TOC entry 411 (class 1259 OID 31619)
-- Name: vehicle_vessel_jackup; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.vehicle_vessel_jackup (
    id integer NOT NULL,
    fk_vehicle_id bigint,
    fk_vehicle_type_id smallint,
    beam double precision,
    max_draft double precision,
    deck_space double precision,
    max_deck_load_pressure double precision,
    max_cargo_mass double precision,
    crane_max_load_mass double precision,
    dynamic_positioning_capabilities boolean,
    jackup_max_water_depth double precision,
    jackup_speed_down double precision,
    jackup_max_payload_mass double precision,
    external_personel integer,
    jacking_max_hs double precision,
    jacking_max_tp double precision,
    jacking_max_cs double precision,
    jacking_max_ws double precision,
    CONSTRAINT vehicle_vessel_jackup_fk_vehicle_type_id_check CHECK ((fk_vehicle_type_id = ANY (ARRAY[10, 11])))
);


--
-- TOC entry 412 (class 1259 OID 31623)
-- Name: vehicle_vessel_jackup_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.vehicle_vessel_jackup_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5645 (class 0 OID 0)
-- Dependencies: 412
-- Name: vehicle_vessel_jackup_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.vehicle_vessel_jackup_id_seq OWNED BY reference.vehicle_vessel_jackup.id;


--
-- TOC entry 413 (class 1259 OID 31625)
-- Name: vehicle_vessel_tugboat; Type: TABLE; Schema: reference; Owner: -
--

CREATE TABLE reference.vehicle_vessel_tugboat (
    id integer NOT NULL,
    fk_vehicle_id bigint,
    fk_vehicle_type_id smallint,
    beam double precision,
    max_draft double precision,
    consumption_towing double precision,
    bollard_pull double precision,
    CONSTRAINT vehicle_vessel_tugboat_fk_vehicle_type_id_check CHECK ((fk_vehicle_type_id = 13))
);


--
-- TOC entry 414 (class 1259 OID 31629)
-- Name: vehicle_vessel_tugboat_id_seq; Type: SEQUENCE; Schema: reference; Owner: -
--

CREATE SEQUENCE reference.vehicle_vessel_tugboat_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 5646 (class 0 OID 0)
-- Dependencies: 414
-- Name: vehicle_vessel_tugboat_id_seq; Type: SEQUENCE OWNED BY; Schema: reference; Owner: -
--

ALTER SEQUENCE reference.vehicle_vessel_tugboat_id_seq OWNED BY reference.vehicle_vessel_tugboat.id;


--
-- TOC entry 415 (class 1259 OID 31631)
-- Name: view_component_cable_dynamic; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_component_cable_dynamic AS
 SELECT component.id AS component_id,
    component.description,
    component_continuous.diameter,
    component_continuous.dry_mass_per_unit_length,
    component_continuous.wet_mass_per_unit_length,
    component_cable.minimum_breaking_load,
    component_cable.minimum_bend_radius,
    component_cable.number_conductors,
    component_cable.number_fibre_channels,
    component_cable.resistance_dc_20,
    component_cable.resistance_ac_90,
    component_cable.inductive_reactance,
    component_cable.capacitance,
    component_cable.rated_current_air,
    component_cable.rated_current_buried,
    component_cable.rated_current_jtube,
    component_cable.rated_voltage_u0,
    component_cable.operational_temp_max,
    component_continuous.cost_per_unit_length,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM ((((reference.component_cable
     JOIN reference.component_continuous ON ((component_cable.fk_component_continuous_id = component_continuous.id)))
     JOIN reference.component_shared ON ((component_continuous.fk_component_id = component_shared.fk_component_id)))
     JOIN reference.component ON ((component_continuous.fk_component_id = component.id)))
     JOIN reference.component_type ON ((component_cable.fk_component_type_id = component_type.id)))
  WHERE ((component_type.description)::text = 'cable dynamic'::text);


--
-- TOC entry 416 (class 1259 OID 31636)
-- Name: view_component_cable_static; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_component_cable_static AS
 SELECT component.id AS component_id,
    component.description,
    component_continuous.diameter,
    component_continuous.dry_mass_per_unit_length,
    component_continuous.wet_mass_per_unit_length,
    component_cable.minimum_breaking_load,
    component_cable.minimum_bend_radius,
    component_cable.number_conductors,
    component_cable.number_fibre_channels,
    component_cable.resistance_dc_20,
    component_cable.resistance_ac_90,
    component_cable.inductive_reactance,
    component_cable.capacitance,
    component_cable.rated_current_air,
    component_cable.rated_current_buried,
    component_cable.rated_current_jtube,
    component_cable.rated_voltage_u0,
    component_cable.operational_temp_max,
    component_continuous.cost_per_unit_length,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM ((((reference.component_cable
     JOIN reference.component_continuous ON ((component_cable.fk_component_continuous_id = component_continuous.id)))
     JOIN reference.component_shared ON ((component_continuous.fk_component_id = component_shared.fk_component_id)))
     JOIN reference.component ON ((component_continuous.fk_component_id = component.id)))
     JOIN reference.component_type ON ((component_cable.fk_component_type_id = component_type.id)))
  WHERE ((component_type.description)::text = 'cable static'::text);


--
-- TOC entry 417 (class 1259 OID 31641)
-- Name: view_component_collection_point; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_component_collection_point AS
 SELECT component.id AS component_id,
    component.description,
    component_discrete.width,
    component_discrete.length AS depth,
    component_discrete.height,
    component_discrete.dry_mass,
    component_discrete.wet_mass,
    component_collection_point.wet_frontal_area,
    component_collection_point.dry_frontal_area,
    component_collection_point.wet_beam_area,
    component_collection_point.dry_beam_area,
    component_collection_point.maximum_water_depth,
    component_collection_point.orientation_angle,
    component_collection_point.input_lines,
    component_collection_point.output_lines,
    component_collection_point.input_connector_type,
    component_collection_point.output_connector_type,
    component_collection_point.number_fibre_channels,
    component_collection_point.voltage_primary_winding,
    component_collection_point.voltage_secondary_winding,
    component_collection_point.rated_operating_current,
    component_collection_point.operational_temp_min,
    component_collection_point.operational_temp_max,
    component_collection_point.foundation_locations,
    component_collection_point.centre_of_gravity,
    component_discrete.cost,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM (((reference.component_collection_point
     JOIN reference.component_discrete ON ((component_collection_point.fk_component_discrete_id = component_discrete.id)))
     JOIN reference.component_shared ON ((component_discrete.fk_component_id = component_shared.fk_component_id)))
     JOIN reference.component ON ((component_discrete.fk_component_id = component.id)));


--
-- TOC entry 418 (class 1259 OID 31646)
-- Name: view_component_connector_drymate; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_component_connector_drymate AS
 SELECT component.id AS component_id,
    component.description,
    component_discrete.width,
    component_discrete.length AS depth,
    component_discrete.height,
    component_discrete.dry_mass,
    component_discrete.wet_mass,
    component_connector.maximum_water_depth,
    component_connector.number_contacts,
    component_connector.number_fibre_channels,
    component_connector.mating_force,
    component_connector.demating_force,
    component_connector.rated_voltage_u0,
    component_connector.rated_current,
    component_connector.cable_area_min,
    component_connector.cable_area_max,
    component_connector.operational_temp_min,
    component_connector.operational_temp_max,
    component_discrete.cost,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM ((((reference.component_connector
     JOIN reference.component_discrete ON ((component_connector.fk_component_discrete_id = component_discrete.id)))
     JOIN reference.component_shared ON ((component_discrete.fk_component_id = component_shared.fk_component_id)))
     JOIN reference.component ON ((component_discrete.fk_component_id = component.id)))
     JOIN reference.component_type ON ((component_connector.fk_component_type_id = component_type.id)))
  WHERE ((component_type.description)::text = 'connector dry-mate'::text);


--
-- TOC entry 419 (class 1259 OID 31651)
-- Name: view_component_connector_wetmate; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_component_connector_wetmate AS
 SELECT component.id AS component_id,
    component.description,
    component_discrete.width,
    component_discrete.length AS depth,
    component_discrete.height,
    component_discrete.dry_mass,
    component_discrete.wet_mass,
    component_connector.maximum_water_depth,
    component_connector.number_contacts,
    component_connector.number_fibre_channels,
    component_connector.mating_force,
    component_connector.demating_force,
    component_connector.rated_voltage_u0,
    component_connector.rated_current,
    component_connector.cable_area_min,
    component_connector.cable_area_max,
    component_connector.operational_temp_min,
    component_connector.operational_temp_max,
    component_discrete.cost,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM ((((reference.component_connector
     JOIN reference.component_discrete ON ((component_connector.fk_component_discrete_id = component_discrete.id)))
     JOIN reference.component_shared ON ((component_discrete.fk_component_id = component_shared.fk_component_id)))
     JOIN reference.component ON ((component_discrete.fk_component_id = component.id)))
     JOIN reference.component_type ON ((component_connector.fk_component_type_id = component_type.id)))
  WHERE ((component_type.description)::text = 'connector wet-mate'::text);


--
-- TOC entry 420 (class 1259 OID 31656)
-- Name: view_component_foundations_anchor; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_component_foundations_anchor AS
 SELECT component.id AS component_id,
    component.description,
    component_discrete.width,
    component_discrete.length AS depth,
    component_discrete.height,
    component_discrete.dry_mass,
    component_discrete.wet_mass,
    component_anchor.connecting_size,
    component_anchor.minimum_breaking_load,
    component_anchor.axial_stiffness,
    component_discrete.cost,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM (((reference.component_anchor
     JOIN reference.component_discrete ON ((component_anchor.fk_component_discrete_id = component_discrete.id)))
     JOIN reference.component_shared ON ((component_discrete.fk_component_id = component_shared.fk_component_id)))
     JOIN reference.component ON ((component_discrete.fk_component_id = component.id)));


--
-- TOC entry 421 (class 1259 OID 31661)
-- Name: view_component_foundations_anchor_coefs; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_component_foundations_anchor_coefs AS
 SELECT component.id AS component_id,
    component_anchor.soft_holding_cap_coef_1,
    component_anchor.soft_holding_cap_coef_2,
    component_anchor.soft_penetration_coef_1,
    component_anchor.soft_penetration_coef_2,
    component_anchor.sand_holding_cap_coef_1,
    component_anchor.sand_holding_cap_coef_2,
    component_anchor.sand_penetration_coef_1,
    component_anchor.sand_penetration_coef_2
   FROM ((reference.component_anchor
     JOIN reference.component_discrete ON ((component_anchor.fk_component_discrete_id = component_discrete.id)))
     JOIN reference.component ON ((component_discrete.fk_component_id = component.id)));


--
-- TOC entry 422 (class 1259 OID 31666)
-- Name: view_component_foundations_pile; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_component_foundations_pile AS
 SELECT component.id AS component_id,
    component.description,
    component_continuous.diameter,
    component_continuous.dry_mass_per_unit_length,
    component_continuous.wet_mass_per_unit_length,
    component_pile.wall_thickness,
    component_pile.yield_stress,
    component_pile.youngs_modulus,
    component_continuous.cost_per_unit_length,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM (((reference.component_pile
     JOIN reference.component_continuous ON ((component_pile.fk_component_continuous_id = component_continuous.id)))
     JOIN reference.component_shared ON ((component_continuous.fk_component_id = component_shared.fk_component_id)))
     JOIN reference.component ON ((component_continuous.fk_component_id = component.id)));


--
-- TOC entry 423 (class 1259 OID 31671)
-- Name: view_component_moorings_chain; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_component_moorings_chain AS
 SELECT component.id AS component_id,
    component.description,
    component_continuous.diameter,
    component_continuous.dry_mass_per_unit_length,
    component_continuous.wet_mass_per_unit_length,
    component_mooring_continuous.connecting_length,
    component_mooring_continuous.minimum_breaking_load,
    component_mooring_continuous.axial_stiffness,
    component_continuous.cost_per_unit_length,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM ((((reference.component_mooring_continuous
     JOIN reference.component_continuous ON ((component_mooring_continuous.fk_component_continuous_id = component_continuous.id)))
     JOIN reference.component_shared ON ((component_continuous.fk_component_id = component_shared.fk_component_id)))
     JOIN reference.component ON ((component_continuous.fk_component_id = component.id)))
     JOIN reference.component_type ON ((component_mooring_continuous.fk_component_type_id = component_type.id)))
  WHERE ((component_type.description)::text = 'chain'::text);


--
-- TOC entry 424 (class 1259 OID 31676)
-- Name: view_component_moorings_forerunner; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_component_moorings_forerunner AS
 SELECT component.id AS component_id,
    component.description,
    component_continuous.diameter,
    component_continuous.dry_mass_per_unit_length,
    component_continuous.wet_mass_per_unit_length,
    component_mooring_continuous.connecting_length,
    component_mooring_continuous.minimum_breaking_load,
    component_mooring_continuous.axial_stiffness,
    component_continuous.cost_per_unit_length,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM ((((reference.component_mooring_continuous
     JOIN reference.component_continuous ON ((component_mooring_continuous.fk_component_continuous_id = component_continuous.id)))
     JOIN reference.component_shared ON ((component_continuous.fk_component_id = component_shared.fk_component_id)))
     JOIN reference.component ON ((component_continuous.fk_component_id = component.id)))
     JOIN reference.component_type ON ((component_mooring_continuous.fk_component_type_id = component_type.id)))
  WHERE ((component_type.description)::text = 'forerunner'::text);


--
-- TOC entry 425 (class 1259 OID 31681)
-- Name: view_component_moorings_rope; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_component_moorings_rope AS
 SELECT component.id AS component_id,
    component.description,
    component_continuous.diameter,
    component_continuous.dry_mass_per_unit_length,
    component_continuous.wet_mass_per_unit_length,
    component_rope.material,
    component_rope.minimum_breaking_load,
    component_rope.rope_stiffness_curve,
    component_continuous.cost_per_unit_length,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM (((reference.component_rope
     JOIN reference.component_continuous ON ((component_rope.fk_component_continuous_id = component_continuous.id)))
     JOIN reference.component_shared ON ((component_continuous.fk_component_id = component_shared.fk_component_id)))
     JOIN reference.component ON ((component_continuous.fk_component_id = component.id)));


--
-- TOC entry 426 (class 1259 OID 31686)
-- Name: view_component_moorings_shackle; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_component_moorings_shackle AS
 SELECT component.id AS component_id,
    component.description,
    component_discrete.width,
    component_discrete.length AS depth,
    component_discrete.height,
    component_discrete.dry_mass,
    component_discrete.wet_mass,
    component_mooring_discrete.nominal_diameter,
    component_mooring_discrete.connecting_length,
    component_mooring_discrete.minimum_breaking_load,
    component_mooring_discrete.axial_stiffness,
    component_discrete.cost,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM ((((reference.component_mooring_discrete
     JOIN reference.component_discrete ON ((component_mooring_discrete.fk_component_discrete_id = component_discrete.id)))
     JOIN reference.component_shared ON ((component_discrete.fk_component_id = component_shared.fk_component_id)))
     JOIN reference.component ON ((component_discrete.fk_component_id = component.id)))
     JOIN reference.component_type ON ((component_mooring_discrete.fk_component_type_id = component_type.id)))
  WHERE ((component_type.description)::text = 'shackle'::text);


--
-- TOC entry 427 (class 1259 OID 31691)
-- Name: view_component_moorings_swivel; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_component_moorings_swivel AS
 SELECT component.id AS component_id,
    component.description,
    component_discrete.width,
    component_discrete.length AS depth,
    component_discrete.height,
    component_discrete.dry_mass,
    component_discrete.wet_mass,
    component_mooring_discrete.nominal_diameter,
    component_mooring_discrete.connecting_length,
    component_mooring_discrete.minimum_breaking_load,
    component_mooring_discrete.axial_stiffness,
    component_discrete.cost,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM ((((reference.component_mooring_discrete
     JOIN reference.component_discrete ON ((component_mooring_discrete.fk_component_discrete_id = component_discrete.id)))
     JOIN reference.component_shared ON ((component_discrete.fk_component_id = component_shared.fk_component_id)))
     JOIN reference.component ON ((component_discrete.fk_component_id = component.id)))
     JOIN reference.component_type ON ((component_mooring_discrete.fk_component_type_id = component_type.id)))
  WHERE ((component_type.description)::text = 'swivel'::text);


--
-- TOC entry 428 (class 1259 OID 31696)
-- Name: view_component_transformer; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_component_transformer AS
 SELECT component.id AS component_id,
    component.description,
    component_discrete.width,
    component_discrete.length AS depth,
    component_discrete.height,
    component_discrete.dry_mass,
    component_discrete.wet_mass,
    component_transformer.maximum_water_depth,
    component_transformer.power_rating,
    component_transformer.impedance,
    component_transformer.windings,
    component_transformer.voltage_primary_winding,
    component_transformer.voltage_secondary_winding,
    component_transformer.voltage_tertiary_winding,
    component_transformer.operational_temp_min,
    component_transformer.operational_temp_max,
    component_discrete.cost,
    component_shared.preparation_person_hours,
    component_shared.inspection_person_hours,
    component_shared.maintenance_person_hours,
    component_shared.replacement_person_hours,
    component_shared.ncfr_lower_bound,
    component_shared.ncfr_mean,
    component_shared.ncfr_upper_bound,
    component_shared.cfr_lower_bound,
    component_shared.cfr_mean,
    component_shared.cfr_upper_bound,
    component_shared.environmental_impact
   FROM (((reference.component_transformer
     JOIN reference.component_discrete ON ((component_transformer.fk_component_discrete_id = component_discrete.id)))
     JOIN reference.component_shared ON ((component_discrete.fk_component_id = component_shared.fk_component_id)))
     JOIN reference.component ON ((component_discrete.fk_component_id = component.id)));


--
-- TOC entry 429 (class 1259 OID 31701)
-- Name: view_operations_limit_cs; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_operations_limit_cs AS
 SELECT operations_type.description AS operations_type,
    operations_limit_cs.cs_limit
   FROM (reference.operations_limit_cs
     JOIN reference.operations_type ON ((operations_limit_cs.fk_operations_id = operations_type.id)));


--
-- TOC entry 430 (class 1259 OID 31705)
-- Name: view_operations_limit_hs; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_operations_limit_hs AS
 SELECT operations_type.description AS operations_type,
    operations_limit_hs.hs_limit
   FROM (reference.operations_limit_hs
     JOIN reference.operations_type ON ((operations_limit_hs.fk_operations_id = operations_type.id)));


--
-- TOC entry 431 (class 1259 OID 31709)
-- Name: view_operations_limit_tp; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_operations_limit_tp AS
 SELECT operations_type.description AS operations_type,
    operations_limit_tp.tp_limit
   FROM (reference.operations_limit_tp
     JOIN reference.operations_type ON ((operations_limit_tp.fk_operations_id = operations_type.id)));


--
-- TOC entry 432 (class 1259 OID 31713)
-- Name: view_operations_limit_ws; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_operations_limit_ws AS
 SELECT operations_type.description AS operations_type,
    operations_limit_ws.ws_limit
   FROM (reference.operations_limit_ws
     JOIN reference.operations_type ON ((operations_limit_ws.fk_operations_id = operations_type.id)));


--
-- TOC entry 433 (class 1259 OID 31717)
-- Name: view_soil_type_geotechnical_properties; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_soil_type_geotechnical_properties AS
 SELECT soil_type.description AS soil_type,
    soil_type_geotechnical_properties.drained_soil_friction_angle,
    soil_type_geotechnical_properties.relative_soil_density,
    soil_type_geotechnical_properties.buoyant_unit_weight_of_soil,
    soil_type_geotechnical_properties.undrained_soil_shear_strength_constant_term,
    soil_type_geotechnical_properties.undrained_soil_shear_strength_depth_dependent_term,
    soil_type_geotechnical_properties.effective_drained_cohesion,
    soil_type_geotechnical_properties.seafloor_friction_coefficient,
    soil_type_geotechnical_properties.soil_sensitivity,
    soil_type_geotechnical_properties.rock_compressive_strength
   FROM (reference.soil_type_geotechnical_properties
     JOIN reference.soil_type ON ((soil_type_geotechnical_properties.fk_soil_type_id = soil_type.id)));


--
-- TOC entry 434 (class 1259 OID 31721)
-- Name: view_vehicle_helicopter; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_vehicle_helicopter AS
 SELECT vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    vehicle_shared.consumption,
    vehicle_shared.transit_speed,
    vehicle_helicopter.deck_space,
    vehicle_helicopter.max_deck_load_pressure,
    vehicle_helicopter.max_cargo_mass,
    vehicle_helicopter.crane_max_load_mass,
    vehicle_helicopter.external_personel,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM ((reference.vehicle_helicopter
     JOIN reference.vehicle_shared ON ((vehicle_helicopter.fk_vehicle_id = vehicle_shared.fk_vehicle_id)))
     JOIN reference.vehicle ON ((vehicle_shared.fk_vehicle_id = vehicle.id)));


--
-- TOC entry 435 (class 1259 OID 31726)
-- Name: view_vehicle_vessel_ahts; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_vehicle_vessel_ahts AS
 SELECT vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    vehicle_vessel_anchor_handling.beam,
    vehicle_vessel_anchor_handling.max_draft,
    vehicle_shared.consumption,
    vehicle_vessel_anchor_handling.consumption_towing,
    vehicle_shared.transit_speed,
    vehicle_vessel_anchor_handling.deck_space,
    vehicle_vessel_anchor_handling.max_deck_load_pressure,
    vehicle_vessel_anchor_handling.max_cargo_mass,
    vehicle_vessel_anchor_handling.crane_max_load_mass,
    vehicle_vessel_anchor_handling.bollard_pull,
    vehicle_vessel_anchor_handling.anchor_handling_drum_capacity,
    vehicle_vessel_anchor_handling.anchor_handling_winch_rated_pull,
    vehicle_vessel_anchor_handling.external_personel,
    vehicle_vessel_anchor_handling.towing_max_hs,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM (((reference.vehicle_vessel_anchor_handling
     JOIN reference.vehicle_shared ON ((vehicle_vessel_anchor_handling.fk_vehicle_id = vehicle_shared.fk_vehicle_id)))
     JOIN reference.vehicle ON ((vehicle_shared.fk_vehicle_id = vehicle.id)))
     JOIN reference.vehicle_type ON ((vehicle_vessel_anchor_handling.fk_vehicle_type_id = vehicle_type.id)))
  WHERE ((vehicle_type.description)::text = 'anchor handling tug supply vessel'::text);


--
-- TOC entry 436 (class 1259 OID 31731)
-- Name: view_vehicle_vessel_barge; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_vehicle_vessel_barge AS
 SELECT vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    vehicle_vessel_cargo.beam,
    vehicle_vessel_cargo.max_draft,
    vehicle_shared.consumption,
    vehicle_shared.transit_speed,
    vehicle_vessel_cargo.deck_space,
    vehicle_vessel_cargo.max_deck_load_pressure,
    vehicle_vessel_cargo.max_cargo_mass,
    vehicle_vessel_cargo.crane_max_load_mass,
    vehicle_vessel_cargo.dynamic_positioning_capabilities,
    vehicle_vessel_cargo.external_personel,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM (((reference.vehicle_vessel_cargo
     JOIN reference.vehicle_shared ON ((vehicle_vessel_cargo.fk_vehicle_id = vehicle_shared.fk_vehicle_id)))
     JOIN reference.vehicle ON ((vehicle_shared.fk_vehicle_id = vehicle.id)))
     JOIN reference.vehicle_type ON ((vehicle_vessel_cargo.fk_vehicle_type_id = vehicle_type.id)))
  WHERE ((vehicle_type.description)::text = 'barge'::text);


--
-- TOC entry 437 (class 1259 OID 31736)
-- Name: view_vehicle_vessel_clb; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_vehicle_vessel_clb AS
 SELECT vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    vehicle_vessel_cable_laying.beam,
    vehicle_vessel_cable_laying.max_draft,
    vehicle_shared.consumption,
    vehicle_shared.transit_speed,
    vehicle_vessel_cable_laying.deck_space,
    vehicle_vessel_cable_laying.max_deck_load_pressure,
    vehicle_vessel_cable_laying.max_cargo_mass,
    vehicle_vessel_cable_laying.crane_max_load_mass,
    vehicle_vessel_cable_laying.number_turntables,
    vehicle_vessel_cable_laying.turntable_max_load_mass,
    vehicle_vessel_cable_laying.turntable_inner_diameter,
    vehicle_vessel_cable_laying.cable_splice_capabilities,
    vehicle_vessel_cable_laying.dynamic_positioning_capabilities,
    vehicle_vessel_cable_laying.external_personel,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM (((reference.vehicle_vessel_cable_laying
     JOIN reference.vehicle_shared ON ((vehicle_vessel_cable_laying.fk_vehicle_id = vehicle_shared.fk_vehicle_id)))
     JOIN reference.vehicle ON ((vehicle_shared.fk_vehicle_id = vehicle.id)))
     JOIN reference.vehicle_type ON ((vehicle_vessel_cable_laying.fk_vehicle_type_id = vehicle_type.id)))
  WHERE ((vehicle_type.description)::text = 'cable laying barge'::text);


--
-- TOC entry 438 (class 1259 OID 31741)
-- Name: view_vehicle_vessel_clv; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_vehicle_vessel_clv AS
 SELECT vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    vehicle_vessel_cable_laying.beam,
    vehicle_vessel_cable_laying.max_draft,
    vehicle_shared.consumption,
    vehicle_shared.transit_speed,
    vehicle_vessel_cable_laying.deck_space,
    vehicle_vessel_cable_laying.max_deck_load_pressure,
    vehicle_vessel_cable_laying.max_cargo_mass,
    vehicle_vessel_cable_laying.crane_max_load_mass,
    vehicle_vessel_cable_laying.bollard_pull,
    vehicle_vessel_cable_laying.number_turntables,
    vehicle_vessel_cable_laying.turntable_max_load_mass,
    vehicle_vessel_cable_laying.turntable_inner_diameter,
    vehicle_vessel_cable_laying.cable_splice_capabilities,
    vehicle_vessel_cable_laying.dynamic_positioning_capabilities,
    vehicle_vessel_cable_laying.external_personel,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM (((reference.vehicle_vessel_cable_laying
     JOIN reference.vehicle_shared ON ((vehicle_vessel_cable_laying.fk_vehicle_id = vehicle_shared.fk_vehicle_id)))
     JOIN reference.vehicle ON ((vehicle_shared.fk_vehicle_id = vehicle.id)))
     JOIN reference.vehicle_type ON ((vehicle_vessel_cable_laying.fk_vehicle_type_id = vehicle_type.id)))
  WHERE ((vehicle_type.description)::text = 'cable laying vessel'::text);


--
-- TOC entry 439 (class 1259 OID 31746)
-- Name: view_vehicle_vessel_crane_barge; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_vehicle_vessel_crane_barge AS
 SELECT vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    vehicle_vessel_cargo.beam,
    vehicle_vessel_cargo.max_draft,
    vehicle_shared.consumption,
    vehicle_shared.transit_speed,
    vehicle_vessel_cargo.deck_space,
    vehicle_vessel_cargo.max_deck_load_pressure,
    vehicle_vessel_cargo.max_cargo_mass,
    vehicle_vessel_cargo.crane_max_load_mass,
    vehicle_vessel_cargo.dynamic_positioning_capabilities,
    vehicle_vessel_cargo.external_personel,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM (((reference.vehicle_vessel_cargo
     JOIN reference.vehicle_shared ON ((vehicle_vessel_cargo.fk_vehicle_id = vehicle_shared.fk_vehicle_id)))
     JOIN reference.vehicle ON ((vehicle_shared.fk_vehicle_id = vehicle.id)))
     JOIN reference.vehicle_type ON ((vehicle_vessel_cargo.fk_vehicle_type_id = vehicle_type.id)))
  WHERE ((vehicle_type.description)::text = 'crane barge'::text);


--
-- TOC entry 440 (class 1259 OID 31751)
-- Name: view_vehicle_vessel_crane_vessel; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_vehicle_vessel_crane_vessel AS
 SELECT vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    vehicle_vessel_cargo.beam,
    vehicle_vessel_cargo.max_draft,
    vehicle_shared.consumption,
    vehicle_shared.transit_speed,
    vehicle_vessel_cargo.deck_space,
    vehicle_vessel_cargo.max_deck_load_pressure,
    vehicle_vessel_cargo.max_cargo_mass,
    vehicle_vessel_cargo.crane_max_load_mass,
    vehicle_vessel_cargo.dynamic_positioning_capabilities,
    vehicle_vessel_cargo.external_personel,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM (((reference.vehicle_vessel_cargo
     JOIN reference.vehicle_shared ON ((vehicle_vessel_cargo.fk_vehicle_id = vehicle_shared.fk_vehicle_id)))
     JOIN reference.vehicle ON ((vehicle_shared.fk_vehicle_id = vehicle.id)))
     JOIN reference.vehicle_type ON ((vehicle_vessel_cargo.fk_vehicle_type_id = vehicle_type.id)))
  WHERE ((vehicle_type.description)::text = 'crane vessel'::text);


--
-- TOC entry 441 (class 1259 OID 31756)
-- Name: view_vehicle_vessel_csv; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_vehicle_vessel_csv AS
 SELECT vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    vehicle_vessel_cargo.beam,
    vehicle_vessel_cargo.max_draft,
    vehicle_shared.consumption,
    vehicle_shared.transit_speed,
    vehicle_vessel_cargo.deck_space,
    vehicle_vessel_cargo.max_deck_load_pressure,
    vehicle_vessel_cargo.max_cargo_mass,
    vehicle_vessel_cargo.crane_max_load_mass,
    vehicle_vessel_cargo.dynamic_positioning_capabilities,
    vehicle_vessel_cargo.external_personel,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM (((reference.vehicle_vessel_cargo
     JOIN reference.vehicle_shared ON ((vehicle_vessel_cargo.fk_vehicle_id = vehicle_shared.fk_vehicle_id)))
     JOIN reference.vehicle ON ((vehicle_shared.fk_vehicle_id = vehicle.id)))
     JOIN reference.vehicle_type ON ((vehicle_vessel_cargo.fk_vehicle_type_id = vehicle_type.id)))
  WHERE ((vehicle_type.description)::text = 'construction support vessel'::text);


--
-- TOC entry 442 (class 1259 OID 31761)
-- Name: view_vehicle_vessel_ctv; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_vehicle_vessel_ctv AS
 SELECT vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    vehicle_vessel_cargo.beam,
    vehicle_vessel_cargo.max_draft,
    vehicle_shared.consumption,
    vehicle_shared.transit_speed,
    vehicle_vessel_cargo.deck_space,
    vehicle_vessel_cargo.max_deck_load_pressure,
    vehicle_vessel_cargo.max_cargo_mass,
    vehicle_vessel_cargo.crane_max_load_mass,
    vehicle_vessel_cargo.dynamic_positioning_capabilities,
    vehicle_vessel_cargo.external_personel,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM (((reference.vehicle_vessel_cargo
     JOIN reference.vehicle_shared ON ((vehicle_vessel_cargo.fk_vehicle_id = vehicle_shared.fk_vehicle_id)))
     JOIN reference.vehicle ON ((vehicle_shared.fk_vehicle_id = vehicle.id)))
     JOIN reference.vehicle_type ON ((vehicle_vessel_cargo.fk_vehicle_type_id = vehicle_type.id)))
  WHERE ((vehicle_type.description)::text = 'crew transfer vessel'::text);


--
-- TOC entry 443 (class 1259 OID 31766)
-- Name: view_vehicle_vessel_jackup_barge; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_vehicle_vessel_jackup_barge AS
 SELECT vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    vehicle_vessel_jackup.beam,
    vehicle_vessel_jackup.max_draft,
    vehicle_shared.consumption,
    vehicle_shared.transit_speed,
    vehicle_vessel_jackup.deck_space,
    vehicle_vessel_jackup.max_deck_load_pressure,
    vehicle_vessel_jackup.max_cargo_mass,
    vehicle_vessel_jackup.crane_max_load_mass,
    vehicle_vessel_jackup.dynamic_positioning_capabilities,
    vehicle_vessel_jackup.external_personel,
    vehicle_vessel_jackup.jackup_max_water_depth,
    vehicle_vessel_jackup.jackup_speed_down,
    vehicle_vessel_jackup.jackup_max_payload_mass,
    vehicle_vessel_jackup.jacking_max_hs,
    vehicle_vessel_jackup.jacking_max_tp,
    vehicle_vessel_jackup.jacking_max_cs,
    vehicle_vessel_jackup.jacking_max_ws,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM (((reference.vehicle_vessel_jackup
     JOIN reference.vehicle_shared ON ((vehicle_vessel_jackup.fk_vehicle_id = vehicle_shared.fk_vehicle_id)))
     JOIN reference.vehicle ON ((vehicle_shared.fk_vehicle_id = vehicle.id)))
     JOIN reference.vehicle_type ON ((vehicle_vessel_jackup.fk_vehicle_type_id = vehicle_type.id)))
  WHERE ((vehicle_type.description)::text = 'jackup barge'::text);


--
-- TOC entry 444 (class 1259 OID 31771)
-- Name: view_vehicle_vessel_jackup_vessel; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_vehicle_vessel_jackup_vessel AS
 SELECT vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    vehicle_vessel_jackup.beam,
    vehicle_vessel_jackup.max_draft,
    vehicle_shared.consumption,
    vehicle_shared.transit_speed,
    vehicle_vessel_jackup.deck_space,
    vehicle_vessel_jackup.max_deck_load_pressure,
    vehicle_vessel_jackup.max_cargo_mass,
    vehicle_vessel_jackup.crane_max_load_mass,
    vehicle_vessel_jackup.dynamic_positioning_capabilities,
    vehicle_vessel_jackup.external_personel,
    vehicle_vessel_jackup.jackup_max_water_depth,
    vehicle_vessel_jackup.jackup_speed_down,
    vehicle_vessel_jackup.jackup_max_payload_mass,
    vehicle_vessel_jackup.jacking_max_hs,
    vehicle_vessel_jackup.jacking_max_tp,
    vehicle_vessel_jackup.jacking_max_cs,
    vehicle_vessel_jackup.jacking_max_ws,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM (((reference.vehicle_vessel_jackup
     JOIN reference.vehicle_shared ON ((vehicle_vessel_jackup.fk_vehicle_id = vehicle_shared.fk_vehicle_id)))
     JOIN reference.vehicle ON ((vehicle_shared.fk_vehicle_id = vehicle.id)))
     JOIN reference.vehicle_type ON ((vehicle_vessel_jackup.fk_vehicle_type_id = vehicle_type.id)))
  WHERE ((vehicle_type.description)::text = 'jackup vessel'::text);


--
-- TOC entry 445 (class 1259 OID 31776)
-- Name: view_vehicle_vessel_multicat; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_vehicle_vessel_multicat AS
 SELECT vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    vehicle_vessel_anchor_handling.beam,
    vehicle_vessel_anchor_handling.max_draft,
    vehicle_shared.consumption,
    vehicle_vessel_anchor_handling.consumption_towing,
    vehicle_shared.transit_speed,
    vehicle_vessel_anchor_handling.deck_space,
    vehicle_vessel_anchor_handling.max_deck_load_pressure,
    vehicle_vessel_anchor_handling.max_cargo_mass,
    vehicle_vessel_anchor_handling.crane_max_load_mass,
    vehicle_vessel_anchor_handling.bollard_pull,
    vehicle_vessel_anchor_handling.anchor_handling_drum_capacity,
    vehicle_vessel_anchor_handling.anchor_handling_winch_rated_pull,
    vehicle_vessel_anchor_handling.external_personel,
    vehicle_vessel_anchor_handling.towing_max_hs,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM (((reference.vehicle_vessel_anchor_handling
     JOIN reference.vehicle_shared ON ((vehicle_vessel_anchor_handling.fk_vehicle_id = vehicle_shared.fk_vehicle_id)))
     JOIN reference.vehicle ON ((vehicle_shared.fk_vehicle_id = vehicle.id)))
     JOIN reference.vehicle_type ON ((vehicle_vessel_anchor_handling.fk_vehicle_type_id = vehicle_type.id)))
  WHERE ((vehicle_type.description)::text = 'multicat'::text);


--
-- TOC entry 446 (class 1259 OID 31781)
-- Name: view_vehicle_vessel_tugboat; Type: VIEW; Schema: reference; Owner: -
--

CREATE VIEW reference.view_vehicle_vessel_tugboat AS
 SELECT vehicle.description,
    vehicle_shared.gross_tonnage,
    vehicle_shared.length,
    vehicle_vessel_tugboat.beam,
    vehicle_vessel_tugboat.max_draft,
    vehicle_shared.consumption,
    vehicle_vessel_tugboat.consumption_towing,
    vehicle_shared.transit_speed,
    vehicle_vessel_tugboat.bollard_pull,
    vehicle_shared.transit_max_hs,
    vehicle_shared.transit_max_tp,
    vehicle_shared.transit_max_cs,
    vehicle_shared.transit_max_ws,
    vehicle_shared.mobilisation_time,
    vehicle_shared.mobilisation_percentage_cost,
    vehicle_shared.min_day_rate,
    vehicle_shared.max_day_rate
   FROM ((reference.vehicle_vessel_tugboat
     JOIN reference.vehicle_shared ON ((vehicle_vessel_tugboat.fk_vehicle_id = vehicle_shared.fk_vehicle_id)))
     JOIN reference.vehicle ON ((vehicle_shared.fk_vehicle_id = vehicle.id)));


--
-- TOC entry 4999 (class 2604 OID 31786)
-- Name: bathymetry id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.bathymetry ALTER COLUMN id SET DEFAULT nextval('project.bathymetry_id_seq'::regclass);


--
-- TOC entry 5001 (class 2604 OID 31787)
-- Name: cable_corridor_bathymetry id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.cable_corridor_bathymetry ALTER COLUMN id SET DEFAULT nextval('project.cable_corridor_bathymetry_id_seq'::regclass);


--
-- TOC entry 5002 (class 2604 OID 31788)
-- Name: cable_corridor_bathymetry_layer id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.cable_corridor_bathymetry_layer ALTER COLUMN id SET DEFAULT nextval('project.cable_corridor_bathymetry_layer_id_seq'::regclass);


--
-- TOC entry 5003 (class 2604 OID 31789)
-- Name: cable_corridor_constraint id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.cable_corridor_constraint ALTER COLUMN id SET DEFAULT nextval('project.cable_corridor_constraint_id_seq'::regclass);


--
-- TOC entry 5004 (class 2604 OID 31790)
-- Name: device id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.device ALTER COLUMN id SET DEFAULT nextval('project.device_id_seq'::regclass);


--
-- TOC entry 5006 (class 2604 OID 31791)
-- Name: device_floating id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.device_floating ALTER COLUMN id SET DEFAULT nextval('project.device_floating_id_seq'::regclass);


--
-- TOC entry 5007 (class 2604 OID 31792)
-- Name: device_shared id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.device_shared ALTER COLUMN id SET DEFAULT nextval('project.device_shared_id_seq'::regclass);


--
-- TOC entry 5012 (class 2604 OID 31793)
-- Name: device_tidal id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.device_tidal ALTER COLUMN id SET DEFAULT nextval('project.device_tidal_id_seq'::regclass);


--
-- TOC entry 5013 (class 2604 OID 31794)
-- Name: device_tidal_power_performance id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.device_tidal_power_performance ALTER COLUMN id SET DEFAULT nextval('project.device_tidal_power_performance_id_seq'::regclass);


--
-- TOC entry 5014 (class 2604 OID 31795)
-- Name: device_wave id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.device_wave ALTER COLUMN id SET DEFAULT nextval('project.device_wave_id_seq'::regclass);


--
-- TOC entry 5015 (class 2604 OID 31796)
-- Name: lease_area id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.lease_area ALTER COLUMN id SET DEFAULT nextval('project.lease_area_id_seq'::regclass);


--
-- TOC entry 5018 (class 2604 OID 31797)
-- Name: site id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.site ALTER COLUMN id SET DEFAULT nextval('project.site_id_seq'::regclass);


--
-- TOC entry 4997 (class 2604 OID 31798)
-- Name: sub_systems id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems ALTER COLUMN id SET DEFAULT nextval('project.sub_systems_id_seq'::regclass);


--
-- TOC entry 5019 (class 2604 OID 31799)
-- Name: sub_systems_access id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_access ALTER COLUMN id SET DEFAULT nextval('project.sub_systems_access_id_seq'::regclass);


--
-- TOC entry 5020 (class 2604 OID 31800)
-- Name: sub_systems_economic id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_economic ALTER COLUMN id SET DEFAULT nextval('project.sub_systems_economic_id_seq'::regclass);


--
-- TOC entry 5021 (class 2604 OID 31801)
-- Name: sub_systems_inspection id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_inspection ALTER COLUMN id SET DEFAULT nextval('project.sub_systems_inspection_id_seq'::regclass);


--
-- TOC entry 5022 (class 2604 OID 31802)
-- Name: sub_systems_install id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_install ALTER COLUMN id SET DEFAULT nextval('project.sub_systems_install_id_seq'::regclass);


--
-- TOC entry 5023 (class 2604 OID 31803)
-- Name: sub_systems_maintenance id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_maintenance ALTER COLUMN id SET DEFAULT nextval('project.sub_systems_maintenance_id_seq'::regclass);


--
-- TOC entry 5024 (class 2604 OID 31804)
-- Name: sub_systems_operation_weightings id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_operation_weightings ALTER COLUMN id SET DEFAULT nextval('project.sub_systems_operation_weightings_id_seq'::regclass);


--
-- TOC entry 5025 (class 2604 OID 31805)
-- Name: sub_systems_replace id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_replace ALTER COLUMN id SET DEFAULT nextval('project.sub_systems_replace_id_seq'::regclass);


--
-- TOC entry 5026 (class 2604 OID 31806)
-- Name: time_series_energy_tidal id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.time_series_energy_tidal ALTER COLUMN id SET DEFAULT nextval('project.time_series_energy_tidal_id_seq'::regclass);


--
-- TOC entry 5027 (class 2604 OID 31807)
-- Name: time_series_energy_wave id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.time_series_energy_wave ALTER COLUMN id SET DEFAULT nextval('project.time_series_energy_wave_id_seq'::regclass);


--
-- TOC entry 5028 (class 2604 OID 31808)
-- Name: time_series_om_tidal id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.time_series_om_tidal ALTER COLUMN id SET DEFAULT nextval('project.time_series_om_tidal_id_seq'::regclass);


--
-- TOC entry 5029 (class 2604 OID 31809)
-- Name: time_series_om_wave id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.time_series_om_wave ALTER COLUMN id SET DEFAULT nextval('project.time_series_om_wave_id_seq'::regclass);


--
-- TOC entry 5030 (class 2604 OID 31810)
-- Name: time_series_om_wind id; Type: DEFAULT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.time_series_om_wind ALTER COLUMN id SET DEFAULT nextval('project.time_series_om_wind_id_seq'::regclass);


--
-- TOC entry 5031 (class 2604 OID 31811)
-- Name: component id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component ALTER COLUMN id SET DEFAULT nextval('reference.component_id_seq'::regclass);


--
-- TOC entry 5032 (class 2604 OID 31812)
-- Name: component_anchor id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_anchor ALTER COLUMN id SET DEFAULT nextval('reference.component_anchor_id_seq'::regclass);


--
-- TOC entry 5034 (class 2604 OID 31813)
-- Name: component_cable id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_cable ALTER COLUMN id SET DEFAULT nextval('reference.component_cable_id_seq'::regclass);


--
-- TOC entry 5036 (class 2604 OID 31814)
-- Name: component_collection_point id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_collection_point ALTER COLUMN id SET DEFAULT nextval('reference.component_collection_point_id_seq'::regclass);


--
-- TOC entry 5040 (class 2604 OID 31815)
-- Name: component_connector id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_connector ALTER COLUMN id SET DEFAULT nextval('reference.component_connector_id_seq'::regclass);


--
-- TOC entry 5042 (class 2604 OID 31816)
-- Name: component_continuous id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_continuous ALTER COLUMN id SET DEFAULT nextval('reference.component_continuous_id_seq'::regclass);


--
-- TOC entry 5043 (class 2604 OID 31817)
-- Name: component_discrete id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_discrete ALTER COLUMN id SET DEFAULT nextval('reference.component_discrete_id_seq'::regclass);


--
-- TOC entry 5044 (class 2604 OID 31818)
-- Name: component_mooring_continuous id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_mooring_continuous ALTER COLUMN id SET DEFAULT nextval('reference.component_mooring_continuous_id_seq'::regclass);


--
-- TOC entry 5046 (class 2604 OID 31819)
-- Name: component_mooring_discrete id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_mooring_discrete ALTER COLUMN id SET DEFAULT nextval('reference.component_mooring_discrete_id_seq'::regclass);


--
-- TOC entry 5048 (class 2604 OID 31820)
-- Name: component_pile id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_pile ALTER COLUMN id SET DEFAULT nextval('reference.component_pile_id_seq'::regclass);


--
-- TOC entry 5050 (class 2604 OID 31821)
-- Name: component_rope id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_rope ALTER COLUMN id SET DEFAULT nextval('reference.component_rope_id_seq'::regclass);


--
-- TOC entry 5053 (class 2604 OID 31822)
-- Name: component_shared id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_shared ALTER COLUMN id SET DEFAULT nextval('reference.component_shared_id_seq'::regclass);


--
-- TOC entry 5054 (class 2604 OID 31823)
-- Name: component_transformer id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_transformer ALTER COLUMN id SET DEFAULT nextval('reference.component_transformer_id_seq'::regclass);


--
-- TOC entry 5056 (class 2604 OID 31824)
-- Name: component_type id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_type ALTER COLUMN id SET DEFAULT nextval('reference.component_type_id_seq'::regclass);


--
-- TOC entry 5058 (class 2604 OID 31825)
-- Name: equipment_cable_burial id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_cable_burial ALTER COLUMN id SET DEFAULT nextval('reference.equipment_cable_burial_id_seq'::regclass);


--
-- TOC entry 5059 (class 2604 OID 31826)
-- Name: equipment_divers id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_divers ALTER COLUMN id SET DEFAULT nextval('reference.equipment_divers_id_seq'::regclass);


--
-- TOC entry 5060 (class 2604 OID 31827)
-- Name: equipment_drilling_rigs id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_drilling_rigs ALTER COLUMN id SET DEFAULT nextval('reference.equipment_drilling_rigs_id_seq'::regclass);


--
-- TOC entry 5061 (class 2604 OID 31828)
-- Name: equipment_excavating id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_excavating ALTER COLUMN id SET DEFAULT nextval('reference.equipment_excavating_id_seq'::regclass);


--
-- TOC entry 5062 (class 2604 OID 31829)
-- Name: equipment_hammer id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_hammer ALTER COLUMN id SET DEFAULT nextval('reference.equipment_hammer_id_seq'::regclass);


--
-- TOC entry 5063 (class 2604 OID 31830)
-- Name: equipment_mattress id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_mattress ALTER COLUMN id SET DEFAULT nextval('reference.equipment_mattress_id_seq'::regclass);


--
-- TOC entry 5064 (class 2604 OID 31831)
-- Name: equipment_rock_filter_bags id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_rock_filter_bags ALTER COLUMN id SET DEFAULT nextval('reference.equipment_rock_filter_bags_id_seq'::regclass);


--
-- TOC entry 5065 (class 2604 OID 31832)
-- Name: equipment_rov id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_rov ALTER COLUMN id SET DEFAULT nextval('reference.equipment_rov_id_seq'::regclass);


--
-- TOC entry 5067 (class 2604 OID 31833)
-- Name: equipment_split_pipe id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_split_pipe ALTER COLUMN id SET DEFAULT nextval('reference.equipment_split_pipe_id_seq'::regclass);


--
-- TOC entry 5068 (class 2604 OID 31834)
-- Name: equipment_vibro_driver id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_vibro_driver ALTER COLUMN id SET DEFAULT nextval('reference.equipment_vibro_driver_id_seq'::regclass);


--
-- TOC entry 5069 (class 2604 OID 31835)
-- Name: operations_limit_cs id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.operations_limit_cs ALTER COLUMN id SET DEFAULT nextval('reference.operations_limit_cs_id_seq'::regclass);


--
-- TOC entry 5070 (class 2604 OID 31836)
-- Name: operations_limit_hs id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.operations_limit_hs ALTER COLUMN id SET DEFAULT nextval('reference.operations_limit_hs_id_seq'::regclass);


--
-- TOC entry 5071 (class 2604 OID 31837)
-- Name: operations_limit_tp id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.operations_limit_tp ALTER COLUMN id SET DEFAULT nextval('reference.operations_limit_tp_id_seq'::regclass);


--
-- TOC entry 5072 (class 2604 OID 31838)
-- Name: operations_limit_ws id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.operations_limit_ws ALTER COLUMN id SET DEFAULT nextval('reference.operations_limit_ws_id_seq'::regclass);


--
-- TOC entry 5073 (class 2604 OID 31839)
-- Name: operations_type id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.operations_type ALTER COLUMN id SET DEFAULT nextval('reference.operations_type_id_seq'::regclass);


--
-- TOC entry 5074 (class 2604 OID 31840)
-- Name: ports id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.ports ALTER COLUMN id SET DEFAULT nextval('reference.ports_id_seq'::regclass);


--
-- TOC entry 4996 (class 2604 OID 31841)
-- Name: soil_type id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.soil_type ALTER COLUMN id SET DEFAULT nextval('reference.soil_type_id_seq'::regclass);


--
-- TOC entry 5076 (class 2604 OID 31842)
-- Name: vehicle id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle ALTER COLUMN id SET DEFAULT nextval('reference.vehicle_id_seq'::regclass);


--
-- TOC entry 5077 (class 2604 OID 31843)
-- Name: vehicle_helicopter id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_helicopter ALTER COLUMN id SET DEFAULT nextval('reference.vehicle_helicopter_id_seq'::regclass);


--
-- TOC entry 5079 (class 2604 OID 31844)
-- Name: vehicle_shared id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_shared ALTER COLUMN id SET DEFAULT nextval('reference.vehicle_shared_id_seq'::regclass);


--
-- TOC entry 5080 (class 2604 OID 31845)
-- Name: vehicle_type id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_type ALTER COLUMN id SET DEFAULT nextval('reference.vehicle_type_id_seq'::regclass);


--
-- TOC entry 5081 (class 2604 OID 31846)
-- Name: vehicle_vessel_anchor_handling id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_vessel_anchor_handling ALTER COLUMN id SET DEFAULT nextval('reference.vehicle_vessel_anchor_handling_id_seq'::regclass);


--
-- TOC entry 5083 (class 2604 OID 31847)
-- Name: vehicle_vessel_cable_laying id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_vessel_cable_laying ALTER COLUMN id SET DEFAULT nextval('reference.vehicle_vessel_cable_laying_id_seq'::regclass);


--
-- TOC entry 5085 (class 2604 OID 31848)
-- Name: vehicle_vessel_cargo id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_vessel_cargo ALTER COLUMN id SET DEFAULT nextval('reference.vehicle_vessel_cargo_id_seq'::regclass);


--
-- TOC entry 5087 (class 2604 OID 31849)
-- Name: vehicle_vessel_jackup id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_vessel_jackup ALTER COLUMN id SET DEFAULT nextval('reference.vehicle_vessel_jackup_id_seq'::regclass);


--
-- TOC entry 5089 (class 2604 OID 31850)
-- Name: vehicle_vessel_tugboat id; Type: DEFAULT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_vessel_tugboat ALTER COLUMN id SET DEFAULT nextval('reference.vehicle_vessel_tugboat_id_seq'::regclass);


--
-- TOC entry 5102 (class 2606 OID 31852)
-- Name: bathymetry_layer bathymetry_layer_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.bathymetry_layer
    ADD CONSTRAINT bathymetry_layer_pkey PRIMARY KEY (id);


--
-- TOC entry 5098 (class 2606 OID 31854)
-- Name: bathymetry bathymetry_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.bathymetry
    ADD CONSTRAINT bathymetry_pkey PRIMARY KEY (id);


--
-- TOC entry 5109 (class 2606 OID 31856)
-- Name: cable_corridor_bathymetry_layer cable_corridor_bathymetry_layer_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.cable_corridor_bathymetry_layer
    ADD CONSTRAINT cable_corridor_bathymetry_layer_pkey PRIMARY KEY (id);


--
-- TOC entry 5105 (class 2606 OID 31858)
-- Name: cable_corridor_bathymetry cable_corridor_bathymetry_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.cable_corridor_bathymetry
    ADD CONSTRAINT cable_corridor_bathymetry_pkey PRIMARY KEY (id);


--
-- TOC entry 5112 (class 2606 OID 31860)
-- Name: cable_corridor_constraint cable_corridor_constraint_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.cable_corridor_constraint
    ADD CONSTRAINT cable_corridor_constraint_pkey PRIMARY KEY (id);


--
-- TOC entry 5115 (class 2606 OID 31862)
-- Name: constraint constraint_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project."constraint"
    ADD CONSTRAINT constraint_pkey PRIMARY KEY (id);


--
-- TOC entry 5120 (class 2606 OID 31864)
-- Name: device_floating device_floating_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.device_floating
    ADD CONSTRAINT device_floating_pkey PRIMARY KEY (id);


--
-- TOC entry 5117 (class 2606 OID 31866)
-- Name: device device_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.device
    ADD CONSTRAINT device_pkey PRIMARY KEY (id);


--
-- TOC entry 5123 (class 2606 OID 31868)
-- Name: device_shared device_shared_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.device_shared
    ADD CONSTRAINT device_shared_pkey PRIMARY KEY (id);


--
-- TOC entry 5126 (class 2606 OID 31870)
-- Name: device_tidal device_tidal_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.device_tidal
    ADD CONSTRAINT device_tidal_pkey PRIMARY KEY (id);


--
-- TOC entry 5129 (class 2606 OID 31872)
-- Name: device_tidal_power_performance device_tidal_power_performance_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.device_tidal_power_performance
    ADD CONSTRAINT device_tidal_power_performance_pkey PRIMARY KEY (id);


--
-- TOC entry 5132 (class 2606 OID 31874)
-- Name: device_wave device_wave_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.device_wave
    ADD CONSTRAINT device_wave_pkey PRIMARY KEY (id);


--
-- TOC entry 5135 (class 2606 OID 31876)
-- Name: lease_area lease_area_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.lease_area
    ADD CONSTRAINT lease_area_pkey PRIMARY KEY (id);


--
-- TOC entry 5137 (class 2606 OID 31878)
-- Name: site site_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.site
    ADD CONSTRAINT site_pkey PRIMARY KEY (id);


--
-- TOC entry 5140 (class 2606 OID 31880)
-- Name: sub_systems_access sub_systems_access_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_access
    ADD CONSTRAINT sub_systems_access_pkey PRIMARY KEY (id);


--
-- TOC entry 5143 (class 2606 OID 31882)
-- Name: sub_systems_economic sub_systems_economic_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_economic
    ADD CONSTRAINT sub_systems_economic_pkey PRIMARY KEY (id);


--
-- TOC entry 5146 (class 2606 OID 31884)
-- Name: sub_systems_inspection sub_systems_inspection_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_inspection
    ADD CONSTRAINT sub_systems_inspection_pkey PRIMARY KEY (id);


--
-- TOC entry 5149 (class 2606 OID 31886)
-- Name: sub_systems_install sub_systems_install_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_install
    ADD CONSTRAINT sub_systems_install_pkey PRIMARY KEY (id);


--
-- TOC entry 5152 (class 2606 OID 31888)
-- Name: sub_systems_maintenance sub_systems_maintenance_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_maintenance
    ADD CONSTRAINT sub_systems_maintenance_pkey PRIMARY KEY (id);


--
-- TOC entry 5155 (class 2606 OID 31890)
-- Name: sub_systems_operation_weightings sub_systems_operation_weightings_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_operation_weightings
    ADD CONSTRAINT sub_systems_operation_weightings_pkey PRIMARY KEY (id);


--
-- TOC entry 5095 (class 2606 OID 31892)
-- Name: sub_systems sub_systems_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems
    ADD CONSTRAINT sub_systems_pkey PRIMARY KEY (id);


--
-- TOC entry 5158 (class 2606 OID 31894)
-- Name: sub_systems_replace sub_systems_replace_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_replace
    ADD CONSTRAINT sub_systems_replace_pkey PRIMARY KEY (id);


--
-- TOC entry 5161 (class 2606 OID 31896)
-- Name: time_series_energy_tidal time_series_energy_tidal_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.time_series_energy_tidal
    ADD CONSTRAINT time_series_energy_tidal_pkey PRIMARY KEY (id);


--
-- TOC entry 5164 (class 2606 OID 31898)
-- Name: time_series_energy_wave time_series_energy_wave_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.time_series_energy_wave
    ADD CONSTRAINT time_series_energy_wave_pkey PRIMARY KEY (id);


--
-- TOC entry 5167 (class 2606 OID 31900)
-- Name: time_series_om_tidal time_series_om_tidal_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.time_series_om_tidal
    ADD CONSTRAINT time_series_om_tidal_pkey PRIMARY KEY (id);


--
-- TOC entry 5170 (class 2606 OID 31902)
-- Name: time_series_om_wave time_series_om_wave_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.time_series_om_wave
    ADD CONSTRAINT time_series_om_wave_pkey PRIMARY KEY (id);


--
-- TOC entry 5173 (class 2606 OID 31904)
-- Name: time_series_om_wind time_series_om_wind_pkey; Type: CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.time_series_om_wind
    ADD CONSTRAINT time_series_om_wind_pkey PRIMARY KEY (id);


--
-- TOC entry 5179 (class 2606 OID 31906)
-- Name: component_anchor component_anchor_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_anchor
    ADD CONSTRAINT component_anchor_pkey PRIMARY KEY (id);


--
-- TOC entry 5183 (class 2606 OID 31908)
-- Name: component_cable component_cable_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_cable
    ADD CONSTRAINT component_cable_pkey PRIMARY KEY (id);


--
-- TOC entry 5187 (class 2606 OID 31910)
-- Name: component_collection_point component_collection_point_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_collection_point
    ADD CONSTRAINT component_collection_point_pkey PRIMARY KEY (id);


--
-- TOC entry 5191 (class 2606 OID 31912)
-- Name: component_connector component_connector_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_connector
    ADD CONSTRAINT component_connector_pkey PRIMARY KEY (id);


--
-- TOC entry 5194 (class 2606 OID 31914)
-- Name: component_continuous component_continuous_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_continuous
    ADD CONSTRAINT component_continuous_pkey PRIMARY KEY (id);


--
-- TOC entry 5197 (class 2606 OID 31916)
-- Name: component_discrete component_discrete_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_discrete
    ADD CONSTRAINT component_discrete_pkey PRIMARY KEY (id);


--
-- TOC entry 5201 (class 2606 OID 31918)
-- Name: component_mooring_continuous component_mooring_continuous_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_mooring_continuous
    ADD CONSTRAINT component_mooring_continuous_pkey PRIMARY KEY (id);


--
-- TOC entry 5205 (class 2606 OID 31920)
-- Name: component_mooring_discrete component_mooring_discrete_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_mooring_discrete
    ADD CONSTRAINT component_mooring_discrete_pkey PRIMARY KEY (id);


--
-- TOC entry 5209 (class 2606 OID 31922)
-- Name: component_pile component_pile_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_pile
    ADD CONSTRAINT component_pile_pkey PRIMARY KEY (id);


--
-- TOC entry 5175 (class 2606 OID 31924)
-- Name: component component_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component
    ADD CONSTRAINT component_pkey PRIMARY KEY (id);


--
-- TOC entry 5213 (class 2606 OID 31926)
-- Name: component_rope component_rope_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_rope
    ADD CONSTRAINT component_rope_pkey PRIMARY KEY (id);


--
-- TOC entry 5216 (class 2606 OID 31928)
-- Name: component_shared component_shared_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_shared
    ADD CONSTRAINT component_shared_pkey PRIMARY KEY (id);


--
-- TOC entry 5220 (class 2606 OID 31930)
-- Name: component_transformer component_transformer_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_transformer
    ADD CONSTRAINT component_transformer_pkey PRIMARY KEY (id);


--
-- TOC entry 5222 (class 2606 OID 31932)
-- Name: component_type component_type_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_type
    ADD CONSTRAINT component_type_pkey PRIMARY KEY (id);


--
-- TOC entry 5224 (class 2606 OID 31934)
-- Name: constants constants_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.constants
    ADD CONSTRAINT constants_pkey PRIMARY KEY (lock);


--
-- TOC entry 5226 (class 2606 OID 31936)
-- Name: equipment_cable_burial equipment_cable_burial_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_cable_burial
    ADD CONSTRAINT equipment_cable_burial_pkey PRIMARY KEY (id);


--
-- TOC entry 5228 (class 2606 OID 31938)
-- Name: equipment_divers equipment_divers_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_divers
    ADD CONSTRAINT equipment_divers_pkey PRIMARY KEY (id);


--
-- TOC entry 5230 (class 2606 OID 31940)
-- Name: equipment_drilling_rigs equipment_drilling_rigs_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_drilling_rigs
    ADD CONSTRAINT equipment_drilling_rigs_pkey PRIMARY KEY (id);


--
-- TOC entry 5232 (class 2606 OID 31942)
-- Name: equipment_excavating equipment_excavating_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_excavating
    ADD CONSTRAINT equipment_excavating_pkey PRIMARY KEY (id);


--
-- TOC entry 5234 (class 2606 OID 31944)
-- Name: equipment_hammer equipment_hammer_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_hammer
    ADD CONSTRAINT equipment_hammer_pkey PRIMARY KEY (id);


--
-- TOC entry 5236 (class 2606 OID 31946)
-- Name: equipment_mattress equipment_mattress_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_mattress
    ADD CONSTRAINT equipment_mattress_pkey PRIMARY KEY (id);


--
-- TOC entry 5238 (class 2606 OID 31948)
-- Name: equipment_rock_filter_bags equipment_rock_filter_bags_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_rock_filter_bags
    ADD CONSTRAINT equipment_rock_filter_bags_pkey PRIMARY KEY (id);


--
-- TOC entry 5240 (class 2606 OID 31950)
-- Name: equipment_rov equipment_rov_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_rov
    ADD CONSTRAINT equipment_rov_pkey PRIMARY KEY (id);


--
-- TOC entry 5242 (class 2606 OID 31952)
-- Name: equipment_soil_lay_rates equipment_soil_lay_rates_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_soil_lay_rates
    ADD CONSTRAINT equipment_soil_lay_rates_pkey PRIMARY KEY (equipment_type);


--
-- TOC entry 5244 (class 2606 OID 31954)
-- Name: equipment_soil_penet_rates equipment_soil_penet_rates_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_soil_penet_rates
    ADD CONSTRAINT equipment_soil_penet_rates_pkey PRIMARY KEY (equipment_type);


--
-- TOC entry 5246 (class 2606 OID 31956)
-- Name: equipment_split_pipe equipment_split_pipe_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_split_pipe
    ADD CONSTRAINT equipment_split_pipe_pkey PRIMARY KEY (id);


--
-- TOC entry 5248 (class 2606 OID 31958)
-- Name: equipment_vibro_driver equipment_vibro_driver_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.equipment_vibro_driver
    ADD CONSTRAINT equipment_vibro_driver_pkey PRIMARY KEY (id);


--
-- TOC entry 5250 (class 2606 OID 31960)
-- Name: operations_limit_cs operations_limit_cs_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.operations_limit_cs
    ADD CONSTRAINT operations_limit_cs_pkey PRIMARY KEY (id);


--
-- TOC entry 5252 (class 2606 OID 31962)
-- Name: operations_limit_hs operations_limit_hs_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.operations_limit_hs
    ADD CONSTRAINT operations_limit_hs_pkey PRIMARY KEY (id);


--
-- TOC entry 5254 (class 2606 OID 31964)
-- Name: operations_limit_tp operations_limit_tp_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.operations_limit_tp
    ADD CONSTRAINT operations_limit_tp_pkey PRIMARY KEY (id);


--
-- TOC entry 5256 (class 2606 OID 31966)
-- Name: operations_limit_ws operations_limit_ws_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.operations_limit_ws
    ADD CONSTRAINT operations_limit_ws_pkey PRIMARY KEY (id);


--
-- TOC entry 5258 (class 2606 OID 31968)
-- Name: operations_type operations_type_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.operations_type
    ADD CONSTRAINT operations_type_pkey PRIMARY KEY (id);


--
-- TOC entry 5260 (class 2606 OID 31970)
-- Name: ports ports_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.ports
    ADD CONSTRAINT ports_pkey PRIMARY KEY (id);


--
-- TOC entry 5262 (class 2606 OID 31972)
-- Name: ref_current_drag_coef_rect ref_current_drag_coef_rect_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.ref_current_drag_coef_rect
    ADD CONSTRAINT ref_current_drag_coef_rect_pkey PRIMARY KEY (width_length);


--
-- TOC entry 5264 (class 2606 OID 31974)
-- Name: ref_drag_coef_cyl ref_drag_coef_cyl_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.ref_drag_coef_cyl
    ADD CONSTRAINT ref_drag_coef_cyl_pkey PRIMARY KEY (reynolds_number);


--
-- TOC entry 5266 (class 2606 OID 31976)
-- Name: ref_drift_coef_float_rect ref_drift_coef_float_rect_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.ref_drift_coef_float_rect
    ADD CONSTRAINT ref_drift_coef_float_rect_pkey PRIMARY KEY (wavenumber_draft);


--
-- TOC entry 5268 (class 2606 OID 31978)
-- Name: ref_holding_capacity_factors_plate_anchors ref_holding_capacity_factors_plate_anchors_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.ref_holding_capacity_factors_plate_anchors
    ADD CONSTRAINT ref_holding_capacity_factors_plate_anchors_pkey PRIMARY KEY (relative_embedment_depth);


--
-- TOC entry 5270 (class 2606 OID 31980)
-- Name: ref_line_bcf ref_line_bcf_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.ref_line_bcf
    ADD CONSTRAINT ref_line_bcf_pkey PRIMARY KEY (soil_friction_angle);


--
-- TOC entry 5272 (class 2606 OID 31982)
-- Name: ref_pile_deflection_coefficients ref_pile_deflection_coefficients_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.ref_pile_deflection_coefficients
    ADD CONSTRAINT ref_pile_deflection_coefficients_pkey PRIMARY KEY (depth_coefficient);


--
-- TOC entry 5274 (class 2606 OID 31984)
-- Name: ref_pile_limiting_values_noncalcareous ref_pile_limiting_values_noncalcareous_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.ref_pile_limiting_values_noncalcareous
    ADD CONSTRAINT ref_pile_limiting_values_noncalcareous_pkey PRIMARY KEY (soil_friction_angle);


--
-- TOC entry 5276 (class 2606 OID 31986)
-- Name: ref_pile_moment_coefficient_sam ref_pile_moment_coefficient_sam_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.ref_pile_moment_coefficient_sam
    ADD CONSTRAINT ref_pile_moment_coefficient_sam_pkey PRIMARY KEY (depth_coefficient);


--
-- TOC entry 5278 (class 2606 OID 31988)
-- Name: ref_pile_moment_coefficient_sbm ref_pile_moment_coefficient_sbm_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.ref_pile_moment_coefficient_sbm
    ADD CONSTRAINT ref_pile_moment_coefficient_sbm_pkey PRIMARY KEY (depth_coefficient);


--
-- TOC entry 5280 (class 2606 OID 31990)
-- Name: ref_rectangular_wave_inertia ref_rectangular_wave_inertia_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.ref_rectangular_wave_inertia
    ADD CONSTRAINT ref_rectangular_wave_inertia_pkey PRIMARY KEY ("width/length");


--
-- TOC entry 5282 (class 2606 OID 31992)
-- Name: ref_subgrade_reaction_coefficient_cohesionless ref_subgrade_reaction_coefficient_cohesionless_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.ref_subgrade_reaction_coefficient_cohesionless
    ADD CONSTRAINT ref_subgrade_reaction_coefficient_cohesionless_pkey PRIMARY KEY (allowable_deflection_diameter);


--
-- TOC entry 5284 (class 2606 OID 31994)
-- Name: ref_subgrade_reaction_coefficient_k1_cohesive ref_subgrade_reaction_coefficient_k1_cohesive_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.ref_subgrade_reaction_coefficient_k1_cohesive
    ADD CONSTRAINT ref_subgrade_reaction_coefficient_k1_cohesive_pkey PRIMARY KEY (allowable_deflection_diameter);


--
-- TOC entry 5286 (class 2606 OID 31996)
-- Name: ref_superline_nylon ref_superline_nylon_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.ref_superline_nylon
    ADD CONSTRAINT ref_superline_nylon_pkey PRIMARY KEY (extension);


--
-- TOC entry 5288 (class 2606 OID 31998)
-- Name: ref_superline_polyester ref_superline_polyester_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.ref_superline_polyester
    ADD CONSTRAINT ref_superline_polyester_pkey PRIMARY KEY (extension);


--
-- TOC entry 5290 (class 2606 OID 32000)
-- Name: ref_superline_steelite ref_superline_steelite_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.ref_superline_steelite
    ADD CONSTRAINT ref_superline_steelite_pkey PRIMARY KEY (extension);


--
-- TOC entry 5292 (class 2606 OID 32002)
-- Name: ref_wake_amplification_factor_cyl ref_wake_amplification_factor_cyl_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.ref_wake_amplification_factor_cyl
    ADD CONSTRAINT ref_wake_amplification_factor_cyl_pkey PRIMARY KEY (kc_steady_drag_coefficient);


--
-- TOC entry 5294 (class 2606 OID 32004)
-- Name: ref_wind_drag_coef_rect ref_wind_drag_coef_rect_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.ref_wind_drag_coef_rect
    ADD CONSTRAINT ref_wind_drag_coef_rect_pkey PRIMARY KEY (width_length);


--
-- TOC entry 5296 (class 2606 OID 32006)
-- Name: soil_type_geotechnical_properties soil_type_geotechnical_properties_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.soil_type_geotechnical_properties
    ADD CONSTRAINT soil_type_geotechnical_properties_pkey PRIMARY KEY (fk_soil_type_id);


--
-- TOC entry 5092 (class 2606 OID 32008)
-- Name: soil_type soil_type_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.soil_type
    ADD CONSTRAINT soil_type_pkey PRIMARY KEY (id);


--
-- TOC entry 5302 (class 2606 OID 32010)
-- Name: vehicle_helicopter vehicle_helicopter_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_helicopter
    ADD CONSTRAINT vehicle_helicopter_pkey PRIMARY KEY (id);


--
-- TOC entry 5298 (class 2606 OID 32012)
-- Name: vehicle vehicle_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle
    ADD CONSTRAINT vehicle_pkey PRIMARY KEY (id);


--
-- TOC entry 5305 (class 2606 OID 32014)
-- Name: vehicle_shared vehicle_shared_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_shared
    ADD CONSTRAINT vehicle_shared_pkey PRIMARY KEY (id);


--
-- TOC entry 5307 (class 2606 OID 32016)
-- Name: vehicle_type vehicle_type_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_type
    ADD CONSTRAINT vehicle_type_pkey PRIMARY KEY (id);


--
-- TOC entry 5311 (class 2606 OID 32018)
-- Name: vehicle_vessel_anchor_handling vehicle_vessel_anchor_handling_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_vessel_anchor_handling
    ADD CONSTRAINT vehicle_vessel_anchor_handling_pkey PRIMARY KEY (id);


--
-- TOC entry 5315 (class 2606 OID 32020)
-- Name: vehicle_vessel_cable_laying vehicle_vessel_cable_laying_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_vessel_cable_laying
    ADD CONSTRAINT vehicle_vessel_cable_laying_pkey PRIMARY KEY (id);


--
-- TOC entry 5319 (class 2606 OID 32022)
-- Name: vehicle_vessel_cargo vehicle_vessel_cargo_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_vessel_cargo
    ADD CONSTRAINT vehicle_vessel_cargo_pkey PRIMARY KEY (id);


--
-- TOC entry 5323 (class 2606 OID 32024)
-- Name: vehicle_vessel_jackup vehicle_vessel_jackup_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_vessel_jackup
    ADD CONSTRAINT vehicle_vessel_jackup_pkey PRIMARY KEY (id);


--
-- TOC entry 5327 (class 2606 OID 32026)
-- Name: vehicle_vessel_tugboat vehicle_vessel_tugboat_pkey; Type: CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_vessel_tugboat
    ADD CONSTRAINT vehicle_vessel_tugboat_pkey PRIMARY KEY (id);


--
-- TOC entry 5096 (class 1259 OID 32027)
-- Name: bathymetry_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX bathymetry_fk_idx ON project.bathymetry USING btree (fk_site_id);


--
-- TOC entry 5099 (class 1259 OID 32028)
-- Name: bathymetry_layer_fk_bathymetry_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX bathymetry_layer_fk_bathymetry_idx ON project.bathymetry_layer USING btree (fk_bathymetry_id);


--
-- TOC entry 5100 (class 1259 OID 32029)
-- Name: bathymetry_layer_fk_soil_type_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX bathymetry_layer_fk_soil_type_idx ON project.bathymetry_layer USING btree (fk_soil_type_id);


--
-- TOC entry 5103 (class 1259 OID 32030)
-- Name: cable_corridor_bathymetry_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX cable_corridor_bathymetry_fk_idx ON project.cable_corridor_bathymetry USING btree (fk_site_id);


--
-- TOC entry 5106 (class 1259 OID 32031)
-- Name: cable_corridor_bathymetry_fk_soil_type_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX cable_corridor_bathymetry_fk_soil_type_idx ON project.cable_corridor_bathymetry_layer USING btree (fk_soil_type_id);


--
-- TOC entry 5107 (class 1259 OID 32032)
-- Name: cable_corridor_bathymetry_layer_fk_bathymetry_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX cable_corridor_bathymetry_layer_fk_bathymetry_idx ON project.cable_corridor_bathymetry_layer USING btree (fk_bathymetry_id);


--
-- TOC entry 5110 (class 1259 OID 32033)
-- Name: cable_corridor_constraint_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX cable_corridor_constraint_fk_idx ON project.cable_corridor_constraint USING btree (fk_site_id);


--
-- TOC entry 5113 (class 1259 OID 32034)
-- Name: constraint_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX constraint_fk_idx ON project."constraint" USING btree (fk_site_id);


--
-- TOC entry 5118 (class 1259 OID 32035)
-- Name: device_floating_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX device_floating_fk_idx ON project.device_floating USING btree (fk_device_id);


--
-- TOC entry 5121 (class 1259 OID 32036)
-- Name: device_shared_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX device_shared_fk_idx ON project.device_shared USING btree (fk_device_id);


--
-- TOC entry 5124 (class 1259 OID 32037)
-- Name: device_tidal_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX device_tidal_fk_idx ON project.device_tidal USING btree (fk_device_id);


--
-- TOC entry 5127 (class 1259 OID 32038)
-- Name: device_tidal_power_performance_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX device_tidal_power_performance_fk_idx ON project.device_tidal_power_performance USING btree (fk_device_id);


--
-- TOC entry 5130 (class 1259 OID 32039)
-- Name: device_wave_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX device_wave_fk_idx ON project.device_wave USING btree (fk_device_id);


--
-- TOC entry 5133 (class 1259 OID 32040)
-- Name: lease_area_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX lease_area_fk_idx ON project.lease_area USING btree (fk_site_id);


--
-- TOC entry 5138 (class 1259 OID 32041)
-- Name: sub_systems_access_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX sub_systems_access_fk_idx ON project.sub_systems_access USING btree (fk_sub_system_id);


--
-- TOC entry 5141 (class 1259 OID 32042)
-- Name: sub_systems_economic_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX sub_systems_economic_fk_idx ON project.sub_systems_economic USING btree (fk_sub_system_id);


--
-- TOC entry 5093 (class 1259 OID 32043)
-- Name: sub_systems_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX sub_systems_fk_idx ON project.sub_systems USING btree (fk_device_id);


--
-- TOC entry 5144 (class 1259 OID 32044)
-- Name: sub_systems_inspection_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX sub_systems_inspection_fk_idx ON project.sub_systems_inspection USING btree (fk_sub_system_id);


--
-- TOC entry 5147 (class 1259 OID 32045)
-- Name: sub_systems_install_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX sub_systems_install_fk_idx ON project.sub_systems_install USING btree (fk_sub_system_id);


--
-- TOC entry 5150 (class 1259 OID 32046)
-- Name: sub_systems_maintenance_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX sub_systems_maintenance_fk_idx ON project.sub_systems_maintenance USING btree (fk_sub_system_id);


--
-- TOC entry 5153 (class 1259 OID 32047)
-- Name: sub_systems_operation_weightings_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX sub_systems_operation_weightings_fk_idx ON project.sub_systems_operation_weightings USING btree (fk_sub_system_id);


--
-- TOC entry 5156 (class 1259 OID 32048)
-- Name: sub_systems_replace_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX sub_systems_replace_fk_idx ON project.sub_systems_replace USING btree (fk_sub_system_id);


--
-- TOC entry 5159 (class 1259 OID 32049)
-- Name: time_series_energy_tidal_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX time_series_energy_tidal_fk_idx ON project.time_series_energy_tidal USING btree (fk_bathymetry_id);


--
-- TOC entry 5162 (class 1259 OID 32050)
-- Name: time_series_energy_wave_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX time_series_energy_wave_fk_idx ON project.time_series_energy_wave USING btree (fk_site_id);


--
-- TOC entry 5165 (class 1259 OID 32051)
-- Name: time_series_om_tidal_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX time_series_om_tidal_fk_idx ON project.time_series_om_tidal USING btree (fk_site_id);


--
-- TOC entry 5168 (class 1259 OID 32052)
-- Name: time_series_om_wave_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX time_series_om_wave_fk_idx ON project.time_series_om_wave USING btree (fk_site_id);


--
-- TOC entry 5171 (class 1259 OID 32053)
-- Name: time_series_om_wind_fk_idx; Type: INDEX; Schema: project; Owner: -
--

CREATE INDEX time_series_om_wind_fk_idx ON project.time_series_om_wind USING btree (fk_site_id);


--
-- TOC entry 5176 (class 1259 OID 32054)
-- Name: component_anchor_fk_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_anchor_fk_idx ON reference.component_anchor USING btree (fk_component_discrete_id);


--
-- TOC entry 5177 (class 1259 OID 32055)
-- Name: component_anchor_fk_type_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_anchor_fk_type_idx ON reference.component_anchor USING btree (fk_component_type_id);


--
-- TOC entry 5180 (class 1259 OID 32056)
-- Name: component_cable_fk_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_cable_fk_idx ON reference.component_cable USING btree (fk_component_continuous_id);


--
-- TOC entry 5181 (class 1259 OID 32057)
-- Name: component_cable_fk_type_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_cable_fk_type_idx ON reference.component_cable USING btree (fk_component_type_id);


--
-- TOC entry 5184 (class 1259 OID 32058)
-- Name: component_collection_point_fk_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_collection_point_fk_idx ON reference.component_collection_point USING btree (fk_component_discrete_id);


--
-- TOC entry 5185 (class 1259 OID 32059)
-- Name: component_collection_point_fk_type_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_collection_point_fk_type_idx ON reference.component_collection_point USING btree (fk_component_type_id);


--
-- TOC entry 5202 (class 1259 OID 32060)
-- Name: component_component_mooring_discrete_fk_type_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_component_mooring_discrete_fk_type_idx ON reference.component_mooring_discrete USING btree (fk_component_type_id);


--
-- TOC entry 5188 (class 1259 OID 32061)
-- Name: component_connector_fk_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_connector_fk_idx ON reference.component_connector USING btree (fk_component_discrete_id);


--
-- TOC entry 5189 (class 1259 OID 32062)
-- Name: component_connector_fk_type_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_connector_fk_type_idx ON reference.component_connector USING btree (fk_component_type_id);


--
-- TOC entry 5192 (class 1259 OID 32063)
-- Name: component_continuous_fk_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_continuous_fk_idx ON reference.component_continuous USING btree (fk_component_id);


--
-- TOC entry 5195 (class 1259 OID 32064)
-- Name: component_discrete_fk_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_discrete_fk_idx ON reference.component_discrete USING btree (fk_component_id);


--
-- TOC entry 5198 (class 1259 OID 32065)
-- Name: component_mooring_continuous_fk_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_mooring_continuous_fk_idx ON reference.component_mooring_continuous USING btree (fk_component_continuous_id);


--
-- TOC entry 5199 (class 1259 OID 32066)
-- Name: component_mooring_continuous_fk_type_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_mooring_continuous_fk_type_idx ON reference.component_mooring_continuous USING btree (fk_component_type_id);


--
-- TOC entry 5203 (class 1259 OID 32067)
-- Name: component_mooring_discrete_fk_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_mooring_discrete_fk_idx ON reference.component_mooring_discrete USING btree (fk_component_discrete_id);


--
-- TOC entry 5206 (class 1259 OID 32068)
-- Name: component_pile_fk_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_pile_fk_idx ON reference.component_pile USING btree (fk_component_continuous_id);


--
-- TOC entry 5207 (class 1259 OID 32069)
-- Name: component_pile_fk_type_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_pile_fk_type_idx ON reference.component_pile USING btree (fk_component_type_id);


--
-- TOC entry 5210 (class 1259 OID 32070)
-- Name: component_rope_fk_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_rope_fk_idx ON reference.component_rope USING btree (fk_component_continuous_id);


--
-- TOC entry 5211 (class 1259 OID 32071)
-- Name: component_rope_fk_type_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_rope_fk_type_idx ON reference.component_rope USING btree (fk_component_type_id);


--
-- TOC entry 5214 (class 1259 OID 32072)
-- Name: component_shared_fk_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_shared_fk_idx ON reference.component_shared USING btree (fk_component_id);


--
-- TOC entry 5217 (class 1259 OID 32073)
-- Name: component_transformer_fk_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_transformer_fk_idx ON reference.component_transformer USING btree (fk_component_discrete_id);


--
-- TOC entry 5218 (class 1259 OID 32074)
-- Name: component_transformer_fk_type_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX component_transformer_fk_type_idx ON reference.component_transformer USING btree (fk_component_type_id);


--
-- TOC entry 5299 (class 1259 OID 32075)
-- Name: vehicle_helicopter_fk_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX vehicle_helicopter_fk_idx ON reference.vehicle_helicopter USING btree (fk_vehicle_id);


--
-- TOC entry 5300 (class 1259 OID 32076)
-- Name: vehicle_helicopter_fk_type_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX vehicle_helicopter_fk_type_idx ON reference.vehicle_helicopter USING btree (fk_vehicle_type_id);


--
-- TOC entry 5303 (class 1259 OID 32077)
-- Name: vehicle_shared_fk_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX vehicle_shared_fk_idx ON reference.vehicle_shared USING btree (fk_vehicle_id);


--
-- TOC entry 5308 (class 1259 OID 32078)
-- Name: vehicle_vessel_anchor_handling_fk_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX vehicle_vessel_anchor_handling_fk_idx ON reference.vehicle_vessel_anchor_handling USING btree (fk_vehicle_id);


--
-- TOC entry 5309 (class 1259 OID 32079)
-- Name: vehicle_vessel_anchor_handling_fk_type_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX vehicle_vessel_anchor_handling_fk_type_idx ON reference.vehicle_vessel_anchor_handling USING btree (fk_vehicle_type_id);


--
-- TOC entry 5312 (class 1259 OID 32080)
-- Name: vehicle_vessel_cable_laying_fk_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX vehicle_vessel_cable_laying_fk_idx ON reference.vehicle_vessel_cable_laying USING btree (fk_vehicle_id);


--
-- TOC entry 5313 (class 1259 OID 32081)
-- Name: vehicle_vessel_cable_laying_fk_type_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX vehicle_vessel_cable_laying_fk_type_idx ON reference.vehicle_vessel_cable_laying USING btree (fk_vehicle_type_id);


--
-- TOC entry 5316 (class 1259 OID 32082)
-- Name: vehicle_vessel_cargo_fk_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX vehicle_vessel_cargo_fk_idx ON reference.vehicle_vessel_cargo USING btree (fk_vehicle_id);


--
-- TOC entry 5317 (class 1259 OID 32083)
-- Name: vehicle_vessel_cargo_fk_type_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX vehicle_vessel_cargo_fk_type_idx ON reference.vehicle_vessel_cargo USING btree (fk_vehicle_type_id);


--
-- TOC entry 5320 (class 1259 OID 32084)
-- Name: vehicle_vessel_jackup_fk_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX vehicle_vessel_jackup_fk_idx ON reference.vehicle_vessel_jackup USING btree (fk_vehicle_id);


--
-- TOC entry 5321 (class 1259 OID 32085)
-- Name: vehicle_vessel_jackup_fk_type_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX vehicle_vessel_jackup_fk_type_idx ON reference.vehicle_vessel_jackup USING btree (fk_vehicle_type_id);


--
-- TOC entry 5324 (class 1259 OID 32086)
-- Name: vehicle_vessel_tugboat_fk_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX vehicle_vessel_tugboat_fk_idx ON reference.vehicle_vessel_tugboat USING btree (fk_vehicle_id);


--
-- TOC entry 5325 (class 1259 OID 32087)
-- Name: vehicle_vessel_tugboat_fk_type_idx; Type: INDEX; Schema: reference; Owner: -
--

CREATE INDEX vehicle_vessel_tugboat_fk_type_idx ON reference.vehicle_vessel_tugboat USING btree (fk_vehicle_type_id);


--
-- TOC entry 5329 (class 2606 OID 32088)
-- Name: bathymetry bathymetry_fk_site_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.bathymetry
    ADD CONSTRAINT bathymetry_fk_site_id_fkey FOREIGN KEY (fk_site_id) REFERENCES project.site(id);


--
-- TOC entry 5330 (class 2606 OID 32093)
-- Name: bathymetry_layer bathymetry_layer_fk_bathymetry_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.bathymetry_layer
    ADD CONSTRAINT bathymetry_layer_fk_bathymetry_id_fkey FOREIGN KEY (fk_bathymetry_id) REFERENCES project.bathymetry(id);


--
-- TOC entry 5331 (class 2606 OID 32098)
-- Name: bathymetry_layer bathymetry_layer_fk_soil_type_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.bathymetry_layer
    ADD CONSTRAINT bathymetry_layer_fk_soil_type_id_fkey FOREIGN KEY (fk_soil_type_id) REFERENCES reference.soil_type(id);


--
-- TOC entry 5332 (class 2606 OID 32103)
-- Name: cable_corridor_bathymetry cable_corridor_bathymetry_fk_site_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.cable_corridor_bathymetry
    ADD CONSTRAINT cable_corridor_bathymetry_fk_site_id_fkey FOREIGN KEY (fk_site_id) REFERENCES project.site(id);


--
-- TOC entry 5333 (class 2606 OID 32108)
-- Name: cable_corridor_bathymetry_layer cable_corridor_bathymetry_layer_fk_bathymetry_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.cable_corridor_bathymetry_layer
    ADD CONSTRAINT cable_corridor_bathymetry_layer_fk_bathymetry_id_fkey FOREIGN KEY (fk_bathymetry_id) REFERENCES project.cable_corridor_bathymetry(id);


--
-- TOC entry 5334 (class 2606 OID 32113)
-- Name: cable_corridor_bathymetry_layer cable_corridor_bathymetry_layer_fk_soil_type_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.cable_corridor_bathymetry_layer
    ADD CONSTRAINT cable_corridor_bathymetry_layer_fk_soil_type_id_fkey FOREIGN KEY (fk_soil_type_id) REFERENCES reference.soil_type(id);


--
-- TOC entry 5335 (class 2606 OID 32118)
-- Name: cable_corridor_constraint cable_corridor_constraint_fk_site_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.cable_corridor_constraint
    ADD CONSTRAINT cable_corridor_constraint_fk_site_id_fkey FOREIGN KEY (fk_site_id) REFERENCES project.site(id);


--
-- TOC entry 5336 (class 2606 OID 32123)
-- Name: constraint constraint_fk_site_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project."constraint"
    ADD CONSTRAINT constraint_fk_site_id_fkey FOREIGN KEY (fk_site_id) REFERENCES project.site(id);


--
-- TOC entry 5337 (class 2606 OID 32128)
-- Name: device_floating device_floating_fk_device_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.device_floating
    ADD CONSTRAINT device_floating_fk_device_id_fkey FOREIGN KEY (fk_device_id) REFERENCES project.device(id);


--
-- TOC entry 5338 (class 2606 OID 32133)
-- Name: device_shared device_shared_fk_device_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.device_shared
    ADD CONSTRAINT device_shared_fk_device_id_fkey FOREIGN KEY (fk_device_id) REFERENCES project.device(id);


--
-- TOC entry 5339 (class 2606 OID 32138)
-- Name: device_tidal device_tidal_fk_device_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.device_tidal
    ADD CONSTRAINT device_tidal_fk_device_id_fkey FOREIGN KEY (fk_device_id) REFERENCES project.device(id);


--
-- TOC entry 5340 (class 2606 OID 32143)
-- Name: device_tidal_power_performance device_tidal_power_performance_fk_device_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.device_tidal_power_performance
    ADD CONSTRAINT device_tidal_power_performance_fk_device_id_fkey FOREIGN KEY (fk_device_id) REFERENCES project.device(id);


--
-- TOC entry 5341 (class 2606 OID 32148)
-- Name: device_wave device_wave_fk_device_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.device_wave
    ADD CONSTRAINT device_wave_fk_device_id_fkey FOREIGN KEY (fk_device_id) REFERENCES project.device(id);


--
-- TOC entry 5342 (class 2606 OID 32153)
-- Name: lease_area lease_area_fk_site_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.lease_area
    ADD CONSTRAINT lease_area_fk_site_id_fkey FOREIGN KEY (fk_site_id) REFERENCES project.site(id);


--
-- TOC entry 5343 (class 2606 OID 32158)
-- Name: sub_systems_access sub_systems_access_fk_sub_system_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_access
    ADD CONSTRAINT sub_systems_access_fk_sub_system_id_fkey FOREIGN KEY (fk_sub_system_id) REFERENCES project.sub_systems(id);


--
-- TOC entry 5344 (class 2606 OID 32163)
-- Name: sub_systems_economic sub_systems_economic_fk_sub_system_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_economic
    ADD CONSTRAINT sub_systems_economic_fk_sub_system_id_fkey FOREIGN KEY (fk_sub_system_id) REFERENCES project.sub_systems(id);


--
-- TOC entry 5328 (class 2606 OID 32168)
-- Name: sub_systems sub_systems_fk_device_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems
    ADD CONSTRAINT sub_systems_fk_device_id_fkey FOREIGN KEY (fk_device_id) REFERENCES project.device(id);


--
-- TOC entry 5345 (class 2606 OID 32173)
-- Name: sub_systems_inspection sub_systems_inspection_fk_sub_system_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_inspection
    ADD CONSTRAINT sub_systems_inspection_fk_sub_system_id_fkey FOREIGN KEY (fk_sub_system_id) REFERENCES project.sub_systems(id);


--
-- TOC entry 5346 (class 2606 OID 32178)
-- Name: sub_systems_install sub_systems_install_fk_sub_system_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_install
    ADD CONSTRAINT sub_systems_install_fk_sub_system_id_fkey FOREIGN KEY (fk_sub_system_id) REFERENCES project.sub_systems(id);


--
-- TOC entry 5347 (class 2606 OID 32183)
-- Name: sub_systems_maintenance sub_systems_maintenance_fk_sub_system_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_maintenance
    ADD CONSTRAINT sub_systems_maintenance_fk_sub_system_id_fkey FOREIGN KEY (fk_sub_system_id) REFERENCES project.sub_systems(id);


--
-- TOC entry 5348 (class 2606 OID 32188)
-- Name: sub_systems_operation_weightings sub_systems_operation_weightings_fk_sub_system_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_operation_weightings
    ADD CONSTRAINT sub_systems_operation_weightings_fk_sub_system_id_fkey FOREIGN KEY (fk_sub_system_id) REFERENCES project.sub_systems(id);


--
-- TOC entry 5349 (class 2606 OID 32193)
-- Name: sub_systems_replace sub_systems_replace_fk_sub_system_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.sub_systems_replace
    ADD CONSTRAINT sub_systems_replace_fk_sub_system_id_fkey FOREIGN KEY (fk_sub_system_id) REFERENCES project.sub_systems(id);


--
-- TOC entry 5350 (class 2606 OID 32198)
-- Name: time_series_energy_tidal time_series_energy_tidal_fk_bathymetry_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.time_series_energy_tidal
    ADD CONSTRAINT time_series_energy_tidal_fk_bathymetry_id_fkey FOREIGN KEY (fk_bathymetry_id) REFERENCES project.bathymetry(id);


--
-- TOC entry 5351 (class 2606 OID 32203)
-- Name: time_series_energy_wave time_series_energy_wave_fk_site_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.time_series_energy_wave
    ADD CONSTRAINT time_series_energy_wave_fk_site_id_fkey FOREIGN KEY (fk_site_id) REFERENCES project.site(id);


--
-- TOC entry 5352 (class 2606 OID 32208)
-- Name: time_series_om_tidal time_series_om_tidal_fk_site_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.time_series_om_tidal
    ADD CONSTRAINT time_series_om_tidal_fk_site_id_fkey FOREIGN KEY (fk_site_id) REFERENCES project.site(id);


--
-- TOC entry 5353 (class 2606 OID 32213)
-- Name: time_series_om_wave time_series_om_wave_fk_site_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.time_series_om_wave
    ADD CONSTRAINT time_series_om_wave_fk_site_id_fkey FOREIGN KEY (fk_site_id) REFERENCES project.site(id);


--
-- TOC entry 5354 (class 2606 OID 32218)
-- Name: time_series_om_wind time_series_om_wind_fk_site_id_fkey; Type: FK CONSTRAINT; Schema: project; Owner: -
--

ALTER TABLE ONLY project.time_series_om_wind
    ADD CONSTRAINT time_series_om_wind_fk_site_id_fkey FOREIGN KEY (fk_site_id) REFERENCES project.site(id);


--
-- TOC entry 5355 (class 2606 OID 32223)
-- Name: component_anchor component_anchor_fk_component_discrete_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_anchor
    ADD CONSTRAINT component_anchor_fk_component_discrete_id_fkey FOREIGN KEY (fk_component_discrete_id) REFERENCES reference.component_discrete(id);


--
-- TOC entry 5356 (class 2606 OID 32228)
-- Name: component_anchor component_anchor_fk_component_type_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_anchor
    ADD CONSTRAINT component_anchor_fk_component_type_id_fkey FOREIGN KEY (fk_component_type_id) REFERENCES reference.component_type(id);


--
-- TOC entry 5357 (class 2606 OID 32233)
-- Name: component_cable component_cable_fk_component_continuous_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_cable
    ADD CONSTRAINT component_cable_fk_component_continuous_id_fkey FOREIGN KEY (fk_component_continuous_id) REFERENCES reference.component_continuous(id);


--
-- TOC entry 5358 (class 2606 OID 32238)
-- Name: component_cable component_cable_fk_component_type_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_cable
    ADD CONSTRAINT component_cable_fk_component_type_id_fkey FOREIGN KEY (fk_component_type_id) REFERENCES reference.component_type(id);


--
-- TOC entry 5359 (class 2606 OID 32243)
-- Name: component_collection_point component_collection_point_fk_component_discrete_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_collection_point
    ADD CONSTRAINT component_collection_point_fk_component_discrete_id_fkey FOREIGN KEY (fk_component_discrete_id) REFERENCES reference.component_discrete(id);


--
-- TOC entry 5360 (class 2606 OID 32248)
-- Name: component_collection_point component_collection_point_fk_component_type_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_collection_point
    ADD CONSTRAINT component_collection_point_fk_component_type_id_fkey FOREIGN KEY (fk_component_type_id) REFERENCES reference.component_type(id);


--
-- TOC entry 5361 (class 2606 OID 32253)
-- Name: component_connector component_connector_fk_component_discrete_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_connector
    ADD CONSTRAINT component_connector_fk_component_discrete_fkey FOREIGN KEY (fk_component_discrete_id) REFERENCES reference.component_discrete(id);


--
-- TOC entry 5362 (class 2606 OID 32258)
-- Name: component_connector component_connector_fk_component_type_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_connector
    ADD CONSTRAINT component_connector_fk_component_type_id_fkey FOREIGN KEY (fk_component_type_id) REFERENCES reference.component_type(id);


--
-- TOC entry 5363 (class 2606 OID 32263)
-- Name: component_continuous component_continuous_fk_component_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_continuous
    ADD CONSTRAINT component_continuous_fk_component_id_fkey FOREIGN KEY (fk_component_id) REFERENCES reference.component(id);


--
-- TOC entry 5364 (class 2606 OID 32268)
-- Name: component_discrete component_discrete_fk_component_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_discrete
    ADD CONSTRAINT component_discrete_fk_component_id_fkey FOREIGN KEY (fk_component_id) REFERENCES reference.component(id);


--
-- TOC entry 5365 (class 2606 OID 32273)
-- Name: component_mooring_continuous component_mooring_continuous_fk_component_continuous_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_mooring_continuous
    ADD CONSTRAINT component_mooring_continuous_fk_component_continuous_id_fkey FOREIGN KEY (fk_component_continuous_id) REFERENCES reference.component_continuous(id);


--
-- TOC entry 5366 (class 2606 OID 32278)
-- Name: component_mooring_continuous component_mooring_continuous_fk_component_type_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_mooring_continuous
    ADD CONSTRAINT component_mooring_continuous_fk_component_type_id_fkey FOREIGN KEY (fk_component_type_id) REFERENCES reference.component_type(id);


--
-- TOC entry 5367 (class 2606 OID 32283)
-- Name: component_mooring_discrete component_mooring_discrete_fk_component_discrete_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_mooring_discrete
    ADD CONSTRAINT component_mooring_discrete_fk_component_discrete_id_fkey FOREIGN KEY (fk_component_discrete_id) REFERENCES reference.component_discrete(id);


--
-- TOC entry 5368 (class 2606 OID 32288)
-- Name: component_mooring_discrete component_mooring_discrete_fk_component_type_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_mooring_discrete
    ADD CONSTRAINT component_mooring_discrete_fk_component_type_id_fkey FOREIGN KEY (fk_component_type_id) REFERENCES reference.component_type(id);


--
-- TOC entry 5369 (class 2606 OID 32293)
-- Name: component_pile component_pile_fk_component_continuous_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_pile
    ADD CONSTRAINT component_pile_fk_component_continuous_id_fkey FOREIGN KEY (fk_component_continuous_id) REFERENCES reference.component_continuous(id);


--
-- TOC entry 5370 (class 2606 OID 32298)
-- Name: component_pile component_pile_fk_component_type_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_pile
    ADD CONSTRAINT component_pile_fk_component_type_id_fkey FOREIGN KEY (fk_component_type_id) REFERENCES reference.component_type(id);


--
-- TOC entry 5371 (class 2606 OID 32303)
-- Name: component_rope component_rope_fk_component_continuous_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_rope
    ADD CONSTRAINT component_rope_fk_component_continuous_id_fkey FOREIGN KEY (fk_component_continuous_id) REFERENCES reference.component_continuous(id);


--
-- TOC entry 5372 (class 2606 OID 32308)
-- Name: component_rope component_rope_fk_component_type_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_rope
    ADD CONSTRAINT component_rope_fk_component_type_id_fkey FOREIGN KEY (fk_component_type_id) REFERENCES reference.component_type(id);


--
-- TOC entry 5373 (class 2606 OID 32313)
-- Name: component_shared component_shared_fk_component_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_shared
    ADD CONSTRAINT component_shared_fk_component_id_fkey FOREIGN KEY (fk_component_id) REFERENCES reference.component(id);


--
-- TOC entry 5374 (class 2606 OID 32318)
-- Name: component_transformer component_transformer_fk_component_discrete_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_transformer
    ADD CONSTRAINT component_transformer_fk_component_discrete_id_fkey FOREIGN KEY (fk_component_discrete_id) REFERENCES reference.component_discrete(id);


--
-- TOC entry 5375 (class 2606 OID 32323)
-- Name: component_transformer component_transformer_fk_component_type_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.component_transformer
    ADD CONSTRAINT component_transformer_fk_component_type_id_fkey FOREIGN KEY (fk_component_type_id) REFERENCES reference.component_type(id);


--
-- TOC entry 5376 (class 2606 OID 32328)
-- Name: operations_limit_cs operations_limit_cs_fk_operations_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.operations_limit_cs
    ADD CONSTRAINT operations_limit_cs_fk_operations_id_fkey FOREIGN KEY (fk_operations_id) REFERENCES reference.operations_type(id);


--
-- TOC entry 5377 (class 2606 OID 32333)
-- Name: operations_limit_hs operations_limit_hs_fk_operations_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.operations_limit_hs
    ADD CONSTRAINT operations_limit_hs_fk_operations_id_fkey FOREIGN KEY (fk_operations_id) REFERENCES reference.operations_type(id);


--
-- TOC entry 5378 (class 2606 OID 32338)
-- Name: operations_limit_tp operations_limit_tp_fk_operations_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.operations_limit_tp
    ADD CONSTRAINT operations_limit_tp_fk_operations_id_fkey FOREIGN KEY (fk_operations_id) REFERENCES reference.operations_type(id);


--
-- TOC entry 5379 (class 2606 OID 32343)
-- Name: operations_limit_ws operations_limit_ws_fk_operations_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.operations_limit_ws
    ADD CONSTRAINT operations_limit_ws_fk_operations_id_fkey FOREIGN KEY (fk_operations_id) REFERENCES reference.operations_type(id);


--
-- TOC entry 5380 (class 2606 OID 32348)
-- Name: soil_type_geotechnical_properties soil_type_geotechnical_properties_fk_soil_type_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.soil_type_geotechnical_properties
    ADD CONSTRAINT soil_type_geotechnical_properties_fk_soil_type_id_fkey FOREIGN KEY (fk_soil_type_id) REFERENCES reference.soil_type(id);


--
-- TOC entry 5381 (class 2606 OID 32353)
-- Name: vehicle_helicopter vehicle_helicopter_fk_vehicle_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_helicopter
    ADD CONSTRAINT vehicle_helicopter_fk_vehicle_id_fkey FOREIGN KEY (fk_vehicle_id) REFERENCES reference.vehicle(id);


--
-- TOC entry 5382 (class 2606 OID 32358)
-- Name: vehicle_helicopter vehicle_helicopter_fk_vehicle_type_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_helicopter
    ADD CONSTRAINT vehicle_helicopter_fk_vehicle_type_id_fkey FOREIGN KEY (fk_vehicle_type_id) REFERENCES reference.vehicle_type(id);


--
-- TOC entry 5383 (class 2606 OID 32363)
-- Name: vehicle_shared vehicle_shared_fk_vehicle_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_shared
    ADD CONSTRAINT vehicle_shared_fk_vehicle_id_fkey FOREIGN KEY (fk_vehicle_id) REFERENCES reference.vehicle(id);


--
-- TOC entry 5384 (class 2606 OID 32368)
-- Name: vehicle_vessel_anchor_handling vehicle_vessel_anchor_handling_fk_vehicle_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_vessel_anchor_handling
    ADD CONSTRAINT vehicle_vessel_anchor_handling_fk_vehicle_id_fkey FOREIGN KEY (fk_vehicle_id) REFERENCES reference.vehicle(id);


--
-- TOC entry 5385 (class 2606 OID 32373)
-- Name: vehicle_vessel_anchor_handling vehicle_vessel_anchor_handling_fk_vehicle_type_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_vessel_anchor_handling
    ADD CONSTRAINT vehicle_vessel_anchor_handling_fk_vehicle_type_id_fkey FOREIGN KEY (fk_vehicle_type_id) REFERENCES reference.vehicle_type(id);


--
-- TOC entry 5386 (class 2606 OID 32378)
-- Name: vehicle_vessel_cable_laying vehicle_vessel_cable_laying_fk_vehicle_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_vessel_cable_laying
    ADD CONSTRAINT vehicle_vessel_cable_laying_fk_vehicle_id_fkey FOREIGN KEY (fk_vehicle_id) REFERENCES reference.vehicle(id);


--
-- TOC entry 5387 (class 2606 OID 32383)
-- Name: vehicle_vessel_cable_laying vehicle_vessel_cable_laying_fk_vehicle_type_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_vessel_cable_laying
    ADD CONSTRAINT vehicle_vessel_cable_laying_fk_vehicle_type_id_fkey FOREIGN KEY (fk_vehicle_type_id) REFERENCES reference.vehicle_type(id);


--
-- TOC entry 5388 (class 2606 OID 32388)
-- Name: vehicle_vessel_cargo vehicle_vessel_cargo_fk_vehicle_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_vessel_cargo
    ADD CONSTRAINT vehicle_vessel_cargo_fk_vehicle_id_fkey FOREIGN KEY (fk_vehicle_id) REFERENCES reference.vehicle(id);


--
-- TOC entry 5389 (class 2606 OID 32393)
-- Name: vehicle_vessel_cargo vehicle_vessel_cargo_fk_vehicle_type_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_vessel_cargo
    ADD CONSTRAINT vehicle_vessel_cargo_fk_vehicle_type_id_fkey FOREIGN KEY (fk_vehicle_type_id) REFERENCES reference.vehicle_type(id);


--
-- TOC entry 5390 (class 2606 OID 32398)
-- Name: vehicle_vessel_jackup vehicle_vessel_jackup_fk_vehicle_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_vessel_jackup
    ADD CONSTRAINT vehicle_vessel_jackup_fk_vehicle_id_fkey FOREIGN KEY (fk_vehicle_id) REFERENCES reference.vehicle(id);


--
-- TOC entry 5391 (class 2606 OID 32403)
-- Name: vehicle_vessel_jackup vehicle_vessel_jackup_fk_vehicle_type_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_vessel_jackup
    ADD CONSTRAINT vehicle_vessel_jackup_fk_vehicle_type_id_fkey FOREIGN KEY (fk_vehicle_type_id) REFERENCES reference.vehicle_type(id);


--
-- TOC entry 5392 (class 2606 OID 32408)
-- Name: vehicle_vessel_tugboat vehicle_vessel_tugboat_fk_vehicle_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_vessel_tugboat
    ADD CONSTRAINT vehicle_vessel_tugboat_fk_vehicle_id_fkey FOREIGN KEY (fk_vehicle_id) REFERENCES reference.vehicle(id);


--
-- TOC entry 5393 (class 2606 OID 32413)
-- Name: vehicle_vessel_tugboat vehicle_vessel_tugboat_fk_vehicle_type_id_fkey; Type: FK CONSTRAINT; Schema: reference; Owner: -
--

ALTER TABLE ONLY reference.vehicle_vessel_tugboat
    ADD CONSTRAINT vehicle_vessel_tugboat_fk_vehicle_type_id_fkey FOREIGN KEY (fk_vehicle_type_id) REFERENCES reference.vehicle_type(id);


-- Completed on 2019-03-12 11:14:07

--
-- PostgreSQL database dump complete
--