openAgent

1{
2  "version": "7",
3  "dialect": "sqlite",
4  "id": "f14a9b18-8207-487e-a3d3-227e629ba9ad",
5  "prevIds": ["169a0f0f-d58f-479f-b024-fa1c7b9a09db"],
6  "ddl": [
7    {
8      "name": "workspace",
9      "entityType": "tables"
10    },
11    {
12      "name": "data_migration",
13      "entityType": "tables"
14    },
15    {
16      "name": "account_state",
17      "entityType": "tables"
18    },
19    {
20      "name": "account",
21      "entityType": "tables"
22    },
23    {
24      "name": "control_account",
25      "entityType": "tables"
26    },
27    {
28      "name": "credential",
29      "entityType": "tables"
30    },
31    {
32      "name": "event_sequence",
33      "entityType": "tables"
34    },
35    {
36      "name": "event",
37      "entityType": "tables"
38    },
39    {
40      "name": "permission",
41      "entityType": "tables"
42    },
43    {
44      "name": "project_directory",
45      "entityType": "tables"
46    },
47    {
48      "name": "project",
49      "entityType": "tables"
50    },
51    {
52      "name": "message",
53      "entityType": "tables"
54    },
55    {
56      "name": "part",
57      "entityType": "tables"
58    },
59    {
60      "name": "session_context_epoch",
61      "entityType": "tables"
62    },
63    {
64      "name": "session_input",
65      "entityType": "tables"
66    },
67    {
68      "name": "session_message",
69      "entityType": "tables"
70    },
71    {
72      "name": "session",
73      "entityType": "tables"
74    },
75    {
76      "name": "todo",
77      "entityType": "tables"
78    },
79    {
80      "name": "session_share",
81      "entityType": "tables"
82    },
83    {
84      "type": "text",
85      "notNull": false,
86      "autoincrement": false,
87      "default": null,
88      "generated": null,
89      "name": "id",
90      "entityType": "columns",
91      "table": "workspace"
92    },
93    {
94      "type": "text",
95      "notNull": true,
96      "autoincrement": false,
97      "default": null,
98      "generated": null,
99      "name": "type",
100      "entityType": "columns",
101      "table": "workspace"
102    },
103    {
104      "type": "text",
105      "notNull": true,
106      "autoincrement": false,
107      "default": "''",
108      "generated": null,
109      "name": "name",
110      "entityType": "columns",
111      "table": "workspace"
112    },
113    {
114      "type": "text",
115      "notNull": false,
116      "autoincrement": false,
117      "default": null,
118      "generated": null,
119      "name": "branch",
120      "entityType": "columns",
121      "table": "workspace"
122    },
123    {
124      "type": "text",
125      "notNull": false,
126      "autoincrement": false,
127      "default": null,
128      "generated": null,
129      "name": "directory",
130      "entityType": "columns",
131      "table": "workspace"
132    },
133    {
134      "type": "text",
135      "notNull": false,
136      "autoincrement": false,
137      "default": null,
138      "generated": null,
139      "name": "extra",
140      "entityType": "columns",
141      "table": "workspace"
142    },
143    {
144      "type": "text",
145      "notNull": true,
146      "autoincrement": false,
147      "default": null,
148      "generated": null,
149      "name": "project_id",
150      "entityType": "columns",
151      "table": "workspace"
152    },
153    {
154      "type": "integer",
155      "notNull": true,
156      "autoincrement": false,
157      "default": null,
158      "generated": null,
159      "name": "time_used",
160      "entityType": "columns",
161      "table": "workspace"
162    },
163    {
164      "type": "text",
165      "notNull": false,
166      "autoincrement": false,
167      "default": null,
168      "generated": null,
169      "name": "name",
170      "entityType": "columns",
171      "table": "data_migration"
172    },
173    {
174      "type": "integer",
175      "notNull": true,
176      "autoincrement": false,
177      "default": null,
178      "generated": null,
179      "name": "time_completed",
180      "entityType": "columns",
181      "table": "data_migration"
182    },
183    {
184      "type": "integer",
185      "notNull": false,
186      "autoincrement": false,
187      "default": null,
188      "generated": null,
189      "name": "id",
190      "entityType": "columns",
191      "table": "account_state"
192    },
193    {
194      "type": "text",
195      "notNull": false,
196      "autoincrement": false,
197      "default": null,
198      "generated": null,
199      "name": "active_account_id",
200      "entityType": "columns",
201      "table": "account_state"
202    },
203    {
204      "type": "text",
205      "notNull": false,
206      "autoincrement": false,
207      "default": null,
208      "generated": null,
209      "name": "active_org_id",
210      "entityType": "columns",
211      "table": "account_state"
212    },
213    {
214      "type": "text",
215      "notNull": false,
216      "autoincrement": false,
217      "default": null,
218      "generated": null,
219      "name": "id",
220      "entityType": "columns",
221      "table": "account"
222    },
223    {
224      "type": "text",
225      "notNull": true,
226      "autoincrement": false,
227      "default": null,
228      "generated": null,
229      "name": "email",
230      "entityType": "columns",
231      "table": "account"
232    },
233    {
234      "type": "text",
235      "notNull": true,
236      "autoincrement": false,
237      "default": null,
238      "generated": null,
239      "name": "url",
240      "entityType": "columns",
241      "table": "account"
242    },
243    {
244      "type": "text",
245      "notNull": true,
246      "autoincrement": false,
247      "default": null,
248      "generated": null,
249      "name": "access_token",
250      "entityType": "columns",
251      "table": "account"
252    },
253    {
254      "type": "text",
255      "notNull": true,
256      "autoincrement": false,
257      "default": null,
258      "generated": null,
259      "name": "refresh_token",
260      "entityType": "columns",
261      "table": "account"
262    },
263    {
264      "type": "integer",
265      "notNull": false,
266      "autoincrement": false,
267      "default": null,
268      "generated": null,
269      "name": "token_expiry",
270      "entityType": "columns",
271      "table": "account"
272    },
273    {
274      "type": "integer",
275      "notNull": true,
276      "autoincrement": false,
277      "default": null,
278      "generated": null,
279      "name": "time_created",
280      "entityType": "columns",
281      "table": "account"
282    },
283    {
284      "type": "integer",
285      "notNull": true,
286      "autoincrement": false,
287      "default": null,
288      "generated": null,
289      "name": "time_updated",
290      "entityType": "columns",
291      "table": "account"
292    },
293    {
294      "type": "text",
295      "notNull": true,
296      "autoincrement": false,
297      "default": null,
298      "generated": null,
299      "name": "email",
300      "entityType": "columns",
301      "table": "control_account"
302    },
303    {
304      "type": "text",
305      "notNull": true,
306      "autoincrement": false,
307      "default": null,
308      "generated": null,
309      "name": "url",
310      "entityType": "columns",
311      "table": "control_account"
312    },
313    {
314      "type": "text",
315      "notNull": true,
316      "autoincrement": false,
317      "default": null,
318      "generated": null,
319      "name": "access_token",
320      "entityType": "columns",
321      "table": "control_account"
322    },
323    {
324      "type": "text",
325      "notNull": true,
326      "autoincrement": false,
327      "default": null,
328      "generated": null,
329      "name": "refresh_token",
330      "entityType": "columns",
331      "table": "control_account"
332    },
333    {
334      "type": "integer",
335      "notNull": false,
336      "autoincrement": false,
337      "default": null,
338      "generated": null,
339      "name": "token_expiry",
340      "entityType": "columns",
341      "table": "control_account"
342    },
343    {
344      "type": "integer",
345      "notNull": true,
346      "autoincrement": false,
347      "default": null,
348      "generated": null,
349      "name": "active",
350      "entityType": "columns",
351      "table": "control_account"
352    },
353    {
354      "type": "integer",
355      "notNull": true,
356      "autoincrement": false,
357      "default": null,
358      "generated": null,
359      "name": "time_created",
360      "entityType": "columns",
361      "table": "control_account"
362    },
363    {
364      "type": "integer",
365      "notNull": true,
366      "autoincrement": false,
367      "default": null,
368      "generated": null,
369      "name": "time_updated",
370      "entityType": "columns",
371      "table": "control_account"
372    },
373    {
374      "type": "text",
375      "notNull": false,
376      "autoincrement": false,
377      "default": null,
378      "generated": null,
379      "name": "id",
380      "entityType": "columns",
381      "table": "credential"
382    },
383    {
384      "type": "text",
385      "notNull": false,
386      "autoincrement": false,
387      "default": null,
388      "generated": null,
389      "name": "integration_id",
390      "entityType": "columns",
391      "table": "credential"
392    },
393    {
394      "type": "text",
395      "notNull": true,
396      "autoincrement": false,
397      "default": null,
398      "generated": null,
399      "name": "label",
400      "entityType": "columns",
401      "table": "credential"
402    },
403    {
404      "type": "text",
405      "notNull": true,
406      "autoincrement": false,
407      "default": null,
408      "generated": null,
409      "name": "value",
410      "entityType": "columns",
411      "table": "credential"
412    },
413    {
414      "type": "text",
415      "notNull": false,
416      "autoincrement": false,
417      "default": null,
418      "generated": null,
419      "name": "connector_id",
420      "entityType": "columns",
421      "table": "credential"
422    },
423    {
424      "type": "text",
425      "notNull": false,
426      "autoincrement": false,
427      "default": null,
428      "generated": null,
429      "name": "method_id",
430      "entityType": "columns",
431      "table": "credential"
432    },
433    {
434      "type": "integer",
435      "notNull": false,
436      "autoincrement": false,
437      "default": null,
438      "generated": null,
439      "name": "active",
440      "entityType": "columns",
441      "table": "credential"
442    },
443    {
444      "type": "integer",
445      "notNull": true,
446      "autoincrement": false,
447      "default": null,
448      "generated": null,
449      "name": "time_created",
450      "entityType": "columns",
451      "table": "credential"
452    },
453    {
454      "type": "integer",
455      "notNull": true,
456      "autoincrement": false,
457      "default": null,
458      "generated": null,
459      "name": "time_updated",
460      "entityType": "columns",
461      "table": "credential"
462    },
463    {
464      "type": "text",
465      "notNull": false,
466      "autoincrement": false,
467      "default": null,
468      "generated": null,
469      "name": "aggregate_id",
470      "entityType": "columns",
471      "table": "event_sequence"
472    },
473    {
474      "type": "integer",
475      "notNull": true,
476      "autoincrement": false,
477      "default": null,
478      "generated": null,
479      "name": "seq",
480      "entityType": "columns",
481      "table": "event_sequence"
482    },
483    {
484      "type": "text",
485      "notNull": false,
486      "autoincrement": false,
487      "default": null,
488      "generated": null,
489      "name": "owner_id",
490      "entityType": "columns",
491      "table": "event_sequence"
492    },
493    {
494      "type": "text",
495      "notNull": false,
496      "autoincrement": false,
497      "default": null,
498      "generated": null,
499      "name": "id",
500      "entityType": "columns",
501      "table": "event"
502    },
503    {
504      "type": "text",
505      "notNull": true,
506      "autoincrement": false,
507      "default": null,
508      "generated": null,
509      "name": "aggregate_id",
510      "entityType": "columns",
511      "table": "event"
512    },
513    {
514      "type": "integer",
515      "notNull": true,
516      "autoincrement": false,
517      "default": null,
518      "generated": null,
519      "name": "seq",
520      "entityType": "columns",
521      "table": "event"
522    },
523    {
524      "type": "text",
525      "notNull": true,
526      "autoincrement": false,
527      "default": null,
528      "generated": null,
529      "name": "type",
530      "entityType": "columns",
531      "table": "event"
532    },
533    {
534      "type": "text",
535      "notNull": true,
536      "autoincrement": false,
537      "default": null,
538      "generated": null,
539      "name": "data",
540      "entityType": "columns",
541      "table": "event"
542    },
543    {
544      "type": "text",
545      "notNull": false,
546      "autoincrement": false,
547      "default": null,
548      "generated": null,
549      "name": "id",
550      "entityType": "columns",
551      "table": "permission"
552    },
553    {
554      "type": "text",
555      "notNull": true,
556      "autoincrement": false,
557      "default": null,
558      "generated": null,
559      "name": "project_id",
560      "entityType": "columns",
561      "table": "permission"
562    },
563    {
564      "type": "text",
565      "notNull": true,
566      "autoincrement": false,
567      "default": null,
568      "generated": null,
569      "name": "action",
570      "entityType": "columns",
571      "table": "permission"
572    },
573    {
574      "type": "text",
575      "notNull": true,
576      "autoincrement": false,
577      "default": null,
578      "generated": null,
579      "name": "resource",
580      "entityType": "columns",
581      "table": "permission"
582    },
583    {
584      "type": "integer",
585      "notNull": true,
586      "autoincrement": false,
587      "default": null,
588      "generated": null,
589      "name": "time_created",
590      "entityType": "columns",
591      "table": "permission"
592    },
593    {
594      "type": "integer",
595      "notNull": true,
596      "autoincrement": false,
597      "default": null,
598      "generated": null,
599      "name": "time_updated",
600      "entityType": "columns",
601      "table": "permission"
602    },
603    {
604      "type": "text",
605      "notNull": true,
606      "autoincrement": false,
607      "default": null,
608      "generated": null,
609      "name": "project_id",
610      "entityType": "columns",
611      "table": "project_directory"
612    },
613    {
614      "type": "text",
615      "notNull": true,
616      "autoincrement": false,
617      "default": null,
618      "generated": null,
619      "name": "directory",
620      "entityType": "columns",
621      "table": "project_directory"
622    },
623    {
624      "type": "text",
625      "notNull": false,
626      "autoincrement": false,
627      "default": null,
628      "generated": null,
629      "name": "type",
630      "entityType": "columns",
631      "table": "project_directory"
632    },
633    {
634      "type": "text",
635      "notNull": false,
636      "autoincrement": false,
637      "default": null,
638      "generated": null,
639      "name": "strategy",
640      "entityType": "columns",
641      "table": "project_directory"
642    },
643    {
644      "type": "integer",
645      "notNull": true,
646      "autoincrement": false,
647      "default": null,
648      "generated": null,
649      "name": "time_created",
650      "entityType": "columns",
651      "table": "project_directory"
652    },
653    {
654      "type": "text",
655      "notNull": false,
656      "autoincrement": false,
657      "default": null,
658      "generated": null,
659      "name": "id",
660      "entityType": "columns",
661      "table": "project"
662    },
663    {
664      "type": "text",
665      "notNull": true,
666      "autoincrement": false,
667      "default": null,
668      "generated": null,
669      "name": "worktree",
670      "entityType": "columns",
671      "table": "project"
672    },
673    {
674      "type": "text",
675      "notNull": false,
676      "autoincrement": false,
677      "default": null,
678      "generated": null,
679      "name": "vcs",
680      "entityType": "columns",
681      "table": "project"
682    },
683    {
684      "type": "text",
685      "notNull": false,
686      "autoincrement": false,
687      "default": null,
688      "generated": null,
689      "name": "name",
690      "entityType": "columns",
691      "table": "project"
692    },
693    {
694      "type": "text",
695      "notNull": false,
696      "autoincrement": false,
697      "default": null,
698      "generated": null,
699      "name": "icon_url",
700      "entityType": "columns",
701      "table": "project"
702    },
703    {
704      "type": "text",
705      "notNull": false,
706      "autoincrement": false,
707      "default": null,
708      "generated": null,
709      "name": "icon_url_override",
710      "entityType": "columns",
711      "table": "project"
712    },
713    {
714      "type": "text",
715      "notNull": false,
716      "autoincrement": false,
717      "default": null,
718      "generated": null,
719      "name": "icon_color",
720      "entityType": "columns",
721      "table": "project"
722    },
723    {
724      "type": "integer",
725      "notNull": true,
726      "autoincrement": false,
727      "default": null,
728      "generated": null,
729      "name": "time_created",
730      "entityType": "columns",
731      "table": "project"
732    },
733    {
734      "type": "integer",
735      "notNull": true,
736      "autoincrement": false,
737      "default": null,
738      "generated": null,
739      "name": "time_updated",
740      "entityType": "columns",
741      "table": "project"
742    },
743    {
744      "type": "integer",
745      "notNull": false,
746      "autoincrement": false,
747      "default": null,
748      "generated": null,
749      "name": "time_initialized",
750      "entityType": "columns",
751      "table": "project"
752    },
753    {
754      "type": "text",
755      "notNull": true,
756      "autoincrement": false,
757      "default": null,
758      "generated": null,
759      "name": "sandboxes",
760      "entityType": "columns",
761      "table": "project"
762    },
763    {
764      "type": "text",
765      "notNull": false,
766      "autoincrement": false,
767      "default": null,
768      "generated": null,
769      "name": "commands",
770      "entityType": "columns",
771      "table": "project"
772    },
773    {
774      "type": "text",
775      "notNull": false,
776      "autoincrement": false,
777      "default": null,
778      "generated": null,
779      "name": "id",
780      "entityType": "columns",
781      "table": "message"
782    },
783    {
784      "type": "text",
785      "notNull": true,
786      "autoincrement": false,
787      "default": null,
788      "generated": null,
789      "name": "session_id",
790      "entityType": "columns",
791      "table": "message"
792    },
793    {
794      "type": "integer",
795      "notNull": true,
796      "autoincrement": false,
797      "default": null,
798      "generated": null,
799      "name": "time_created",
800      "entityType": "columns",
801      "table": "message"
802    },
803    {
804      "type": "integer",
805      "notNull": true,
806      "autoincrement": false,
807      "default": null,
808      "generated": null,
809      "name": "time_updated",
810      "entityType": "columns",
811      "table": "message"
812    },
813    {
814      "type": "text",
815      "notNull": true,
816      "autoincrement": false,
817      "default": null,
818      "generated": null,
819      "name": "data",
820      "entityType": "columns",
821      "table": "message"
822    },
823    {
824      "type": "text",
825      "notNull": false,
826      "autoincrement": false,
827      "default": null,
828      "generated": null,
829      "name": "id",
830      "entityType": "columns",
831      "table": "part"
832    },
833    {
834      "type": "text",
835      "notNull": true,
836      "autoincrement": false,
837      "default": null,
838      "generated": null,
839      "name": "message_id",
840      "entityType": "columns",
841      "table": "part"
842    },
843    {
844      "type": "text",
845      "notNull": true,
846      "autoincrement": false,
847      "default": null,
848      "generated": null,
849      "name": "session_id",
850      "entityType": "columns",
851      "table": "part"
852    },
853    {
854      "type": "integer",
855      "notNull": true,
856      "autoincrement": false,
857      "default": null,
858      "generated": null,
859      "name": "time_created",
860      "entityType": "columns",
861      "table": "part"
862    },
863    {
864      "type": "integer",
865      "notNull": true,
866      "autoincrement": false,
867      "default": null,
868      "generated": null,
869      "name": "time_updated",
870      "entityType": "columns",
871      "table": "part"
872    },
873    {
874      "type": "text",
875      "notNull": true,
876      "autoincrement": false,
877      "default": null,
878      "generated": null,
879      "name": "data",
880      "entityType": "columns",
881      "table": "part"
882    },
883    {
884      "type": "text",
885      "notNull": false,
886      "autoincrement": false,
887      "default": null,
888      "generated": null,
889      "name": "session_id",
890      "entityType": "columns",
891      "table": "session_context_epoch"
892    },
893    {
894      "type": "text",
895      "notNull": true,
896      "autoincrement": false,
897      "default": null,
898      "generated": null,
899      "name": "baseline",
900      "entityType": "columns",
901      "table": "session_context_epoch"
902    },
903    {
904      "type": "text",
905      "notNull": true,
906      "autoincrement": false,
907      "default": null,
908      "generated": null,
909      "name": "snapshot",
910      "entityType": "columns",
911      "table": "session_context_epoch"
912    },
913    {
914      "type": "integer",
915      "notNull": true,
916      "autoincrement": false,
917      "default": null,
918      "generated": null,
919      "name": "baseline_seq",
920      "entityType": "columns",
921      "table": "session_context_epoch"
922    },
923    {
924      "type": "text",
925      "notNull": false,
926      "autoincrement": false,
927      "default": null,
928      "generated": null,
929      "name": "id",
930      "entityType": "columns",
931      "table": "session_input"
932    },
933    {
934      "type": "text",
935      "notNull": true,
936      "autoincrement": false,
937      "default": null,
938      "generated": null,
939      "name": "session_id",
940      "entityType": "columns",
941      "table": "session_input"
942    },
943    {
944      "type": "text",
945      "notNull": true,
946      "autoincrement": false,
947      "default": null,
948      "generated": null,
949      "name": "prompt",
950      "entityType": "columns",
951      "table": "session_input"
952    },
953    {
954      "type": "text",
955      "notNull": true,
956      "autoincrement": false,
957      "default": null,
958      "generated": null,
959      "name": "delivery",
960      "entityType": "columns",
961      "table": "session_input"
962    },
963    {
964      "type": "integer",
965      "notNull": true,
966      "autoincrement": false,
967      "default": null,
968      "generated": null,
969      "name": "admitted_seq",
970      "entityType": "columns",
971      "table": "session_input"
972    },
973    {
974      "type": "integer",
975      "notNull": false,
976      "autoincrement": false,
977      "default": null,
978      "generated": null,
979      "name": "promoted_seq",
980      "entityType": "columns",
981      "table": "session_input"
982    },
983    {
984      "type": "integer",
985      "notNull": true,
986      "autoincrement": false,
987      "default": null,
988      "generated": null,
989      "name": "time_created",
990      "entityType": "columns",
991      "table": "session_input"
992    },
993    {
994      "type": "text",
995      "notNull": false,
996      "autoincrement": false,
997      "default": null,
998      "generated": null,
999      "name": "id",
1000      "entityType": "columns",
1001      "table": "session_message"
1002    },
1003    {
1004      "type": "text",
1005      "notNull": true,
1006      "autoincrement": false,
1007      "default": null,
1008      "generated": null,
1009      "name": "session_id",
1010      "entityType": "columns",
1011      "table": "session_message"
1012    },
1013    {
1014      "type": "text",
1015      "notNull": true,
1016      "autoincrement": false,
1017      "default": null,
1018      "generated": null,
1019      "name": "type",
1020      "entityType": "columns",
1021      "table": "session_message"
1022    },
1023    {
1024      "type": "integer",
1025      "notNull": true,
1026      "autoincrement": false,
1027      "default": null,
1028      "generated": null,
1029      "name": "seq",
1030      "entityType": "columns",
1031      "table": "session_message"
1032    },
1033    {
1034      "type": "integer",
1035      "notNull": true,
1036      "autoincrement": false,
1037      "default": null,
1038      "generated": null,
1039      "name": "time_created",
1040      "entityType": "columns",
1041      "table": "session_message"
1042    },
1043    {
1044      "type": "integer",
1045      "notNull": true,
1046      "autoincrement": false,
1047      "default": null,
1048      "generated": null,
1049      "name": "time_updated",
1050      "entityType": "columns",
1051      "table": "session_message"
1052    },
1053    {
1054      "type": "text",
1055      "notNull": true,
1056      "autoincrement": false,
1057      "default": null,
1058      "generated": null,
1059      "name": "data",
1060      "entityType": "columns",
1061      "table": "session_message"
1062    },
1063    {
1064      "type": "text",
1065      "notNull": false,
1066      "autoincrement": false,
1067      "default": null,
1068      "generated": null,
1069      "name": "id",
1070      "entityType": "columns",
1071      "table": "session"
1072    },
1073    {
1074      "type": "text",
1075      "notNull": true,
1076      "autoincrement": false,
1077      "default": null,
1078      "generated": null,
1079      "name": "project_id",
1080      "entityType": "columns",
1081      "table": "session"
1082    },
1083    {
1084      "type": "text",
1085      "notNull": false,
1086      "autoincrement": false,
1087      "default": null,
1088      "generated": null,
1089      "name": "workspace_id",
1090      "entityType": "columns",
1091      "table": "session"
1092    },
1093    {
1094      "type": "text",
1095      "notNull": false,
1096      "autoincrement": false,
1097      "default": null,
1098      "generated": null,
1099      "name": "parent_id",
1100      "entityType": "columns",
1101      "table": "session"
1102    },
1103    {
1104      "type": "text",
1105      "notNull": true,
1106      "autoincrement": false,
1107      "default": null,
1108      "generated": null,
1109      "name": "slug",
1110      "entityType": "columns",
1111      "table": "session"
1112    },
1113    {
1114      "type": "text",
1115      "notNull": true,
1116      "autoincrement": false,
1117      "default": null,
1118      "generated": null,
1119      "name": "directory",
1120      "entityType": "columns",
1121      "table": "session"
1122    },
1123    {
1124      "type": "text",
1125      "notNull": false,
1126      "autoincrement": false,
1127      "default": null,
1128      "generated": null,
1129      "name": "path",
1130      "entityType": "columns",
1131      "table": "session"
1132    },
1133    {
1134      "type": "text",
1135      "notNull": true,
1136      "autoincrement": false,
1137      "default": null,
1138      "generated": null,
1139      "name": "title",
1140      "entityType": "columns",
1141      "table": "session"
1142    },
1143    {
1144      "type": "text",
1145      "notNull": true,
1146      "autoincrement": false,
1147      "default": null,
1148      "generated": null,
1149      "name": "version",
1150      "entityType": "columns",
1151      "table": "session"
1152    },
1153    {
1154      "type": "text",
1155      "notNull": false,
1156      "autoincrement": false,
1157      "default": null,
1158      "generated": null,
1159      "name": "share_url",
1160      "entityType": "columns",
1161      "table": "session"
1162    },
1163    {
1164      "type": "integer",
1165      "notNull": false,
1166      "autoincrement": false,
1167      "default": null,
1168      "generated": null,
1169      "name": "summary_additions",
1170      "entityType": "columns",
1171      "table": "session"
1172    },
1173    {
1174      "type": "integer",
1175      "notNull": false,
1176      "autoincrement": false,
1177      "default": null,
1178      "generated": null,
1179      "name": "summary_deletions",
1180      "entityType": "columns",
1181      "table": "session"
1182    },
1183    {
1184      "type": "integer",
1185      "notNull": false,
1186      "autoincrement": false,
1187      "default": null,
1188      "generated": null,
1189      "name": "summary_files",
1190      "entityType": "columns",
1191      "table": "session"
1192    },
1193    {
1194      "type": "text",
1195      "notNull": false,
1196      "autoincrement": false,
1197      "default": null,
1198      "generated": null,
1199      "name": "summary_diffs",
1200      "entityType": "columns",
1201      "table": "session"
1202    },
1203    {
1204      "type": "text",
1205      "notNull": false,
1206      "autoincrement": false,
1207      "default": null,
1208      "generated": null,
1209      "name": "metadata",
1210      "entityType": "columns",
1211      "table": "session"
1212    },
1213    {
1214      "type": "real",
1215      "notNull": true,
1216      "autoincrement": false,
1217      "default": "0",
1218      "generated": null,
1219      "name": "cost",
1220      "entityType": "columns",
1221      "table": "session"
1222    },
1223    {
1224      "type": "integer",
1225      "notNull": true,
1226      "autoincrement": false,
1227      "default": "0",
1228      "generated": null,
1229      "name": "tokens_input",
1230      "entityType": "columns",
1231      "table": "session"
1232    },
1233    {
1234      "type": "integer",
1235      "notNull": true,
1236      "autoincrement": false,
1237      "default": "0",
1238      "generated": null,
1239      "name": "tokens_output",
1240      "entityType": "columns",
1241      "table": "session"
1242    },
1243    {
1244      "type": "integer",
1245      "notNull": true,
1246      "autoincrement": false,
1247      "default": "0",
1248      "generated": null,
1249      "name": "tokens_reasoning",
1250      "entityType": "columns",
1251      "table": "session"
1252    },
1253    {
1254      "type": "integer",
1255      "notNull": true,
1256      "autoincrement": false,
1257      "default": "0",
1258      "generated": null,
1259      "name": "tokens_cache_read",
1260      "entityType": "columns",
1261      "table": "session"
1262    },
1263    {
1264      "type": "integer",
1265      "notNull": true,
1266      "autoincrement": false,
1267      "default": "0",
1268      "generated": null,
1269      "name": "tokens_cache_write",
1270      "entityType": "columns",
1271      "table": "session"
1272    },
1273    {
1274      "type": "text",
1275      "notNull": false,
1276      "autoincrement": false,
1277      "default": null,
1278      "generated": null,
1279      "name": "revert",
1280      "entityType": "columns",
1281      "table": "session"
1282    },
1283    {
1284      "type": "text",
1285      "notNull": false,
1286      "autoincrement": false,
1287      "default": null,
1288      "generated": null,
1289      "name": "permission",
1290      "entityType": "columns",
1291      "table": "session"
1292    },
1293    {
1294      "type": "text",
1295      "notNull": false,
1296      "autoincrement": false,
1297      "default": null,
1298      "generated": null,
1299      "name": "agent",
1300      "entityType": "columns",
1301      "table": "session"
1302    },
1303    {
1304      "type": "text",
1305      "notNull": false,
1306      "autoincrement": false,
1307      "default": null,
1308      "generated": null,
1309      "name": "model",
1310      "entityType": "columns",
1311      "table": "session"
1312    },
1313    {
1314      "type": "integer",
1315      "notNull": true,
1316      "autoincrement": false,
1317      "default": null,
1318      "generated": null,
1319      "name": "time_created",
1320      "entityType": "columns",
1321      "table": "session"
1322    },
1323    {
1324      "type": "integer",
1325      "notNull": true,
1326      "autoincrement": false,
1327      "default": null,
1328      "generated": null,
1329      "name": "time_updated",
1330      "entityType": "columns",
1331      "table": "session"
1332    },
1333    {
1334      "type": "integer",
1335      "notNull": false,
1336      "autoincrement": false,
1337      "default": null,
1338      "generated": null,
1339      "name": "time_compacting",
1340      "entityType": "columns",
1341      "table": "session"
1342    },
1343    {
1344      "type": "integer",
1345      "notNull": false,
1346      "autoincrement": false,
1347      "default": null,
1348      "generated": null,
1349      "name": "time_archived",
1350      "entityType": "columns",
1351      "table": "session"
1352    },
1353    {
1354      "type": "text",
1355      "notNull": true,
1356      "autoincrement": false,
1357      "default": null,
1358      "generated": null,
1359      "name": "session_id",
1360      "entityType": "columns",
1361      "table": "todo"
1362    },
1363    {
1364      "type": "text",
1365      "notNull": true,
1366      "autoincrement": false,
1367      "default": null,
1368      "generated": null,
1369      "name": "content",
1370      "entityType": "columns",
1371      "table": "todo"
1372    },
1373    {
1374      "type": "text",
1375      "notNull": true,
1376      "autoincrement": false,
1377      "default": null,
1378      "generated": null,
1379      "name": "status",
1380      "entityType": "columns",
1381      "table": "todo"
1382    },
1383    {
1384      "type": "text",
1385      "notNull": true,
1386      "autoincrement": false,
1387      "default": null,
1388      "generated": null,
1389      "name": "priority",
1390      "entityType": "columns",
1391      "table": "todo"
1392    },
1393    {
1394      "type": "integer",
1395      "notNull": true,
1396      "autoincrement": false,
1397      "default": null,
1398      "generated": null,
1399      "name": "position",
1400      "entityType": "columns",
1401      "table": "todo"
1402    },
1403    {
1404      "type": "integer",
1405      "notNull": true,
1406      "autoincrement": false,
1407      "default": null,
1408      "generated": null,
1409      "name": "time_created",
1410      "entityType": "columns",
1411      "table": "todo"
1412    },
1413    {
1414      "type": "integer",
1415      "notNull": true,
1416      "autoincrement": false,
1417      "default": null,
1418      "generated": null,
1419      "name": "time_updated",
1420      "entityType": "columns",
1421      "table": "todo"
1422    },
1423    {
1424      "type": "text",
1425      "notNull": false,
1426      "autoincrement": false,
1427      "default": null,
1428      "generated": null,
1429      "name": "session_id",
1430      "entityType": "columns",
1431      "table": "session_share"
1432    },
1433    {
1434      "type": "text",
1435      "notNull": true,
1436      "autoincrement": false,
1437      "default": null,
1438      "generated": null,
1439      "name": "id",
1440      "entityType": "columns",
1441      "table": "session_share"
1442    },
1443    {
1444      "type": "text",
1445      "notNull": true,
1446      "autoincrement": false,
1447      "default": null,
1448      "generated": null,
1449      "name": "secret",
1450      "entityType": "columns",
1451      "table": "session_share"
1452    },
1453    {
1454      "type": "text",
1455      "notNull": true,
1456      "autoincrement": false,
1457      "default": null,
1458      "generated": null,
1459      "name": "url",
1460      "entityType": "columns",
1461      "table": "session_share"
1462    },
1463    {
1464      "type": "integer",
1465      "notNull": true,
1466      "autoincrement": false,
1467      "default": null,
1468      "generated": null,
1469      "name": "time_created",
1470      "entityType": "columns",
1471      "table": "session_share"
1472    },
1473    {
1474      "type": "integer",
1475      "notNull": true,
1476      "autoincrement": false,
1477      "default": null,
1478      "generated": null,
1479      "name": "time_updated",
1480      "entityType": "columns",
1481      "table": "session_share"
1482    },
1483    {
1484      "columns": ["project_id"],
1485      "tableTo": "project",
1486      "columnsTo": ["id"],
1487      "onUpdate": "NO ACTION",
1488      "onDelete": "CASCADE",
1489      "nameExplicit": false,
1490      "name": "fk_workspace_project_id_project_id_fk",
1491      "entityType": "fks",
1492      "table": "workspace"
1493    },
1494    {
1495      "columns": ["active_account_id"],
1496      "tableTo": "account",
1497      "columnsTo": ["id"],
1498      "onUpdate": "NO ACTION",
1499      "onDelete": "SET NULL",
1500      "nameExplicit": false,
1501      "name": "fk_account_state_active_account_id_account_id_fk",
1502      "entityType": "fks",
1503      "table": "account_state"
1504    },
1505    {
1506      "columns": ["aggregate_id"],
1507      "tableTo": "event_sequence",
1508      "columnsTo": ["aggregate_id"],
1509      "onUpdate": "NO ACTION",
1510      "onDelete": "CASCADE",
1511      "nameExplicit": false,
1512      "name": "fk_event_aggregate_id_event_sequence_aggregate_id_fk",
1513      "entityType": "fks",
1514      "table": "event"
1515    },
1516    {
1517      "columns": ["project_id"],
1518      "tableTo": "project",
1519      "columnsTo": ["id"],
1520      "onUpdate": "NO ACTION",
1521      "onDelete": "CASCADE",
1522      "nameExplicit": false,
1523      "name": "fk_permission_project_id_project_id_fk",
1524      "entityType": "fks",
1525      "table": "permission"
1526    },
1527    {
1528      "columns": ["project_id"],
1529      "tableTo": "project",
1530      "columnsTo": ["id"],
1531      "onUpdate": "NO ACTION",
1532      "onDelete": "CASCADE",
1533      "nameExplicit": false,
1534      "name": "fk_project_directory_project_id_project_id_fk",
1535      "entityType": "fks",
1536      "table": "project_directory"
1537    },
1538    {
1539      "columns": ["session_id"],
1540      "tableTo": "session",
1541      "columnsTo": ["id"],
1542      "onUpdate": "NO ACTION",
1543      "onDelete": "CASCADE",
1544      "nameExplicit": false,
1545      "name": "fk_message_session_id_session_id_fk",
1546      "entityType": "fks",
1547      "table": "message"
1548    },
1549    {
1550      "columns": ["message_id"],
1551      "tableTo": "message",
1552      "columnsTo": ["id"],
1553      "onUpdate": "NO ACTION",
1554      "onDelete": "CASCADE",
1555      "nameExplicit": false,
1556      "name": "fk_part_message_id_message_id_fk",
1557      "entityType": "fks",
1558      "table": "part"
1559    },
1560    {
1561      "columns": ["session_id"],
1562      "tableTo": "session",
1563      "columnsTo": ["id"],
1564      "onUpdate": "NO ACTION",
1565      "onDelete": "CASCADE",
1566      "nameExplicit": false,
1567      "name": "fk_session_context_epoch_session_id_session_id_fk",
1568      "entityType": "fks",
1569      "table": "session_context_epoch"
1570    },
1571    {
1572      "columns": ["session_id"],
1573      "tableTo": "session",
1574      "columnsTo": ["id"],
1575      "onUpdate": "NO ACTION",
1576      "onDelete": "CASCADE",
1577      "nameExplicit": false,
1578      "name": "fk_session_input_session_id_session_id_fk",
1579      "entityType": "fks",
1580      "table": "session_input"
1581    },
1582    {
1583      "columns": ["session_id"],
1584      "tableTo": "session",
1585      "columnsTo": ["id"],
1586      "onUpdate": "NO ACTION",
1587      "onDelete": "CASCADE",
1588      "nameExplicit": false,
1589      "name": "fk_session_message_session_id_session_id_fk",
1590      "entityType": "fks",
1591      "table": "session_message"
1592    },
1593    {
1594      "columns": ["project_id"],
1595      "tableTo": "project",
1596      "columnsTo": ["id"],
1597      "onUpdate": "NO ACTION",
1598      "onDelete": "CASCADE",
1599      "nameExplicit": false,
1600      "name": "fk_session_project_id_project_id_fk",
1601      "entityType": "fks",
1602      "table": "session"
1603    },
1604    {
1605      "columns": ["session_id"],
1606      "tableTo": "session",
1607      "columnsTo": ["id"],
1608      "onUpdate": "NO ACTION",
1609      "onDelete": "CASCADE",
1610      "nameExplicit": false,
1611      "name": "fk_todo_session_id_session_id_fk",
1612      "entityType": "fks",
1613      "table": "todo"
1614    },
1615    {
1616      "columns": ["session_id"],
1617      "tableTo": "session",
1618      "columnsTo": ["id"],
1619      "onUpdate": "NO ACTION",
1620      "onDelete": "CASCADE",
1621      "nameExplicit": false,
1622      "name": "fk_session_share_session_id_session_id_fk",
1623      "entityType": "fks",
1624      "table": "session_share"
1625    },
1626    {
1627      "columns": ["email", "url"],
1628      "nameExplicit": false,
1629      "name": "control_account_pk",
1630      "entityType": "pks",
1631      "table": "control_account"
1632    },
1633    {
1634      "columns": ["project_id", "directory"],
1635      "nameExplicit": false,
1636      "name": "project_directory_pk",
1637      "entityType": "pks",
1638      "table": "project_directory"
1639    },
1640    {
1641      "columns": ["session_id", "position"],
1642      "nameExplicit": false,
1643      "name": "todo_pk",
1644      "entityType": "pks",
1645      "table": "todo"
1646    },
1647    {
1648      "columns": ["id"],
1649      "nameExplicit": false,
1650      "name": "workspace_pk",
1651      "table": "workspace",
1652      "entityType": "pks"
1653    },
1654    {
1655      "columns": ["name"],
1656      "nameExplicit": false,
1657      "name": "data_migration_pk",
1658      "table": "data_migration",
1659      "entityType": "pks"
1660    },
1661    {
1662      "columns": ["id"],
1663      "nameExplicit": false,
1664      "name": "account_state_pk",
1665      "table": "account_state",
1666      "entityType": "pks"
1667    },
1668    {
1669      "columns": ["id"],
1670      "nameExplicit": false,
1671      "name": "account_pk",
1672      "table": "account",
1673      "entityType": "pks"
1674    },
1675    {
1676      "columns": ["id"],
1677      "nameExplicit": false,
1678      "name": "credential_pk",
1679      "table": "credential",
1680      "entityType": "pks"
1681    },
1682    {
1683      "columns": ["aggregate_id"],
1684      "nameExplicit": false,
1685      "name": "event_sequence_pk",
1686      "table": "event_sequence",
1687      "entityType": "pks"
1688    },
1689    {
1690      "columns": ["id"],
1691      "nameExplicit": false,
1692      "name": "event_pk",
1693      "table": "event",
1694      "entityType": "pks"
1695    },
1696    {
1697      "columns": ["id"],
1698      "nameExplicit": false,
1699      "name": "permission_pk",
1700      "table": "permission",
1701      "entityType": "pks"
1702    },
1703    {
1704      "columns": ["id"],
1705      "nameExplicit": false,
1706      "name": "project_pk",
1707      "table": "project",
1708      "entityType": "pks"
1709    },
1710    {
1711      "columns": ["id"],
1712      "nameExplicit": false,
1713      "name": "message_pk",
1714      "table": "message",
1715      "entityType": "pks"
1716    },
1717    {
1718      "columns": ["id"],
1719      "nameExplicit": false,
1720      "name": "part_pk",
1721      "table": "part",
1722      "entityType": "pks"
1723    },
1724    {
1725      "columns": ["session_id"],
1726      "nameExplicit": false,
1727      "name": "session_context_epoch_pk",
1728      "table": "session_context_epoch",
1729      "entityType": "pks"
1730    },
1731    {
1732      "columns": ["id"],
1733      "nameExplicit": false,
1734      "name": "session_input_pk",
1735      "table": "session_input",
1736      "entityType": "pks"
1737    },
1738    {
1739      "columns": ["id"],
1740      "nameExplicit": false,
1741      "name": "session_message_pk",
1742      "table": "session_message",
1743      "entityType": "pks"
1744    },
1745    {
1746      "columns": ["id"],
1747      "nameExplicit": false,
1748      "name": "session_pk",
1749      "table": "session",
1750      "entityType": "pks"
1751    },
1752    {
1753      "columns": ["session_id"],
1754      "nameExplicit": false,
1755      "name": "session_share_pk",
1756      "table": "session_share",
1757      "entityType": "pks"
1758    },
1759    {
1760      "columns": [
1761        {
1762          "value": "aggregate_id",
1763          "isExpression": false
1764        },
1765        {
1766          "value": "seq",
1767          "isExpression": false
1768        }
1769      ],
1770      "isUnique": true,
1771      "where": null,
1772      "origin": "manual",
1773      "name": "event_aggregate_seq_idx",
1774      "entityType": "indexes",
1775      "table": "event"
1776    },
1777    {
1778      "columns": [
1779        {
1780          "value": "aggregate_id",
1781          "isExpression": false
1782        },
1783        {
1784          "value": "type",
1785          "isExpression": false
1786        },
1787        {
1788          "value": "seq",
1789          "isExpression": false
1790        }
1791      ],
1792      "isUnique": false,
1793      "where": null,
1794      "origin": "manual",
1795      "name": "event_aggregate_type_seq_idx",
1796      "entityType": "indexes",
1797      "table": "event"
1798    },
1799    {
1800      "columns": [
1801        {
1802          "value": "project_id",
1803          "isExpression": false
1804        },
1805        {
1806          "value": "action",
1807          "isExpression": false
1808        },
1809        {
1810          "value": "resource",
1811          "isExpression": false
1812        }
1813      ],
1814      "isUnique": true,
1815      "where": null,
1816      "origin": "manual",
1817      "name": "permission_project_action_resource_idx",
1818      "entityType": "indexes",
1819      "table": "permission"
1820    },
1821    {
1822      "columns": [
1823        {
1824          "value": "session_id",
1825          "isExpression": false
1826        },
1827        {
1828          "value": "time_created",
1829          "isExpression": false
1830        },
1831        {
1832          "value": "id",
1833          "isExpression": false
1834        }
1835      ],
1836      "isUnique": false,
1837      "where": null,
1838      "origin": "manual",
1839      "name": "message_session_time_created_id_idx",
1840      "entityType": "indexes",
1841      "table": "message"
1842    },
1843    {
1844      "columns": [
1845        {
1846          "value": "message_id",
1847          "isExpression": false
1848        },
1849        {
1850          "value": "id",
1851          "isExpression": false
1852        }
1853      ],
1854      "isUnique": false,
1855      "where": null,
1856      "origin": "manual",
1857      "name": "part_message_id_id_idx",
1858      "entityType": "indexes",
1859      "table": "part"
1860    },
1861    {
1862      "columns": [
1863        {
1864          "value": "session_id",
1865          "isExpression": false
1866        }
1867      ],
1868      "isUnique": false,
1869      "where": null,
1870      "origin": "manual",
1871      "name": "part_session_idx",
1872      "entityType": "indexes",
1873      "table": "part"
1874    },
1875    {
1876      "columns": [
1877        {
1878          "value": "session_id",
1879          "isExpression": false
1880        },
1881        {
1882          "value": "promoted_seq",
1883          "isExpression": false
1884        },
1885        {
1886          "value": "delivery",
1887          "isExpression": false
1888        },
1889        {
1890          "value": "admitted_seq",
1891          "isExpression": false
1892        }
1893      ],
1894      "isUnique": false,
1895      "where": null,
1896      "origin": "manual",
1897      "name": "session_input_session_pending_delivery_seq_idx",
1898      "entityType": "indexes",
1899      "table": "session_input"
1900    },
1901    {
1902      "columns": [
1903        {
1904          "value": "session_id",
1905          "isExpression": false
1906        },
1907        {
1908          "value": "admitted_seq",
1909          "isExpression": false
1910        }
1911      ],
1912      "isUnique": true,
1913      "where": null,
1914      "origin": "manual",
1915      "name": "session_input_session_admitted_seq_idx",
1916      "entityType": "indexes",
1917      "table": "session_input"
1918    },
1919    {
1920      "columns": [
1921        {
1922          "value": "session_id",
1923          "isExpression": false
1924        },
1925        {
1926          "value": "promoted_seq",
1927          "isExpression": false
1928        }
1929      ],
1930      "isUnique": true,
1931      "where": null,
1932      "origin": "manual",
1933      "name": "session_input_session_promoted_seq_idx",
1934      "entityType": "indexes",
1935      "table": "session_input"
1936    },
1937    {
1938      "columns": [
1939        {
1940          "value": "session_id",
1941          "isExpression": false
1942        },
1943        {
1944          "value": "seq",
1945          "isExpression": false
1946        }
1947      ],
1948      "isUnique": true,
1949      "where": null,
1950      "origin": "manual",
1951      "name": "session_message_session_seq_idx",
1952      "entityType": "indexes",
1953      "table": "session_message"
1954    },
1955    {
1956      "columns": [
1957        {
1958          "value": "session_id",
1959          "isExpression": false
1960        },
1961        {
1962          "value": "type",
1963          "isExpression": false
1964        },
1965        {
1966          "value": "seq",
1967          "isExpression": false
1968        }
1969      ],
1970      "isUnique": false,
1971      "where": null,
1972      "origin": "manual",
1973      "name": "session_message_session_type_seq_idx",
1974      "entityType": "indexes",
1975      "table": "session_message"
1976    },
1977    {
1978      "columns": [
1979        {
1980          "value": "session_id",
1981          "isExpression": false
1982        },
1983        {
1984          "value": "time_created",
1985          "isExpression": false
1986        },
1987        {
1988          "value": "id",
1989          "isExpression": false
1990        }
1991      ],
1992      "isUnique": false,
1993      "where": null,
1994      "origin": "manual",
1995      "name": "session_message_session_time_created_id_idx",
1996      "entityType": "indexes",
1997      "table": "session_message"
1998    },
1999    {
2000      "columns": [
2001        {
2002          "value": "time_created",
2003          "isExpression": false
2004        }
2005      ],
2006      "isUnique": false,
2007      "where": null,
2008      "origin": "manual",
2009      "name": "session_message_time_created_idx",
2010      "entityType": "indexes",
2011      "table": "session_message"
2012    },
2013    {
2014      "columns": [
2015        {
2016          "value": "project_id",
2017          "isExpression": false
2018        }
2019      ],
2020      "isUnique": false,
2021      "where": null,
2022      "origin": "manual",
2023      "name": "session_project_idx",
2024      "entityType": "indexes",
2025      "table": "session"
2026    },
2027    {
2028      "columns": [
2029        {
2030          "value": "workspace_id",
2031          "isExpression": false
2032        }
2033      ],
2034      "isUnique": false,
2035      "where": null,
2036      "origin": "manual",
2037      "name": "session_workspace_idx",
2038      "entityType": "indexes",
2039      "table": "session"
2040    },
2041    {
2042      "columns": [
2043        {
2044          "value": "parent_id",
2045          "isExpression": false
2046        }
2047      ],
2048      "isUnique": false,
2049      "where": null,
2050      "origin": "manual",
2051      "name": "session_parent_idx",
2052      "entityType": "indexes",
2053      "table": "session"
2054    },
2055    {
2056      "columns": [
2057        {
2058          "value": "session_id",
2059          "isExpression": false
2060        }
2061      ],
2062      "isUnique": false,
2063      "where": null,
2064      "origin": "manual",
2065      "name": "todo_session_idx",
2066      "entityType": "indexes",
2067      "table": "todo"
2068    }
2069  ],
2070  "renames": []
2071}
2072