--

-- PostgreSQL database dump

--

-- Dumped from database version 13.6

-- Dumped by pg_dump version 13.6

SET statement_timeout = 0;

SET lock_timeout = 0;

SET idle_in_transaction_session_timeout = 0;

SET client_encoding = 'UTF8';

SET standard_conforming_strings = on;

SELECT pg_catalog.set_config('search_path', '', false);

SET check_function_bodies = false;

SET xmloption = content;

SET client_min_messages = warning;

SET row_security = off;

SET default_tablespace = '';

SET default_table_access_method = heap;

--

-- Name: activities; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public.activities (

id uuid NOT NULL,

type text NOT NULL,

"timestamp" timestamp with time zone NOT NULL,

platform text NOT NULL,

info jsonb DEFAULT '{}'::jsonb,

"crowdInfo" jsonb DEFAULT '{}'::jsonb,

"isKeyAction" boolean DEFAULT false NOT NULL,

score integer DEFAULT 2,

"sourceId" text NOT NULL,

"sourceParentId" character varying(255),

"importHash" character varying(255),

"createdAt" timestamp with time zone NOT NULL,

"updatedAt" timestamp with time zone NOT NULL,

"deletedAt" timestamp with time zone,

"communityMemberId" uuid NOT NULL,

"conversationId" uuid,

"parentId" uuid,

"tenantId" uuid NOT NULL,

"createdById" uuid,

"updatedById" uuid

);

--

-- Name: auditLogs; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public."auditLogs" (

id uuid NOT NULL,

"entityName" character varying(255) NOT NULL,

"entityId" character varying(255) NOT NULL,

"tenantId" uuid,

action character varying(32) NOT NULL,

"createdById" uuid,

"createdByEmail" character varying(255),

"timestamp" timestamp with time zone NOT NULL,

"values" json NOT NULL

);

--

-- Name: automationExecutions; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public."automationExecutions" (

id uuid NOT NULL,

"automationId" uuid NOT NULL,

type character varying(80) NOT NULL,

"tenantId" uuid NOT NULL,

trigger character varying(80) NOT NULL,

state character varying(80) NOT NULL,

error json,

"executedAt" timestamp with time zone NOT NULL,

"eventId" character varying(255) NOT NULL,

payload json NOT NULL

);

--

-- Name: automations; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public.automations (

id uuid NOT NULL,

type character varying(80) NOT NULL,

"tenantId" uuid NOT NULL,

trigger character varying(80) NOT NULL,

settings jsonb NOT NULL,

state character varying(80) NOT NULL,

"createdAt" timestamp with time zone NOT NULL,

"updatedAt" timestamp with time zone NOT NULL,

"createdById" uuid,

"updatedById" uuid

);

--

-- Name: communityMemberNoMerge; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public."communityMemberNoMerge" (

"createdAt" timestamp with time zone NOT NULL,

"updatedAt" timestamp with time zone NOT NULL,

"communityMemberId" uuid NOT NULL,

"noMergeId" uuid NOT NULL

);

--

-- Name: communityMemberTags; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public."communityMemberTags" (

"createdAt" timestamp with time zone NOT NULL,

"updatedAt" timestamp with time zone NOT NULL,

"communityMemberId" uuid NOT NULL,

"tagId" uuid NOT NULL

);

--

-- Name: communityMemberToMerge; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public."communityMemberToMerge" (

"createdAt" timestamp with time zone NOT NULL,

"updatedAt" timestamp with time zone NOT NULL,

"communityMemberId" uuid NOT NULL,

"toMergeId" uuid NOT NULL

);

--

-- Name: communityMembers; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public."communityMembers" (

id uuid NOT NULL,

username jsonb NOT NULL,

type character varying(255) DEFAULT 'member'::character varying NOT NULL,

info jsonb DEFAULT '{}'::jsonb,

"crowdInfo" jsonb DEFAULT '{}'::jsonb,

email text,

score integer DEFAULT '-1'::integer,

bio text,

organisation text,

location text,

signals text,

"joinedAt" timestamp with time zone NOT NULL,

"importHash" character varying(255),

reach jsonb DEFAULT '{"total": -1}'::jsonb,

"createdAt" timestamp with time zone NOT NULL,

"updatedAt" timestamp with time zone NOT NULL,

"deletedAt" timestamp with time zone,

"tenantId" uuid NOT NULL,

"createdById" uuid,

"updatedById" uuid

);

