Mercurial > gemma

comparison schema/gemma.sql @ 4922:9bd6a0ca63ea fairway-marks-import

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add import for fairway marks of type BOYLAT
author Tom Gottfried <tom@intevation.de>
date Fri, 14 Feb 2020 12:14:36 +0100
parents 399458e60a9b
children b86ce7fc4da3
comparison
equal deleted inserted replaced
4920:a9fac2394238 4922:9bd6a0ca63ea
884 fm_bcnlat_id int REFERENCES fairway_marks_bcnlat, 884 fm_bcnlat_id int REFERENCES fairway_marks_bcnlat,
885 dirimp smallint REFERENCES dirimps, 885 dirimp smallint REFERENCES dirimps,
886 PRIMARY KEY (fm_bcnlat_id, dirimp) 886 PRIMARY KEY (fm_bcnlat_id, dirimp)
887 ) 887 )
888 888
889 -- Additional attributes for IENC features BOYCAR 889 -- Additional attributes for IENC feature BOYCAR
890 CREATE TABLE fairway_marks_boycar ( 890 CREATE TABLE fairway_marks_boycar (
891 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, 891 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
892 colour varchar, 892 colour varchar,
893 colpat varchar, 893 colpat varchar,
894 conrad int, 894 conrad int,
902 ((CAST((geom, 902 ((CAST((geom,
903 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, 903 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
904 scamin, picrep, txtdsc, sordat, sorind, 904 scamin, picrep, txtdsc, sordat, sorind,
905 0, colour, colpat, conrad, marsys, boyshp 905 0, colour, colpat, conrad, marsys, boyshp
906 ) AS fairway_marks_boycar) 906 ) AS fairway_marks_boycar)
907 ))
908
909 -- Additional attributes for IENC feature BOYLAT
910 CREATE TABLE fairway_marks_boylat (
911 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
912 colour varchar,
913 colpat varchar,
914 conrad int,
915 marsys int,
916 boyshp int,
917 catlam int
918 ) INHERITS (fairway_marks)
919 -- Prevent identical entries using composite type comparison
920 -- (i.e. considering two NULL values in a field equal):
921 CREATE UNIQUE INDEX fairway_marks_boylat_distinct_rows
922 ON fairway_marks_boylat
923 ((CAST((geom,
924 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
925 scamin, picrep, txtdsc, sordat, sorind,
926 0, colour, colpat, conrad, marsys, boyshp, catlam
927 ) AS fairway_marks_boylat)
907 )) 928 ))
908 ; 929 ;
909 930
910 931
911 -- 932 --