SQLize
Online
/
PHPize Online
/
SQLtest Online
A
A
A
Share
Donate
Blog
Popular
Donate
A
A
A
Share
Blog
Popular
SQLize.online is a free online SQL environment for quickly running, experimenting with and sharing code.
You can run your SQL code on top of the most popular RDBMS including MySQL, MariaDB, SQLite, PostgreSQL, Oracle and Microsoft SQL Server.
SQL code:
Upload
Copy
Format
Clear
PGDMP ( | whaticketautomatizaai 17.0 (Debian 17.0-1.pgdg110+1) 17.0 (Debian 17.0-1.pgdg110+1) > � 0 0 ENCODING ENCODING SET client_encoding = 'UTF8'; false � 0 0 STDSTRINGS STDSTRINGS ( SET standard_conforming_strings = 'on'; false � 0 0 SEARCHPATH SEARCHPATH 8 SELECT pg_catalog.set_config('search_path', '', false); false � 1262 16384 whaticketautomatizaai DATABASE } CREATE DATABASE whaticketautomatizaai WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'C.UTF-8'; % DROP DATABASE whaticketautomatizaai; postgres false 3079 16394 uuid-ossp EXTENSION ? CREATE EXTENSION IF NOT EXISTS "uuid-ossp" WITH SCHEMA public; DROP EXTENSION "uuid-ossp"; false � 0 0 EXTENSION "uuid-ossp" COMMENT W COMMENT ON EXTENSION "uuid-ossp" IS 'generate universally unique identifiers (UUIDs)'; false 2 g 1255 17555 delete_expired_companies() FUNCTION � CREATE FUNCTION public.delete_expired_companies() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN DELETE FROM "Companies" WHERE "planId" = 100 AND "dueDate" < CURRENT_DATE; RETURN NEW; END; $$; 1 DROP FUNCTION public.delete_expired_companies(); public postgres false f 1255 17533 delete_old_company_sockets() FUNCTION � CREATE FUNCTION public.delete_old_company_sockets() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN DELETE FROM "CompanySockets" WHERE "createdAt" < NOW() - INTERVAL '24 hours'; RETURN NEW; END; $$; 3 DROP FUNCTION public.delete_old_company_sockets(); public postgres false 8 1259 17373 AgendamentoEmails TABLE p CREATE TABLE public."AgendamentoEmails" ( id integer NOT NULL, email character varying(255) NOT NULL, subject character varying(255) NOT NULL, message text, "dataAgendamento" timestamp with time zone NOT NULL, "companyId" integer NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); ' DROP TABLE public."AgendamentoEmails"; public heap r postgres false 7 1259 17372 AgendamentoEmails_id_seq SEQUENCE � CREATE SEQUENCE public."AgendamentoEmails_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; 1 DROP SEQUENCE public."AgendamentoEmails_id_seq"; public postgres false 312 � 0 0 AgendamentoEmails_id_seq SEQUENCE OWNED BY Y ALTER SEQUENCE public."AgendamentoEmails_id_seq" OWNED BY public."AgendamentoEmails".id; public postgres false 311 B 1259 17470 Ajuda TABLE c CREATE TABLE public."Ajuda" ( id integer NOT NULL, texto text, "userId" character varying(255), "socketId" character varying(255), "dataHora" timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, "createdAt" timestamp with time zone DEFAULT now() NOT NULL, "updatedAt" timestamp with time zone DEFAULT now() NOT NULL ); DROP TABLE public."Ajuda"; public heap r postgres false A 1259 17469 Ajuda_id_seq SEQUENCE � CREATE SEQUENCE public."Ajuda_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; % DROP SEQUENCE public."Ajuda_id_seq"; public postgres false 322 � 0 0 Ajuda_id_seq SEQUENCE OWNED BY A ALTER SEQUENCE public."Ajuda_id_seq" OWNED BY public."Ajuda".id; public postgres false 321 H 1259 17536 AnnouncementVisibilities TABLE d CREATE TABLE public."AnnouncementVisibilities" ( id integer NOT NULL, "companyId" integer NOT NULL, "announcementId" integer NOT NULL, visible boolean NOT NULL, title text NOT NULL, text text NOT NULL, "mediaPath" text, "mediaName" text, "createdAt" timestamp with time zone, "updatedAt" timestamp with time zone ); . DROP TABLE public."AnnouncementVisibilities"; public heap r postgres false G 1259 17535 AnnouncementVisibilities_id_seq SEQUENCE � CREATE SEQUENCE public."AnnouncementVisibilities_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; 8 DROP SEQUENCE public."AnnouncementVisibilities_id_seq"; public postgres false 328 � 0 0 AnnouncementVisibilities_id_seq SEQUENCE OWNED BY g ALTER SEQUENCE public."AnnouncementVisibilities_id_seq" OWNED BY public."AnnouncementVisibilities".id; public postgres false 327 1259 16980 Announcements TABLE b CREATE TABLE public."Announcements" ( id integer NOT NULL, priority integer, title character varying(255) NOT NULL, text text NOT NULL, "mediaPath" text, "mediaName" text, "companyId" integer NOT NULL, status boolean, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); # DROP TABLE public."Announcements"; public heap r postgres false 1259 16979 Announcements_id_seq SEQUENCE � CREATE SEQUENCE public."Announcements_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; - DROP SEQUENCE public."Announcements_id_seq"; public postgres false 276 � 0 0 Announcements_id_seq SEQUENCE OWNED BY Q ALTER SEQUENCE public."Announcements_id_seq" OWNED BY public."Announcements".id; public postgres false 275 & 1259 17163 ApiUsages TABLE � CREATE TABLE public."ApiUsages" ( id integer NOT NULL, "companyId" integer DEFAULT 0, "dateUsed" text NOT NULL, "UsedOnDay" integer DEFAULT 0, "usedText" integer DEFAULT 0, "usedPDF" integer DEFAULT 0, "usedImage" integer DEFAULT 0, "usedVideo" integer DEFAULT 0, "usedOther" integer DEFAULT 0, "usedCheckNumber" integer DEFAULT 0, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); DROP TABLE public."ApiUsages"; public heap r postgres false % 1259 17162 ApiUsages_id_seq SEQUENCE � CREATE SEQUENCE public."ApiUsages_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ) DROP SEQUENCE public."ApiUsages_id_seq"; public postgres false 294 � 0 0 ApiUsages_id_seq SEQUENCE OWNED BY I ALTER SEQUENCE public."ApiUsages_id_seq" OWNED BY public."ApiUsages".id; public postgres false 293 1259 16854 Baileys TABLE � CREATE TABLE public."Baileys" ( id integer NOT NULL, "whatsappId" integer NOT NULL, contacts jsonb, chats jsonb, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); DROP TABLE public."Baileys"; public heap r postgres false 1259 17107 BaileysChats TABLE K CREATE TABLE public."BaileysChats" ( id integer NOT NULL, "whatsappId" integer, jid character varying(255) NOT NULL, "conversationTimestamp" character varying(255) NOT NULL, "unreadCount" integer DEFAULT 0, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); " DROP TABLE public."BaileysChats"; public heap r postgres false 1259 17106 BaileysChats_id_seq SEQUENCE � CREATE SEQUENCE public."BaileysChats_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; , DROP SEQUENCE public."BaileysChats_id_seq"; public postgres false 288 � 0 0 BaileysChats_id_seq SEQUENCE OWNED BY O ALTER SEQUENCE public."BaileysChats_id_seq" OWNED BY public."BaileysChats".id; public postgres false 287 " 1259 17122 BaileysMessages TABLE CREATE TABLE public."BaileysMessages" ( id integer NOT NULL, "whatsappId" integer, "baileysChatId" integer, "jsonMessage" json NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); % DROP TABLE public."BaileysMessages"; public heap r postgres false ! 1259 17121 BaileysMessages_id_seq SEQUENCE � CREATE SEQUENCE public."BaileysMessages_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; / DROP SEQUENCE public."BaileysMessages_id_seq"; public postgres false 290 � 0 0 BaileysMessages_id_seq SEQUENCE OWNED BY U ALTER SEQUENCE public."BaileysMessages_id_seq" OWNED BY public."BaileysMessages".id; public postgres false 289 1259 16853 Baileys_id_seq SEQUENCE � CREATE SEQUENCE public."Baileys_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ' DROP SEQUENCE public."Baileys_id_seq"; public postgres false 263 � 0 0 Baileys_id_seq SEQUENCE OWNED BY E ALTER SEQUENCE public."Baileys_id_seq" OWNED BY public."Baileys".id; public postgres false 262 1259 16931 CampaignSettings TABLE � CREATE TABLE public."CampaignSettings" ( id integer NOT NULL, key character varying(255) NOT NULL, value text, "companyId" integer, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); & DROP TABLE public."CampaignSettings"; public heap r postgres false 1259 16930 CampaignSettings_id_seq SEQUENCE � CREATE SEQUENCE public."CampaignSettings_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; 0 DROP SEQUENCE public."CampaignSettings_id_seq"; public postgres false 271 � 0 0 CampaignSettings_id_seq SEQUENCE OWNED BY W ALTER SEQUENCE public."CampaignSettings_id_seq" OWNED BY public."CampaignSettings".id; public postgres false 270 1259 16952 CampaignShipping TABLE CREATE TABLE public."CampaignShipping" ( id integer NOT NULL, "jobId" character varying(255), number character varying(255) NOT NULL, message text NOT NULL, "confirmationMessage" text, confirmation boolean, "contactId" integer, "campaignId" integer NOT NULL, "confirmationRequestedAt" timestamp with time zone, "confirmedAt" timestamp with time zone, "deliveredAt" timestamp with time zone, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); & DROP TABLE public."CampaignShipping"; public heap r postgres false 1259 16951 CampaignShipping_id_seq SEQUENCE � CREATE SEQUENCE public."CampaignShipping_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; 0 DROP SEQUENCE public."CampaignShipping_id_seq"; public postgres false 274 � 0 0 CampaignShipping_id_seq SEQUENCE OWNED BY W ALTER SEQUENCE public."CampaignShipping_id_seq" OWNED BY public."CampaignShipping".id; public postgres false 273 1259 16895 Campaigns TABLE � CREATE TABLE public."Campaigns" ( id integer NOT NULL, name character varying(255) NOT NULL, message1 text DEFAULT ''::text, message2 text DEFAULT ''::text, message3 text DEFAULT ''::text, message4 text DEFAULT ''::text, message5 text DEFAULT ''::text, "confirmationMessage1" text DEFAULT ''::text, "confirmationMessage2" text DEFAULT ''::text, "confirmationMessage3" text DEFAULT ''::text, "confirmationMessage4" text DEFAULT ''::text, "confirmationMessage5" text DEFAULT ''::text, status character varying(255), confirmation boolean DEFAULT false, "mediaPath" text, "mediaName" text, "companyId" integer NOT NULL, "contactListId" integer, "whatsappId" integer, "scheduledAt" timestamp with time zone, "completedAt" timestamp with time zone, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, "fileListId" integer ); DROP TABLE public."Campaigns"; public heap r postgres false 1259 16894 Campaigns_id_seq SEQUENCE � CREATE SEQUENCE public."Campaigns_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ) DROP SEQUENCE public."Campaigns_id_seq"; public postgres false 269 � 0 0 Campaigns_id_seq SEQUENCE OWNED BY I ALTER SEQUENCE public."Campaigns_id_seq" OWNED BY public."Campaigns".id; public postgres false 268 @ 1259 17459 ChatImports TABLE � CREATE TABLE public."ChatImports" ( id integer NOT NULL, "companyId" integer NOT NULL, "isGroupImportActive" boolean DEFAULT false, "shouldCloseTicketAfterImport" boolean DEFAULT false, "importStartTime" timestamp with time zone, "importEndTime" timestamp with time zone, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); ! DROP TABLE public."ChatImports"; public heap r postgres false ? 1259 17458 ChatImports_id_seq SEQUENCE � CREATE SEQUENCE public."ChatImports_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; + DROP SEQUENCE public."ChatImports_id_seq"; public postgres false 320 � 0 0 ChatImports_id_seq SEQUENCE OWNED BY M ALTER SEQUENCE public."ChatImports_id_seq" OWNED BY public."ChatImports".id; public postgres false 319 1259 17033 ChatMessages TABLE 5 CREATE TABLE public."ChatMessages" ( id integer NOT NULL, "chatId" integer NOT NULL, "senderId" integer NOT NULL, message text DEFAULT ''::text, "mediaPath" text, "mediaName" text, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); " DROP TABLE public."ChatMessages"; public heap r postgres false 1259 17032 ChatMessages_id_seq SEQUENCE � CREATE SEQUENCE public."ChatMessages_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; , DROP SEQUENCE public."ChatMessages_id_seq"; public postgres false 282 � 0 0 ChatMessages_id_seq SEQUENCE OWNED BY O ALTER SEQUENCE public."ChatMessages_id_seq" OWNED BY public."ChatMessages".id; public postgres false 281 1259 17015 ChatUsers TABLE CREATE TABLE public."ChatUsers" ( id integer NOT NULL, "chatId" integer NOT NULL, "userId" integer NOT NULL, unreads integer DEFAULT 0, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); DROP TABLE public."ChatUsers"; public heap r postgres false 1259 17014 ChatUsers_id_seq SEQUENCE � CREATE SEQUENCE public."ChatUsers_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ) DROP SEQUENCE public."ChatUsers_id_seq"; public postgres false 280 � 0 0 ChatUsers_id_seq SEQUENCE OWNED BY I ALTER SEQUENCE public."ChatUsers_id_seq" OWNED BY public."ChatUsers".id; public postgres false 279 � 1259 16725 Chatbots TABLE � CREATE TABLE public."Chatbots" ( id integer NOT NULL, name character varying(255) NOT NULL, "queueId" integer, "chatbotId" integer, "greetingMessage" text, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, "isAgent" boolean DEFAULT false, "optionType" character varying(255) DEFAULT 'text'::character varying ); DROP TABLE public."Chatbots"; public heap r postgres false � 1259 16724 Chatbots_id_seq SEQUENCE � CREATE SEQUENCE public."Chatbots_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ( DROP SEQUENCE public."Chatbots_id_seq"; public postgres false 252 � 0 0 Chatbots_id_seq SEQUENCE OWNED BY G ALTER SEQUENCE public."Chatbots_id_seq" OWNED BY public."Chatbots".id; public postgres false 251 1259 16994 Chats TABLE Y CREATE TABLE public."Chats" ( id integer NOT NULL, title text DEFAULT ''::text, uuid character varying(255) DEFAULT ''::character varying, "ownerId" integer NOT NULL, "lastMessage" text, "companyId" integer NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); DROP TABLE public."Chats"; public heap r postgres false Y 1259 17693 ChatsImport TABLE 5 CREATE TABLE public."ChatsImport" ( id integer NOT NULL, "whatsappId" integer NOT NULL, "messageCount" integer NOT NULL, messages jsonb, "createdAt" timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, "updatedAt" timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL ); ! DROP TABLE public."ChatsImport"; public heap r postgres false X 1259 17692 ChatsImport_id_seq SEQUENCE � CREATE SEQUENCE public."ChatsImport_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; + DROP SEQUENCE public."ChatsImport_id_seq"; public postgres false 345 � 0 0 ChatsImport_id_seq SEQUENCE OWNED BY M ALTER SEQUENCE public."ChatsImport_id_seq" OWNED BY public."ChatsImport".id; public postgres false 344 1259 16993 Chats_id_seq SEQUENCE � CREATE SEQUENCE public."Chats_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; % DROP SEQUENCE public."Chats_id_seq"; public postgres false 278 � 0 0 Chats_id_seq SEQUENCE OWNED BY A ALTER SEQUENCE public."Chats_id_seq" OWNED BY public."Chats".id; public postgres false 277 � 1259 16554 Companies TABLE � CREATE TABLE public."Companies" ( id integer NOT NULL, name character varying(255) NOT NULL, phone character varying(255), email character varying(255), "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, "planId" integer, status boolean DEFAULT true, schedules jsonb DEFAULT '[]'::jsonb, "dueDate" timestamp with time zone, recurrence character varying(255) DEFAULT ''::character varying, document character varying(255) DEFAULT ''::character varying, "paymentMethod" character varying(255) DEFAULT ''::character varying, "lastLogin" timestamp with time zone, "verificationToken" character varying(255) DEFAULT NULL::character varying, "isVerified" boolean DEFAULT false, token character varying(255) DEFAULT NULL::character varying, whitelabel boolean DEFAULT false NOT NULL, dominio character varying(255) ); DROP TABLE public."Companies"; public heap r postgres false � 1259 16553 Companies_id_seq SEQUENCE � CREATE SEQUENCE public."Companies_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ) DROP SEQUENCE public."Companies_id_seq"; public postgres false 238 � 0 0 Companies_id_seq SEQUENCE OWNED BY I ALTER SEQUENCE public."Companies_id_seq" OWNED BY public."Companies".id; public postgres false 237 F 1259 17520 CompanySockets TABLE . CREATE TABLE public."CompanySockets" ( id integer NOT NULL, "companyId" integer NOT NULL, "socketId" character varying(255) NOT NULL, "createdAt" timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, "updatedAt" timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL ); $ DROP TABLE public."CompanySockets"; public heap r postgres false E 1259 17519 CompanySockets_id_seq SEQUENCE � CREATE SEQUENCE public."CompanySockets_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; . DROP SEQUENCE public."CompanySockets_id_seq"; public postgres false 326 � 0 0 CompanySockets_id_seq SEQUENCE OWNED BY S ALTER SEQUENCE public."CompanySockets_id_seq" OWNED BY public."CompanySockets".id; public postgres false 325 > 1259 17423 Configurations TABLE � CREATE TABLE public."Configurations" ( id integer NOT NULL, "nomeSistema" character varying(255), "numeroSuporte" character varying(255), "codigoCor" character varying(255), logo bytea, "mensagemWhatsApp" text, "mensagemEmail" text, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, "mensagemRedefinicaoSenha" text, "logoLogin" bytea, "logoBanner" bytea, "primaryDark" character varying(255), "textPrimary" character varying(255), "tabHeaderBackground" character varying(255), options character varying(255), "fancyBackground" character varying(255), inputdigita character varying(255), login character varying(255), "barraSuperior" character varying(255), "companyId" integer, "TicketsManagerTabs" character varying(255), "Login" character varying(255), "FundoLogin" bytea, fundologin text, "codigoCorfundo" character varying(255), "Cadastro" character varying(255), "Dashboard" character varying(255), "nomeLogo" character varying(255), "nomeLogoLogin" character varying(255), "nomeBanner" character varying(255), "politicaPrivacidade" text, "termosDeUso" text ); $ DROP TABLE public."Configurations"; public heap r postgres false = 1259 17422 Configurations_id_seq SEQUENCE � CREATE SEQUENCE public."Configurations_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; . DROP SEQUENCE public."Configurations_id_seq"; public postgres false 318 � 0 0 Configurations_id_seq SEQUENCE OWNED BY S ALTER SEQUENCE public."Configurations_id_seq" OWNED BY public."Configurations".id; public postgres false 317 � 1259 16474 ContactCustomFields TABLE $ CREATE TABLE public."ContactCustomFields" ( id integer NOT NULL, name character varying(255) NOT NULL, value character varying(255) NOT NULL, "contactId" integer NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); ) DROP TABLE public."ContactCustomFields"; public heap r postgres false � 1259 16473 ContactCustomFields_id_seq SEQUENCE � CREATE SEQUENCE public."ContactCustomFields_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; 3 DROP SEQUENCE public."ContactCustomFields_id_seq"; public postgres false 231 � 0 0 ContactCustomFields_id_seq SEQUENCE OWNED BY ] ALTER SEQUENCE public."ContactCustomFields_id_seq" OWNED BY public."ContactCustomFields".id; public postgres false 230 1259 16875 ContactListItems TABLE � CREATE TABLE public."ContactListItems" ( id integer NOT NULL, name character varying(255) NOT NULL, number character varying(255) NOT NULL, email character varying(255), "contactListId" integer NOT NULL, "isWhatsappValid" boolean DEFAULT false, "companyId" integer, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); & DROP TABLE public."ContactListItems"; public heap r postgres false 1259 16874 ContactListItems_id_seq SEQUENCE � CREATE SEQUENCE public."ContactListItems_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; 0 DROP SEQUENCE public."ContactListItems_id_seq"; public postgres false 267 � 0 0 ContactListItems_id_seq SEQUENCE OWNED BY W ALTER SEQUENCE public."ContactListItems_id_seq" OWNED BY public."ContactListItems".id; public postgres false 266 1259 16863 ContactLists TABLE � CREATE TABLE public."ContactLists" ( id integer NOT NULL, name character varying(255) NOT NULL, "companyId" integer, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); " DROP TABLE public."ContactLists"; public heap r postgres false 1259 16862 ContactLists_id_seq SEQUENCE � CREATE SEQUENCE public."ContactLists_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; , DROP SEQUENCE public."ContactLists_id_seq"; public postgres false 265 � 0 0 ContactLists_id_seq SEQUENCE OWNED BY O ALTER SEQUENCE public."ContactLists_id_seq" OWNED BY public."ContactLists".id; public postgres false 264 � 1259 16417 Contacts TABLE � CREATE TABLE public."Contacts" ( id integer NOT NULL, name character varying(255) NOT NULL, number character varying(255) NOT NULL, "profilePicUrl" text, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, email character varying(255) DEFAULT ''::character varying NOT NULL, "isGroup" boolean DEFAULT false NOT NULL, "companyId" integer, "acceptAudioMessage" boolean DEFAULT true NOT NULL, channel text DEFAULT 'whatsapp'::text, active boolean DEFAULT true, "disableBot" boolean DEFAULT false NOT NULL, "whatsappId" integer, "additionalData" json, "walleteUserId" integer ); DROP TABLE public."Contacts"; public heap r postgres false � 1259 16416 Contacts_id_seq SEQUENCE � CREATE SEQUENCE public."Contacts_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ( DROP SEQUENCE public."Contacts_id_seq"; public postgres false 224 � 0 0 Contacts_id_seq SEQUENCE OWNED BY G ALTER SEQUENCE public."Contacts_id_seq" OWNED BY public."Contacts".id; public postgres false 223 � 1259 16744 DialogChatBots TABLE CREATE TABLE public."DialogChatBots" ( id integer NOT NULL, awaiting integer DEFAULT 0 NOT NULL, "contactId" integer, "chatbotId" integer, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, "queueId" integer ); $ DROP TABLE public."DialogChatBots"; public heap r postgres false � 1259 16743 DialogChatBots_id_seq SEQUENCE � CREATE SEQUENCE public."DialogChatBots_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; . DROP SEQUENCE public."DialogChatBots_id_seq"; public postgres false 254 � 0 0 DialogChatBots_id_seq SEQUENCE OWNED BY S ALTER SEQUENCE public."DialogChatBots_id_seq" OWNED BY public."DialogChatBots".id; public postgres false 253 6 1259 17359 Emails TABLE P CREATE TABLE public."Emails" ( id integer NOT NULL, sender character varying(255), subject character varying(255), message text, "companyId" integer, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, scheduled boolean, "sendAt" timestamp with time zone ); DROP TABLE public."Emails"; public heap r postgres false 5 1259 17358 Emails_id_seq SEQUENCE � CREATE SEQUENCE public."Emails_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; & DROP SEQUENCE public."Emails_id_seq"; public postgres false 310 � 0 0 Emails_id_seq SEQUENCE OWNED BY C ALTER SEQUENCE public."Emails_id_seq" OWNED BY public."Emails".id; public postgres false 309 : 1259 17393 Eventos TABLE � CREATE TABLE public."Eventos" ( id integer NOT NULL, title character varying(255) NOT NULL, description text, start timestamp with time zone NOT NULL, "end" timestamp with time zone NOT NULL, concluido boolean DEFAULT false, "companyId" integer NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); DROP TABLE public."Eventos"; public heap r postgres false 9 1259 17392 Eventos_id_seq SEQUENCE � CREATE SEQUENCE public."Eventos_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ' DROP SEQUENCE public."Eventos_id_seq"; public postgres false 314 � 0 0 Eventos_id_seq SEQUENCE OWNED BY E ALTER SEQUENCE public."Eventos_id_seq" OWNED BY public."Eventos".id; public postgres false 313 . 1259 17251 Files TABLE CREATE TABLE public."Files" ( id integer NOT NULL, "companyId" integer NOT NULL, name character varying(255) NOT NULL, message text NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); DROP TABLE public."Files"; public heap r postgres false 0 1259 17265 FilesOptions TABLE _ CREATE TABLE public."FilesOptions" ( id integer NOT NULL, name character varying(255) NOT NULL, path character varying(255) NOT NULL, "fileId" integer NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, "mediaType" character varying(255) DEFAULT ''::character varying ); " DROP TABLE public."FilesOptions"; public heap r postgres false / 1259 17264 FilesOptions_id_seq SEQUENCE � CREATE SEQUENCE public."FilesOptions_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; , DROP SEQUENCE public."FilesOptions_id_seq"; public postgres false 304 � 0 0 FilesOptions_id_seq SEQUENCE OWNED BY O ALTER SEQUENCE public."FilesOptions_id_seq" OWNED BY public."FilesOptions".id; public postgres false 303 - 1259 17250 Files_id_seq SEQUENCE � CREATE SEQUENCE public."Files_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; % DROP SEQUENCE public."Files_id_seq"; public postgres false 302 � 0 0 Files_id_seq SEQUENCE OWNED BY A ALTER SEQUENCE public."Files_id_seq" OWNED BY public."Files".id; public postgres false 301 I 1259 17558 Flows TABLE u CREATE TABLE public."Flows" ( id uuid NOT NULL, nodes json, edges json, "companyId" integer NOT NULL, "createdAt" timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, "updatedAt" timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, name character varying(255), schedule json, "offHoursMessage" text, keywords json ); DROP TABLE public."Flows"; public heap r postgres false � 1259 16658 Helps TABLE CREATE TABLE public."Helps" ( id integer NOT NULL, title character varying(255) NOT NULL, description text, video character varying(255), link text, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); DROP TABLE public."Helps"; public heap r postgres false � 1259 16657 Helps_id_seq SEQUENCE � CREATE SEQUENCE public."Helps_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; % DROP SEQUENCE public."Helps_id_seq"; public postgres false 246 � 0 0 Helps_id_seq SEQUENCE OWNED BY A ALTER SEQUENCE public."Helps_id_seq" OWNED BY public."Helps".id; public postgres false 245 $ 1259 17148 Integrations TABLE � CREATE TABLE public."Integrations" ( id integer NOT NULL, "companyId" integer NOT NULL, name character varying(255) NOT NULL, "isActive" boolean DEFAULT false, token text, "foneContact" character varying(255), "userLogin" character varying(255), "passLogin" character varying(255), "finalCurrentMonth" integer, "initialCurrentMonth" integer, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); " DROP TABLE public."Integrations"; public heap r postgres false # 1259 17147 Integrations_id_seq SEQUENCE � CREATE SEQUENCE public."Integrations_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; , DROP SEQUENCE public."Integrations_id_seq"; public postgres false 292 � 0 0 Integrations_id_seq SEQUENCE OWNED BY O ALTER SEQUENCE public."Integrations_id_seq" OWNED BY public."Integrations".id; public postgres false 291 1259 17074 Invoices TABLE [ CREATE TABLE public."Invoices" ( id integer NOT NULL, "companyId" integer NOT NULL, "dueDate" character varying(255), detail character varying(255), status character varying(255), value double precision, users integer DEFAULT 0, connections integer DEFAULT 0, queues integer DEFAULT 0, "useWhatsapp" boolean DEFAULT true, "useFacebook" boolean DEFAULT true, "useInstagram" boolean DEFAULT true, "useCampaigns" boolean DEFAULT true, "useSchedules" boolean DEFAULT true, "useInternalChat" boolean DEFAULT true, "useExternalApi" boolean DEFAULT true, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, "useTypebot" boolean DEFAULT false NOT NULL, "useN8n" boolean DEFAULT false NOT NULL, "useChatGPT" boolean DEFAULT false NOT NULL ); DROP TABLE public."Invoices"; public heap r postgres false 1259 17073 Invoices_id_seq SEQUENCE � CREATE SEQUENCE public."Invoices_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ( DROP SEQUENCE public."Invoices_id_seq"; public postgres false 286 � 0 0 Invoices_id_seq SEQUENCE OWNED BY G ALTER SEQUENCE public."Invoices_id_seq" OWNED BY public."Invoices".id; public postgres false 285 [ 1259 17709 MessageImportStatuses TABLE � CREATE TABLE public."MessageImportStatuses" ( id integer NOT NULL, "whatsappId" integer NOT NULL, "totalMessages" integer NOT NULL, "importedMessages" integer DEFAULT 0 NOT NULL, "createdAt" timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, "updatedAt" timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, status character varying(255) DEFAULT 'pending'::character varying NOT NULL ); + DROP TABLE public."MessageImportStatuses"; public heap r postgres false Z 1259 17708 MessageImportStatuses_id_seq SEQUENCE � CREATE SEQUENCE public."MessageImportStatuses_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; 5 DROP SEQUENCE public."MessageImportStatuses_id_seq"; public postgres false 347 � 0 0 MessageImportStatuses_id_seq SEQUENCE OWNED BY a ALTER SEQUENCE public."MessageImportStatuses_id_seq" OWNED BY public."MessageImportStatuses".id; public postgres false 346 � 1259 16445 Messages TABLE � CREATE TABLE public."Messages" ( id character varying(255) NOT NULL, body text NOT NULL, ack integer DEFAULT 0 NOT NULL, read boolean DEFAULT false NOT NULL, "mediaType" character varying(255), "mediaUrl" character varying(255), "ticketId" integer NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, "fromMe" boolean DEFAULT false NOT NULL, "isDeleted" boolean DEFAULT false NOT NULL, "contactId" integer, "quotedMsgId" character varying(255), "companyId" integer, "remoteJid" text, "dataJson" text, participant text, "queueId" integer, "isEdited" boolean DEFAULT false NOT NULL, transcription text ); DROP TABLE public."Messages"; public heap r postgres false K 1259 17573 NotyNodes TABLE # CREATE TABLE public."NotyNodes" ( id integer NOT NULL, "ticketId" integer NOT NULL, "notifyNumber" character varying(255), "createdAt" timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, "updatedAt" timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL ); DROP TABLE public."NotyNodes"; public heap r postgres false J 1259 17572 NotyNodes_id_seq SEQUENCE � CREATE SEQUENCE public."NotyNodes_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ) DROP SEQUENCE public."NotyNodes_id_seq"; public postgres false 331 � 0 0 NotyNodes_id_seq SEQUENCE OWNED BY I ALTER SEQUENCE public."NotyNodes_id_seq" OWNED BY public."NotyNodes".id; public postgres false 330 R 1259 17640 OldMessages TABLE � CREATE TABLE public."OldMessages" ( id integer NOT NULL, "messageId" character varying(255) NOT NULL, body text NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); ! DROP TABLE public."OldMessages"; public heap r postgres false Q 1259 17639 OldMessages_id_seq SEQUENCE � CREATE SEQUENCE public."OldMessages_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; + DROP SEQUENCE public."OldMessages_id_seq"; public postgres false 338 � 0 0 OldMessages_id_seq SEQUENCE OWNED BY M ALTER SEQUENCE public."OldMessages_id_seq" OWNED BY public."OldMessages".id; public postgres false 337 L 1259 17598 Pixels TABLE � CREATE TABLE public."Pixels" ( id uuid NOT NULL, nome character varying(255), pixel character varying(255), "companyId" integer DEFAULT 0 NOT NULL, url character varying(255), convercoes integer DEFAULT 0 NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, "whatsappId" character varying(255), message character varying(255) ); DROP TABLE public."Pixels"; public heap r postgres false � 1259 16600 Plans TABLE � CREATE TABLE public."Plans" ( id integer NOT NULL, name character varying(255) NOT NULL, users integer DEFAULT 0, connections integer DEFAULT 0, queues integer DEFAULT 0, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, amount character varying(255), "useFacebook" boolean DEFAULT true, "useInstagram" boolean DEFAULT true, "useWhatsapp" boolean DEFAULT true, "useCampaigns" boolean DEFAULT true, "useExternalApi" boolean DEFAULT true, "useInternalChat" boolean DEFAULT true, "useSchedules" boolean DEFAULT true, "useKanban" boolean DEFAULT true, "useIntegrations" boolean DEFAULT true, "useOpenAi" boolean DEFAULT true, memory integer, "useTypebot" boolean DEFAULT false NOT NULL, "useN8n" boolean DEFAULT false NOT NULL, "useChatGPT" boolean DEFAULT false NOT NULL, "usePlanoTeste" boolean ); DROP TABLE public."Plans"; public heap r postgres false � 1259 16599 Plans_id_seq SEQUENCE � CREATE SEQUENCE public."Plans_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; % DROP SEQUENCE public."Plans_id_seq"; public postgres false 240 � 0 0 Plans_id_seq SEQUENCE OWNED BY A ALTER SEQUENCE public."Plans_id_seq" OWNED BY public."Plans".id; public postgres false 239 2 1259 17291 Prompts TABLE � CREATE TABLE public."Prompts" ( id integer NOT NULL, name text NOT NULL, "apiKey" text NOT NULL, prompt text NOT NULL, "maxTokens" integer DEFAULT 100 NOT NULL, "maxMessages" integer DEFAULT 10 NOT NULL, temperature integer DEFAULT 1 NOT NULL, "promptTokens" integer DEFAULT 0 NOT NULL, "completionTokens" integer DEFAULT 0 NOT NULL, "totalTokens" integer DEFAULT 0 NOT NULL, voice text, "voiceKey" text, "voiceRegion" text, "queueId" integer NOT NULL, "companyId" integer NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); DROP TABLE public."Prompts"; public heap r postgres false 1 1259 17290 Prompts_id_seq SEQUENCE � CREATE SEQUENCE public."Prompts_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ' DROP SEQUENCE public."Prompts_id_seq"; public postgres false 306 � 0 0 Prompts_id_seq SEQUENCE OWNED BY E ALTER SEQUENCE public."Prompts_id_seq" OWNED BY public."Prompts".id; public postgres false 305 , 1259 17227 QueueIntegrations TABLE CREATE TABLE public."QueueIntegrations" ( id integer NOT NULL, type character varying(255) NOT NULL, name character varying(255) NOT NULL, "projectName" character varying(255) NOT NULL, "jsonContent" text NOT NULL, language character varying(255) NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, "urlN8N" character varying(255) DEFAULT true NOT NULL, "companyId" integer, "typebotSlug" character varying(255) DEFAULT ''::character varying NOT NULL, "typebotKeywordFinish" character varying(255) DEFAULT ''::character varying NOT NULL, "typebotUnknownMessage" character varying(255) DEFAULT ''::character varying NOT NULL, "typebotExpires" integer DEFAULT 0 NOT NULL, "typebotDelayMessage" integer DEFAULT 1000 NOT NULL, "typebotRestartMessage" character varying(255) DEFAULT ''::character varying, "typebotKeywordRestart" character varying(255) DEFAULT ''::character varying, "aiToken" text, "aiPrompt" text ); ' DROP TABLE public."QueueIntegrations"; public heap r postgres false + 1259 17226 QueueIntegrations_id_seq SEQUENCE � CREATE SEQUENCE public."QueueIntegrations_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; 1 DROP SEQUENCE public."QueueIntegrations_id_seq"; public postgres false 300 � 0 0 QueueIntegrations_id_seq SEQUENCE OWNED BY Y ALTER SEQUENCE public."QueueIntegrations_id_seq" OWNED BY public."QueueIntegrations".id; public postgres false 299 1259 16762 QueueOptions TABLE L CREATE TABLE public."QueueOptions" ( id integer NOT NULL, title character varying(255) NOT NULL, message text, option text, "queueId" integer, "parentId" integer, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, "optionType" character varying(255) ); " DROP TABLE public."QueueOptions"; public heap r postgres false � 1259 16761 QueueOptions_id_seq SEQUENCE � CREATE SEQUENCE public."QueueOptions_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; , DROP SEQUENCE public."QueueOptions_id_seq"; public postgres false 256 � 0 0 QueueOptions_id_seq SEQUENCE OWNED BY O ALTER SEQUENCE public."QueueOptions_id_seq" OWNED BY public."QueueOptions".id; public postgres false 255 � 1259 16526 Queues TABLE � CREATE TABLE public."Queues" ( id integer NOT NULL, name character varying(255) NOT NULL, color character varying(255) NOT NULL, "greetingMessage" text, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, "companyId" integer, "outOfHoursMessage" text, schedules jsonb DEFAULT '[]'::jsonb, "orderQueue" integer, "integrationId" integer, "promptId" integer, options jsonb DEFAULT '[]'::jsonb ); DROP TABLE public."Queues"; public heap r postgres false � 1259 16525 Queues_id_seq SEQUENCE � CREATE SEQUENCE public."Queues_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; & DROP SEQUENCE public."Queues_id_seq"; public postgres false 234 � 0 0 Queues_id_seq SEQUENCE OWNED BY C ALTER SEQUENCE public."Queues_id_seq" OWNED BY public."Queues".id; public postgres false 233 � 1259 16643 QuickMessages TABLE � CREATE TABLE public."QuickMessages" ( id integer NOT NULL, shortcode character varying(255) NOT NULL, message text, "companyId" integer, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, "userId" integer, "mediaPath" character varying(255) DEFAULT NULL::character varying, "mediaName" character varying(255) DEFAULT NULL::character varying, geral boolean DEFAULT false NOT NULL ); # DROP TABLE public."QuickMessages"; public heap r postgres false � 1259 16642 QuickMessages_id_seq SEQUENCE � CREATE SEQUENCE public."QuickMessages_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; - DROP SEQUENCE public."QuickMessages_id_seq"; public postgres false 244 � 0 0 QuickMessages_id_seq SEQUENCE OWNED BY Q ALTER SEQUENCE public."QuickMessages_id_seq" OWNED BY public."QuickMessages".id; public postgres false 243 ( 1259 17183 Ratings TABLE CREATE TABLE public."Ratings" ( id integer NOT NULL, "companyId" integer NOT NULL, name character varying(255) NOT NULL, message text NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); DROP TABLE public."Ratings"; public heap r postgres false * 1259 17197 RatingsOptions TABLE CREATE TABLE public."RatingsOptions" ( id integer NOT NULL, name character varying(255) NOT NULL, value character varying(255) NOT NULL, "ratingId" integer NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); $ DROP TABLE public."RatingsOptions"; public heap r postgres false ) 1259 17196 RatingsOptions_id_seq SEQUENCE � CREATE SEQUENCE public."RatingsOptions_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; . DROP SEQUENCE public."RatingsOptions_id_seq"; public postgres false 298 � 0 0 RatingsOptions_id_seq SEQUENCE OWNED BY S ALTER SEQUENCE public."RatingsOptions_id_seq" OWNED BY public."RatingsOptions".id; public postgres false 297 ' 1259 17182 Ratings_id_seq SEQUENCE � CREATE SEQUENCE public."Ratings_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ' DROP SEQUENCE public."Ratings_id_seq"; public postgres false 296 � 0 0 Ratings_id_seq SEQUENCE OWNED BY E ALTER SEQUENCE public."Ratings_id_seq" OWNED BY public."Ratings".id; public postgres false 295 1259 16787 Schedules TABLE � CREATE TABLE public."Schedules" ( id integer NOT NULL, body text NOT NULL, "sendAt" timestamp with time zone, "sentAt" timestamp with time zone, "contactId" integer, "ticketId" integer, "userId" integer, "companyId" integer, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, status character varying(255), "mediaName" text, "mediaPath" text, recurrence boolean, "openTicket" boolean, connection character varying(255), "queueId" integer, recurrence2 character varying(255), recurrencedia character varying(255), recurrencediasemana character varying(255) ); DROP TABLE public."Schedules"; public heap r postgres false 1259 16786 Schedules_id_seq SEQUENCE � CREATE SEQUENCE public."Schedules_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ) DROP SEQUENCE public."Schedules_id_seq"; public postgres false 258 � 0 0 Schedules_id_seq SEQUENCE OWNED BY I ALTER SEQUENCE public."Schedules_id_seq" OWNED BY public."Schedules".id; public postgres false 257 � 1259 16389 SequelizeMeta TABLE R CREATE TABLE public."SequelizeMeta" ( name character varying(255) NOT NULL ); # DROP TABLE public."SequelizeMeta"; public heap r postgres false P 1259 17631 ServerData TABLE CREATE TABLE public."ServerData" ( id integer NOT NULL, totalmem character varying(255), freemem character varying(255), "cpuUsage" integer, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); DROP TABLE public."ServerData"; public heap r postgres false O 1259 17630 ServerData_id_seq SEQUENCE � CREATE SEQUENCE public."ServerData_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; * DROP SEQUENCE public."ServerData_id_seq"; public postgres false 336 � 0 0 ServerData_id_seq SEQUENCE OWNED BY K ALTER SEQUENCE public."ServerData_id_seq" OWNED BY public."ServerData".id; public postgres false 335 � 1259 16490 Settings TABLE � CREATE TABLE public."Settings" ( key character varying(255) NOT NULL, value text NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, "companyId" integer, id integer NOT NULL ); DROP TABLE public."Settings"; public heap r postgres false 1259 16944 Settings_id_seq SEQUENCE � CREATE SEQUENCE public."Settings_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ( DROP SEQUENCE public."Settings_id_seq"; public postgres false 232 � 0 0 Settings_id_seq SEQUENCE OWNED BY G ALTER SEQUENCE public."Settings_id_seq" OWNED BY public."Settings".id; public postgres false 272 N 1259 17609 SiteIntegrations TABLE � CREATE TABLE public."SiteIntegrations" ( id integer NOT NULL, name character varying(255), "companyId" integer, "accessCount" integer DEFAULT 0, url character varying(255), connection character varying(255), "phoneNumber" character varying(255), "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, "urlSite" character varying(255) ); & DROP TABLE public."SiteIntegrations"; public heap r postgres false M 1259 17608 SiteIntegrations_id_seq SEQUENCE � CREATE SEQUENCE public."SiteIntegrations_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; 0 DROP SEQUENCE public."SiteIntegrations_id_seq"; public postgres false 334 � 0 0 SiteIntegrations_id_seq SEQUENCE OWNED BY W ALTER SEQUENCE public."SiteIntegrations_id_seq" OWNED BY public."SiteIntegrations".id; public postgres false 333 T 1259 17654 StatusTicket TABLE � CREATE TABLE public."StatusTicket" ( id integer NOT NULL, priority integer, title character varying(255) NOT NULL, text text NOT NULL, color character varying(255) NOT NULL, "mediaPath" text, "mediaName" text, "companyId" integer NOT NULL, status boolean, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); " DROP TABLE public."StatusTicket"; public heap r postgres false S 1259 17653 StatusTicket_id_seq SEQUENCE � CREATE SEQUENCE public."StatusTicket_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; , DROP SEQUENCE public."StatusTicket_id_seq"; public postgres false 340 � 0 0 StatusTicket_id_seq SEQUENCE OWNED BY O ALTER SEQUENCE public."StatusTicket_id_seq" OWNED BY public."StatusTicket".id; public postgres false 339 1259 17059 Subscriptions TABLE � CREATE TABLE public."Subscriptions" ( id integer NOT NULL, "isActive" boolean DEFAULT false, "expiresAt" timestamp with time zone NOT NULL, "userPriceCents" integer, "whatsPriceCents" integer, "lastInvoiceUrl" character varying(255), "lastPlanChange" timestamp with time zone, "companyId" integer, "providerSubscriptionId" character varying(255) NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); # DROP TABLE public."Subscriptions"; public heap r postgres false 1259 17058 Subscriptions_id_seq SEQUENCE � CREATE SEQUENCE public."Subscriptions_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; - DROP SEQUENCE public."Subscriptions_id_seq"; public postgres false 284 � 0 0 Subscriptions_id_seq SEQUENCE OWNED BY Q ALTER SEQUENCE public."Subscriptions_id_seq" OWNED BY public."Subscriptions".id; public postgres false 283 1259 16826 Tags TABLE 8 CREATE TABLE public."Tags" ( id integer NOT NULL, name character varying(255) NOT NULL, color character varying(255), "companyId" integer NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, kanban integer, "orderTag" integer ); DROP TABLE public."Tags"; public heap r postgres false 1259 16825 Tags_id_seq SEQUENCE � CREATE SEQUENCE public."Tags_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; $ DROP SEQUENCE public."Tags_id_seq"; public postgres false 260 � 0 0 Tags_id_seq SEQUENCE OWNED BY ? ALTER SEQUENCE public."Tags_id_seq" OWNED BY public."Tags".id; public postgres false 259 4 1259 17338 Tasks TABLE CREATE TABLE public."Tasks" ( id integer NOT NULL, text character varying(255), description text, created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL, "companyId" integer NOT NULL, "userId" integer ); DROP TABLE public."Tasks"; public heap r postgres false 3 1259 17337 Tasks_id_seq SEQUENCE � CREATE SEQUENCE public."Tasks_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; % DROP SEQUENCE public."Tasks_id_seq"; public postgres false 308 � 0 0 Tasks_id_seq SEQUENCE OWNED BY A ALTER SEQUENCE public."Tasks_id_seq" OWNED BY public."Tasks".id; public postgres false 307 � 1259 16621 TicketNotes TABLE CREATE TABLE public."TicketNotes" ( id integer NOT NULL, note character varying(255) NOT NULL, "userId" integer, "contactId" integer NOT NULL, "ticketId" integer, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); ! DROP TABLE public."TicketNotes"; public heap r postgres false � 1259 16620 TicketNotes_id_seq SEQUENCE � CREATE SEQUENCE public."TicketNotes_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; + DROP SEQUENCE public."TicketNotes_id_seq"; public postgres false 242 � 0 0 TicketNotes_id_seq SEQUENCE OWNED BY M ALTER SEQUENCE public."TicketNotes_id_seq" OWNED BY public."TicketNotes".id; public postgres false 241 U 1259 17667 TicketStatus TABLE � CREATE TABLE public."TicketStatus" ( "ticketId" integer NOT NULL, "statusTicketId" integer NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); " DROP TABLE public."TicketStatus"; public heap r postgres false 1259 16839 TicketTags TABLE � CREATE TABLE public."TicketTags" ( "ticketId" integer NOT NULL, "tagId" integer NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, "contactId" integer ); DROP TABLE public."TicketTags"; public heap r postgres false � 1259 16669 TicketTraking TABLE CREATE TABLE public."TicketTraking" ( id integer NOT NULL, "ticketId" integer, "companyId" integer, "whatsappId" integer, "userId" integer, "createdAt" timestamp with time zone, "updatedAt" timestamp with time zone, "queuedAt" timestamp with time zone, "startedAt" timestamp with time zone, "finishedAt" timestamp with time zone, "ratingAt" timestamp with time zone, rated boolean DEFAULT false, "ratingId" integer, "chatbotAt" timestamp with time zone ); # DROP TABLE public."TicketTraking"; public heap r postgres false � 1259 16668 TicketTraking_id_seq SEQUENCE � CREATE SEQUENCE public."TicketTraking_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; - DROP SEQUENCE public."TicketTraking_id_seq"; public postgres false 248 0 0 TicketTraking_id_seq SEQUENCE OWNED BY Q ALTER SEQUENCE public."TicketTraking_id_seq" OWNED BY public."TicketTraking".id; public postgres false 247 D 1259 17503 TicketUser TABLE � CREATE TABLE public."TicketUser" ( id integer NOT NULL, "ticketId" integer NOT NULL, "userId" integer NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); DROP TABLE public."TicketUser"; public heap r postgres false C 1259 17502 TicketUser_id_seq SEQUENCE � CREATE SEQUENCE public."TicketUser_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; * DROP SEQUENCE public."TicketUser_id_seq"; public postgres false 324 0 0 TicketUser_id_seq SEQUENCE OWNED BY K ALTER SEQUENCE public."TicketUser_id_seq" OWNED BY public."TicketUser".id; public postgres false 323 � 1259 16426 Tickets TABLE � CREATE TABLE public."Tickets" ( id integer NOT NULL, status character varying(255) DEFAULT 'pending'::character varying NOT NULL, "lastMessage" text DEFAULT ''::text, "contactId" integer, "userId" integer, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, "whatsappId" integer, "isGroup" boolean DEFAULT false NOT NULL, "unreadMessages" integer, "queueId" integer, "companyId" integer, uuid uuid, chatbot boolean DEFAULT false, "queueOptionId" integer, "isBot" boolean, channel text DEFAULT 'whatsapp'::text, "amountUsedBotQueues" integer, "fromMe" boolean DEFAULT false NOT NULL, "useIntegration" boolean DEFAULT false, "integrationId" integer, "typebotSessionId" character varying(255) DEFAULT NULL::character varying, "typebotStatus" boolean DEFAULT false NOT NULL, "promptId" character varying(255) DEFAULT NULL::character varying, "startTypebot" boolean DEFAULT false NOT NULL, "secionIdTypebot" character varying(255), "specialMessage" character varying(255), "messageTypeBot" character varying(255) DEFAULT 'defaultType'::character varying, prompt integer, "participantIds" integer[], etapa character varying(255), "currentNodeId" character varying(255), "awaitingResponseNodeId" uuid, "lastNodeIdSent" character varying(255), "unreadMessagesCount" integer DEFAULT 0 NOT NULL, "awaitingRating" boolean DEFAULT false NOT NULL, "awaitingRatingId" integer, "awaitingUserId" integer, "flowId" uuid, "afterHoursMessageSent" boolean DEFAULT false NOT NULL, imported timestamp with time zone ); DROP TABLE public."Tickets"; public heap r postgres false � 1259 16425 Tickets_id_seq SEQUENCE � CREATE SEQUENCE public."Tickets_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ' DROP SEQUENCE public."Tickets_id_seq"; public postgres false 226 0 0 Tickets_id_seq SEQUENCE OWNED BY E ALTER SEQUENCE public."Tickets_id_seq" OWNED BY public."Tickets".id; public postgres false 225 � 1259 16548 UserQueues TABLE � CREATE TABLE public."UserQueues" ( "userId" integer NOT NULL, "queueId" integer NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); DROP TABLE public."UserQueues"; public heap r postgres false � 1259 16697 UserRatings TABLE , CREATE TABLE public."UserRatings" ( id integer NOT NULL, "ticketId" integer, "companyId" integer, "userId" integer, rate integer DEFAULT 0, "createdAt" timestamp with time zone, "updatedAt" timestamp with time zone, "ratingIdOption" integer, "ratingId" integer ); ! DROP TABLE public."UserRatings"; public heap r postgres false � 1259 16696 UserRatings_id_seq SEQUENCE � CREATE SEQUENCE public."UserRatings_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; + DROP SEQUENCE public."UserRatings_id_seq"; public postgres false 250 0 0 UserRatings_id_seq SEQUENCE OWNED BY M ALTER SEQUENCE public."UserRatings_id_seq" OWNED BY public."UserRatings".id; public postgres false 249 � 1259 16406 Users TABLE � CREATE TABLE public."Users" ( id integer NOT NULL, name character varying(255) NOT NULL, email character varying(255) NOT NULL, "passwordHash" character varying(255) NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, profile character varying(255) DEFAULT 'admin'::character varying NOT NULL, "tokenVersion" integer DEFAULT 0 NOT NULL, "companyId" integer, super boolean DEFAULT false, online boolean DEFAULT false, "endWork" character varying(255) DEFAULT '23:59'::character varying, "startWork" character varying(255) DEFAULT '00:00'::character varying, color character varying(255), "farewellMessage" text, "whatsappId" integer, "allTicket" character varying(255) DEFAULT 'disable'::character varying NOT NULL, "allHistoric" character varying(255) DEFAULT 'disabled'::character varying NOT NULL, "allUserChat" character varying(255) DEFAULT 'disabled'::character varying NOT NULL, "resetPassword" character varying(255), "confirmationToken" character varying(255) DEFAULT NULL::character varying, "profileState" character varying(255), intervalo boolean DEFAULT false NOT NULL, "profilePic" character varying(255) DEFAULT ''::character varying, "accessPages" character varying(255)[] DEFAULT (ARRAY[]::character varying[])::character varying(255)[] NOT NULL ); DROP TABLE public."Users"; public heap r postgres false � 1259 16405 Users_id_seq SEQUENCE � CREATE SEQUENCE public."Users_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; % DROP SEQUENCE public."Users_id_seq"; public postgres false 222 0 0 Users_id_seq SEQUENCE OWNED BY A ALTER SEQUENCE public."Users_id_seq" OWNED BY public."Users".id; public postgres false 221 � 1259 16543 WhatsappQueues TABLE � CREATE TABLE public."WhatsappQueues" ( "whatsappId" integer NOT NULL, "queueId" integer NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); $ DROP TABLE public."WhatsappQueues"; public heap r postgres false � 1259 16465 Whatsapps TABLE B CREATE TABLE public."Whatsapps" ( id integer NOT NULL, session text, qrcode text, status character varying(255), battery character varying(255), plugged boolean, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, name character varying(255) NOT NULL, "isDefault" boolean DEFAULT false NOT NULL, retries integer DEFAULT 0 NOT NULL, "greetingMessage" text, "companyId" integer, "complationMessage" text, "outOfHoursMessage" text, token text, "farewellMessage" text, provider text DEFAULT 'stable'::text, number text, channel text, "facebookUserToken" text, "tokenMeta" text, "facebookPageUserId" text, "facebookUserId" text, "sendIdQueue" integer, "promptId" integer, "integrationId" integer, "chatGPTEnabled" boolean DEFAULT false NOT NULL, "typebotEnabled" boolean DEFAULT false NOT NULL, "n8nEnabled" boolean DEFAULT false NOT NULL, "typebotCredential" character varying(255), "n8nCredential" character varying(255), "maxUseBotQueues" integer DEFAULT 3, "expiresTicket" integer DEFAULT 0, "expiresInactiveMessage" character varying(255) DEFAULT ''::character varying, "timeUseBotQueues" integer DEFAULT 0, "typingEnabled" boolean DEFAULT false NOT NULL, "isActive" boolean DEFAULT false, "greetingMediaAttachment" text, "transferQueueId" integer, "timeToTransfer" integer, "ratingMessage" character varying(255) DEFAULT NULL::character varying, "isImportModalOpen" boolean DEFAULT false, selectedfila integer[], "yesNoValue" character varying(255), minutes character varying(255), titlelist text DEFAULT ''::text NOT NULL, "flowId" uuid, "proxyHost" text, "proxyPort" integer, "proxyUsername" text, "proxyPassword" text, "selectedInterval" integer, "selectedMoveQueueId" integer, inatividade character varying(255), "randomizeImmediately" boolean DEFAULT false NOT NULL, "selectedAttendants" text[], "selectedDepartments" text[], "importOldMessages" timestamp with time zone, "importRecentMessages" timestamp with time zone, "statusImportMessages" character varying(255), "closedTicketsPostImported" boolean DEFAULT false, "importOldMessagesGroups" boolean DEFAULT false ); DROP TABLE public."Whatsapps"; public heap r postgres false � 1259 16464 Whatsapps_id_seq SEQUENCE � CREATE SEQUENCE public."Whatsapps_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ) DROP SEQUENCE public."Whatsapps_id_seq"; public postgres false 229 0 0 Whatsapps_id_seq SEQUENCE OWNED BY I ALTER SEQUENCE public."Whatsapps_id_seq" OWNED BY public."Whatsapps".id; public postgres false 228 < 1259 17414 credentials TABLE � CREATE TABLE public.credentials ( id integer NOT NULL, "typebotCredentials" character varying(255), "n8nCredentials" character varying(255), "chatGptCredential" character varying(255), "companyId" integer NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL, "tokenHubsoft" text, "tokenExpiration" timestamp with time zone ); DROP TABLE public.credentials; public heap r postgres false ; 1259 17413 credentials_id_seq SEQUENCE � CREATE SEQUENCE public.credentials_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ) DROP SEQUENCE public.credentials_id_seq; public postgres false 316 0 0 credentials_id_seq SEQUENCE OWNED BY I ALTER SEQUENCE public.credentials_id_seq OWNED BY public.credentials.id; public postgres false 315 W 1259 17685 veryChats TABLE � CREATE TABLE public."veryChats" ( id integer NOT NULL, "isActive" boolean DEFAULT true NOT NULL, "createdAt" timestamp with time zone NOT NULL, "updatedAt" timestamp with time zone NOT NULL ); DROP TABLE public."veryChats"; public heap r postgres false V 1259 17684 veryChats_id_seq SEQUENCE � CREATE SEQUENCE public."veryChats_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ) DROP SEQUENCE public."veryChats_id_seq"; public postgres false 343 0 0 veryChats_id_seq SEQUENCE OWNED BY I ALTER SEQUENCE public."veryChats_id_seq" OWNED BY public."veryChats".id; public postgres false 342 � 2604 17376 AgendamentoEmails id DEFAULT � ALTER TABLE ONLY public."AgendamentoEmails" ALTER COLUMN id SET DEFAULT nextval('public."AgendamentoEmails_id_seq"'::regclass); E ALTER TABLE public."AgendamentoEmails" ALTER COLUMN id DROP DEFAULT; public postgres false 312 311 312 � 2604 17473 Ajuda id DEFAULT h ALTER TABLE ONLY public."Ajuda" ALTER COLUMN id SET DEFAULT nextval('public."Ajuda_id_seq"'::regclass); 9 ALTER TABLE public."Ajuda" ALTER COLUMN id DROP DEFAULT; public postgres false 322 321 322 � 2604 17539 AnnouncementVisibilities id DEFAULT � ALTER TABLE ONLY public."AnnouncementVisibilities" ALTER COLUMN id SET DEFAULT nextval('public."AnnouncementVisibilities_id_seq"'::regclass); L ALTER TABLE public."AnnouncementVisibilities" ALTER COLUMN id DROP DEFAULT; public postgres false 327 328 328 H 2604 16983 Announcements id DEFAULT x ALTER TABLE ONLY public."Announcements" ALTER COLUMN id SET DEFAULT nextval('public."Announcements_id_seq"'::regclass); A ALTER TABLE public."Announcements" ALTER COLUMN id DROP DEFAULT; public postgres false 275 276 276 e 2604 17166 ApiUsages id DEFAULT p ALTER TABLE ONLY public."ApiUsages" ALTER COLUMN id SET DEFAULT nextval('public."ApiUsages_id_seq"'::regclass); = ALTER TABLE public."ApiUsages" ALTER COLUMN id DROP DEFAULT; public postgres false 294 293 294 6 2604 16857 Baileys id DEFAULT l ALTER TABLE ONLY public."Baileys" ALTER COLUMN id SET DEFAULT nextval('public."Baileys_id_seq"'::regclass); ; ALTER TABLE public."Baileys" ALTER COLUMN id DROP DEFAULT; public postgres false 262 263 263 ` 2604 17110 BaileysChats id DEFAULT v ALTER TABLE ONLY public."BaileysChats" ALTER COLUMN id SET DEFAULT nextval('public."BaileysChats_id_seq"'::regclass); @ ALTER TABLE public."BaileysChats" ALTER COLUMN id DROP DEFAULT; public postgres false 288 287 288 b 2604 17125 BaileysMessages id DEFAULT | ALTER TABLE ONLY public."BaileysMessages" ALTER COLUMN id SET DEFAULT nextval('public."BaileysMessages_id_seq"'::regclass); C ALTER TABLE public."BaileysMessages" ALTER COLUMN id DROP DEFAULT; public postgres false 289 290 290 F 2604 16934 CampaignSettings id DEFAULT ~ ALTER TABLE ONLY public."CampaignSettings" ALTER COLUMN id SET DEFAULT nextval('public."CampaignSettings_id_seq"'::regclass); D ALTER TABLE public."CampaignSettings" ALTER COLUMN id DROP DEFAULT; public postgres false 271 270 271 G 2604 16955 CampaignShipping id DEFAULT ~ ALTER TABLE ONLY public."CampaignShipping" ALTER COLUMN id SET DEFAULT nextval('public."CampaignShipping_id_seq"'::regclass); D ALTER TABLE public."CampaignShipping" ALTER COLUMN id DROP DEFAULT; public postgres false 274 273 274 : 2604 16898 Campaigns id DEFAULT p ALTER TABLE ONLY public."Campaigns" ALTER COLUMN id SET DEFAULT nextval('public."Campaigns_id_seq"'::regclass); = ALTER TABLE public."Campaigns" ALTER COLUMN id DROP DEFAULT; public postgres false 269 268 269 � 2604 17462 ChatImports id DEFAULT t ALTER TABLE ONLY public."ChatImports" ALTER COLUMN id SET DEFAULT nextval('public."ChatImports_id_seq"'::regclass); ? ALTER TABLE public."ChatImports" ALTER COLUMN id DROP DEFAULT; public postgres false 320 319 320 N 2604 17036 ChatMessages id DEFAULT v ALTER TABLE ONLY public."ChatMessages" ALTER COLUMN id SET DEFAULT nextval('public."ChatMessages_id_seq"'::regclass); @ ALTER TABLE public."ChatMessages" ALTER COLUMN id DROP DEFAULT; public postgres false 282 281 282 L 2604 17018 ChatUsers id DEFAULT p ALTER TABLE ONLY public."ChatUsers" ALTER COLUMN id SET DEFAULT nextval('public."ChatUsers_id_seq"'::regclass); = ALTER TABLE public."ChatUsers" ALTER COLUMN id DROP DEFAULT; public postgres false 279 280 280 . 2604 16728 Chatbots id DEFAULT n ALTER TABLE ONLY public."Chatbots" ALTER COLUMN id SET DEFAULT nextval('public."Chatbots_id_seq"'::regclass); < ALTER TABLE public."Chatbots" ALTER COLUMN id DROP DEFAULT; public postgres false 251 252 252 I 2604 16997 Chats id DEFAULT h ALTER TABLE ONLY public."Chats" ALTER COLUMN id SET DEFAULT nextval('public."Chats_id_seq"'::regclass); 9 ALTER TABLE public."Chats" ALTER COLUMN id DROP DEFAULT; public postgres false 278 277 278 � 2604 17696 ChatsImport id DEFAULT t ALTER TABLE ONLY public."ChatsImport" ALTER COLUMN id SET DEFAULT nextval('public."ChatsImport_id_seq"'::regclass); ? ALTER TABLE public."ChatsImport" ALTER COLUMN id DROP DEFAULT; public postgres false 345 344 345 2604 16557 Companies id DEFAULT p ALTER TABLE ONLY public."Companies" ALTER COLUMN id SET DEFAULT nextval('public."Companies_id_seq"'::regclass); = ALTER TABLE public."Companies" ALTER COLUMN id DROP DEFAULT; public postgres false 237 238 238 � 2604 17523 CompanySockets id DEFAULT z ALTER TABLE ONLY public."CompanySockets" ALTER COLUMN id SET DEFAULT nextval('public."CompanySockets_id_seq"'::regclass); B ALTER TABLE public."CompanySockets" ALTER COLUMN id DROP DEFAULT; public postgres false 326 325 326 � 2604 17426 Configurations id DEFAULT z ALTER TABLE ONLY public."Configurations" ALTER COLUMN id SET DEFAULT nextval('public."Configurations_id_seq"'::regclass); B ALTER TABLE public."Configurations" ALTER COLUMN id DROP DEFAULT; public postgres false 317 318 318 2604 16477 ContactCustomFields id DEFAULT � ALTER TABLE ONLY public."ContactCustomFields" ALTER COLUMN id SET DEFAULT nextval('public."ContactCustomFields_id_seq"'::regclass); G ALTER TABLE public."ContactCustomFields" ALTER COLUMN id DROP DEFAULT; public postgres false 231 230 231 8 2604 16878 ContactListItems id DEFAULT ~ ALTER TABLE ONLY public."ContactListItems" ALTER COLUMN id SET DEFAULT nextval('public."ContactListItems_id_seq"'::regclass); D ALTER TABLE public."ContactListItems" ALTER COLUMN id DROP DEFAULT; public postgres false 266 267 267 7 2604 16866 ContactLists id DEFAULT v ALTER TABLE ONLY public."ContactLists" ALTER COLUMN id SET DEFAULT nextval('public."ContactLists_id_seq"'::regclass); @ ALTER TABLE public."ContactLists" ALTER COLUMN id DROP DEFAULT; public postgres false 264 265 265 � 2604 16420 Contacts id DEFAULT n ALTER TABLE ONLY public."Contacts" ALTER COLUMN id SET DEFAULT nextval('public."Contacts_id_seq"'::regclass); < ALTER TABLE public."Contacts" ALTER COLUMN id DROP DEFAULT; public postgres false 223 224 224 1 2604 16747 DialogChatBots id DEFAULT z ALTER TABLE ONLY public."DialogChatBots" ALTER COLUMN id SET DEFAULT nextval('public."DialogChatBots_id_seq"'::regclass); B ALTER TABLE public."DialogChatBots" ALTER COLUMN id DROP DEFAULT; public postgres false 253 254 254 � 2604 17362 Emails id DEFAULT j ALTER TABLE ONLY public."Emails" ALTER COLUMN id SET DEFAULT nextval('public."Emails_id_seq"'::regclass); : ALTER TABLE public."Emails" ALTER COLUMN id DROP DEFAULT; public postgres false 310 309 310 � 2604 17396 Eventos id DEFAULT l ALTER TABLE ONLY public."Eventos" ALTER COLUMN id SET DEFAULT nextval('public."Eventos_id_seq"'::regclass); ; ALTER TABLE public."Eventos" ALTER COLUMN id DROP DEFAULT; public postgres false 314 313 314 y 2604 17254 Files id DEFAULT h ALTER TABLE ONLY public."Files" ALTER COLUMN id SET DEFAULT nextval('public."Files_id_seq"'::regclass); 9 ALTER TABLE public."Files" ALTER COLUMN id DROP DEFAULT; public postgres false 301 302 302 z 2604 17268 FilesOptions id DEFAULT v ALTER TABLE ONLY public."FilesOptions" ALTER COLUMN id SET DEFAULT nextval('public."FilesOptions_id_seq"'::regclass); @ ALTER TABLE public."FilesOptions" ALTER COLUMN id DROP DEFAULT; public postgres false 303 304 304 ) 2604 16661 Helps id DEFAULT h ALTER TABLE ONLY public."Helps" ALTER COLUMN id SET DEFAULT nextval('public."Helps_id_seq"'::regclass); 9 ALTER TABLE public."Helps" ALTER COLUMN id DROP DEFAULT; public postgres false 245 246 246 c 2604 17151 Integrations id DEFAULT v ALTER TABLE ONLY public."Integrations" ALTER COLUMN id SET DEFAULT nextval('public."Integrations_id_seq"'::regclass); @ ALTER TABLE public."Integrations" ALTER COLUMN id DROP DEFAULT; public postgres false 291 292 292 R 2604 17077 Invoices id DEFAULT n ALTER TABLE ONLY public."Invoices" ALTER COLUMN id SET DEFAULT nextval('public."Invoices_id_seq"'::regclass); < ALTER TABLE public."Invoices" ALTER COLUMN id DROP DEFAULT; public postgres false 286 285 286 � 2604 17712 MessageImportStatuses id DEFAULT � ALTER TABLE ONLY public."MessageImportStatuses" ALTER COLUMN id SET DEFAULT nextval('public."MessageImportStatuses_id_seq"'::regclass); I ALTER TABLE public."MessageImportStatuses" ALTER COLUMN id DROP DEFAULT; public postgres false 346 347 347 � 2604 17576 NotyNodes id DEFAULT p ALTER TABLE ONLY public."NotyNodes" ALTER COLUMN id SET DEFAULT nextval('public."NotyNodes_id_seq"'::regclass); = ALTER TABLE public."NotyNodes" ALTER COLUMN id DROP DEFAULT; public postgres false 331 330 331 � 2604 17643 OldMessages id DEFAULT t ALTER TABLE ONLY public."OldMessages" ALTER COLUMN id SET DEFAULT nextval('public."OldMessages_id_seq"'::regclass); ? ALTER TABLE public."OldMessages" ALTER COLUMN id DROP DEFAULT; public postgres false 338 337 338 2604 16603 Plans id DEFAULT h ALTER TABLE ONLY public."Plans" ALTER COLUMN id SET DEFAULT nextval('public."Plans_id_seq"'::regclass); 9 ALTER TABLE public."Plans" ALTER COLUMN id DROP DEFAULT; public postgres false 240 239 240 | 2604 17294 Prompts id DEFAULT l ALTER TABLE ONLY public."Prompts" ALTER COLUMN id SET DEFAULT nextval('public."Prompts_id_seq"'::regclass); ; ALTER TABLE public."Prompts" ALTER COLUMN id DROP DEFAULT; public postgres false 306 305 306 p 2604 17230 QueueIntegrations id DEFAULT � ALTER TABLE ONLY public."QueueIntegrations" ALTER COLUMN id SET DEFAULT nextval('public."QueueIntegrations_id_seq"'::regclass); E ALTER TABLE public."QueueIntegrations" ALTER COLUMN id DROP DEFAULT; public postgres false 299 300 300 3 2604 16765 QueueOptions id DEFAULT v ALTER TABLE ONLY public."QueueOptions" ALTER COLUMN id SET DEFAULT nextval('public."QueueOptions_id_seq"'::regclass); @ ALTER TABLE public."QueueOptions" ALTER COLUMN id DROP DEFAULT; public postgres false 255 256 256 2604 16529 Queues id DEFAULT j ALTER TABLE ONLY public."Queues" ALTER COLUMN id SET DEFAULT nextval('public."Queues_id_seq"'::regclass); : ALTER TABLE public."Queues" ALTER COLUMN id DROP DEFAULT; public postgres false 234 233 234 % 2604 16646 QuickMessages id DEFAULT x ALTER TABLE ONLY public."QuickMessages" ALTER COLUMN id SET DEFAULT nextval('public."QuickMessages_id_seq"'::regclass); A ALTER TABLE public."QuickMessages" ALTER COLUMN id DROP DEFAULT; public postgres false 243 244 244 n 2604 17186 Ratings id DEFAULT l ALTER TABLE ONLY public."Ratings" ALTER COLUMN id SET DEFAULT nextval('public."Ratings_id_seq"'::regclass); ; ALTER TABLE public."Ratings" ALTER COLUMN id DROP DEFAULT; public postgres false 296 295 296 o 2604 17200 RatingsOptions id DEFAULT z ALTER TABLE ONLY public."RatingsOptions" ALTER COLUMN id SET DEFAULT nextval('public."RatingsOptions_id_seq"'::regclass); B ALTER TABLE public."RatingsOptions" ALTER COLUMN id DROP DEFAULT; public postgres false 297 298 298 4 2604 16790 Schedules id DEFAULT p ALTER TABLE ONLY public."Schedules" ALTER COLUMN id SET DEFAULT nextval('public."Schedules_id_seq"'::regclass); = ALTER TABLE public."Schedules" ALTER COLUMN id DROP DEFAULT; public postgres false 258 257 258 � 2604 17634 ServerData id DEFAULT r ALTER TABLE ONLY public."ServerData" ALTER COLUMN id SET DEFAULT nextval('public."ServerData_id_seq"'::regclass); > ALTER TABLE public."ServerData" ALTER COLUMN id DROP DEFAULT; public postgres false 336 335 336 2604 16945 Settings id DEFAULT n ALTER TABLE ONLY public."Settings" ALTER COLUMN id SET DEFAULT nextval('public."Settings_id_seq"'::regclass); < ALTER TABLE public."Settings" ALTER COLUMN id DROP DEFAULT; public postgres false 272 232 � 2604 17612 SiteIntegrations id DEFAULT ~ ALTER TABLE ONLY public."SiteIntegrations" ALTER COLUMN id SET DEFAULT nextval('public."SiteIntegrations_id_seq"'::regclass); D ALTER TABLE public."SiteIntegrations" ALTER COLUMN id DROP DEFAULT; public postgres false 333 334 334 � 2604 17657 StatusTicket id DEFAULT v ALTER TABLE ONLY public."StatusTicket" ALTER COLUMN id SET DEFAULT nextval('public."StatusTicket_id_seq"'::regclass); @ ALTER TABLE public."StatusTicket" ALTER COLUMN id DROP DEFAULT; public postgres false 340 339 340 P 2604 17062 Subscriptions id DEFAULT x ALTER TABLE ONLY public."Subscriptions" ALTER COLUMN id SET DEFAULT nextval('public."Subscriptions_id_seq"'::regclass); A ALTER TABLE public."Subscriptions" ALTER COLUMN id DROP DEFAULT; public postgres false 284 283 284 5 2604 16829 Tags id DEFAULT f ALTER TABLE ONLY public."Tags" ALTER COLUMN id SET DEFAULT nextval('public."Tags_id_seq"'::regclass); 8 ALTER TABLE public."Tags" ALTER COLUMN id DROP DEFAULT; public postgres false 259 260 260 � 2604 17341 Tasks id DEFAULT h ALTER TABLE ONLY public."Tasks" ALTER COLUMN id SET DEFAULT nextval('public."Tasks_id_seq"'::regclass); 9 ALTER TABLE public."Tasks" ALTER COLUMN id DROP DEFAULT; public postgres false 307 308 308 $ 2604 16624 TicketNotes id DEFAULT t ALTER TABLE ONLY public."TicketNotes" ALTER COLUMN id SET DEFAULT nextval('public."TicketNotes_id_seq"'::regclass); ? ALTER TABLE public."TicketNotes" ALTER COLUMN id DROP DEFAULT; public postgres false 242 241 242 * 2604 16672 TicketTraking id DEFAULT x ALTER TABLE ONLY public."TicketTraking" ALTER COLUMN id SET DEFAULT nextval('public."TicketTraking_id_seq"'::regclass); A ALTER TABLE public."TicketTraking" ALTER COLUMN id DROP DEFAULT; public postgres false 247 248 248 � 2604 17506 TicketUser id DEFAULT r ALTER TABLE ONLY public."TicketUser" ALTER COLUMN id SET DEFAULT nextval('public."TicketUser_id_seq"'::regclass); > ALTER TABLE public."TicketUser" ALTER COLUMN id DROP DEFAULT; public postgres false 324 323 324 � 2604 16429 Tickets id DEFAULT l ALTER TABLE ONLY public."Tickets" ALTER COLUMN id SET DEFAULT nextval('public."Tickets_id_seq"'::regclass); ; ALTER TABLE public."Tickets" ALTER COLUMN id DROP DEFAULT; public postgres false 225 226 226 , 2604 16700 UserRatings id DEFAULT t ALTER TABLE ONLY public."UserRatings" ALTER COLUMN id SET DEFAULT nextval('public."UserRatings_id_seq"'::regclass); ? ALTER TABLE public."UserRatings" ALTER COLUMN id DROP DEFAULT; public postgres false 250 249 250 � 2604 16409 Users id DEFAULT h ALTER TABLE ONLY public."Users" ALTER COLUMN id SET DEFAULT nextval('public."Users_id_seq"'::regclass); 9 ALTER TABLE public."Users" ALTER COLUMN id DROP DEFAULT; public postgres false 222 221 222 � 2604 16468 Whatsapps id DEFAULT p ALTER TABLE ONLY public."Whatsapps" ALTER COLUMN id SET DEFAULT nextval('public."Whatsapps_id_seq"'::regclass); = ALTER TABLE public."Whatsapps" ALTER COLUMN id DROP DEFAULT; public postgres false 228 229 229 � 2604 17417 credentials id DEFAULT p ALTER TABLE ONLY public.credentials ALTER COLUMN id SET DEFAULT nextval('public.credentials_id_seq'::regclass); = ALTER TABLE public.credentials ALTER COLUMN id DROP DEFAULT; public postgres false 316 315 316 � 2604 17688 veryChats id DEFAULT p ALTER TABLE ONLY public."veryChats" ALTER COLUMN id SET DEFAULT nextval('public."veryChats_id_seq"'::regclass); = ALTER TABLE public."veryChats" ALTER COLUMN id DROP DEFAULT; public postgres false 342 343 343 � 0 17373 AgendamentoEmails TABLE DATA � COPY public."AgendamentoEmails" (id, email, subject, message, "dataAgendamento", "companyId", "createdAt", "updatedAt") FROM stdin; public postgres false 312 SA � 0 17470 Ajuda TABLE DATA h COPY public."Ajuda" (id, texto, "userId", "socketId", "dataHora", "createdAt", "updatedAt") FROM stdin; public postgres false 322 pA � 0 17536 AnnouncementVisibilities TABLE DATA � COPY public."AnnouncementVisibilities" (id, "companyId", "announcementId", visible, title, text, "mediaPath", "mediaName", "createdAt", "updatedAt") FROM stdin; public postgres false 328 �A } 0 16980 Announcements TABLE DATA � COPY public."Announcements" (id, priority, title, text, "mediaPath", "mediaName", "companyId", status, "createdAt", "updatedAt") FROM stdin; public postgres false 276 LD � 0 17163 ApiUsages TABLE DATA � COPY public."ApiUsages" (id, "companyId", "dateUsed", "UsedOnDay", "usedText", "usedPDF", "usedImage", "usedVideo", "usedOther", "usedCheckNumber", "createdAt", "updatedAt") FROM stdin; public postgres false 294 G p 0 16854 Baileys TABLE DATA ` COPY public."Baileys" (id, "whatsappId", contacts, chats, "createdAt", "updatedAt") FROM stdin; public postgres false 263 'G � 0 17107 BaileysChats TABLE DATA � COPY public."BaileysChats" (id, "whatsappId", jid, "conversationTimestamp", "unreadCount", "createdAt", "updatedAt") FROM stdin; public postgres false 288 DG � 0 17122 BaileysMessages TABLE DATA w COPY public."BaileysMessages" (id, "whatsappId", "baileysChatId", "jsonMessage", "createdAt", "updatedAt") FROM stdin; public postgres false 290 aG x 0 16931 CampaignSettings TABLE DATA c COPY public."CampaignSettings" (id, key, value, "companyId", "createdAt", "updatedAt") FROM stdin; public postgres false 271 ~G { 0 16952 CampaignShipping TABLE DATA � COPY public."CampaignShipping" (id, "jobId", number, message, "confirmationMessage", confirmation, "contactId", "campaignId", "confirmationRequestedAt", "confirmedAt", "deliveredAt", "createdAt", "updatedAt") FROM stdin; public postgres false 274 �G v 0 16895 Campaigns TABLE DATA { COPY public."Campaigns" (id, name, message1, message2, message3, message4, message5, "confirmationMessage1", "confirmationMessage2", "confirmationMessage3", "confirmationMessage4", "confirmationMessage5", status, confirmation, "mediaPath", "mediaName", "companyId", "contactListId", "whatsappId", "scheduledAt", "completedAt", "createdAt", "updatedAt", "fileListId") FROM stdin; public postgres false 269 �G � 0 17459 ChatImports TABLE DATA � COPY public."ChatImports" (id, "companyId", "isGroupImportActive", "shouldCloseTicketAfterImport", "importStartTime", "importEndTime", "createdAt", "updatedAt") FROM stdin; public postgres false 320 �G � 0 17033 ChatMessages TABLE DATA COPY public."ChatMessages" (id, "chatId", "senderId", message, "mediaPath", "mediaName", "createdAt", "updatedAt") FROM stdin; public postgres false 282 �G � 0 17015 ChatUsers TABLE DATA ` COPY public."ChatUsers" (id, "chatId", "userId", unreads, "createdAt", "updatedAt") FROM stdin; public postgres false 280 H e 0 16725 Chatbots TABLE DATA � COPY public."Chatbots" (id, name, "queueId", "chatbotId", "greetingMessage", "createdAt", "updatedAt", "isAgent", "optionType") FROM stdin; public postgres false 252 ,H 0 16994 Chats TABLE DATA s COPY public."Chats" (id, title, uuid, "ownerId", "lastMessage", "companyId", "createdAt", "updatedAt") FROM stdin; public postgres false 278 IH � 0 17693 ChatsImport TABLE DATA m COPY public."ChatsImport" (id, "whatsappId", "messageCount", messages, "createdAt", "updatedAt") FROM stdin; public postgres false 345 fH W 0 16554 Companies TABLE DATA � COPY public."Companies" (id, name, phone, email, "createdAt", "updatedAt", "planId", status, schedules, "dueDate", recurrence, document, "paymentMethod", "lastLogin", "verificationToken", "isVerified", token, whitelabel, dominio) FROM stdin; public postgres false 238 �H � 0 17520 CompanySockets TABLE DATA a COPY public."CompanySockets" (id, "companyId", "socketId", "createdAt", "updatedAt") FROM stdin; public postgres false 326 oI � 0 17423 Configurations TABLE DATA COPY public."Configurations" (id, "nomeSistema", "numeroSuporte", "codigoCor", logo, "mensagemWhatsApp", "mensagemEmail", "createdAt", "updatedAt", "mensagemRedefinicaoSenha", "logoLogin", "logoBanner", "primaryDark", "textPrimary", "tabHeaderBackground", options, "fancyBackground", inputdigita, login, "barraSuperior", "companyId", "TicketsManagerTabs", "Login", "FundoLogin", fundologin, "codigoCorfundo", "Cadastro", "Dashboard", "nomeLogo", "nomeLogoLogin", "nomeBanner", "politicaPrivacidade", "termosDeUso") FROM stdin; public postgres false 318 �I P 0 16474 ContactCustomFields TABLE DATA g COPY public."ContactCustomFields" (id, name, value, "contactId", "createdAt", "updatedAt") FROM stdin; public postgres false 231 K t 0 16875 ContactListItems TABLE DATA � COPY public."ContactListItems" (id, name, number, email, "contactListId", "isWhatsappValid", "companyId", "createdAt", "updatedAt") FROM stdin; public postgres false 267 'K r 0 16863 ContactLists TABLE DATA Y COPY public."ContactLists" (id, name, "companyId", "createdAt", "updatedAt") FROM stdin; public postgres false 265 DK I 0 16417 Contacts TABLE DATA � COPY public."Contacts" (id, name, number, "profilePicUrl", "createdAt", "updatedAt", email, "isGroup", "companyId", "acceptAudioMessage", channel, active, "disableBot", "whatsappId", "additionalData", "walleteUserId") FROM stdin; public postgres false 224 aK g 0 16744 DialogChatBots TABLE DATA w COPY public."DialogChatBots" (id, awaiting, "contactId", "chatbotId", "createdAt", "updatedAt", "queueId") FROM stdin; public postgres false 254 ~K � 0 17359 Emails TABLE DATA | COPY public."Emails" (id, sender, subject, message, "companyId", "createdAt", "updatedAt", scheduled, "sendAt") FROM stdin; public postgres false 310 �K � 0 17393 Eventos TABLE DATA { COPY public."Eventos" (id, title, description, start, "end", concluido, "companyId", "createdAt", "updatedAt") FROM stdin; public postgres false 314 �K � 0 17251 Files TABLE DATA [ COPY public."Files" (id, "companyId", name, message, "createdAt", "updatedAt") FROM stdin; public postgres false 302 �K � 0 17265 FilesOptions TABLE DATA i COPY public."FilesOptions" (id, name, path, "fileId", "createdAt", "updatedAt", "mediaType") FROM stdin; public postgres false 304 �K � 0 17558 Flows TABLE DATA � COPY public."Flows" (id, nodes, edges, "companyId", "createdAt", "updatedAt", name, schedule, "offHoursMessage", keywords) FROM stdin; public postgres false 329 L _ 0 16658 Helps TABLE DATA ` COPY public."Helps" (id, title, description, video, link, "createdAt", "updatedAt") FROM stdin; public postgres false 246 ,L � 0 17148 Integrations TABLE DATA � COPY public."Integrations" (id, "companyId", name, "isActive", token, "foneContact", "userLogin", "passLogin", "finalCurrentMonth", "initialCurrentMonth", "createdAt", "updatedAt") FROM stdin; public postgres false 292 IL � 0 17074 Invoices TABLE DATA & COPY public."Invoices" (id, "companyId", "dueDate", detail, status, value, users, connections, queues, "useWhatsapp", "useFacebook", "useInstagram", "useCampaigns", "useSchedules", "useInternalChat", "useExternalApi", "createdAt", "updatedAt", "useTypebot", "useN8n", "useChatGPT") FROM stdin; public postgres false 286 fL � 0 17709 MessageImportStatuses TABLE DATA � COPY public."MessageImportStatuses" (id, "whatsappId", "totalMessages", "importedMessages", "createdAt", "updatedAt", status) FROM stdin; public postgres false 347 �L L 0 16445 Messages TABLE DATA COPY public."Messages" (id, body, ack, read, "mediaType", "mediaUrl", "ticketId", "createdAt", "updatedAt", "fromMe", "isDeleted", "contactId", "quotedMsgId", "companyId", "remoteJid", "dataJson", participant, "queueId", "isEdited", transcription) FROM stdin; public postgres false 227 �L � 0 17573 NotyNodes TABLE DATA _ COPY public."NotyNodes" (id, "ticketId", "notifyNumber", "createdAt", "updatedAt") FROM stdin; public postgres false 331 �L � 0 17640 OldMessages TABLE DATA X COPY public."OldMessages" (id, "messageId", body, "createdAt", "updatedAt") FROM stdin; public postgres false 338 M � 0 17598 Pixels TABLE DATA � COPY public."Pixels" (id, nome, pixel, "companyId", url, convercoes, "createdAt", "updatedAt", "whatsappId", message) FROM stdin; public postgres false 332 5M Y 0 16600 Plans TABLE DATA H COPY public."Plans" (id, name, users, connections, queues, "createdAt", "updatedAt", amount, "useFacebook", "useInstagram", "useWhatsapp", "useCampaigns", "useExternalApi", "useInternalChat", "useSchedules", "useKanban", "useIntegrations", "useOpenAi", memory, "useTypebot", "useN8n", "useChatGPT", "usePlanoTeste") FROM stdin; public postgres false 240 RM � 0 17291 Prompts TABLE DATA � COPY public."Prompts" (id, name, "apiKey", prompt, "maxTokens", "maxMessages", temperature, "promptTokens", "completionTokens", "totalTokens", voice, "voiceKey", "voiceRegion", "queueId", "companyId", "createdAt", "updatedAt") FROM stdin; public postgres false 306 �M � 0 17227 QueueIntegrations TABLE DATA H COPY public."QueueIntegrations" (id, type, name, "projectName", "jsonContent", language, "createdAt", "updatedAt", "urlN8N", "companyId", "typebotSlug", "typebotKeywordFinish", "typebotUnknownMessage", "typebotExpires", "typebotDelayMessage", "typebotRestartMessage", "typebotKeywordRestart", "aiToken", "aiPrompt") FROM stdin; public postgres false 300 �M i 0 16762 QueueOptions TABLE DATA � COPY public."QueueOptions" (id, title, message, option, "queueId", "parentId", "createdAt", "updatedAt", "optionType") FROM stdin; public postgres false 256 �M S 0 16526 Queues TABLE DATA � COPY public."Queues" (id, name, color, "greetingMessage", "createdAt", "updatedAt", "companyId", "outOfHoursMessage", schedules, "orderQueue", "integrationId", "promptId", options) FROM stdin; public postgres false 234 �M ] 0 16643 QuickMessages TABLE DATA � COPY public."QuickMessages" (id, shortcode, message, "companyId", "createdAt", "updatedAt", "userId", "mediaPath", "mediaName", geral) FROM stdin; public postgres false 244 N � 0 17183 Ratings TABLE DATA ] COPY public."Ratings" (id, "companyId", name, message, "createdAt", "updatedAt") FROM stdin; public postgres false 296 7N � 0 17197 RatingsOptions TABLE DATA a COPY public."RatingsOptions" (id, name, value, "ratingId", "createdAt", "updatedAt") FROM stdin; public postgres false 298 TN k 0 16787 Schedules TABLE DATA COPY public."Schedules" (id, body, "sendAt", "sentAt", "contactId", "ticketId", "userId", "companyId", "createdAt", "updatedAt", status, "mediaName", "mediaPath", recurrence, "openTicket", connection, "queueId", recurrence2, recurrencedia, recurrencediasemana) FROM stdin; public postgres false 258 qN E 0 16389 SequelizeMeta TABLE DATA / COPY public."SequelizeMeta" (name) FROM stdin; public postgres false 220 �N � 0 17631 ServerData TABLE DATA c COPY public."ServerData" (id, totalmem, freemem, "cpuUsage", "createdAt", "updatedAt") FROM stdin; public postgres false 336 �] Q 0 16490 Settings TABLE DATA [ COPY public."Settings" (key, value, "createdAt", "updatedAt", "companyId", id) FROM stdin; public postgres false 232 K^ � 0 17609 SiteIntegrations TABLE DATA � COPY public."SiteIntegrations" (id, name, "companyId", "accessCount", url, connection, "phoneNumber", "createdAt", "updatedAt", "urlSite") FROM stdin; public postgres false 334 c � 0 17654 StatusTicket TABLE DATA � COPY public."StatusTicket" (id, priority, title, text, color, "mediaPath", "mediaName", "companyId", status, "createdAt", "updatedAt") FROM stdin; public postgres false 340 +c � 0 17059 Subscriptions TABLE DATA � COPY public."Subscriptions" (id, "isActive", "expiresAt", "userPriceCents", "whatsPriceCents", "lastInvoiceUrl", "lastPlanChange", "companyId", "providerSubscriptionId", "createdAt", "updatedAt") FROM stdin; public postgres false 284 Hc m 0 16826 Tags TABLE DATA l COPY public."Tags" (id, name, color, "companyId", "createdAt", "updatedAt", kanban, "orderTag") FROM stdin; public postgres false 260 ec � 0 17338 Tasks TABLE DATA g COPY public."Tasks" (id, text, description, created_at, updated_at, "companyId", "userId") FROM stdin; public postgres false 308 �c [ 0 16621 TicketNotes TABLE DATA n COPY public."TicketNotes" (id, note, "userId", "contactId", "ticketId", "createdAt", "updatedAt") FROM stdin; public postgres false 242 �c � 0 17667 TicketStatus TABLE DATA ` COPY public."TicketStatus" ("ticketId", "statusTicketId", "createdAt", "updatedAt") FROM stdin; public postgres false 341 �c n 0 16839 TicketTags TABLE DATA b COPY public."TicketTags" ("ticketId", "tagId", "createdAt", "updatedAt", "contactId") FROM stdin; public postgres false 261 �c a 0 16669 TicketTraking TABLE DATA � COPY public."TicketTraking" (id, "ticketId", "companyId", "whatsappId", "userId", "createdAt", "updatedAt", "queuedAt", "startedAt", "finishedAt", "ratingAt", rated, "ratingId", "chatbotAt") FROM stdin; public postgres false 248 �c � 0 17503 TicketUser TABLE DATA Z COPY public."TicketUser" (id, "ticketId", "userId", "createdAt", "updatedAt") FROM stdin; public postgres false 324 d K 0 16426 Tickets TABLE DATA z COPY public."Tickets" (id, status, "lastMessage", "contactId", "userId", "createdAt", "updatedAt", "whatsappId", "isGroup", "unreadMessages", "queueId", "companyId", uuid, chatbot, "queueOptionId", "isBot", channel, "amountUsedBotQueues", "fromMe", "useIntegration", "integrationId", "typebotSessionId", "typebotStatus", "promptId", "startTypebot", "secionIdTypebot", "specialMessage", "messageTypeBot", prompt, "participantIds", etapa, "currentNodeId", "awaitingResponseNodeId", "lastNodeIdSent", "unreadMessagesCount", "awaitingRating", "awaitingRatingId", "awaitingUserId", "flowId", "afterHoursMessageSent", imported) FROM stdin; public postgres false 226 0d U 0 16548 UserQueues TABLE DATA U COPY public."UserQueues" ("userId", "queueId", "createdAt", "updatedAt") FROM stdin; public postgres false 236 Md c 0 16697 UserRatings TABLE DATA � COPY public."UserRatings" (id, "ticketId", "companyId", "userId", rate, "createdAt", "updatedAt", "ratingIdOption", "ratingId") FROM stdin; public postgres false 250 jd G 0 16406 Users TABLE DATA Z COPY public."Users" (id, name, email, "passwordHash", "createdAt", "updatedAt", profile, "tokenVersion", "companyId", super, online, "endWork", "startWork", color, "farewellMessage", "whatsappId", "allTicket", "allHistoric", "allUserChat", "resetPassword", "confirmationToken", "profileState", intervalo, "profilePic", "accessPages") FROM stdin; public postgres false 222 �d T 0 16543 WhatsappQueues TABLE DATA ] COPY public."WhatsappQueues" ("whatsappId", "queueId", "createdAt", "updatedAt") FROM stdin; public postgres false 235 �e N 0 16465 Whatsapps TABLE DATA COPY public."Whatsapps" (id, session, qrcode, status, battery, plugged, "createdAt", "updatedAt", name, "isDefault", retries, "greetingMessage", "companyId", "complationMessage", "outOfHoursMessage", token, "farewellMessage", provider, number, channel, "facebookUserToken", "tokenMeta", "facebookPageUserId", "facebookUserId", "sendIdQueue", "promptId", "integrationId", "chatGPTEnabled", "typebotEnabled", "n8nEnabled", "typebotCredential", "n8nCredential", "maxUseBotQueues", "expiresTicket", "expiresInactiveMessage", "timeUseBotQueues", "typingEnabled", "isActive", "greetingMediaAttachment", "transferQueueId", "timeToTransfer", "ratingMessage", "isImportModalOpen", selectedfila, "yesNoValue", minutes, titlelist, "flowId", "proxyHost", "proxyPort", "proxyUsername", "proxyPassword", "selectedInterval", "selectedMoveQueueId", inatividade, "randomizeImmediately", "selectedAttendants", "selectedDepartments", "importOldMessages", "importRecentMessages", "statusImportMessages", "closedTicketsPostImported", "importOldMessagesGroups") FROM stdin; public postgres false 229 �e � 0 17414 credentials TABLE DATA � COPY public.credentials (id, "typebotCredentials", "n8nCredentials", "chatGptCredential", "companyId", "createdAt", "updatedAt", "tokenHubsoft", "tokenExpiration") FROM stdin; public postgres false 316 �e � 0 17685 veryChats TABLE DATA O COPY public."veryChats" (id, "isActive", "createdAt", "updatedAt") FROM stdin; public postgres false 343 �e 0 0 AgendamentoEmails_id_seq SEQUENCE SET I SELECT pg_catalog.setval('public."AgendamentoEmails_id_seq"', 1, false); public postgres false 311 0 0 Ajuda_id_seq SEQUENCE SET = SELECT pg_catalog.setval('public."Ajuda_id_seq"', 1, false); public postgres false 321 0 0 AnnouncementVisibilities_id_seq SEQUENCE SET O SELECT pg_catalog.setval('public."AnnouncementVisibilities_id_seq"', 1, true); public postgres false 327 0 0 Announcements_id_seq SEQUENCE SET D SELECT pg_catalog.setval('public."Announcements_id_seq"', 1, true); public postgres false 275 0 0 ApiUsages_id_seq SEQUENCE SET A SELECT pg_catalog.setval('public."ApiUsages_id_seq"', 1, false); public postgres false 293 0 0 BaileysChats_id_seq SEQUENCE SET D SELECT pg_catalog.setval('public."BaileysChats_id_seq"', 1, false); public postgres false 287 0 0 BaileysMessages_id_seq SEQUENCE SET G SELECT pg_catalog.setval('public."BaileysMessages_id_seq"', 1, false); public postgres false 289 0 0 Baileys_id_seq SEQUENCE SET ? SELECT pg_catalog.setval('public."Baileys_id_seq"', 1, false); public postgres false 262 0 0 CampaignSettings_id_seq SEQUENCE SET H SELECT pg_catalog.setval('public."CampaignSettings_id_seq"', 1, false); public postgres false 270 0 0 CampaignShipping_id_seq SEQUENCE SET H SELECT pg_catalog.setval('public."CampaignShipping_id_seq"', 1, false); public postgres false 273 0 0 Campaigns_id_seq SEQUENCE SET A SELECT pg_catalog.setval('public."Campaigns_id_seq"', 1, false); public postgres false 268 0 0 ChatImports_id_seq SEQUENCE SET C SELECT pg_catalog.setval('public."ChatImports_id_seq"', 1, false); public postgres false 319 0 0 ChatMessages_id_seq SEQUENCE SET D SELECT pg_catalog.setval('public."ChatMessages_id_seq"', 1, false); public postgres false 281 0 0 ChatUsers_id_seq SEQUENCE SET A SELECT pg_catalog.setval('public."ChatUsers_id_seq"', 1, false); public postgres false 279 0 0 Chatbots_id_seq SEQUENCE SET @ SELECT pg_catalog.setval('public."Chatbots_id_seq"', 1, false); public postgres false 251 0 0 ChatsImport_id_seq SEQUENCE SET C SELECT pg_catalog.setval('public."ChatsImport_id_seq"', 1, false); public postgres false 344 0 0 Chats_id_seq SEQUENCE SET = SELECT pg_catalog.setval('public."Chats_id_seq"', 1, false); public postgres false 277 0 0 Companies_id_seq SEQUENCE SET @ SELECT pg_catalog.setval('public."Companies_id_seq"', 2, true); public postgres false 237 0 0 CompanySockets_id_seq SEQUENCE SET F SELECT pg_catalog.setval('public."CompanySockets_id_seq"', 1, false); public postgres false 325 0 0 Configurations_id_seq SEQUENCE SET E SELECT pg_catalog.setval('public."Configurations_id_seq"', 1, true); public postgres false 317 0 0 ContactCustomFields_id_seq SEQUENCE SET K SELECT pg_catalog.setval('public."ContactCustomFields_id_seq"', 1, false); public postgres false 230 0 0 ContactListItems_id_seq SEQUENCE SET H SELECT pg_catalog.setval('public."ContactListItems_id_seq"', 1, false); public postgres false 266 0 0 ContactLists_id_seq SEQUENCE SET D SELECT pg_catalog.setval('public."ContactLists_id_seq"', 1, false); public postgres false 264 0 0 Contacts_id_seq SEQUENCE SET @ SELECT pg_catalog.setval('public."Contacts_id_seq"', 1, false); public postgres false 223 0 0 DialogChatBots_id_seq SEQUENCE SET F SELECT pg_catalog.setval('public."DialogChatBots_id_seq"', 1, false); public postgres false 253 ! 0 0 Emails_id_seq SEQUENCE SET > SELECT pg_catalog.setval('public."Emails_id_seq"', 1, false); public postgres false 309 " 0 0 Eventos_id_seq SEQUENCE SET ? SELECT pg_catalog.setval('public."Eventos_id_seq"', 1, false); public postgres false 313 # 0 0 FilesOptions_id_seq SEQUENCE SET D SELECT pg_catalog.setval('public."FilesOptions_id_seq"', 1, false); public postgres false 303 $ 0 0 Files_id_seq SEQUENCE SET = SELECT pg_catalog.setval('public."Files_id_seq"', 1, false); public postgres false 301 % 0 0 Helps_id_seq SEQUENCE SET = SELECT pg_catalog.setval('public."Helps_id_seq"', 1, false); public postgres false 245 & 0 0 Integrations_id_seq SEQUENCE SET D SELECT pg_catalog.setval('public."Integrations_id_seq"', 1, false); public postgres false 291 ' 0 0 Invoices_id_seq SEQUENCE SET ? SELECT pg_catalog.setval('public."Invoices_id_seq"', 1, true); public postgres false 285 ( 0 0 MessageImportStatuses_id_seq SEQUENCE SET M SELECT pg_catalog.setval('public."MessageImportStatuses_id_seq"', 1, false); public postgres false 346 ) 0 0 NotyNodes_id_seq SEQUENCE SET A SELECT pg_catalog.setval('public."NotyNodes_id_seq"', 1, false); public postgres false 330 * 0 0 OldMessages_id_seq SEQUENCE SET C SELECT pg_catalog.setval('public."OldMessages_id_seq"', 1, false); public postgres false 337 + 0 0 Plans_id_seq SEQUENCE SET < SELECT pg_catalog.setval('public."Plans_id_seq"', 1, true); public postgres false 239 , 0 0 Prompts_id_seq SEQUENCE SET ? SELECT pg_catalog.setval('public."Prompts_id_seq"', 1, false); public postgres false 305 - 0 0 QueueIntegrations_id_seq SEQUENCE SET I SELECT pg_catalog.setval('public."QueueIntegrations_id_seq"', 1, false); public postgres false 299 . 0 0 QueueOptions_id_seq SEQUENCE SET D SELECT pg_catalog.setval('public."QueueOptions_id_seq"', 1, false); public postgres false 255 / 0 0 Queues_id_seq SEQUENCE SET > SELECT pg_catalog.setval('public."Queues_id_seq"', 1, false); public postgres false 233 0 0 0 QuickMessages_id_seq SEQUENCE SET E SELECT pg_catalog.setval('public."QuickMessages_id_seq"', 1, false); public postgres false 243 1 0 0 RatingsOptions_id_seq SEQUENCE SET F SELECT pg_catalog.setval('public."RatingsOptions_id_seq"', 1, false); public postgres false 297 2 0 0 Ratings_id_seq SEQUENCE SET ? SELECT pg_catalog.setval('public."Ratings_id_seq"', 1, false); public postgres false 295 3 0 0 Schedules_id_seq SEQUENCE SET A SELECT pg_catalog.setval('public."Schedules_id_seq"', 1, false); public postgres false 257 4 0 0 ServerData_id_seq SEQUENCE SET A SELECT pg_catalog.setval('public."ServerData_id_seq"', 2, true); public postgres false 335 5 0 0 Settings_id_seq SEQUENCE SET @ SELECT pg_catalog.setval('public."Settings_id_seq"', 81, true); public postgres false 272 6 0 0 SiteIntegrations_id_seq SEQUENCE SET H SELECT pg_catalog.setval('public."SiteIntegrations_id_seq"', 1, false); public postgres false 333 7 0 0 StatusTicket_id_seq SEQUENCE SET D SELECT pg_catalog.setval('public."StatusTicket_id_seq"', 1, false); public postgres false 339 8 0 0 Subscriptions_id_seq SEQUENCE SET E SELECT pg_catalog.setval('public."Subscriptions_id_seq"', 1, false); public postgres false 283 9 0 0 Tags_id_seq SEQUENCE SET < SELECT pg_catalog.setval('public."Tags_id_seq"', 1, false); public postgres false 259 : 0 0 Tasks_id_seq SEQUENCE SET = SELECT pg_catalog.setval('public."Tasks_id_seq"', 1, false); public postgres false 307 ; 0 0 TicketNotes_id_seq SEQUENCE SET C SELECT pg_catalog.setval('public."TicketNotes_id_seq"', 1, false); public postgres false 241 < 0 0 TicketTraking_id_seq SEQUENCE SET E SELECT pg_catalog.setval('public."TicketTraking_id_seq"', 1, false); public postgres false 247 = 0 0 TicketUser_id_seq SEQUENCE SET B SELECT pg_catalog.setval('public."TicketUser_id_seq"', 1, false); public postgres false 323 > 0 0 Tickets_id_seq SEQUENCE SET ? SELECT pg_catalog.setval('public."Tickets_id_seq"', 1, false); public postgres false 225 ? 0 0 UserRatings_id_seq SEQUENCE SET C SELECT pg_catalog.setval('public."UserRatings_id_seq"', 1, false); public postgres false 249 @ 0 0 Users_id_seq SEQUENCE SET < SELECT pg_catalog.setval('public."Users_id_seq"', 2, true); public postgres false 221 A 0 0 Whatsapps_id_seq SEQUENCE SET A SELECT pg_catalog.setval('public."Whatsapps_id_seq"', 1, false); public postgres false 228 B 0 0 credentials_id_seq SEQUENCE SET A SELECT pg_catalog.setval('public.credentials_id_seq', 1, false); public postgres false 315 C 0 0 veryChats_id_seq SEQUENCE SET A SELECT pg_catalog.setval('public."veryChats_id_seq"', 1, false); public postgres false 342 ! 2606 17380 ( AgendamentoEmails AgendamentoEmails_pkey CONSTRAINT j ALTER TABLE ONLY public."AgendamentoEmails" ADD CONSTRAINT "AgendamentoEmails_pkey" PRIMARY KEY (id); V ALTER TABLE ONLY public."AgendamentoEmails" DROP CONSTRAINT "AgendamentoEmails_pkey"; public postgres false 312 + 2606 17478 Ajuda Ajuda_pkey CONSTRAINT R ALTER TABLE ONLY public."Ajuda" ADD CONSTRAINT "Ajuda_pkey" PRIMARY KEY (id); > ALTER TABLE ONLY public."Ajuda" DROP CONSTRAINT "Ajuda_pkey"; public postgres false 322 1 2606 17541 6 AnnouncementVisibilities AnnouncementVisibilities_pkey CONSTRAINT x ALTER TABLE ONLY public."AnnouncementVisibilities" ADD CONSTRAINT "AnnouncementVisibilities_pkey" PRIMARY KEY (id); d ALTER TABLE ONLY public."AnnouncementVisibilities" DROP CONSTRAINT "AnnouncementVisibilities_pkey"; public postgres false 328 � 2606 16987 Announcements Announcements_pkey CONSTRAINT b ALTER TABLE ONLY public."Announcements" ADD CONSTRAINT "Announcements_pkey" PRIMARY KEY (id); N ALTER TABLE ONLY public."Announcements" DROP CONSTRAINT "Announcements_pkey"; public postgres false 276 2606 17178 ApiUsages ApiUsages_pkey CONSTRAINT Z ALTER TABLE ONLY public."ApiUsages" ADD CONSTRAINT "ApiUsages_pkey" PRIMARY KEY (id); F ALTER TABLE ONLY public."ApiUsages" DROP CONSTRAINT "ApiUsages_pkey"; public postgres false 294 2606 17115 BaileysChats BaileysChats_pkey CONSTRAINT ` ALTER TABLE ONLY public."BaileysChats" ADD CONSTRAINT "BaileysChats_pkey" PRIMARY KEY (id); L ALTER TABLE ONLY public."BaileysChats" DROP CONSTRAINT "BaileysChats_pkey"; public postgres false 288 2606 17129 $ BaileysMessages BaileysMessages_pkey CONSTRAINT f ALTER TABLE ONLY public."BaileysMessages" ADD CONSTRAINT "BaileysMessages_pkey" PRIMARY KEY (id); R ALTER TABLE ONLY public."BaileysMessages" DROP CONSTRAINT "BaileysMessages_pkey"; public postgres false 290 � 2606 16861 Baileys Baileys_pkey CONSTRAINT d ALTER TABLE ONLY public."Baileys" ADD CONSTRAINT "Baileys_pkey" PRIMARY KEY (id, "whatsappId"); B ALTER TABLE ONLY public."Baileys" DROP CONSTRAINT "Baileys_pkey"; public postgres false 263 263 � 2606 16938 & CampaignSettings CampaignSettings_pkey CONSTRAINT h ALTER TABLE ONLY public."CampaignSettings" ADD CONSTRAINT "CampaignSettings_pkey" PRIMARY KEY (id); T ALTER TABLE ONLY public."CampaignSettings" DROP CONSTRAINT "CampaignSettings_pkey"; public postgres false 271 � 2606 16959 & CampaignShipping CampaignShipping_pkey CONSTRAINT h ALTER TABLE ONLY public."CampaignShipping" ADD CONSTRAINT "CampaignShipping_pkey" PRIMARY KEY (id); T ALTER TABLE ONLY public."CampaignShipping" DROP CONSTRAINT "CampaignShipping_pkey"; public postgres false 274 � 2606 16913 Campaigns Campaigns_pkey CONSTRAINT Z ALTER TABLE ONLY public."Campaigns" ADD CONSTRAINT "Campaigns_pkey" PRIMARY KEY (id); F ALTER TABLE ONLY public."Campaigns" DROP CONSTRAINT "Campaigns_pkey"; public postgres false 269 ) 2606 17466 ChatImports ChatImports_pkey CONSTRAINT ^ ALTER TABLE ONLY public."ChatImports" ADD CONSTRAINT "ChatImports_pkey" PRIMARY KEY (id); J ALTER TABLE ONLY public."ChatImports" DROP CONSTRAINT "ChatImports_pkey"; public postgres false 320 � 2606 17041 ChatMessages ChatMessages_pkey CONSTRAINT ` ALTER TABLE ONLY public."ChatMessages" ADD CONSTRAINT "ChatMessages_pkey" PRIMARY KEY (id); L ALTER TABLE ONLY public."ChatMessages" DROP CONSTRAINT "ChatMessages_pkey"; public postgres false 282 � 2606 17021 ChatUsers ChatUsers_pkey CONSTRAINT Z ALTER TABLE ONLY public."ChatUsers" ADD CONSTRAINT "ChatUsers_pkey" PRIMARY KEY (id); F ALTER TABLE ONLY public."ChatUsers" DROP CONSTRAINT "ChatUsers_pkey"; public postgres false 280 � 2606 16732 Chatbots Chatbots_pkey CONSTRAINT X ALTER TABLE ONLY public."Chatbots" ADD CONSTRAINT "Chatbots_pkey" PRIMARY KEY (id); D ALTER TABLE ONLY public."Chatbots" DROP CONSTRAINT "Chatbots_pkey"; public postgres false 252 C 2606 17702 ChatsImport ChatsImport_pkey CONSTRAINT ^ ALTER TABLE ONLY public."ChatsImport" ADD CONSTRAINT "ChatsImport_pkey" PRIMARY KEY (id); J ALTER TABLE ONLY public."ChatsImport" DROP CONSTRAINT "ChatsImport_pkey"; public postgres false 345 � 2606 17003 Chats Chats_pkey CONSTRAINT R ALTER TABLE ONLY public."Chats" ADD CONSTRAINT "Chats_pkey" PRIMARY KEY (id); > ALTER TABLE ONLY public."Chats" DROP CONSTRAINT "Chats_pkey"; public postgres false 278 � 2606 16563 Companies Companies_name_key CONSTRAINT [ ALTER TABLE ONLY public."Companies" ADD CONSTRAINT "Companies_name_key" UNIQUE (name); J ALTER TABLE ONLY public."Companies" DROP CONSTRAINT "Companies_name_key"; public postgres false 238 � 2606 16561 Companies Companies_pkey CONSTRAINT Z ALTER TABLE ONLY public."Companies" ADD CONSTRAINT "Companies_pkey" PRIMARY KEY (id); F ALTER TABLE ONLY public."Companies" DROP CONSTRAINT "Companies_pkey"; public postgres false 238 / 2606 17527 " CompanySockets CompanySockets_pkey CONSTRAINT d ALTER TABLE ONLY public."CompanySockets" ADD CONSTRAINT "CompanySockets_pkey" PRIMARY KEY (id); P ALTER TABLE ONLY public."CompanySockets" DROP CONSTRAINT "CompanySockets_pkey"; public postgres false 326 ' 2606 17430 " Configurations Configurations_pkey CONSTRAINT d ALTER TABLE ONLY public."Configurations" ADD CONSTRAINT "Configurations_pkey" PRIMARY KEY (id); P ALTER TABLE ONLY public."Configurations" DROP CONSTRAINT "Configurations_pkey"; public postgres false 318 � 2606 16481 , ContactCustomFields ContactCustomFields_pkey CONSTRAINT n ALTER TABLE ONLY public."ContactCustomFields" ADD CONSTRAINT "ContactCustomFields_pkey" PRIMARY KEY (id); Z ALTER TABLE ONLY public."ContactCustomFields" DROP CONSTRAINT "ContactCustomFields_pkey"; public postgres false 231 � 2606 16883 & ContactListItems ContactListItems_pkey CONSTRAINT h ALTER TABLE ONLY public."ContactListItems" ADD CONSTRAINT "ContactListItems_pkey" PRIMARY KEY (id); T ALTER TABLE ONLY public."ContactListItems" DROP CONSTRAINT "ContactListItems_pkey"; public postgres false 267 � 2606 16868 ContactLists ContactLists_pkey CONSTRAINT ` ALTER TABLE ONLY public."ContactLists" ADD CONSTRAINT "ContactLists_pkey" PRIMARY KEY (id); L ALTER TABLE ONLY public."ContactLists" DROP CONSTRAINT "ContactLists_pkey"; public postgres false 265 � 2606 16424 Contacts Contacts_pkey CONSTRAINT X ALTER TABLE ONLY public."Contacts" ADD CONSTRAINT "Contacts_pkey" PRIMARY KEY (id); D ALTER TABLE ONLY public."Contacts" DROP CONSTRAINT "Contacts_pkey"; public postgres false 224 � 2606 16750 " DialogChatBots DialogChatBots_pkey CONSTRAINT d ALTER TABLE ONLY public."DialogChatBots" ADD CONSTRAINT "DialogChatBots_pkey" PRIMARY KEY (id); P ALTER TABLE ONLY public."DialogChatBots" DROP CONSTRAINT "DialogChatBots_pkey"; public postgres false 254 2606 17366 Emails Emails_pkey CONSTRAINT T ALTER TABLE ONLY public."Emails" ADD CONSTRAINT "Emails_pkey" PRIMARY KEY (id); @ ALTER TABLE ONLY public."Emails" DROP CONSTRAINT "Emails_pkey"; public postgres false 310 # 2606 17401 Eventos Eventos_pkey CONSTRAINT V ALTER TABLE ONLY public."Eventos" ADD CONSTRAINT "Eventos_pkey" PRIMARY KEY (id); B ALTER TABLE ONLY public."Eventos" DROP CONSTRAINT "Eventos_pkey"; public postgres false 314 2606 17272 FilesOptions FilesOptions_pkey CONSTRAINT ` ALTER TABLE ONLY public."FilesOptions" ADD CONSTRAINT "FilesOptions_pkey" PRIMARY KEY (id); L ALTER TABLE ONLY public."FilesOptions" DROP CONSTRAINT "FilesOptions_pkey"; public postgres false 304 2606 17258 Files Files_pkey CONSTRAINT R ALTER TABLE ONLY public."Files" ADD CONSTRAINT "Files_pkey" PRIMARY KEY (id); > ALTER TABLE ONLY public."Files" DROP CONSTRAINT "Files_pkey"; public postgres false 302 3 2606 17566 Flows Flows_pkey CONSTRAINT R ALTER TABLE ONLY public."Flows" ADD CONSTRAINT "Flows_pkey" PRIMARY KEY (id); > ALTER TABLE ONLY public."Flows" DROP CONSTRAINT "Flows_pkey"; public postgres false 329 � 2606 16665 Helps Helps_pkey CONSTRAINT R ALTER TABLE ONLY public."Helps" ADD CONSTRAINT "Helps_pkey" PRIMARY KEY (id); > ALTER TABLE ONLY public."Helps" DROP CONSTRAINT "Helps_pkey"; public postgres false 246 2606 17156 Integrations Integrations_pkey CONSTRAINT ` ALTER TABLE ONLY public."Integrations" ADD CONSTRAINT "Integrations_pkey" PRIMARY KEY (id); L ALTER TABLE ONLY public."Integrations" DROP CONSTRAINT "Integrations_pkey"; public postgres false 292 2606 17091 Invoices Invoices_pkey CONSTRAINT X ALTER TABLE ONLY public."Invoices" ADD CONSTRAINT "Invoices_pkey" PRIMARY KEY (id); D ALTER TABLE ONLY public."Invoices" DROP CONSTRAINT "Invoices_pkey"; public postgres false 286 E 2606 17717 0 MessageImportStatuses MessageImportStatuses_pkey CONSTRAINT r ALTER TABLE ONLY public."MessageImportStatuses" ADD CONSTRAINT "MessageImportStatuses_pkey" PRIMARY KEY (id); ^ ALTER TABLE ONLY public."MessageImportStatuses" DROP CONSTRAINT "MessageImportStatuses_pkey"; public postgres false 347 � 2606 16453 Messages Messages_pkey CONSTRAINT X ALTER TABLE ONLY public."Messages" ADD CONSTRAINT "Messages_pkey" PRIMARY KEY (id); D ALTER TABLE ONLY public."Messages" DROP CONSTRAINT "Messages_pkey"; public postgres false 227 5 2606 17580 NotyNodes NotyNodes_pkey CONSTRAINT Z ALTER TABLE ONLY public."NotyNodes" ADD CONSTRAINT "NotyNodes_pkey" PRIMARY KEY (id); F ALTER TABLE ONLY public."NotyNodes" DROP CONSTRAINT "NotyNodes_pkey"; public postgres false 331 = 2606 17647 OldMessages OldMessages_pkey CONSTRAINT ^ ALTER TABLE ONLY public."OldMessages" ADD CONSTRAINT "OldMessages_pkey" PRIMARY KEY (id); J ALTER TABLE ONLY public."OldMessages" DROP CONSTRAINT "OldMessages_pkey"; public postgres false 338 7 2606 17606 Pixels Pixels_pkey CONSTRAINT T ALTER TABLE ONLY public."Pixels" ADD CONSTRAINT "Pixels_pkey" PRIMARY KEY (id); @ ALTER TABLE ONLY public."Pixels" DROP CONSTRAINT "Pixels_pkey"; public postgres false 332 � 2606 16610 Plans Plans_name_key CONSTRAINT S ALTER TABLE ONLY public."Plans" ADD CONSTRAINT "Plans_name_key" UNIQUE (name); B ALTER TABLE ONLY public."Plans" DROP CONSTRAINT "Plans_name_key"; public postgres false 240 � 2606 16608 Plans Plans_pkey CONSTRAINT R ALTER TABLE ONLY public."Plans" ADD CONSTRAINT "Plans_pkey" PRIMARY KEY (id); > ALTER TABLE ONLY public."Plans" DROP CONSTRAINT "Plans_pkey"; public postgres false 240 2606 17304 Prompts Prompts_pkey CONSTRAINT V ALTER TABLE ONLY public."Prompts" ADD CONSTRAINT "Prompts_pkey" PRIMARY KEY (id); B ALTER TABLE ONLY public."Prompts" DROP CONSTRAINT "Prompts_pkey"; public postgres false 306 2606 17236 , QueueIntegrations QueueIntegrations_name_key CONSTRAINT k ALTER TABLE ONLY public."QueueIntegrations" ADD CONSTRAINT "QueueIntegrations_name_key" UNIQUE (name); Z ALTER TABLE ONLY public."QueueIntegrations" DROP CONSTRAINT "QueueIntegrations_name_key"; public postgres false 300 2606 17234 ( QueueIntegrations QueueIntegrations_pkey CONSTRAINT j ALTER TABLE ONLY public."QueueIntegrations" ADD CONSTRAINT "QueueIntegrations_pkey" PRIMARY KEY (id); V ALTER TABLE ONLY public."QueueIntegrations" DROP CONSTRAINT "QueueIntegrations_pkey"; public postgres false 300 2606 17238 3 QueueIntegrations QueueIntegrations_projectName_key CONSTRAINT { ALTER TABLE ONLY public."QueueIntegrations" ADD CONSTRAINT "QueueIntegrations_projectName_key" UNIQUE ("projectName"); a ALTER TABLE ONLY public."QueueIntegrations" DROP CONSTRAINT "QueueIntegrations_projectName_key"; public postgres false 300 � 2606 16769 QueueOptions QueueOptions_pkey CONSTRAINT ` ALTER TABLE ONLY public."QueueOptions" ADD CONSTRAINT "QueueOptions_pkey" PRIMARY KEY (id); L ALTER TABLE ONLY public."QueueOptions" DROP CONSTRAINT "QueueOptions_pkey"; public postgres false 256 � 2606 16721 Queues Queues_color_key CONSTRAINT d ALTER TABLE ONLY public."Queues" ADD CONSTRAINT "Queues_color_key" UNIQUE (color, "companyId"); E ALTER TABLE ONLY public."Queues" DROP CONSTRAINT "Queues_color_key"; public postgres false 234 234 � 2606 16723 Queues Queues_name_key CONSTRAINT b ALTER TABLE ONLY public."Queues" ADD CONSTRAINT "Queues_name_key" UNIQUE (name, "companyId"); D ALTER TABLE ONLY public."Queues" DROP CONSTRAINT "Queues_name_key"; public postgres false 234 234 � 2606 16533 Queues Queues_pkey CONSTRAINT T ALTER TABLE ONLY public."Queues" ADD CONSTRAINT "Queues_pkey" PRIMARY KEY (id); @ ALTER TABLE ONLY public."Queues" DROP CONSTRAINT "Queues_pkey"; public postgres false 234 � 2606 16650 QuickMessages QuickMessages_pkey CONSTRAINT b ALTER TABLE ONLY public."QuickMessages" ADD CONSTRAINT "QuickMessages_pkey" PRIMARY KEY (id); N ALTER TABLE ONLY public."QuickMessages" DROP CONSTRAINT "QuickMessages_pkey"; public postgres false 244 2606 17204 " RatingsOptions RatingsOptions_pkey CONSTRAINT d ALTER TABLE ONLY public."RatingsOptions" ADD CONSTRAINT "RatingsOptions_pkey" PRIMARY KEY (id); P ALTER TABLE ONLY public."RatingsOptions" DROP CONSTRAINT "RatingsOptions_pkey"; public postgres false 298 2606 17190 Ratings Ratings_pkey CONSTRAINT V ALTER TABLE ONLY public."Ratings" ADD CONSTRAINT "Ratings_pkey" PRIMARY KEY (id); B ALTER TABLE ONLY public."Ratings" DROP CONSTRAINT "Ratings_pkey"; public postgres false 296 � 2606 16794 Schedules Schedules_pkey CONSTRAINT Z ALTER TABLE ONLY public."Schedules" ADD CONSTRAINT "Schedules_pkey" PRIMARY KEY (id); F ALTER TABLE ONLY public."Schedules" DROP CONSTRAINT "Schedules_pkey"; public postgres false 258 � 2606 16393 SequelizeMeta SequelizeMeta_pkey CONSTRAINT d ALTER TABLE ONLY public."SequelizeMeta" ADD CONSTRAINT "SequelizeMeta_pkey" PRIMARY KEY (name); N ALTER TABLE ONLY public."SequelizeMeta" DROP CONSTRAINT "SequelizeMeta_pkey"; public postgres false 220 ; 2606 17638 ServerData ServerData_pkey CONSTRAINT \ ALTER TABLE ONLY public."ServerData" ADD CONSTRAINT "ServerData_pkey" PRIMARY KEY (id); H ALTER TABLE ONLY public."ServerData" DROP CONSTRAINT "ServerData_pkey"; public postgres false 336 9 2606 17617 & SiteIntegrations SiteIntegrations_pkey CONSTRAINT h ALTER TABLE ONLY public."SiteIntegrations" ADD CONSTRAINT "SiteIntegrations_pkey" PRIMARY KEY (id); T ALTER TABLE ONLY public."SiteIntegrations" DROP CONSTRAINT "SiteIntegrations_pkey"; public postgres false 334 ? 2606 17661 StatusTicket StatusTicket_pkey CONSTRAINT ` ALTER TABLE ONLY public."StatusTicket" ADD CONSTRAINT "StatusTicket_pkey" PRIMARY KEY (id); L ALTER TABLE ONLY public."StatusTicket" DROP CONSTRAINT "StatusTicket_pkey"; public postgres false 340 2606 17067 Subscriptions Subscriptions_pkey CONSTRAINT b ALTER TABLE ONLY public."Subscriptions" ADD CONSTRAINT "Subscriptions_pkey" PRIMARY KEY (id); N ALTER TABLE ONLY public."Subscriptions" DROP CONSTRAINT "Subscriptions_pkey"; public postgres false 284 � 2606 16833 Tags Tags_pkey CONSTRAINT P ALTER TABLE ONLY public."Tags" ADD CONSTRAINT "Tags_pkey" PRIMARY KEY (id); < ALTER TABLE ONLY public."Tags" DROP CONSTRAINT "Tags_pkey"; public postgres false 260 2606 17345 Tasks Tasks_pkey CONSTRAINT R ALTER TABLE ONLY public."Tasks" ADD CONSTRAINT "Tasks_pkey" PRIMARY KEY (id); > ALTER TABLE ONLY public."Tasks" DROP CONSTRAINT "Tasks_pkey"; public postgres false 308 � 2606 16626 TicketNotes TicketNotes_pkey CONSTRAINT ^ ALTER TABLE ONLY public."TicketNotes" ADD CONSTRAINT "TicketNotes_pkey" PRIMARY KEY (id); J ALTER TABLE ONLY public."TicketNotes" DROP CONSTRAINT "TicketNotes_pkey"; public postgres false 242 � 2606 16674 TicketTraking TicketTraking_pkey CONSTRAINT b ALTER TABLE ONLY public."TicketTraking" ADD CONSTRAINT "TicketTraking_pkey" PRIMARY KEY (id); N ALTER TABLE ONLY public."TicketTraking" DROP CONSTRAINT "TicketTraking_pkey"; public postgres false 248 - 2606 17508 TicketUser TicketUser_pkey CONSTRAINT \ ALTER TABLE ONLY public."TicketUser" ADD CONSTRAINT "TicketUser_pkey" PRIMARY KEY (id); H ALTER TABLE ONLY public."TicketUser" DROP CONSTRAINT "TicketUser_pkey"; public postgres false 324 � 2606 16434 Tickets Tickets_pkey CONSTRAINT V ALTER TABLE ONLY public."Tickets" ADD CONSTRAINT "Tickets_pkey" PRIMARY KEY (id); B ALTER TABLE ONLY public."Tickets" DROP CONSTRAINT "Tickets_pkey"; public postgres false 226 � 2606 16552 UserQueues UserQueues_pkey CONSTRAINT m ALTER TABLE ONLY public."UserQueues" ADD CONSTRAINT "UserQueues_pkey" PRIMARY KEY ("userId", "queueId"); H ALTER TABLE ONLY public."UserQueues" DROP CONSTRAINT "UserQueues_pkey"; public postgres false 236 236 � 2606 16703 UserRatings UserRatings_pkey CONSTRAINT ^ ALTER TABLE ONLY public."UserRatings" ADD CONSTRAINT "UserRatings_pkey" PRIMARY KEY (id); J ALTER TABLE ONLY public."UserRatings" DROP CONSTRAINT "UserRatings_pkey"; public postgres false 250 � 2606 16415 Users Users_email_key CONSTRAINT U ALTER TABLE ONLY public."Users" ADD CONSTRAINT "Users_email_key" UNIQUE (email); C ALTER TABLE ONLY public."Users" DROP CONSTRAINT "Users_email_key"; public postgres false 222 � 2606 16413 Users Users_pkey CONSTRAINT R ALTER TABLE ONLY public."Users" ADD CONSTRAINT "Users_pkey" PRIMARY KEY (id); > ALTER TABLE ONLY public."Users" DROP CONSTRAINT "Users_pkey"; public postgres false 222 � 2606 16547 " WhatsappQueues WhatsappQueues_pkey CONSTRAINT y ALTER TABLE ONLY public."WhatsappQueues" ADD CONSTRAINT "WhatsappQueues_pkey" PRIMARY KEY ("whatsappId", "queueId"); P ALTER TABLE ONLY public."WhatsappQueues" DROP CONSTRAINT "WhatsappQueues_pkey"; public postgres false 235 235 � 2606 16472 Whatsapps Whatsapps_pkey CONSTRAINT Z ALTER TABLE ONLY public."Whatsapps" ADD CONSTRAINT "Whatsapps_pkey" PRIMARY KEY (id); F ALTER TABLE ONLY public."Whatsapps" DROP CONSTRAINT "Whatsapps_pkey"; public postgres false 229 % 2606 17421 credentials credentials_pkey CONSTRAINT Z ALTER TABLE ONLY public.credentials ADD CONSTRAINT credentials_pkey PRIMARY KEY (id); F ALTER TABLE ONLY public.credentials DROP CONSTRAINT credentials_pkey; public postgres false 316 � 2606 16667 Contacts number_companyid_unique CONSTRAINT l ALTER TABLE ONLY public."Contacts" ADD CONSTRAINT number_companyid_unique UNIQUE (number, "companyId"); L ALTER TABLE ONLY public."Contacts" DROP CONSTRAINT number_companyid_unique; public postgres false 224 224 � 2606 17683 Tickets unique_contact_company CONSTRAINT o ALTER TABLE ONLY public."Tickets" ADD CONSTRAINT unique_contact_company UNIQUE ("contactId", "companyId"); J ALTER TABLE ONLY public."Tickets" DROP CONSTRAINT unique_contact_company; public postgres false 226 226 A 2606 17691 veryChats veryChats_pkey CONSTRAINT Z ALTER TABLE ONLY public."veryChats" ADD CONSTRAINT "veryChats_pkey" PRIMARY KEY (id); F ALTER TABLE ONLY public."veryChats" DROP CONSTRAINT "veryChats_pkey"; public postgres false 343 � 1259 17053 idx_cont_company_id INDEX Q CREATE INDEX idx_cont_company_id ON public."Contacts" USING btree ("companyId"); ' DROP INDEX public.idx_cont_company_id; public postgres false 224 � 1259 17057 idx_cpsh_campaign_id INDEX [ CREATE INDEX idx_cpsh_campaign_id ON public."CampaignShipping" USING btree ("campaignId"); ( DROP INDEX public.idx_cpsh_campaign_id; public postgres false 274 � 1259 17056 idx_ctli_contact_list_id INDEX b CREATE INDEX idx_ctli_contact_list_id ON public."ContactListItems" USING btree ("contactListId"); , DROP INDEX public.idx_ctli_contact_list_id; public postgres false 267 � 1259 17055 idx_ms_company_id_ticket_id INDEX e CREATE INDEX idx_ms_company_id_ticket_id ON public."Messages" USING btree ("companyId", "ticketId"); / DROP INDEX public.idx_ms_company_id_ticket_id; public postgres false 227 227 � 1259 17052 idx_sched_company_id INDEX S CREATE INDEX idx_sched_company_id ON public."Schedules" USING btree ("companyId"); ( DROP INDEX public.idx_sched_company_id; public postgres false 258 � 1259 17054 idx_tg_company_id INDEX K CREATE INDEX idx_tg_company_id ON public."Tags" USING btree ("companyId"); % DROP INDEX public.idx_tg_company_id; public postgres false 260 � 2620 17556 & Companies trg_delete_expired_companies TRIGGER � CREATE TRIGGER trg_delete_expired_companies AFTER INSERT OR UPDATE OF "planId", "dueDate" ON public."Companies" FOR EACH ROW EXECUTE FUNCTION public.delete_expired_companies(); A DROP TRIGGER trg_delete_expired_companies ON public."Companies"; public postgres false 238 238 359 238 � 2620 17534 1 CompanySockets trigger_delete_old_company_sockets TRIGGER � CREATE TRIGGER trigger_delete_old_company_sockets AFTER INSERT ON public."CompanySockets" FOR EACH ROW EXECUTE FUNCTION public.delete_old_company_sockets(); L DROP TRIGGER trigger_delete_old_company_sockets ON public."CompanySockets"; public postgres false 326 358 � 2606 17381 2 AgendamentoEmails AgendamentoEmails_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."AgendamentoEmails" ADD CONSTRAINT "AgendamentoEmails_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE CASCADE; ` ALTER TABLE ONLY public."AgendamentoEmails" DROP CONSTRAINT "AgendamentoEmails_companyId_fkey"; public postgres false 3791 312 238 � 2606 17547 E AnnouncementVisibilities AnnouncementVisibilities_announcementId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."AnnouncementVisibilities" ADD CONSTRAINT "AnnouncementVisibilities_announcementId_fkey" FOREIGN KEY ("announcementId") REFERENCES public."Announcements"(id) ON UPDATE CASCADE ON DELETE CASCADE; s ALTER TABLE ONLY public."AnnouncementVisibilities" DROP CONSTRAINT "AnnouncementVisibilities_announcementId_fkey"; public postgres false 276 328 3833 � 2606 17542 @ AnnouncementVisibilities AnnouncementVisibilities_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."AnnouncementVisibilities" ADD CONSTRAINT "AnnouncementVisibilities_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE CASCADE; n ALTER TABLE ONLY public."AnnouncementVisibilities" DROP CONSTRAINT "AnnouncementVisibilities_companyId_fkey"; public postgres false 238 328 3791 � 2606 16988 * Announcements Announcements_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Announcements" ADD CONSTRAINT "Announcements_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE CASCADE; X ALTER TABLE ONLY public."Announcements" DROP CONSTRAINT "Announcements_companyId_fkey"; public postgres false 238 276 3791 � 2606 17116 ) BaileysChats BaileysChats_whatsappId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."BaileysChats" ADD CONSTRAINT "BaileysChats_whatsappId_fkey" FOREIGN KEY ("whatsappId") REFERENCES public."Whatsapps"(id) ON UPDATE CASCADE ON DELETE CASCADE; W ALTER TABLE ONLY public."BaileysChats" DROP CONSTRAINT "BaileysChats_whatsappId_fkey"; public postgres false 229 288 3775 � 2606 17135 2 BaileysMessages BaileysMessages_baileysChatId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."BaileysMessages" ADD CONSTRAINT "BaileysMessages_baileysChatId_fkey" FOREIGN KEY ("baileysChatId") REFERENCES public."BaileysChats"(id) ON UPDATE CASCADE ON DELETE CASCADE; ` ALTER TABLE ONLY public."BaileysMessages" DROP CONSTRAINT "BaileysMessages_baileysChatId_fkey"; public postgres false 288 3845 290 � 2606 17130 / BaileysMessages BaileysMessages_whatsappId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."BaileysMessages" ADD CONSTRAINT "BaileysMessages_whatsappId_fkey" FOREIGN KEY ("whatsappId") REFERENCES public."Whatsapps"(id) ON UPDATE CASCADE ON DELETE CASCADE; ] ALTER TABLE ONLY public."BaileysMessages" DROP CONSTRAINT "BaileysMessages_whatsappId_fkey"; public postgres false 290 3775 229 � 2606 16939 0 CampaignSettings CampaignSettings_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."CampaignSettings" ADD CONSTRAINT "CampaignSettings_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE CASCADE; ^ ALTER TABLE ONLY public."CampaignSettings" DROP CONSTRAINT "CampaignSettings_companyId_fkey"; public postgres false 3791 238 271 � 2606 16965 1 CampaignShipping CampaignShipping_campaignId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."CampaignShipping" ADD CONSTRAINT "CampaignShipping_campaignId_fkey" FOREIGN KEY ("campaignId") REFERENCES public."Campaigns"(id) ON UPDATE CASCADE ON DELETE CASCADE; _ ALTER TABLE ONLY public."CampaignShipping" DROP CONSTRAINT "CampaignShipping_campaignId_fkey"; public postgres false 274 269 3826 � 2606 16960 0 CampaignShipping CampaignShipping_contactId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."CampaignShipping" ADD CONSTRAINT "CampaignShipping_contactId_fkey" FOREIGN KEY ("contactId") REFERENCES public."ContactListItems"(id) ON UPDATE SET NULL ON DELETE SET NULL; ^ ALTER TABLE ONLY public."CampaignShipping" DROP CONSTRAINT "CampaignShipping_contactId_fkey"; public postgres false 267 3823 274 � 2606 16914 " Campaigns Campaigns_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Campaigns" ADD CONSTRAINT "Campaigns_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE CASCADE; P ALTER TABLE ONLY public."Campaigns" DROP CONSTRAINT "Campaigns_companyId_fkey"; public postgres false 269 238 3791 � 2606 16919 & Campaigns Campaigns_contactListId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Campaigns" ADD CONSTRAINT "Campaigns_contactListId_fkey" FOREIGN KEY ("contactListId") REFERENCES public."ContactLists"(id) ON UPDATE SET NULL ON DELETE SET NULL; T ALTER TABLE ONLY public."Campaigns" DROP CONSTRAINT "Campaigns_contactListId_fkey"; public postgres false 3821 269 265 � 2606 17331 # Campaigns Campaigns_fileListId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Campaigns" ADD CONSTRAINT "Campaigns_fileListId_fkey" FOREIGN KEY ("fileListId") REFERENCES public."Files"(id) ON UPDATE CASCADE ON DELETE SET NULL; Q ALTER TABLE ONLY public."Campaigns" DROP CONSTRAINT "Campaigns_fileListId_fkey"; public postgres false 269 3863 302 � 2606 16924 # Campaigns Campaigns_whatsappId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Campaigns" ADD CONSTRAINT "Campaigns_whatsappId_fkey" FOREIGN KEY ("whatsappId") REFERENCES public."Whatsapps"(id) ON UPDATE SET NULL ON DELETE SET NULL; Q ALTER TABLE ONLY public."Campaigns" DROP CONSTRAINT "Campaigns_whatsappId_fkey"; public postgres false 229 269 3775 � 2606 17042 % ChatMessages ChatMessages_chatId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."ChatMessages" ADD CONSTRAINT "ChatMessages_chatId_fkey" FOREIGN KEY ("chatId") REFERENCES public."Chats"(id) ON UPDATE CASCADE ON DELETE CASCADE; S ALTER TABLE ONLY public."ChatMessages" DROP CONSTRAINT "ChatMessages_chatId_fkey"; public postgres false 278 282 3835 � 2606 17047 ' ChatMessages ChatMessages_senderId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."ChatMessages" ADD CONSTRAINT "ChatMessages_senderId_fkey" FOREIGN KEY ("senderId") REFERENCES public."Users"(id) ON UPDATE CASCADE ON DELETE CASCADE; U ALTER TABLE ONLY public."ChatMessages" DROP CONSTRAINT "ChatMessages_senderId_fkey"; public postgres false 3761 282 222 � 2606 17022 ChatUsers ChatUsers_chatId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."ChatUsers" ADD CONSTRAINT "ChatUsers_chatId_fkey" FOREIGN KEY ("chatId") REFERENCES public."Chats"(id) ON UPDATE CASCADE ON DELETE CASCADE; M ALTER TABLE ONLY public."ChatUsers" DROP CONSTRAINT "ChatUsers_chatId_fkey"; public postgres false 280 3835 278 � 2606 17027 ChatUsers ChatUsers_userId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."ChatUsers" ADD CONSTRAINT "ChatUsers_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."Users"(id) ON UPDATE CASCADE ON DELETE CASCADE; M ALTER TABLE ONLY public."ChatUsers" DROP CONSTRAINT "ChatUsers_userId_fkey"; public postgres false 222 3761 280 r 2606 16738 Chatbots Chatbots_chatbotId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Chatbots" ADD CONSTRAINT "Chatbots_chatbotId_fkey" FOREIGN KEY ("chatbotId") REFERENCES public."Chatbots"(id) ON UPDATE CASCADE ON DELETE CASCADE; N ALTER TABLE ONLY public."Chatbots" DROP CONSTRAINT "Chatbots_chatbotId_fkey"; public postgres false 252 252 3807 s 2606 16733 Chatbots Chatbots_queueId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Chatbots" ADD CONSTRAINT "Chatbots_queueId_fkey" FOREIGN KEY ("queueId") REFERENCES public."Queues"(id) ON UPDATE CASCADE ON DELETE CASCADE; L ALTER TABLE ONLY public."Chatbots" DROP CONSTRAINT "Chatbots_queueId_fkey"; public postgres false 3783 234 252 � 2606 17703 ' ChatsImport ChatsImport_whatsappId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."ChatsImport" ADD CONSTRAINT "ChatsImport_whatsappId_fkey" FOREIGN KEY ("whatsappId") REFERENCES public."Whatsapps"(id) ON UPDATE CASCADE ON DELETE CASCADE; U ALTER TABLE ONLY public."ChatsImport" DROP CONSTRAINT "ChatsImport_whatsappId_fkey"; public postgres false 345 3775 229 � 2606 17009 Chats Chats_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Chats" ADD CONSTRAINT "Chats_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE CASCADE; H ALTER TABLE ONLY public."Chats" DROP CONSTRAINT "Chats_companyId_fkey"; public postgres false 3791 238 278 � 2606 17004 Chats Chats_ownerId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Chats" ADD CONSTRAINT "Chats_ownerId_fkey" FOREIGN KEY ("ownerId") REFERENCES public."Users"(id) ON UPDATE CASCADE ON DELETE CASCADE; F ALTER TABLE ONLY public."Chats" DROP CONSTRAINT "Chats_ownerId_fkey"; public postgres false 3761 222 278 b 2606 16613 Companies Companies_planId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Companies" ADD CONSTRAINT "Companies_planId_fkey" FOREIGN KEY ("planId") REFERENCES public."Plans"(id) ON UPDATE CASCADE ON DELETE SET NULL; M ALTER TABLE ONLY public."Companies" DROP CONSTRAINT "Companies_planId_fkey"; public postgres false 3795 238 240 � 2606 17528 , CompanySockets CompanySockets_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."CompanySockets" ADD CONSTRAINT "CompanySockets_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE CASCADE; Z ALTER TABLE ONLY public."CompanySockets" DROP CONSTRAINT "CompanySockets_companyId_fkey"; public postgres false 326 3791 238 ] 2606 16482 6 ContactCustomFields ContactCustomFields_contactId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."ContactCustomFields" ADD CONSTRAINT "ContactCustomFields_contactId_fkey" FOREIGN KEY ("contactId") REFERENCES public."Contacts"(id) ON UPDATE CASCADE ON DELETE CASCADE; d ALTER TABLE ONLY public."ContactCustomFields" DROP CONSTRAINT "ContactCustomFields_contactId_fkey"; public postgres false 224 3763 231 � 2606 16889 0 ContactListItems ContactListItems_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."ContactListItems" ADD CONSTRAINT "ContactListItems_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE CASCADE; ^ ALTER TABLE ONLY public."ContactListItems" DROP CONSTRAINT "ContactListItems_companyId_fkey"; public postgres false 238 3791 267 � 2606 16884 4 ContactListItems ContactListItems_contactListId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."ContactListItems" ADD CONSTRAINT "ContactListItems_contactListId_fkey" FOREIGN KEY ("contactListId") REFERENCES public."ContactLists"(id) ON UPDATE CASCADE ON DELETE CASCADE; b ALTER TABLE ONLY public."ContactListItems" DROP CONSTRAINT "ContactListItems_contactListId_fkey"; public postgres false 267 3821 265 � 2606 16869 ( ContactLists ContactLists_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."ContactLists" ADD CONSTRAINT "ContactLists_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE CASCADE; V ALTER TABLE ONLY public."ContactLists" DROP CONSTRAINT "ContactLists_companyId_fkey"; public postgres false 238 3791 265 H 2606 16574 Contacts Contacts_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Contacts" ADD CONSTRAINT "Contacts_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE SET NULL; N ALTER TABLE ONLY public."Contacts" DROP CONSTRAINT "Contacts_companyId_fkey"; public postgres false 238 3791 224 I 2606 17447 ! Contacts Contacts_whatsappId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Contacts" ADD CONSTRAINT "Contacts_whatsappId_fkey" FOREIGN KEY ("whatsappId") REFERENCES public."Whatsapps"(id) ON UPDATE CASCADE ON DELETE SET NULL; O ALTER TABLE ONLY public."Contacts" DROP CONSTRAINT "Contacts_whatsappId_fkey"; public postgres false 3775 224 229 t 2606 16756 , DialogChatBots DialogChatBots_chatbotId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."DialogChatBots" ADD CONSTRAINT "DialogChatBots_chatbotId_fkey" FOREIGN KEY ("chatbotId") REFERENCES public."Chatbots"(id) ON UPDATE CASCADE ON DELETE SET NULL; Z ALTER TABLE ONLY public."DialogChatBots" DROP CONSTRAINT "DialogChatBots_chatbotId_fkey"; public postgres false 254 252 3807 u 2606 16751 , DialogChatBots DialogChatBots_contactId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."DialogChatBots" ADD CONSTRAINT "DialogChatBots_contactId_fkey" FOREIGN KEY ("contactId") REFERENCES public."Contacts"(id) ON UPDATE CASCADE ON DELETE CASCADE; Z ALTER TABLE ONLY public."DialogChatBots" DROP CONSTRAINT "DialogChatBots_contactId_fkey"; public postgres false 254 224 3763 v 2606 16815 * DialogChatBots DialogChatBots_queueId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."DialogChatBots" ADD CONSTRAINT "DialogChatBots_queueId_fkey" FOREIGN KEY ("queueId") REFERENCES public."Queues"(id) ON UPDATE CASCADE ON DELETE SET NULL; X ALTER TABLE ONLY public."DialogChatBots" DROP CONSTRAINT "DialogChatBots_queueId_fkey"; public postgres false 234 254 3783 � 2606 17367 Emails Emails_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Emails" ADD CONSTRAINT "Emails_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE CASCADE; J ALTER TABLE ONLY public."Emails" DROP CONSTRAINT "Emails_companyId_fkey"; public postgres false 3791 238 310 � 2606 17402 Eventos Eventos_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Eventos" ADD CONSTRAINT "Eventos_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE CASCADE; L ALTER TABLE ONLY public."Eventos" DROP CONSTRAINT "Eventos_companyId_fkey"; public postgres false 238 3791 314 � 2606 17273 % FilesOptions FilesOptions_fileId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."FilesOptions" ADD CONSTRAINT "FilesOptions_fileId_fkey" FOREIGN KEY ("fileId") REFERENCES public."Files"(id) ON UPDATE CASCADE ON DELETE CASCADE; S ALTER TABLE ONLY public."FilesOptions" DROP CONSTRAINT "FilesOptions_fileId_fkey"; public postgres false 304 3863 302 � 2606 17259 Files Files_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Files" ADD CONSTRAINT "Files_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE CASCADE; H ALTER TABLE ONLY public."Files" DROP CONSTRAINT "Files_companyId_fkey"; public postgres false 302 3791 238 � 2606 17157 ( Integrations Integrations_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Integrations" ADD CONSTRAINT "Integrations_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE SET NULL; V ALTER TABLE ONLY public."Integrations" DROP CONSTRAINT "Integrations_companyId_fkey"; public postgres false 3791 292 238 � 2606 17092 Invoices Invoices_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Invoices" ADD CONSTRAINT "Invoices_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE SET NULL; N ALTER TABLE ONLY public."Invoices" DROP CONSTRAINT "Invoices_companyId_fkey"; public postgres false 286 3791 238 � 2606 17452 ! Invoices Invoices_companyId_fkey1 FK CONSTRAINT � ALTER TABLE ONLY public."Invoices" ADD CONSTRAINT "Invoices_companyId_fkey1" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE CASCADE; O ALTER TABLE ONLY public."Invoices" DROP CONSTRAINT "Invoices_companyId_fkey1"; public postgres false 238 286 3791 � 2606 17718 ; MessageImportStatuses MessageImportStatuses_whatsappId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."MessageImportStatuses" ADD CONSTRAINT "MessageImportStatuses_whatsappId_fkey" FOREIGN KEY ("whatsappId") REFERENCES public."Whatsapps"(id) ON UPDATE CASCADE ON DELETE CASCADE; i ALTER TABLE ONLY public."MessageImportStatuses" DROP CONSTRAINT "MessageImportStatuses_whatsappId_fkey"; public postgres false 229 347 3775 T 2606 16579 Messages Messages_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Messages" ADD CONSTRAINT "Messages_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE SET NULL; N ALTER TABLE ONLY public."Messages" DROP CONSTRAINT "Messages_companyId_fkey"; public postgres false 3791 227 238 U 2606 16509 Messages Messages_contactId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Messages" ADD CONSTRAINT "Messages_contactId_fkey" FOREIGN KEY ("contactId") REFERENCES public."Contacts"(id) ON UPDATE CASCADE ON DELETE CASCADE; N ALTER TABLE ONLY public."Messages" DROP CONSTRAINT "Messages_contactId_fkey"; public postgres false 3763 227 224 V 2606 16970 Messages Messages_queueId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Messages" ADD CONSTRAINT "Messages_queueId_fkey" FOREIGN KEY ("queueId") REFERENCES public."Queues"(id) ON UPDATE SET NULL ON DELETE SET NULL; L ALTER TABLE ONLY public."Messages" DROP CONSTRAINT "Messages_queueId_fkey"; public postgres false 234 3783 227 W 2606 16520 " Messages Messages_quotedMsgId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Messages" ADD CONSTRAINT "Messages_quotedMsgId_fkey" FOREIGN KEY ("quotedMsgId") REFERENCES public."Messages"(id) ON UPDATE CASCADE ON DELETE SET NULL; P ALTER TABLE ONLY public."Messages" DROP CONSTRAINT "Messages_quotedMsgId_fkey"; public postgres false 227 3772 227 X 2606 16459 Messages Messages_ticketId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Messages" ADD CONSTRAINT "Messages_ticketId_fkey" FOREIGN KEY ("ticketId") REFERENCES public."Tickets"(id) ON UPDATE CASCADE ON DELETE CASCADE; M ALTER TABLE ONLY public."Messages" DROP CONSTRAINT "Messages_ticketId_fkey"; public postgres false 226 3768 227 � 2606 17581 ! NotyNodes NotyNodes_ticketId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."NotyNodes" ADD CONSTRAINT "NotyNodes_ticketId_fkey" FOREIGN KEY ("ticketId") REFERENCES public."Tickets"(id) ON UPDATE CASCADE ON DELETE CASCADE; O ALTER TABLE ONLY public."NotyNodes" DROP CONSTRAINT "NotyNodes_ticketId_fkey"; public postgres false 3768 226 331 � 2606 17648 & OldMessages OldMessages_messageId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."OldMessages" ADD CONSTRAINT "OldMessages_messageId_fkey" FOREIGN KEY ("messageId") REFERENCES public."Messages"(id) ON UPDATE CASCADE ON DELETE CASCADE; T ALTER TABLE ONLY public."OldMessages" DROP CONSTRAINT "OldMessages_messageId_fkey"; public postgres false 338 227 3772 � 2606 17310 Prompts Prompts_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Prompts" ADD CONSTRAINT "Prompts_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id); L ALTER TABLE ONLY public."Prompts" DROP CONSTRAINT "Prompts_companyId_fkey"; public postgres false 238 306 3791 � 2606 17305 Prompts Prompts_queueId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Prompts" ADD CONSTRAINT "Prompts_queueId_fkey" FOREIGN KEY ("queueId") REFERENCES public."Queues"(id); J ALTER TABLE ONLY public."Prompts" DROP CONSTRAINT "Prompts_queueId_fkey"; public postgres false 306 234 3783 � 2606 17245 2 QueueIntegrations QueueIntegrations_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."QueueIntegrations" ADD CONSTRAINT "QueueIntegrations_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE SET NULL; ` ALTER TABLE ONLY public."QueueIntegrations" DROP CONSTRAINT "QueueIntegrations_companyId_fkey"; public postgres false 238 300 3791 w 2606 16775 ' QueueOptions QueueOptions_parentId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."QueueOptions" ADD CONSTRAINT "QueueOptions_parentId_fkey" FOREIGN KEY ("parentId") REFERENCES public."QueueOptions"(id) ON UPDATE CASCADE ON DELETE CASCADE; U ALTER TABLE ONLY public."QueueOptions" DROP CONSTRAINT "QueueOptions_parentId_fkey"; public postgres false 256 3811 256 x 2606 16770 & QueueOptions QueueOptions_queueId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."QueueOptions" ADD CONSTRAINT "QueueOptions_queueId_fkey" FOREIGN KEY ("queueId") REFERENCES public."Queues"(id) ON UPDATE CASCADE ON DELETE CASCADE; T ALTER TABLE ONLY public."QueueOptions" DROP CONSTRAINT "QueueOptions_queueId_fkey"; public postgres false 234 256 3783 _ 2606 16584 Queues Queues_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Queues" ADD CONSTRAINT "Queues_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE SET NULL; J ALTER TABLE ONLY public."Queues" DROP CONSTRAINT "Queues_companyId_fkey"; public postgres false 238 3791 234 ` 2606 17321 Queues Queues_integrationId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Queues" ADD CONSTRAINT "Queues_integrationId_fkey" FOREIGN KEY ("integrationId") REFERENCES public."QueueIntegrations"(id) ON UPDATE CASCADE ON DELETE SET NULL; N ALTER TABLE ONLY public."Queues" DROP CONSTRAINT "Queues_integrationId_fkey"; public postgres false 3859 300 234 a 2606 17431 Queues Queues_promptId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Queues" ADD CONSTRAINT "Queues_promptId_fkey" FOREIGN KEY ("promptId") REFERENCES public."Prompts"(id) ON UPDATE CASCADE ON DELETE SET NULL; I ALTER TABLE ONLY public."Queues" DROP CONSTRAINT "Queues_promptId_fkey"; public postgres false 306 3867 234 f 2606 16651 * QuickMessages QuickMessages_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."QuickMessages" ADD CONSTRAINT "QuickMessages_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE CASCADE; X ALTER TABLE ONLY public."QuickMessages" DROP CONSTRAINT "QuickMessages_companyId_fkey"; public postgres false 3791 244 238 g 2606 16820 ' QuickMessages QuickMessages_userId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."QuickMessages" ADD CONSTRAINT "QuickMessages_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."Users"(id) ON UPDATE CASCADE ON DELETE CASCADE; U ALTER TABLE ONLY public."QuickMessages" DROP CONSTRAINT "QuickMessages_userId_fkey"; public postgres false 244 3761 222 � 2606 17205 + RatingsOptions RatingsOptions_ratingId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."RatingsOptions" ADD CONSTRAINT "RatingsOptions_ratingId_fkey" FOREIGN KEY ("ratingId") REFERENCES public."Ratings"(id) ON UPDATE CASCADE ON DELETE CASCADE; Y ALTER TABLE ONLY public."RatingsOptions" DROP CONSTRAINT "RatingsOptions_ratingId_fkey"; public postgres false 296 3853 298 � 2606 17191 Ratings Ratings_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Ratings" ADD CONSTRAINT "Ratings_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE CASCADE; L ALTER TABLE ONLY public."Ratings" DROP CONSTRAINT "Ratings_companyId_fkey"; public postgres false 238 3791 296 y 2606 16810 " Schedules Schedules_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Schedules" ADD CONSTRAINT "Schedules_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE CASCADE; P ALTER TABLE ONLY public."Schedules" DROP CONSTRAINT "Schedules_companyId_fkey"; public postgres false 258 238 3791 z 2606 16795 " Schedules Schedules_contactId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Schedules" ADD CONSTRAINT "Schedules_contactId_fkey" FOREIGN KEY ("contactId") REFERENCES public."Contacts"(id) ON UPDATE CASCADE ON DELETE CASCADE; P ALTER TABLE ONLY public."Schedules" DROP CONSTRAINT "Schedules_contactId_fkey"; public postgres false 224 3763 258 { 2606 17487 Schedules Schedules_queueId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Schedules" ADD CONSTRAINT "Schedules_queueId_fkey" FOREIGN KEY ("queueId") REFERENCES public."Queues"(id) ON UPDATE CASCADE ON DELETE SET NULL; N ALTER TABLE ONLY public."Schedules" DROP CONSTRAINT "Schedules_queueId_fkey"; public postgres false 258 3783 234 | 2606 16800 ! Schedules Schedules_ticketId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Schedules" ADD CONSTRAINT "Schedules_ticketId_fkey" FOREIGN KEY ("ticketId") REFERENCES public."Tickets"(id) ON UPDATE SET NULL ON DELETE SET NULL; O ALTER TABLE ONLY public."Schedules" DROP CONSTRAINT "Schedules_ticketId_fkey"; public postgres false 258 226 3768 } 2606 16805 Schedules Schedules_userId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Schedules" ADD CONSTRAINT "Schedules_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."Users"(id) ON UPDATE SET NULL ON DELETE SET NULL; M ALTER TABLE ONLY public."Schedules" DROP CONSTRAINT "Schedules_userId_fkey"; public postgres false 222 3761 258 ^ 2606 16564 Settings Settings_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Settings" ADD CONSTRAINT "Settings_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE SET NULL; N ALTER TABLE ONLY public."Settings" DROP CONSTRAINT "Settings_companyId_fkey"; public postgres false 238 232 3791 � 2606 17662 ( StatusTicket StatusTicket_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."StatusTicket" ADD CONSTRAINT "StatusTicket_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE CASCADE; V ALTER TABLE ONLY public."StatusTicket" DROP CONSTRAINT "StatusTicket_companyId_fkey"; public postgres false 340 238 3791 � 2606 17068 * Subscriptions Subscriptions_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Subscriptions" ADD CONSTRAINT "Subscriptions_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE CASCADE; X ALTER TABLE ONLY public."Subscriptions" DROP CONSTRAINT "Subscriptions_companyId_fkey"; public postgres false 3791 238 284 ~ 2606 16834 Tags Tags_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Tags" ADD CONSTRAINT "Tags_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE CASCADE; F ALTER TABLE ONLY public."Tags" DROP CONSTRAINT "Tags_companyId_fkey"; public postgres false 3791 260 238 � 2606 17346 Tasks Tasks_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Tasks" ADD CONSTRAINT "Tasks_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id); H ALTER TABLE ONLY public."Tasks" DROP CONSTRAINT "Tasks_companyId_fkey"; public postgres false 308 238 3791 � 2606 17351 Tasks Tasks_userId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Tasks" ADD CONSTRAINT "Tasks_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."Users"(id) ON UPDATE CASCADE ON DELETE SET NULL; E ALTER TABLE ONLY public."Tasks" DROP CONSTRAINT "Tasks_userId_fkey"; public postgres false 3761 308 222 c 2606 16632 & TicketNotes TicketNotes_contactId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."TicketNotes" ADD CONSTRAINT "TicketNotes_contactId_fkey" FOREIGN KEY ("contactId") REFERENCES public."Contacts"(id) ON UPDATE CASCADE ON DELETE CASCADE; T ALTER TABLE ONLY public."TicketNotes" DROP CONSTRAINT "TicketNotes_contactId_fkey"; public postgres false 242 224 3763 d 2606 16637 % TicketNotes TicketNotes_ticketId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."TicketNotes" ADD CONSTRAINT "TicketNotes_ticketId_fkey" FOREIGN KEY ("ticketId") REFERENCES public."Tickets"(id) ON UPDATE CASCADE ON DELETE SET NULL; S ALTER TABLE ONLY public."TicketNotes" DROP CONSTRAINT "TicketNotes_ticketId_fkey"; public postgres false 242 226 3768 e 2606 16627 # TicketNotes TicketNotes_userId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."TicketNotes" ADD CONSTRAINT "TicketNotes_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."Users"(id) ON UPDATE CASCADE ON DELETE SET NULL; Q ALTER TABLE ONLY public."TicketNotes" DROP CONSTRAINT "TicketNotes_userId_fkey"; public postgres false 3761 242 222 � 2606 17675 - TicketStatus TicketStatus_statusTicketId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."TicketStatus" ADD CONSTRAINT "TicketStatus_statusTicketId_fkey" FOREIGN KEY ("statusTicketId") REFERENCES public."StatusTicket"(id) ON UPDATE CASCADE ON DELETE CASCADE; [ ALTER TABLE ONLY public."TicketStatus" DROP CONSTRAINT "TicketStatus_statusTicketId_fkey"; public postgres false 341 3903 340 � 2606 17670 ' TicketStatus TicketStatus_ticketId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."TicketStatus" ADD CONSTRAINT "TicketStatus_ticketId_fkey" FOREIGN KEY ("ticketId") REFERENCES public."Tickets"(id) ON UPDATE CASCADE ON DELETE CASCADE; U ALTER TABLE ONLY public."TicketStatus" DROP CONSTRAINT "TicketStatus_ticketId_fkey"; public postgres false 226 341 3768 2606 17725 $ TicketTags TicketTags_contactId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."TicketTags" ADD CONSTRAINT "TicketTags_contactId_fkey" FOREIGN KEY ("contactId") REFERENCES public."Contacts"(id) ON UPDATE CASCADE ON DELETE CASCADE; R ALTER TABLE ONLY public."TicketTags" DROP CONSTRAINT "TicketTags_contactId_fkey"; public postgres false 3763 224 261 � 2606 16847 TicketTags TicketTags_tagId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."TicketTags" ADD CONSTRAINT "TicketTags_tagId_fkey" FOREIGN KEY ("tagId") REFERENCES public."Tags"(id) ON UPDATE CASCADE ON DELETE CASCADE; N ALTER TABLE ONLY public."TicketTags" DROP CONSTRAINT "TicketTags_tagId_fkey"; public postgres false 260 261 3816 � 2606 16842 # TicketTags TicketTags_ticketId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."TicketTags" ADD CONSTRAINT "TicketTags_ticketId_fkey" FOREIGN KEY ("ticketId") REFERENCES public."Tickets"(id) ON UPDATE CASCADE ON DELETE CASCADE; Q ALTER TABLE ONLY public."TicketTags" DROP CONSTRAINT "TicketTags_ticketId_fkey"; public postgres false 226 3768 261 h 2606 16680 * TicketTraking TicketTraking_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."TicketTraking" ADD CONSTRAINT "TicketTraking_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON DELETE SET NULL; X ALTER TABLE ONLY public."TicketTraking" DROP CONSTRAINT "TicketTraking_companyId_fkey"; public postgres false 248 3791 238 i 2606 17591 ) TicketTraking TicketTraking_ratingId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."TicketTraking" ADD CONSTRAINT "TicketTraking_ratingId_fkey" FOREIGN KEY ("ratingId") REFERENCES public."Ratings"(id) ON UPDATE CASCADE ON DELETE CASCADE; W ALTER TABLE ONLY public."TicketTraking" DROP CONSTRAINT "TicketTraking_ratingId_fkey"; public postgres false 3853 248 296 j 2606 16675 ) TicketTraking TicketTraking_ticketId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."TicketTraking" ADD CONSTRAINT "TicketTraking_ticketId_fkey" FOREIGN KEY ("ticketId") REFERENCES public."Tickets"(id) ON DELETE SET NULL; W ALTER TABLE ONLY public."TicketTraking" DROP CONSTRAINT "TicketTraking_ticketId_fkey"; public postgres false 248 226 3768 k 2606 16690 ' TicketTraking TicketTraking_userId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."TicketTraking" ADD CONSTRAINT "TicketTraking_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."Users"(id) ON DELETE SET NULL; U ALTER TABLE ONLY public."TicketTraking" DROP CONSTRAINT "TicketTraking_userId_fkey"; public postgres false 222 3761 248 l 2606 16685 + TicketTraking TicketTraking_whatsappId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."TicketTraking" ADD CONSTRAINT "TicketTraking_whatsappId_fkey" FOREIGN KEY ("whatsappId") REFERENCES public."Whatsapps"(id) ON DELETE SET NULL; Y ALTER TABLE ONLY public."TicketTraking" DROP CONSTRAINT "TicketTraking_whatsappId_fkey"; public postgres false 229 3775 248 � 2606 17509 # TicketUser TicketUser_ticketId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."TicketUser" ADD CONSTRAINT "TicketUser_ticketId_fkey" FOREIGN KEY ("ticketId") REFERENCES public."Tickets"(id); Q ALTER TABLE ONLY public."TicketUser" DROP CONSTRAINT "TicketUser_ticketId_fkey"; public postgres false 3768 324 226 � 2606 17514 ! TicketUser TicketUser_userId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."TicketUser" ADD CONSTRAINT "TicketUser_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."Users"(id); O ALTER TABLE ONLY public."TicketUser" DROP CONSTRAINT "TicketUser_userId_fkey"; public postgres false 3761 222 324 J 2606 17619 % Tickets Tickets_awaitingRatingId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Tickets" ADD CONSTRAINT "Tickets_awaitingRatingId_fkey" FOREIGN KEY ("awaitingRatingId") REFERENCES public."Ratings"(id); S ALTER TABLE ONLY public."Tickets" DROP CONSTRAINT "Tickets_awaitingRatingId_fkey"; public postgres false 226 296 3853 K 2606 16594 Tickets Tickets_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Tickets" ADD CONSTRAINT "Tickets_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE SET NULL; L ALTER TABLE ONLY public."Tickets" DROP CONSTRAINT "Tickets_companyId_fkey"; public postgres false 226 238 3791 L 2606 16435 Tickets Tickets_contactId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Tickets" ADD CONSTRAINT "Tickets_contactId_fkey" FOREIGN KEY ("contactId") REFERENCES public."Contacts"(id) ON UPDATE CASCADE ON DELETE CASCADE; L ALTER TABLE ONLY public."Tickets" DROP CONSTRAINT "Tickets_contactId_fkey"; public postgres false 226 3763 224 M 2606 17625 Tickets Tickets_flowId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Tickets" ADD CONSTRAINT "Tickets_flowId_fkey" FOREIGN KEY ("flowId") REFERENCES public."Flows"(id) ON UPDATE CASCADE ON DELETE SET NULL; I ALTER TABLE ONLY public."Tickets" DROP CONSTRAINT "Tickets_flowId_fkey"; public postgres false 3891 226 329 N 2606 17285 " Tickets Tickets_integrationId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Tickets" ADD CONSTRAINT "Tickets_integrationId_fkey" FOREIGN KEY ("integrationId") REFERENCES public."QueueIntegrations"(id); P ALTER TABLE ONLY public."Tickets" DROP CONSTRAINT "Tickets_integrationId_fkey"; public postgres false 300 226 3859 O 2606 17492 Tickets Tickets_prompt_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Tickets" ADD CONSTRAINT "Tickets_prompt_fkey" FOREIGN KEY (prompt) REFERENCES public."Prompts"(id) ON UPDATE CASCADE ON DELETE SET NULL; I ALTER TABLE ONLY public."Tickets" DROP CONSTRAINT "Tickets_prompt_fkey"; public postgres false 306 226 3867 P 2606 16538 Tickets Tickets_queueId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Tickets" ADD CONSTRAINT "Tickets_queueId_fkey" FOREIGN KEY ("queueId") REFERENCES public."Queues"(id) ON UPDATE CASCADE ON DELETE SET NULL; J ALTER TABLE ONLY public."Tickets" DROP CONSTRAINT "Tickets_queueId_fkey"; public postgres false 226 3783 234 Q 2606 16781 " Tickets Tickets_queueOptionId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Tickets" ADD CONSTRAINT "Tickets_queueOptionId_fkey" FOREIGN KEY ("queueOptionId") REFERENCES public."QueueOptions"(id) ON UPDATE SET NULL ON DELETE SET NULL; P ALTER TABLE ONLY public."Tickets" DROP CONSTRAINT "Tickets_queueOptionId_fkey"; public postgres false 3811 226 256 R 2606 16440 Tickets Tickets_userId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Tickets" ADD CONSTRAINT "Tickets_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."Users"(id) ON UPDATE CASCADE ON DELETE SET NULL; I ALTER TABLE ONLY public."Tickets" DROP CONSTRAINT "Tickets_userId_fkey"; public postgres false 222 3761 226 S 2606 16500 Tickets Tickets_whatsappId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Tickets" ADD CONSTRAINT "Tickets_whatsappId_fkey" FOREIGN KEY ("whatsappId") REFERENCES public."Whatsapps"(id) ON UPDATE CASCADE ON DELETE SET NULL; M ALTER TABLE ONLY public."Tickets" DROP CONSTRAINT "Tickets_whatsappId_fkey"; public postgres false 229 3775 226 m 2606 16709 & UserRatings UserRatings_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."UserRatings" ADD CONSTRAINT "UserRatings_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON DELETE SET NULL; T ALTER TABLE ONLY public."UserRatings" DROP CONSTRAINT "UserRatings_companyId_fkey"; public postgres false 3791 238 250 n 2606 17215 + UserRatings UserRatings_ratingIdOption_fkey FK CONSTRAINT � ALTER TABLE ONLY public."UserRatings" ADD CONSTRAINT "UserRatings_ratingIdOption_fkey" FOREIGN KEY ("ratingIdOption") REFERENCES public."RatingsOptions"(id) ON UPDATE RESTRICT ON DELETE RESTRICT; Y ALTER TABLE ONLY public."UserRatings" DROP CONSTRAINT "UserRatings_ratingIdOption_fkey"; public postgres false 250 3855 298 o 2606 17586 % UserRatings UserRatings_ratingId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."UserRatings" ADD CONSTRAINT "UserRatings_ratingId_fkey" FOREIGN KEY ("ratingId") REFERENCES public."Ratings"(id) ON DELETE CASCADE; S ALTER TABLE ONLY public."UserRatings" DROP CONSTRAINT "UserRatings_ratingId_fkey"; public postgres false 296 250 3853 p 2606 16704 % UserRatings UserRatings_ticketId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."UserRatings" ADD CONSTRAINT "UserRatings_ticketId_fkey" FOREIGN KEY ("ticketId") REFERENCES public."Tickets"(id) ON DELETE SET NULL; S ALTER TABLE ONLY public."UserRatings" DROP CONSTRAINT "UserRatings_ticketId_fkey"; public postgres false 250 3768 226 q 2606 16714 # UserRatings UserRatings_userId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."UserRatings" ADD CONSTRAINT "UserRatings_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."Users"(id) ON DELETE SET NULL; Q ALTER TABLE ONLY public."UserRatings" DROP CONSTRAINT "UserRatings_userId_fkey"; public postgres false 250 3761 222 F 2606 16569 Users Users_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Users" ADD CONSTRAINT "Users_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE SET NULL; H ALTER TABLE ONLY public."Users" DROP CONSTRAINT "Users_companyId_fkey"; public postgres false 238 3791 222 G 2606 17240 Users Users_whatsappId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Users" ADD CONSTRAINT "Users_whatsappId_fkey" FOREIGN KEY ("whatsappId") REFERENCES public."Whatsapps"(id) ON UPDATE CASCADE ON DELETE SET NULL; I ALTER TABLE ONLY public."Users" DROP CONSTRAINT "Users_whatsappId_fkey"; public postgres false 222 3775 229 Y 2606 16589 " Whatsapps Whatsapps_companyId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Whatsapps" ADD CONSTRAINT "Whatsapps_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES public."Companies"(id) ON UPDATE CASCADE ON DELETE SET NULL; P ALTER TABLE ONLY public."Whatsapps" DROP CONSTRAINT "Whatsapps_companyId_fkey"; public postgres false 229 3791 238 Z 2606 17567 Whatsapps Whatsapps_flowId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Whatsapps" ADD CONSTRAINT "Whatsapps_flowId_fkey" FOREIGN KEY ("flowId") REFERENCES public."Flows"(id) ON UPDATE CASCADE ON DELETE SET NULL; M ALTER TABLE ONLY public."Whatsapps" DROP CONSTRAINT "Whatsapps_flowId_fkey"; public postgres false 3891 229 329 [ 2606 17326 & Whatsapps Whatsapps_integrationId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Whatsapps" ADD CONSTRAINT "Whatsapps_integrationId_fkey" FOREIGN KEY ("integrationId") REFERENCES public."QueueIntegrations"(id) ON UPDATE CASCADE ON DELETE SET NULL; T ALTER TABLE ONLY public."Whatsapps" DROP CONSTRAINT "Whatsapps_integrationId_fkey"; public postgres false 300 3859 229 \ 2606 17315 ! Whatsapps Whatsapps_promptId_fkey FK CONSTRAINT � ALTER TABLE ONLY public."Whatsapps" ADD CONSTRAINT "Whatsapps_promptId_fkey" FOREIGN KEY ("promptId") REFERENCES public."Prompts"(id) ON UPDATE RESTRICT ON DELETE RESTRICT; O ALTER TABLE ONLY public."Whatsapps" DROP CONSTRAINT "Whatsapps_promptId_fkey"; public postgres false 229 306 3867 � x������ � � � x������ � � � � x�}S�jA>�>E=�v����m �c�qA*=��3�cO���"��E���� �x�7��#X=���.L�T�W_}�հ7��� X֊S� �r9�1�R��/^��#�:S� �P��!�l;F˻C(�����C9Q�N� fz��/^^�ԑ9!� <�j~����4d_��(�փ�O�4i�!52r���-B� D���ʀiѰ�v��EE h ��<���Ym Sa��0GűgH�����Ph�p�*Fm�K��Dn-$z I�^��W�2����$����u��cI���r�,���$3��P~�}��m*�=��� �7�Ik=;�2w&A����.؈� y�g�5<�Tt�L �� �,� W�sT�ʔ� �YF9�&��H�]��� 2� n�>?�ݖ��>ɹ��T�� N*�w��B2r�ʫ� Z�����2�ԖK�\7�gp�Dō*�x�0�U0u�|�_;v �9��M+��V� ���^��v��2�ՀW� ��k����"�2�7LϾz�#��6N� �G�K�x!*G�ڣ��b��v�^�h�]�=Y ��-�|��y;'X��.Ѽ�]-X��ɕ4&�j}v��ֻI*͊�1�rK/N %���q�������%q�;�S��}�\����pk��~wkk0�F��� �Q�y��GkÁ�a�9oOw�����`�?��,������� } � x�uS�jA>�>E=�v�]��m �c�qA*=�� 3�cw���"��E���� �x�7��#X=��3�U��W_}Qp`�2Gia��/�0�1�d����� 82��0T��괈���ъ� B��O���c�e����p�f����L �Xf����&A%�b�'0���GPVK�A�'r1 �4� !�,9m�0G�Pd YW]i� ���?w�h� ���7�8�}~%�@�R�X� �Q��3$�_��Yd'Һ�QW�v0�[ � pR��g�U1�@�a�3��[¦w��IN���jY�l{��BI�Շ���n[����og0��wHB�ٱ���:΅T)5 �g=��`�ZPnС� ��7��@w�]-R*���<�I��Y*@�)�D�<�\[���q����v;6S�ec���?]Ȭfx�]�)&� �Eݡ�Ag0�?׆g��jɓ�'� �� d� '�'�}̝'��ߞ��fΨ��������W�A��a���j�+Q���5ъԈ{[�j���[�g_=�&��磭P�`��[�Qoz6�U�e�~��nNa�WG �W��v����rvK4�sW VJ�C|%O�uZ�]���n�s�lfL��܋�BY�=u2O��4 �X]ޒ�����s!�> W.��~mF�[���Q4= ��\%A����Gkѐ ޝ��'íp��6��d0 ��o�p� � x������ � � p x������ � � � x������ � � � x������ � � x x������ � � { x������ � � v x������ � � � x������ � � � x������ � � � x������ � � e x������ � � x������ � � � x������ � � W � x�}P�j�0 <;_� ��lɯS)�?��Av�RhH��__{J[J�A�F�����CFT�N �4B�>s�����'�:��K�7� �,� V=n�UvE!���'Un���=����n���e�7@�wv�H����eM� ��Ն�����:I0c��E��V�e�P�zOT�9� �L�LA�TNjMN�Sjg ���� !-� Xt�t� �����p6�0|��S � x������ � � � n x�}R�n�0 >�Oa�+�(Pn=� �i�p�R�ڸKR41�a� ��}�%T08��ʎ���g�q�ՖK�r���I���$J���(�4w�-)�+*!'xY�5YUA��n~��H�eq, ���G� ϒ�,���� ���滻P �̢�Å�r �rZJ%���� ���#�F7S#� ��b |��Rը]TC�Y�1�՞�u�b Kܰ�Bme!����Hy��U�Q5;7��ϼħC��k����W��qs��~�__�7���R��m�= �u��>Y��Z���p�Q( ���5��;/YB]i�}�*[i�IP�**��%��B�KH6X���g�h)�0 :q:J��Eߢ����e �0 � ��A P x������ � � t x������ � � r x������ � � I x������ � � g x������ � � � x������ � � � x������ � � � x������ � � � x������ � � � x������ � � _ x������ � � � x������ � � � K x�3�4�4202�54�5410�#]c ������`ș_���i0��7�@��� �@&�NA�=... }d> � x������ � � L x������ � � � x������ � � � x������ � � � x������ � � Y D x�3� �I��W0�44�"##]C R00�2��2��360�50�'eh`�Y���q��a� W� )� � x������ � � � x������ � � i x������ � � S x������ � � ] x������ � � � x������ � � � x������ � � k x������ � � E N x��[ٖܶ}�W��C���8��xKV����s�`�� x�$�eF��Ovp�Q,Y�l��R��� "1��")�4�i����Y�Q7��������Ng��c�R���k'v��,�1��_ �$��\�8� EL� ��M#�{BR�w�d�uD�y��kt��x�$��6�2�(H4u{H�$KIZD�v�J ��$�$�6:0�z�R.���,���q��L�$�$ͣ�#k/FIQ���ê���F�kϭ\'$Ͳ���Cw�Cv�ê�$YE���O�h/>��CV��Zv��5��`yB�G�`5?����7��,ϔ����vQ%UBh��h�k\��BoON �7#y3�vQ�j&1��>����� *R���L� ��=��7� ��up8� L(�3�}�����W��+Z���1M�8�����-(��H�-<��P��F�J�i��?DIE�XN9�i|�߇�p��(��s��@��ec��e '��Z��Z���V���И��s�3_~� >�o\�:�#%�CIL��Y�t� �d�2���9��q굣8 ��ڳV��=4�3m$��U��v� �|W���ɶT�+�ސ�`�+�wS����<�m1��n�sG2ٕ<(�ّ#�����{�� �]���p�O r��Ek��-0Nl�Lj�u4� y=7�n�Q:j�O�(�� �� �2�FF�o0~�f7O����a��n%�8���o�42 w���MnqG�2 y�M��Ck @ H��40�N��ˤ6T+�; ����&���F��������ov�-RŞC涞 +�Yp�����<kP.�R�mͿ*��l#W� �V!�"2� `����FBC� y���c�k��Z ����u=����Ϭ�qI��/H� �ql37��!6DZ�8r� � �jH��UcX3t cn�5�B� )�]��lf���Fb/\N�K} !��*V>� �^�X��m���f�\�DJ&]~5��.��y�X� `� �s@��?F�m{P �z6�����V� � u�O�W�f�_�8-��`� ��į{x��3������t8|f|>$��a-B�V �Ɏ�(��qda�S������v ���Z����6�Q�I���O�0���'��*��z�* μ��-������$ D� ��fp�ƥ���m!{9�+o'L2�� � �lJ֠/^��d ��t� X.�^���6��i/;�ݮh�;q�*H�Y�~bӣMV>m����k)�w%t����� �K1;�x?�͵���I��V� D�Գ���N3 �4����?��ӽ��ZǪ�V����|-�-Y�#L�Z�D#,�� Ժb�� ��>��o��q����� ������ ��Ȳ#�mh1�]�\�dâH��R�*�(�w gJ!�� �b�~ҫ��� �=�:� ���� ��8�� ��u�C˚�^��oy�-�g˗ `��D�� �qظO&���� �� @(Rr��6���yd�|���D����v�Q9�hQ(�w�S�S�#C�&���! � \U<s��xH��"��Ɗ��9� 8�5�A�*��$��ȸ .5��,�T�;��j�>X��=[ ��? ���� =D���.�)�p���� ��o�dJ�eQ�B6�&Uj(�� �X9�6&SH� /#ij�r��-�7P�m�C��x ����E����.�KR{�� ��C�I �G�Ut$�r j%V��+Jo4�V+_x� ? }#��}�fZ�"�_� �'�x�n>[{���� s� �J����&��.>(�\ڸk�� �Z��g����G]�;�_��pr�f�q u���O����S Z��"ij1��̂ �ԃ�>e T��@l�'4�P��π�q .T �M�̻�����}�13��NA7���@ �BϖQ)� �YI�{ >���C-�&} �'�&E�'�\ڳ�R-��X�����Kg�An��(�=��>�Z�JJ 0� ���f�PvJ �V��h櫏�� ѕ��� 0�2�)��\t�k��h�EO(��� ��qK��4����1;��Sya�(@v^�Z�z\aJ���v��L�K��')��N���`�[?NIz��*�A� �R����O��&�v-N�����jh`�R�'X���?10d�^ڲݢU����&�V�^kV�'�I�/1���� ���;]�w� QY~Q��b!Dy����ʶP;2�<��K�ZQ�H�30:N��%�ؐK�`�7��HRh�a�[���Ű��@cS�x��&6KK�Ib��7ovA��`nz�=� i���R&VK���,$���d*|L@ht�jq~5��$�0��X�Q�2ą\#���hʼnu�<<2#��� "�� ,������P�B �v<����t���RL/�&�X3a>I�� �`��w�U��DF2s� �J�3�z���T]�bGDkL &��r����>t�.9�/�I�ʋ|�c�� s��� ��t :'���q%�"e�MI������#{D�`��R6l.� -�,K����qQy]��7� ���b�P�*�j����>>� ��7r��"�Z�C� o&-���qs���h��2�$h������&�J�\ �J����0+Th Y���� �fk �i�%W����̚��'H��Ju3���J����U�"��t��%Z�u sȘ("ۜD�퓻���CwX���q�Ǝ����!L�� �Ũ֫�\�`���Y �e��؏���NIx@�Xc�:�*����Xm�T�QV[lj]pD�� �����"�p� �2�w i��z[2 ��E(�3����� �2�J1�� =�Q<�FL��'�cᥒ�=����X�l*���� �2 �w&�����\� L�su8�NH�����B$�v�� �8�v�p�� A�)3������ �0j�ó} � '){O��d�0繭���XÓ���[��ةn e�v$�\���3�b�^�������ّ�v�M�i���0(�T���PJ�-m��FO=�:��c���l ��t@L o��� �@�@�%�m���^��s*��<��}��"�t ?��@p#�^�|b=� � ; ��QJM ��M8� ��_u �� �hg) 0$Z�I���A5�~g������`@ y���dȰ�>(͛����Ϋ��Pչr��V�mĂ3z�"��_Wl<�ڦ9���D�CǴ\�ժ'��C����a�W`ʴ�S��m5�T�:��/22VQ�¸_y�H���y� Tٸ��H�������R��C���d e-��� �6[ E��_�2����019��쿞�KT�G#�.����i�SZe� Ed�ڠ7��<�� !ܤ�z�,y�&S ��ۢ'a'-S����Fw�ܘ��� _���g��9z�#��S���·Fn��CV���_�6nx8lF(�,!�< �#yb8�z���Dp �5q����1oS���+��i��v�j^6�C���Ms�U�ݪ?r�m�/ y��ը�3> �RWv� �n��c�d���2���8�i�ID(�A�!70�Y��xi�)k`ȯ�p��n3Zغ�^���~���z�F�o0�u�� lҦ:�ls�j��!���yR�j�*�7B�{������%�Ė0���H��2�؆M=�Zs�&mR�#8 P����� ��m9d�f2��V��� �nʔ� �W㏪��`���ec[��_ؤ�Cx+M�Jwߐ�\Eu4�����CP����I���q~��z� ���Ҙ)�N�%�����:�ݚ��@<t�ks�hB5ݙ��j筻$+ �̔f�n������{�:� �rLZ�k �1�U�Wh!�8b]��<��;����խ^������ w� � O x�3�4ֳ0Vpw�4�3� �Ʀ�FF&��@�``ne` Dz��x������4цF(�-`� эB������ �x� Q � x����n�6ǯŧ�Л6h }�fpݴ06;�t����c��Dj$���0E��)�b;�%o ,e��C�tu��ș���p�* �<� �]�l'�� '��q|���L�K�%[QK5+����@�i��� >Og{$�R�J��X>駳|RcܿR���<�(��Bmn$�j�� �m!� h#6�Ed��l�~��[)�� ���� ���4ˠ��3�&���-���+Z��mڽ���r�y������K 5� �x�6�����Zf��Pl�����5�s&:gg�k��Pn@V��vm�*� �A�R���v�P 3��&ƪ{7&�b�2���!%EG� ��ր�9$+p�rs�۱d�9ˡԕ)e���A �71�sL� VB�LhQG{��71&TQjR� &{[zK�ٚet&��Tt�eH�� (m!��\�3լ) wܵ�� � �^�?�\�t�4q�'����gD@~�Z^~��6����:bKD>n�����8��n� �r?&��k&KG��z fB�h�Q� ΦJ1��,�~Ϥ�iqqv˧�F�\Ҝ*;�N�i���?9���&��H��!���v���U��~���Kj���g� ���b2���j%ن��9}�ADi� �[h ��"w�n�8�`.�g7�\�<�.�i�eZ��_q!�g�{���m��{7X.�3�L:��gT ��?-���/g��p'��j���MB� .J��Qk�rh�9B*~O,�R�A@4�@[��Z�'$,o!�$"���+�1�+FY&���h�۠���,���5���EÝ�B��)))�#���I���i����c� ��[z�� �;�ZP�QM@����3����UQ)S�Di�Z����k��gZ�Wl�^�\i�L@ �֢���0%�C]^�j���q��|#i��bㆷ�/�g~���~�kN/�x/ z4�e��{VB[�ۀ�n�)�۟&�@��[�di :����̀2�C�ʶ���c����:����Lj�&+�އ��;�LVt�p� ��#�aH�C�� ���ø�dŧ� ��?��LV�K�} �3Ҟ� 5��]� �׆@�Ɋ��}��@wp�z�ǻ��&go���h��4� v�� ���X=� �A\g���t��pC �:�w�0�����%���d�M l�0����J B��t8�:����vB�-��� � x������ � � � x������ � � � x������ � � m x������ � � � x������ � � [ x������ � � � x������ � � n x������ � � a x������ � � � x������ � � K x������ � � U x������ � � c x������ � � G x����J�`��'O�En&Vs�4�DM�*Z�M֒fm�ت����A� ����=�������M, YT��P$�̈˫���.-'/��p ���!�]E5jǖ-��/p��� q�#�ʚt��ʉ�<A�j<<��h �"�o?��]��W&?��J����5�K�B4F�o��*��S6~'�V���=�|�^`gΖk��h�,s���F7�ts�oj�,ݕ��(e@�C��R8��S6B�;g�q�9�a�4wu� T x������ � � N x������ � � � x������ � � � x������ � �
SQL
Server:
MariaDB 11.4
MariaDB 11.5
MariaDB 10
MariaDB 10 Sakila (ReadOnly)
MySQL 5.7
MySQL 5.7 Sakila (ReadOnly)
MySQL 8.0
MySQL 8.0 Sakila (ReadOnly)
SQLite 3
PostgreSQL 10 Bookings (ReadOnly)
PostgreSQL 11
PostgreSQL 12
PostgreSQL 13
PostgreSQL 14
PostgreSQL 15
MS SQL Server 2017
MS SQL Server 2019
MS SQL Server 2022
MS SQL Server 2022 AdventureWorks (ReadOnly)
Firebird 4.0
Firebird 4.0 (Employee)
Oracle Database 19c (HR)
Oracle Database 21c
Oracle Database 23c Free
SOQOL
Version
ER Diagram
Preserve result
Stuck with a problem?
Got Error?
Ask ChatGPT!
Result:
Copy
Clear