--

-- Name: conversationSettings; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public."conversationSettings" (

id uuid NOT NULL,

"customUrl" text,

"logoUrl" text,

"faviconUrl" text,

theme jsonb,

"autoPublish" jsonb,

"createdAt" timestamp with time zone NOT NULL,

"updatedAt" timestamp with time zone NOT NULL,

"tenantId" uuid,

"createdById" uuid,

"updatedById" uuid

);

--

-- Name: conversations; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public.conversations (

id uuid NOT NULL,

title text NOT NULL,

slug text NOT NULL,

published boolean DEFAULT false NOT NULL,

"createdAt" timestamp with time zone NOT NULL,

"updatedAt" timestamp with time zone NOT NULL,

"tenantId" uuid NOT NULL,

"createdById" uuid,

"updatedById" uuid

);

--

-- Name: eagleEyeContents; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public."eagleEyeContents" (

id uuid NOT NULL,

"sourceId" text NOT NULL,

"vectorId" text NOT NULL,

status character varying(255) DEFAULT NULL::character varying,

title text NOT NULL,

username text NOT NULL,

url text NOT NULL,

text text,

"timestamp" timestamp with time zone NOT NULL,

platform text NOT NULL,

keywords text[],

"similarityScore" double precision,

"userAttributes" jsonb,

"postAttributes" jsonb,

"importHash" character varying(255),

"createdAt" timestamp with time zone NOT NULL,

"updatedAt" timestamp with time zone NOT NULL,

"deletedAt" timestamp with time zone,

"tenantId" uuid NOT NULL,

"createdById" uuid,

"updatedById" uuid

);

--

-- Name: files; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public.files (

id uuid NOT NULL,

"belongsTo" character varying(255) NOT NULL,

"belongsToId" character varying(255) NOT NULL,

"belongsToColumn" character varying(255) NOT NULL,

name character varying(2083) NOT NULL,

"sizeInBytes" integer,

"privateUrl" character varying(2083),

"publicUrl" character varying(2083),

"createdAt" timestamp with time zone NOT NULL,

"updatedAt" timestamp with time zone NOT NULL,

"deletedAt" timestamp with time zone,

"tenantId" uuid,

"createdById" uuid,

"updatedById" uuid

);

--

-- Name: integrations; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public.integrations (

id uuid NOT NULL,

platform text,

status text,

"limitCount" integer,

"limitLastResetAt" timestamp with time zone,

token text,

"refreshToken" text,

settings jsonb DEFAULT '{}'::jsonb,

"integrationIdentifier" text,

"importHash" character varying(255),

"createdAt" timestamp with time zone NOT NULL,

"updatedAt" timestamp with time zone NOT NULL,

"deletedAt" timestamp with time zone,

"tenantId" uuid NOT NULL,

"createdById" uuid,

"updatedById" uuid

);

--

-- Name: microservices; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public.microservices (

id uuid NOT NULL,

init boolean DEFAULT false NOT NULL,

running boolean DEFAULT false NOT NULL,

type text NOT NULL,

variant text DEFAULT 'default'::text,

settings jsonb DEFAULT '{}'::jsonb NOT NULL,

"importHash" character varying(255),

"createdAt" timestamp with time zone NOT NULL,

"updatedAt" timestamp with time zone NOT NULL,

"tenantId" uuid NOT NULL,

"createdById" uuid,

"updatedById" uuid

);

--

-- Name: reports; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public.reports (

id uuid NOT NULL,

public boolean DEFAULT false NOT NULL,

name text NOT NULL,

"importHash" character varying(255),

"createdAt" timestamp with time zone NOT NULL,

"updatedAt" timestamp with time zone NOT NULL,

"deletedAt" timestamp with time zone,

"tenantId" uuid NOT NULL,

"createdById" uuid,

"updatedById" uuid

);

