| creator_user_id bigint NOT NULL, | | creator_user_id bigint NOT NULL, |
| content character varying NOT NULL, | | content character varying NOT NULL, |
| photo_key character varying, | | photo_key character varying, |
| n | geom public.geometry(Point,4326) NOT NULL, | n | geom public.geometry(Point,4326), |
| address character varying NOT NULL, | | address character varying, |
| | | link character varying, |
| during tstzrange NOT NULL, | | during tstzrange NOT NULL, |
| created timestamp with time zone DEFAULT now() NOT NULL, | | created timestamp with time zone DEFAULT now() NOT NULL, |
| last_edited timestamp with time zone DEFAULT now() NOT NULL, | | last_edited timestamp with time zone DEFAULT now() NOT NULL, |
| is_cancelled boolean DEFAULT false NOT NULL, | | is_cancelled boolean DEFAULT false NOT NULL, |
| is_deleted boolean DEFAULT false NOT NULL, | | is_deleted boolean DEFAULT false NOT NULL, |
| t | moderation_state_id bigint NOT NULL | t | moderation_state_id bigint NOT NULL, |
| | | CONSTRAINT ck_event_occurrences_geom_iff_address CHECK (((geom IS NULL) = (address IS NULL))), |
| | | CONSTRAINT ck_event_occurrences_link_or_geom CHECK (((geom IS NULL) <> (link IS NULL))) |
| ); | | ); |
| | | |
| CREATE TABLE public.event_organizers ( | | CREATE TABLE public.event_organizers ( |