@@ -33,6 +33,18 @@ enum TypebotSessionStatus {
3333 paused
3434}
3535
36+ enum TriggerType {
37+ all
38+ keyword
39+ }
40+
41+ enum TriggerOperator {
42+ contains
43+ equals
44+ startsWith
45+ endsWith
46+ }
47+
3648model Instance {
3749 id String @id @default (cuid () )
3850 name String @unique @db.VarChar (255 )
@@ -42,6 +54,7 @@ model Instance {
4254 integration String ? @db.VarChar (100 )
4355 number String ? @db.VarChar (100 )
4456 token String ? @unique @db.VarChar (255 )
57+ clientName String ? @db.VarChar (100 )
4558 createdAt DateTime ? @default (now () ) @db.Timestamp
4659 updatedAt DateTime ? @updatedAt @db.Timestamp
4760 Chat Chat []
@@ -55,22 +68,23 @@ model Instance {
5568 Rabbitmq Rabbitmq ?
5669 Sqs Sqs ?
5770 Websocket Websocket ?
58- Typebot Typebot ?
71+ Typebot Typebot []
5972 Session Session ?
6073 MessageUpdate MessageUpdate []
6174 TypebotSession TypebotSession []
75+ TypebotSetting TypebotSetting ?
6276}
6377
6478model Session {
65- id Int @id @unique @ default (autoincrement () )
79+ id String @id @default (cuid () )
6680 sessionId String @unique
6781 creds String ? @db.Text
6882 createdAt DateTime @default (now () ) @db.Timestamp
6983 Instance Instance @relation (fields : [sessionId ] , references : [id ] , onDelete : Cascade )
7084}
7185
7286model Chat {
73- id Int @id @default (autoincrement () )
87+ id String @id @default (cuid () )
7488 remoteJid String @db.VarChar (100 )
7589 labels Json ? @db.JsonB
7690 createdAt DateTime ? @default (now () ) @db.Timestamp
@@ -80,7 +94,7 @@ model Chat {
8094}
8195
8296model Contact {
83- id Int @id @default (autoincrement () )
97+ id String @id @default (cuid () )
8498 remoteJid String @db.VarChar (100 )
8599 pushName String ? @db.VarChar (100 )
86100 profilePicUrl String ? @db.VarChar (500 )
@@ -91,7 +105,7 @@ model Contact {
91105}
92106
93107model Message {
94- id Int @id @default (autoincrement () )
108+ id String @id @default (cuid () )
95109 key Json @db.JsonB
96110 pushName String ? @db.VarChar (100 )
97111 participant String ? @db.VarChar (100 )
@@ -107,27 +121,27 @@ model Message {
107121 chatwootIsRead Boolean ? @db.Boolean
108122 Instance Instance @relation (fields : [instanceId ] , references : [id ] , onDelete : Cascade )
109123 instanceId String
110- typebotSessionId Int ?
124+ typebotSessionId String ?
111125 MessageUpdate MessageUpdate []
112126 TypebotSession TypebotSession ? @relation (fields : [typebotSessionId ] , references : [id ] )
113127}
114128
115129model MessageUpdate {
116- id Int @id @default (autoincrement () )
130+ id String @id @default (cuid () )
117131 keyId String @db.VarChar (100 )
118132 remoteJid String @db.VarChar (100 )
119133 fromMe Boolean @db.Boolean
120134 participant String ? @db.VarChar (100 )
121135 pollUpdates Json ? @db.JsonB
122136 status String @db.VarChar (30 )
123137 Message Message @relation (fields : [messageId ] , references : [id ] , onDelete : Cascade )
124- messageId Int
138+ messageId String
125139 Instance Instance @relation (fields : [instanceId ] , references : [id ] , onDelete : Cascade )
126140 instanceId String
127141}
128142
129143model Webhook {
130- id Int @id @default (autoincrement () )
144+ id String @id @default (cuid () )
131145 url String @db.VarChar (500 )
132146 enabled Boolean ? @default (true ) @db.Boolean
133147 events Json ? @db.JsonB
@@ -140,7 +154,7 @@ model Webhook {
140154}
141155
142156model Chatwoot {
143- id Int @id @default (autoincrement () )
157+ id String @id @default (cuid () )
144158 enabled Boolean ? @default (true ) @db.Boolean
145159 accountId String ? @db.VarChar (100 )
146160 token String ? @db.VarChar (100 )
@@ -162,7 +176,7 @@ model Chatwoot {
162176}
163177
164178model Label {
165- id Int @id @default (autoincrement () )
179+ id String @id @default (cuid () )
166180 labelId String ? @unique @db.VarChar (100 )
167181 name String @db.VarChar (100 )
168182 color String @db.VarChar (100 )
@@ -174,7 +188,7 @@ model Label {
174188}
175189
176190model Proxy {
177- id Int @id @default (autoincrement () )
191+ id String @id @default (cuid () )
178192 enabled Boolean @default (false ) @db.Boolean
179193 host String @db.VarChar (100 )
180194 port String @db.VarChar (100 )
@@ -188,7 +202,7 @@ model Proxy {
188202}
189203
190204model Setting {
191- id Int @id @default (autoincrement () )
205+ id String @id @default (cuid () )
192206 rejectCall Boolean @default (false ) @db.Boolean
193207 msgCall String ? @db.VarChar (100 )
194208 groupsIgnore Boolean @default (false ) @db.Boolean
@@ -203,7 +217,7 @@ model Setting {
203217}
204218
205219model Rabbitmq {
206- id Int @id @default (autoincrement () )
220+ id String @id @default (cuid () )
207221 enabled Boolean @default (false ) @db.Boolean
208222 events Json @db.JsonB
209223 createdAt DateTime ? @default (now () ) @db.Timestamp
@@ -213,7 +227,7 @@ model Rabbitmq {
213227}
214228
215229model Sqs {
216- id Int @id @default (autoincrement () )
230+ id String @id @default (cuid () )
217231 enabled Boolean @default (false ) @db.Boolean
218232 events Json @db.JsonB
219233 createdAt DateTime ? @default (now () ) @db.Timestamp
@@ -223,7 +237,7 @@ model Sqs {
223237}
224238
225239model Websocket {
226- id Int @id @default (autoincrement () )
240+ id String @id @default (cuid () )
227241 enabled Boolean @default (false ) @db.Boolean
228242 events Json @db.JsonB
229243 createdAt DateTime ? @default (now () ) @db.Timestamp
@@ -233,24 +247,29 @@ model Websocket {
233247}
234248
235249model Typebot {
236- id Int @id @default (autoincrement () )
250+ id String @id @default (cuid () )
237251 enabled Boolean @default (true ) @db.Boolean
238252 url String @db.VarChar (500 )
239253 typebot String @db.VarChar (100 )
240- expire Int @default (0 ) @db.Integer
254+ expire Int ? @default (0 ) @db.Integer
241255 keywordFinish String ? @db.VarChar (100 )
242256 delayMessage Int ? @db.Integer
243257 unknownMessage String ? @db.VarChar (100 )
244- listeningFromMe Boolean @default (false ) @db.Boolean
258+ listeningFromMe Boolean ? @default (false ) @db.Boolean
259+ stopBotFromMe Boolean ? @default (false ) @db.Boolean
260+ keepOpen Boolean ? @default (false ) @db.Boolean
245261 createdAt DateTime ? @default (now () ) @db.Timestamp
246262 updatedAt DateTime ? @updatedAt @db.Timestamp
263+ triggerType TriggerType ?
264+ triggerOperator TriggerOperator ?
265+ triggerValue String ?
247266 Instance Instance @relation (fields : [instanceId ] , references : [id ] , onDelete : Cascade )
248- instanceId String @unique
267+ instanceId String
249268 sessions TypebotSession []
250269}
251270
252271model TypebotSession {
253- id Int @id @default (autoincrement () )
272+ id String @id @default (cuid () )
254273 remoteJid String @db.VarChar (100 )
255274 pushName String ? @db.VarChar (100 )
256275 sessionId String @db.VarChar (100 )
@@ -260,8 +279,23 @@ model TypebotSession {
260279 createdAt DateTime ? @default (now () ) @db.Timestamp
261280 updatedAt DateTime @updatedAt @db.Timestamp
262281 Typebot Typebot @relation (fields : [typebotId ] , references : [id ] , onDelete : Cascade )
263- typebotId Int
282+ typebotId String
264283 Message Message []
265284 Instance Instance @relation (fields : [instanceId ] , references : [id ] , onDelete : Cascade )
266285 instanceId String
267286}
287+
288+ model TypebotSetting {
289+ id String @id @default (cuid () )
290+ expire Int ? @default (0 ) @db.Integer
291+ keywordFinish String ? @db.VarChar (100 )
292+ delayMessage Int ? @db.Integer
293+ unknownMessage String ? @db.VarChar (100 )
294+ listeningFromMe Boolean ? @default (false ) @db.Boolean
295+ stopBotFromMe Boolean ? @default (false ) @db.Boolean
296+ keepOpen Boolean ? @default (false ) @db.Boolean
297+ createdAt DateTime ? @default (now () ) @db.Timestamp
298+ updatedAt DateTime @updatedAt @db.Timestamp
299+ Instance Instance @relation (fields : [instanceId ] , references : [id ] , onDelete : Cascade )
300+ instanceId String @unique
301+ }
0 commit comments