--

-- Name: settings; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public.settings (

id character varying(255) DEFAULT 'default'::character varying NOT NULL,

website character varying(255),

"backgroundImageUrl" character varying(1024),

"logoUrl" character varying(1024),

"createdAt" timestamp with time zone NOT NULL,

"updatedAt" timestamp with time zone NOT NULL,

"deletedAt" timestamp with time zone,

"tenantId" uuid NOT NULL,

"createdById" uuid,

"updatedById" uuid

);

--

-- Name: tags; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public.tags (

id uuid NOT NULL,

name text NOT NULL,

"importHash" character varying(255),

"createdAt" timestamp with time zone NOT NULL,

"updatedAt" timestamp with time zone NOT NULL,

"deletedAt" timestamp with time zone,

"tenantId" uuid NOT NULL,

"createdById" uuid,

"updatedById" uuid

);

--

-- Name: tenantUsers; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public."tenantUsers" (

id uuid NOT NULL,

roles text[],

"invitationToken" character varying(255),

status character varying(255) NOT NULL,

"createdAt" timestamp with time zone NOT NULL,

"updatedAt" timestamp with time zone NOT NULL,

"deletedAt" timestamp with time zone,

"tenantId" uuid,

"userId" uuid NOT NULL,

"createdById" uuid,

"updatedById" uuid

);

--

-- Name: tenants; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public.tenants (

id uuid NOT NULL,

name character varying(255) NOT NULL,

url character varying(50) NOT NULL,

plan character varying(255) DEFAULT 'free'::character varying NOT NULL,

"planStatus" character varying(255) DEFAULT 'active'::character varying NOT NULL,

"planStripeCustomerId" character varying(255),

"planUserId" uuid,

"onboardedAt" timestamp with time zone,

"hasSampleData" boolean DEFAULT false NOT NULL,

"createdAt" timestamp with time zone NOT NULL,

"updatedAt" timestamp with time zone NOT NULL,

"deletedAt" timestamp with time zone,

"createdById" uuid,

"updatedById" uuid

);

--

-- Name: users; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public.users (

id uuid NOT NULL,

"fullName" character varying(255),

"firstName" character varying(80),

password character varying(255),

"emailVerified" boolean DEFAULT false NOT NULL,

"emailVerificationToken" character varying(255),

"emailVerificationTokenExpiresAt" timestamp with time zone,

provider character varying(255),

"providerId" character varying(2024),

"passwordResetToken" character varying(255),

"passwordResetTokenExpiresAt" timestamp with time zone,

"lastName" character varying(175),

"phoneNumber" character varying(24),

email character varying(255) NOT NULL,

"jwtTokenInvalidBefore" timestamp with time zone,

"importHash" character varying(255),

"createdAt" timestamp with time zone NOT NULL,

"updatedAt" timestamp with time zone NOT NULL,

"deletedAt" timestamp with time zone,

"createdById" uuid,

"updatedById" uuid

);

--

-- Name: widgets; Type: TABLE; Schema: public; Owner: -

--

CREATE TABLE public.widgets (

id uuid NOT NULL,

type text NOT NULL,

title text,

settings jsonb,

cache jsonb,

"importHash" character varying(255),

"createdAt" timestamp with time zone NOT NULL,

"updatedAt" timestamp with time zone NOT NULL,

"deletedAt" timestamp with time zone,

"reportId" uuid,

"tenantId" uuid NOT NULL,

"createdById" uuid,

"updatedById" uuid

);

--

-- Name: activities activities_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.activities

ADD CONSTRAINT activities_pkey PRIMARY KEY (id);

--

-- Name: auditLogs auditLogs_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public."auditLogs"

ADD CONSTRAINT "auditLogs_pkey" PRIMARY KEY (id);

--

-- Name: automationExecutions automationExecutions_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public."automationExecutions"

