aboutsummaryrefslogtreecommitdiffstats
path: root/schema.sql
diff options
context:
space:
mode:
authorGuilhem Moulin <guilhem@fripost.org>2026-03-07 15:27:51 +0100
committerGuilhem Moulin <guilhem@fripost.org>2026-03-07 15:27:51 +0100
commitbaa8667a38a5cc79571da15844d525c665234edc (patch)
tree2beef76bd2aaa347a03498453e030ded71eb7672 /schema.sql
parent8eeb7370ad1828a17f7893601af3381a6ca72ed1 (diff)
schema: Add NOT NULL constraints on some of Lantmäteriet's columns.
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/schema.sql b/schema.sql
index 46dd2be..768f50b 100644
--- a/schema.sql
+++ b/schema.sql
@@ -368,8 +368,8 @@ SET default_table_access_method = heap;
CREATE TABLE lm_topo250.kommunyta (
ogc_fid bigint NOT NULL,
- objektidentitet uuid,
- skapad timestamp without time zone,
+ objektidentitet uuid NOT NULL,
+ skapad timestamp without time zone NOT NULL,
kommunkod smallint NOT NULL,
wkb_geometry public.geometry(MultiPolygon,3006) NOT NULL
);
@@ -466,8 +466,8 @@ ALTER SEQUENCE lm_topo250.kommunyta_sub_ogc_fid_seq OWNED BY lm_topo250.kommunyt
CREATE TABLE lm_topo250.lansyta (
ogc_fid bigint NOT NULL,
- objektidentitet uuid,
- skapad timestamp without time zone,
+ objektidentitet uuid NOT NULL,
+ skapad timestamp without time zone NOT NULL,
lanskod smallint NOT NULL,
wkb_geometry public.geometry(MultiPolygon,3006) NOT NULL
);