--- a/schema/gemma.sql	Fri Feb 14 11:07:38 2020 +0100
+++ b/schema/gemma.sql	Fri Feb 14 12:14:36 2020 +0100
@@ -886,7 +886,7 @@
         PRIMARY KEY (fm_bcnlat_id, dirimp)
     )
 
-    -- Additional attributes for IENC features BOYCAR
+    -- Additional attributes for IENC feature BOYCAR
     CREATE TABLE fairway_marks_boycar (
         id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
         colour varchar,
@@ -905,6 +905,27 @@
                 0, colour, colpat, conrad, marsys, boyshp
             ) AS fairway_marks_boycar)
         ))
+
+    -- Additional attributes for IENC feature BOYLAT
+    CREATE TABLE fairway_marks_boylat (
+        id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
+        colour varchar,
+        colpat varchar,
+        conrad int,
+        marsys int,
+        boyshp int,
+        catlam int
+    ) INHERITS (fairway_marks)
+    -- Prevent identical entries using composite type comparison
+    -- (i.e. considering two NULL values in a field equal):
+    CREATE UNIQUE INDEX fairway_marks_boylat_distinct_rows
+        ON fairway_marks_boylat
+        ((CAST((geom,
+                datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
+                scamin, picrep, txtdsc, sordat, sorind,
+                0, colour, colpat, conrad, marsys, boyshp, catlam
+            ) AS fairway_marks_boylat)
+        ))
 ;