ADD CONSTRAINT "automationExecutions_pkey" PRIMARY KEY (id);

--

-- Name: automations automations_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.automations

ADD CONSTRAINT automations_pkey PRIMARY KEY (id);

--

-- Name: communityMemberNoMerge communityMemberNoMerge_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public."communityMemberNoMerge"

ADD CONSTRAINT "communityMemberNoMerge_pkey" PRIMARY KEY ("communityMemberId", "noMergeId");

--

-- Name: communityMemberTags communityMemberTags_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public."communityMemberTags"

ADD CONSTRAINT "communityMemberTags_pkey" PRIMARY KEY ("communityMemberId", "tagId");

--

-- Name: communityMemberToMerge communityMemberToMerge_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public."communityMemberToMerge"

ADD CONSTRAINT "communityMemberToMerge_pkey" PRIMARY KEY ("communityMemberId", "toMergeId");

--

-- Name: communityMembers communityMembers_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public."communityMembers"

ADD CONSTRAINT "communityMembers_pkey" PRIMARY KEY (id);

--

-- Name: conversationSettings conversationSettings_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public."conversationSettings"

ADD CONSTRAINT "conversationSettings_pkey" PRIMARY KEY (id);

--

-- Name: conversations conversations_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.conversations

ADD CONSTRAINT conversations_pkey PRIMARY KEY (id);

--

-- Name: eagleEyeContents eagleEyeContents_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public."eagleEyeContents"

ADD CONSTRAINT "eagleEyeContents_pkey" PRIMARY KEY (id);

--

-- Name: files files_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.files

ADD CONSTRAINT files_pkey PRIMARY KEY (id);

--

-- Name: integrations integrations_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.integrations

ADD CONSTRAINT integrations_pkey PRIMARY KEY (id);

--

-- Name: microservices microservices_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.microservices

ADD CONSTRAINT microservices_pkey PRIMARY KEY (id);

--

-- Name: reports reports_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.reports

ADD CONSTRAINT reports_pkey PRIMARY KEY (id);

--

-- Name: settings settings_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.settings

ADD CONSTRAINT settings_pkey PRIMARY KEY (id);

--

-- Name: tags tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.tags

ADD CONSTRAINT tags_pkey PRIMARY KEY (id);

--

-- Name: tenantUsers tenantUsers_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public."tenantUsers"

ADD CONSTRAINT "tenantUsers_pkey" PRIMARY KEY (id);

--

-- Name: tenants tenants_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.tenants

ADD CONSTRAINT tenants_pkey PRIMARY KEY (id);

--

-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.users

ADD CONSTRAINT users_pkey PRIMARY KEY (id);

--

-- Name: widgets widgets_pkey; Type: CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.widgets

ADD CONSTRAINT widgets_pkey PRIMARY KEY (id);

--

