CREATE TABLE events (
    id uuid DEFAULT uuid_generate_v4() NOT NULL,
    title character varying(255) NOT NULL,
    slug character varying(255) NOT NULL,
    multi_day boolean,
    image character varying(255),
    social_image character varying(255),
    venue_id uuid,
    admission_fee character varying(255),
    organizer_contact character varying(255),
    brief_description text,
    description text,
    links character varying(255)[] DEFAULT (ARRAY[]::character varying[])::character varying(255)[],
    website_link text,
    ticket_link text,
    fb_event_link character varying(255),
    eventbrite_link character varying(255),
    bitly_link character varying(255),
    tags character varying(255)[] DEFAULT (ARRAY[]::character varying[])::character varying(255)[],
    verified boolean DEFAULT false NOT NULL,
    "createdAt" timestamp with time zone DEFAULT now() NOT NULL,
    "updatedAt" timestamp with time zone DEFAULT now() NOT NULL,
    reviewed_by_org character varying,
    accessibility character varying(255)[] DEFAULT (ARRAY[]::character varying[])::character varying(255)[],
    category character varying(255),
    condition character varying(255)[] DEFAULT (ARRAY[]::character varying[])::character varying(255)[],
    mode character varying(255)
);


CREATE TABLE datetime_venue (
    id uuid NOT NULL,
    event_id uuid NOT NULL,
    venue_id uuid,
    start_time timestamp with time zone NOT NULL,
    end_time timestamp with time zone NOT NULL,
    optional_title character varying(255),
    "createdAt" timestamp with time zone DEFAULT now() NOT NULL,
    "updatedAt" timestamp with time zone DEFAULT now() NOT NULL,
    timezone character varying(255) DEFAULT 'US/Eastern'::character varying NOT NULL,
    category character varying(255)
);


CREATE TABLE venues (
    id uuid DEFAULT uuid_generate_v4() NOT NULL,
    name character varying(255),
    slug character varying(255),
    address character varying(255),
    g_map_link character varying(255),
    "createdAt" timestamp with time zone DEFAULT now() NOT NULL,
    "updatedAt" timestamp with time zone DEFAULT now() NOT NULL,
    is_soft_deleted boolean DEFAULT false NOT NULL,
    gps_lat double precision,
    gps_long double precision,
    gps_alt double precision,
    street character varying(255) DEFAULT NULL::character varying,
    city character varying(255) DEFAULT NULL::character varying,
    state character varying(255) DEFAULT NULL::character varying,
    zip character varying(255) DEFAULT NULL::character varying,
    neighborhood character varying(255) DEFAULT NULL::character varying
);