-- Name: activities_community_member_id_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX activities_community_member_id_tenant_id ON public.activities USING btree ("communityMemberId", "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: activities_conversation_id_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX activities_conversation_id_tenant_id ON public.activities USING btree ("conversationId", "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: activities_deleted_at; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX activities_deleted_at ON public.activities USING btree ("deletedAt");

--

-- Name: activities_import_hash_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE UNIQUE INDEX activities_import_hash_tenant_id ON public.activities USING btree ("importHash", "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: activities_parent_id_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX activities_parent_id_tenant_id ON public.activities USING btree ("parentId", "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: activities_platform_tenant_id_type_timestamp; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX activities_platform_tenant_id_type_timestamp ON public.activities USING btree (platform, "tenantId", type, "timestamp") WHERE ("deletedAt" IS NULL);

--

-- Name: activities_source_id_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX activities_source_id_tenant_id ON public.activities USING btree ("sourceId", "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: activities_source_parent_id_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX activities_source_parent_id_tenant_id ON public.activities USING btree ("sourceParentId", "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: activities_timestamp_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX activities_timestamp_tenant_id ON public.activities USING btree ("timestamp", "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: automation_executions_automation_id; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX automation_executions_automation_id ON public."automationExecutions" USING btree ("automationId");

--

-- Name: automations_type_tenant_id_trigger_state; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX automations_type_tenant_id_trigger_state ON public.automations USING btree (type, "tenantId", trigger, state);

--

-- Name: community_members_created_at_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX community_members_created_at_tenant_id ON public."communityMembers" USING btree ("createdAt", "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: community_members_email_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX community_members_email_tenant_id ON public."communityMembers" USING btree (email, "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: community_members_import_hash_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE UNIQUE INDEX community_members_import_hash_tenant_id ON public."communityMembers" USING btree ("importHash", "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: community_members_joined_at_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX community_members_joined_at_tenant_id ON public."communityMembers" USING btree ("joinedAt", "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: community_members_location_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX community_members_location_tenant_id ON public."communityMembers" USING btree (location, "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: community_members_organisation_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX community_members_organisation_tenant_id ON public."communityMembers" USING btree (organisation, "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: community_members_score_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX community_members_score_tenant_id ON public."communityMembers" USING btree (score, "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: community_members_signals_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX community_members_signals_tenant_id ON public."communityMembers" USING btree (signals, "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: community_members_type_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX community_members_type_tenant_id ON public."communityMembers" USING btree (type, "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: community_members_username; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX community_members_username ON public."communityMembers" USING gin (username jsonb_path_ops);

--

-- Name: conversations_slug_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE UNIQUE INDEX conversations_slug_tenant_id ON public.conversations USING btree (slug, "tenantId");

--

-- Name: discord; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX discord ON public."communityMembers" USING btree (((username ->> 'discord'::text)));

--

-- Name: eagle_eye_contents_import_hash_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE UNIQUE INDEX eagle_eye_contents_import_hash_tenant_id ON public."eagleEyeContents" USING btree ("importHash", "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: eagle_eye_contents_platform_tenant_id_timestamp; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX eagle_eye_contents_platform_tenant_id_timestamp ON public."eagleEyeContents" USING btree (platform, "tenantId", "timestamp") WHERE ("deletedAt" IS NULL);

--

-- Name: eagle_eye_contents_status_tenant_id_timestamp; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX eagle_eye_contents_status_tenant_id_timestamp ON public."eagleEyeContents" USING btree (status, "tenantId", "timestamp") WHERE ("deletedAt" IS NULL);

--

-- Name: eagle_eye_contents_tenant_id_timestamp; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX eagle_eye_contents_tenant_id_timestamp ON public."eagleEyeContents" USING btree ("tenantId", "timestamp") WHERE ("deletedAt" IS NULL);

--

-- Name: github; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX github ON public."communityMembers" USING btree (((username ->> 'github'::text)));

--

-- Name: integrations_import_hash_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE UNIQUE INDEX integrations_import_hash_tenant_id ON public.integrations USING btree ("importHash", "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: integrations_integration_identifier; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX integrations_integration_identifier ON public.integrations USING btree ("integrationIdentifier");

--

-- Name: microservices_import_hash_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE UNIQUE INDEX microservices_import_hash_tenant_id ON public.microservices USING btree ("importHash", "tenantId");

--

-- Name: microservices_type_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE UNIQUE INDEX microservices_type_tenant_id ON public.microservices USING btree (type, "tenantId");

--

-- Name: reports_import_hash_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE UNIQUE INDEX reports_import_hash_tenant_id ON public.reports USING btree ("importHash", "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: slack; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX slack ON public."communityMembers" USING btree (((username ->> 'slack'::text)));

--

-- Name: tags_import_hash_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE UNIQUE INDEX tags_import_hash_tenant_id ON public.tags USING btree ("importHash", "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: tags_name_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE UNIQUE INDEX tags_name_tenant_id ON public.tags USING btree (name, "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: tenants_url; Type: INDEX; Schema: public; Owner: -

--

CREATE UNIQUE INDEX tenants_url ON public.tenants USING btree (url) WHERE ("deletedAt" IS NULL);

--

-- Name: twitter; Type: INDEX; Schema: public; Owner: -

--

CREATE INDEX twitter ON public."communityMembers" USING btree (((username ->> 'twitter'::text)));

--

-- Name: users_email; Type: INDEX; Schema: public; Owner: -

--

CREATE UNIQUE INDEX users_email ON public.users USING btree (email) WHERE ("deletedAt" IS NULL);

--

-- Name: users_import_hash; Type: INDEX; Schema: public; Owner: -

--

CREATE UNIQUE INDEX users_import_hash ON public.users USING btree ("importHash") WHERE ("deletedAt" IS NULL);

--

-- Name: widgets_import_hash_tenant_id; Type: INDEX; Schema: public; Owner: -

--

CREATE UNIQUE INDEX widgets_import_hash_tenant_id ON public.widgets USING btree ("importHash", "tenantId") WHERE ("deletedAt" IS NULL);

--

-- Name: activities activities_communityMemberId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.activities

ADD CONSTRAINT "activities_communityMemberId_fkey" FOREIGN KEY ("communityMemberId") REFERENCES public."communityMembers"(id) ON UPDATE CASCADE ON DELETE CASCADE;

--

-- Name: activities activities_conversationId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.activities

ADD CONSTRAINT "activities_conversationId_fkey" FOREIGN KEY ("conversationId") REFERENCES public.conversations(id) ON UPDATE CASCADE ON DELETE SET NULL;

--

-- Name: activities activities_createdById_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.activities

ADD CONSTRAINT "activities_createdById_fkey" FOREIGN KEY ("createdById") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE SET NULL;

--

-- Name: activities activities_parentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.activities

ADD CONSTRAINT "activities_parentId_fkey" FOREIGN KEY ("parentId") REFERENCES public.activities(id) ON UPDATE CASCADE ON DELETE SET NULL;

--

-- Name: activities activities_tenantId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.activities

ADD CONSTRAINT "activities_tenantId_fkey" FOREIGN KEY ("tenantId") REFERENCES public.tenants(id) ON UPDATE CASCADE;

--

-- Name: activities activities_updatedById_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.activities

ADD CONSTRAINT "activities_updatedById_fkey" FOREIGN KEY ("updatedById") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE SET NULL;

--

-- Name: automationExecutions automationExecutions_automationId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public."automationExecutions"

ADD CONSTRAINT "automationExecutions_automationId_fkey" FOREIGN KEY ("automationId") REFERENCES public.automations(id) ON UPDATE CASCADE;

--

-- Name: automationExecutions automationExecutions_tenantId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public."automationExecutions"

ADD CONSTRAINT "automationExecutions_tenantId_fkey" FOREIGN KEY ("tenantId") REFERENCES public.tenants(id) ON UPDATE CASCADE;

--

-- Name: automations automations_createdById_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.automations

ADD CONSTRAINT "automations_createdById_fkey" FOREIGN KEY ("createdById") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE SET NULL;

--

-- Name: automations automations_tenantId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.automations

ADD CONSTRAINT "automations_tenantId_fkey" FOREIGN KEY ("tenantId") REFERENCES public.tenants(id) ON UPDATE CASCADE;

--

-- Name: automations automations_updatedById_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public.automations

ADD CONSTRAINT "automations_updatedById_fkey" FOREIGN KEY ("updatedById") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE SET NULL;

--

-- Name: communityMemberNoMerge communityMemberNoMerge_communityMemberId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public."communityMemberNoMerge"

ADD CONSTRAINT "communityMemberNoMerge_communityMemberId_fkey" FOREIGN KEY ("communityMemberId") REFERENCES public."communityMembers"(id) ON UPDATE CASCADE ON DELETE CASCADE;

--

-- Name: communityMemberNoMerge communityMemberNoMerge_noMergeId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY public."communityMemberNoMerge"

ADD CONSTRAINT "communityMemberNoMerge_noMergeId_fkey" FOREIGN KEY ("noMergeId") REFERENCES public."communityMembers"(id) ON UPDATE CASCADE ON DELETE CASCADE;