0000_snapshot.json
1 { 2 "version": "6", 3 "dialect": "sqlite", 4 "id": "37474a5d-60f0-48e6-9d78-2f498299d211", 5 "prevId": "00000000-0000-0000-0000-000000000000", 6 "tables": { 7 "categories": { 8 "name": "categories", 9 "columns": { 10 "id": { 11 "name": "id", 12 "type": "integer", 13 "primaryKey": true, 14 "notNull": true, 15 "autoincrement": true 16 }, 17 "name": { 18 "name": "name", 19 "type": "text", 20 "primaryKey": false, 21 "notNull": true, 22 "autoincrement": false 23 }, 24 "slug": { 25 "name": "slug", 26 "type": "text", 27 "primaryKey": false, 28 "notNull": true, 29 "autoincrement": false 30 } 31 }, 32 "indexes": { 33 "categories_slug_unique": { 34 "name": "categories_slug_unique", 35 "columns": [ 36 "slug" 37 ], 38 "isUnique": true 39 } 40 }, 41 "foreignKeys": {}, 42 "compositePrimaryKeys": {}, 43 "uniqueConstraints": {}, 44 "checkConstraints": {} 45 }, 46 "courses": { 47 "name": "courses", 48 "columns": { 49 "id": { 50 "name": "id", 51 "type": "integer", 52 "primaryKey": true, 53 "notNull": true, 54 "autoincrement": true 55 }, 56 "title": { 57 "name": "title", 58 "type": "text", 59 "primaryKey": false, 60 "notNull": true, 61 "autoincrement": false 62 }, 63 "slug": { 64 "name": "slug", 65 "type": "text", 66 "primaryKey": false, 67 "notNull": true, 68 "autoincrement": false 69 }, 70 "description": { 71 "name": "description", 72 "type": "text", 73 "primaryKey": false, 74 "notNull": true, 75 "autoincrement": false 76 }, 77 "sales_copy": { 78 "name": "sales_copy", 79 "type": "text", 80 "primaryKey": false, 81 "notNull": false, 82 "autoincrement": false 83 }, 84 "instructor_id": { 85 "name": "instructor_id", 86 "type": "integer", 87 "primaryKey": false, 88 "notNull": true, 89 "autoincrement": false 90 }, 91 "category_id": { 92 "name": "category_id", 93 "type": "integer", 94 "primaryKey": false, 95 "notNull": true, 96 "autoincrement": false 97 }, 98 "status": { 99 "name": "status", 100 "type": "text", 101 "primaryKey": false, 102 "notNull": true, 103 "autoincrement": false 104 }, 105 "cover_image_url": { 106 "name": "cover_image_url", 107 "type": "text", 108 "primaryKey": false, 109 "notNull": false, 110 "autoincrement": false 111 }, 112 "price": { 113 "name": "price", 114 "type": "integer", 115 "primaryKey": false, 116 "notNull": true, 117 "autoincrement": false, 118 "default": 0 119 }, 120 "ppp_enabled": { 121 "name": "ppp_enabled", 122 "type": "integer", 123 "primaryKey": false, 124 "notNull": true, 125 "autoincrement": false, 126 "default": true 127 }, 128 "created_at": { 129 "name": "created_at", 130 "type": "text", 131 "primaryKey": false, 132 "notNull": true, 133 "autoincrement": false 134 }, 135 "updated_at": { 136 "name": "updated_at", 137 "type": "text", 138 "primaryKey": false, 139 "notNull": true, 140 "autoincrement": false 141 } 142 }, 143 "indexes": { 144 "courses_slug_unique": { 145 "name": "courses_slug_unique", 146 "columns": [ 147 "slug" 148 ], 149 "isUnique": true 150 } 151 }, 152 "foreignKeys": { 153 "courses_instructor_id_users_id_fk": { 154 "name": "courses_instructor_id_users_id_fk", 155 "tableFrom": "courses", 156 "tableTo": "users", 157 "columnsFrom": [ 158 "instructor_id" 159 ], 160 "columnsTo": [ 161 "id" 162 ], 163 "onDelete": "no action", 164 "onUpdate": "no action" 165 }, 166 "courses_category_id_categories_id_fk": { 167 "name": "courses_category_id_categories_id_fk", 168 "tableFrom": "courses", 169 "tableTo": "categories", 170 "columnsFrom": [ 171 "category_id" 172 ], 173 "columnsTo": [ 174 "id" 175 ], 176 "onDelete": "no action", 177 "onUpdate": "no action" 178 } 179 }, 180 "compositePrimaryKeys": {}, 181 "uniqueConstraints": {}, 182 "checkConstraints": {} 183 }, 184 "enrollments": { 185 "name": "enrollments", 186 "columns": { 187 "id": { 188 "name": "id", 189 "type": "integer", 190 "primaryKey": true, 191 "notNull": true, 192 "autoincrement": true 193 }, 194 "user_id": { 195 "name": "user_id", 196 "type": "integer", 197 "primaryKey": false, 198 "notNull": true, 199 "autoincrement": false 200 }, 201 "course_id": { 202 "name": "course_id", 203 "type": "integer", 204 "primaryKey": false, 205 "notNull": true, 206 "autoincrement": false 207 }, 208 "enrolled_at": { 209 "name": "enrolled_at", 210 "type": "text", 211 "primaryKey": false, 212 "notNull": true, 213 "autoincrement": false 214 }, 215 "completed_at": { 216 "name": "completed_at", 217 "type": "text", 218 "primaryKey": false, 219 "notNull": false, 220 "autoincrement": false 221 } 222 }, 223 "indexes": {}, 224 "foreignKeys": { 225 "enrollments_user_id_users_id_fk": { 226 "name": "enrollments_user_id_users_id_fk", 227 "tableFrom": "enrollments", 228 "tableTo": "users", 229 "columnsFrom": [ 230 "user_id" 231 ], 232 "columnsTo": [ 233 "id" 234 ], 235 "onDelete": "no action", 236 "onUpdate": "no action" 237 }, 238 "enrollments_course_id_courses_id_fk": { 239 "name": "enrollments_course_id_courses_id_fk", 240 "tableFrom": "enrollments", 241 "tableTo": "courses", 242 "columnsFrom": [ 243 "course_id" 244 ], 245 "columnsTo": [ 246 "id" 247 ], 248 "onDelete": "no action", 249 "onUpdate": "no action" 250 } 251 }, 252 "compositePrimaryKeys": {}, 253 "uniqueConstraints": {}, 254 "checkConstraints": {} 255 }, 256 "lesson_progress": { 257 "name": "lesson_progress", 258 "columns": { 259 "id": { 260 "name": "id", 261 "type": "integer", 262 "primaryKey": true, 263 "notNull": true, 264 "autoincrement": true 265 }, 266 "user_id": { 267 "name": "user_id", 268 "type": "integer", 269 "primaryKey": false, 270 "notNull": true, 271 "autoincrement": false 272 }, 273 "lesson_id": { 274 "name": "lesson_id", 275 "type": "integer", 276 "primaryKey": false, 277 "notNull": true, 278 "autoincrement": false 279 }, 280 "status": { 281 "name": "status", 282 "type": "text", 283 "primaryKey": false, 284 "notNull": true, 285 "autoincrement": false 286 }, 287 "completed_at": { 288 "name": "completed_at", 289 "type": "text", 290 "primaryKey": false, 291 "notNull": false, 292 "autoincrement": false 293 } 294 }, 295 "indexes": {}, 296 "foreignKeys": { 297 "lesson_progress_user_id_users_id_fk": { 298 "name": "lesson_progress_user_id_users_id_fk", 299 "tableFrom": "lesson_progress", 300 "tableTo": "users", 301 "columnsFrom": [ 302 "user_id" 303 ], 304 "columnsTo": [ 305 "id" 306 ], 307 "onDelete": "no action", 308 "onUpdate": "no action" 309 }, 310 "lesson_progress_lesson_id_lessons_id_fk": { 311 "name": "lesson_progress_lesson_id_lessons_id_fk", 312 "tableFrom": "lesson_progress", 313 "tableTo": "lessons", 314 "columnsFrom": [ 315 "lesson_id" 316 ], 317 "columnsTo": [ 318 "id" 319 ], 320 "onDelete": "no action", 321 "onUpdate": "no action" 322 } 323 }, 324 "compositePrimaryKeys": {}, 325 "uniqueConstraints": {}, 326 "checkConstraints": {} 327 }, 328 "lessons": { 329 "name": "lessons", 330 "columns": { 331 "id": { 332 "name": "id", 333 "type": "integer", 334 "primaryKey": true, 335 "notNull": true, 336 "autoincrement": true 337 }, 338 "module_id": { 339 "name": "module_id", 340 "type": "integer", 341 "primaryKey": false, 342 "notNull": true, 343 "autoincrement": false 344 }, 345 "title": { 346 "name": "title", 347 "type": "text", 348 "primaryKey": false, 349 "notNull": true, 350 "autoincrement": false 351 }, 352 "content": { 353 "name": "content", 354 "type": "text", 355 "primaryKey": false, 356 "notNull": false, 357 "autoincrement": false 358 }, 359 "video_url": { 360 "name": "video_url", 361 "type": "text", 362 "primaryKey": false, 363 "notNull": false, 364 "autoincrement": false 365 }, 366 "position": { 367 "name": "position", 368 "type": "integer", 369 "primaryKey": false, 370 "notNull": true, 371 "autoincrement": false 372 }, 373 "duration_minutes": { 374 "name": "duration_minutes", 375 "type": "integer", 376 "primaryKey": false, 377 "notNull": false, 378 "autoincrement": false 379 }, 380 "created_at": { 381 "name": "created_at", 382 "type": "text", 383 "primaryKey": false, 384 "notNull": true, 385 "autoincrement": false 386 } 387 }, 388 "indexes": {}, 389 "foreignKeys": { 390 "lessons_module_id_modules_id_fk": { 391 "name": "lessons_module_id_modules_id_fk", 392 "tableFrom": "lessons", 393 "tableTo": "modules", 394 "columnsFrom": [ 395 "module_id" 396 ], 397 "columnsTo": [ 398 "id" 399 ], 400 "onDelete": "no action", 401 "onUpdate": "no action" 402 } 403 }, 404 "compositePrimaryKeys": {}, 405 "uniqueConstraints": {}, 406 "checkConstraints": {} 407 }, 408 "modules": { 409 "name": "modules", 410 "columns": { 411 "id": { 412 "name": "id", 413 "type": "integer", 414 "primaryKey": true, 415 "notNull": true, 416 "autoincrement": true 417 }, 418 "course_id": { 419 "name": "course_id", 420 "type": "integer", 421 "primaryKey": false, 422 "notNull": true, 423 "autoincrement": false 424 }, 425 "title": { 426 "name": "title", 427 "type": "text", 428 "primaryKey": false, 429 "notNull": true, 430 "autoincrement": false 431 }, 432 "position": { 433 "name": "position", 434 "type": "integer", 435 "primaryKey": false, 436 "notNull": true, 437 "autoincrement": false 438 }, 439 "created_at": { 440 "name": "created_at", 441 "type": "text", 442 "primaryKey": false, 443 "notNull": true, 444 "autoincrement": false 445 } 446 }, 447 "indexes": {}, 448 "foreignKeys": { 449 "modules_course_id_courses_id_fk": { 450 "name": "modules_course_id_courses_id_fk", 451 "tableFrom": "modules", 452 "tableTo": "courses", 453 "columnsFrom": [ 454 "course_id" 455 ], 456 "columnsTo": [ 457 "id" 458 ], 459 "onDelete": "no action", 460 "onUpdate": "no action" 461 } 462 }, 463 "compositePrimaryKeys": {}, 464 "uniqueConstraints": {}, 465 "checkConstraints": {} 466 }, 467 "purchases": { 468 "name": "purchases", 469 "columns": { 470 "id": { 471 "name": "id", 472 "type": "integer", 473 "primaryKey": true, 474 "notNull": true, 475 "autoincrement": true 476 }, 477 "user_id": { 478 "name": "user_id", 479 "type": "integer", 480 "primaryKey": false, 481 "notNull": true, 482 "autoincrement": false 483 }, 484 "course_id": { 485 "name": "course_id", 486 "type": "integer", 487 "primaryKey": false, 488 "notNull": true, 489 "autoincrement": false 490 }, 491 "price_paid": { 492 "name": "price_paid", 493 "type": "integer", 494 "primaryKey": false, 495 "notNull": true, 496 "autoincrement": false 497 }, 498 "country": { 499 "name": "country", 500 "type": "text", 501 "primaryKey": false, 502 "notNull": false, 503 "autoincrement": false 504 }, 505 "created_at": { 506 "name": "created_at", 507 "type": "text", 508 "primaryKey": false, 509 "notNull": true, 510 "autoincrement": false 511 } 512 }, 513 "indexes": {}, 514 "foreignKeys": { 515 "purchases_user_id_users_id_fk": { 516 "name": "purchases_user_id_users_id_fk", 517 "tableFrom": "purchases", 518 "tableTo": "users", 519 "columnsFrom": [ 520 "user_id" 521 ], 522 "columnsTo": [ 523 "id" 524 ], 525 "onDelete": "no action", 526 "onUpdate": "no action" 527 }, 528 "purchases_course_id_courses_id_fk": { 529 "name": "purchases_course_id_courses_id_fk", 530 "tableFrom": "purchases", 531 "tableTo": "courses", 532 "columnsFrom": [ 533 "course_id" 534 ], 535 "columnsTo": [ 536 "id" 537 ], 538 "onDelete": "no action", 539 "onUpdate": "no action" 540 } 541 }, 542 "compositePrimaryKeys": {}, 543 "uniqueConstraints": {}, 544 "checkConstraints": {} 545 }, 546 "quiz_answers": { 547 "name": "quiz_answers", 548 "columns": { 549 "id": { 550 "name": "id", 551 "type": "integer", 552 "primaryKey": true, 553 "notNull": true, 554 "autoincrement": true 555 }, 556 "attempt_id": { 557 "name": "attempt_id", 558 "type": "integer", 559 "primaryKey": false, 560 "notNull": true, 561 "autoincrement": false 562 }, 563 "question_id": { 564 "name": "question_id", 565 "type": "integer", 566 "primaryKey": false, 567 "notNull": true, 568 "autoincrement": false 569 }, 570 "selected_option_id": { 571 "name": "selected_option_id", 572 "type": "integer", 573 "primaryKey": false, 574 "notNull": true, 575 "autoincrement": false 576 } 577 }, 578 "indexes": {}, 579 "foreignKeys": { 580 "quiz_answers_attempt_id_quiz_attempts_id_fk": { 581 "name": "quiz_answers_attempt_id_quiz_attempts_id_fk", 582 "tableFrom": "quiz_answers", 583 "tableTo": "quiz_attempts", 584 "columnsFrom": [ 585 "attempt_id" 586 ], 587 "columnsTo": [ 588 "id" 589 ], 590 "onDelete": "no action", 591 "onUpdate": "no action" 592 }, 593 "quiz_answers_question_id_quiz_questions_id_fk": { 594 "name": "quiz_answers_question_id_quiz_questions_id_fk", 595 "tableFrom": "quiz_answers", 596 "tableTo": "quiz_questions", 597 "columnsFrom": [ 598 "question_id" 599 ], 600 "columnsTo": [ 601 "id" 602 ], 603 "onDelete": "no action", 604 "onUpdate": "no action" 605 }, 606 "quiz_answers_selected_option_id_quiz_options_id_fk": { 607 "name": "quiz_answers_selected_option_id_quiz_options_id_fk", 608 "tableFrom": "quiz_answers", 609 "tableTo": "quiz_options", 610 "columnsFrom": [ 611 "selected_option_id" 612 ], 613 "columnsTo": [ 614 "id" 615 ], 616 "onDelete": "no action", 617 "onUpdate": "no action" 618 } 619 }, 620 "compositePrimaryKeys": {}, 621 "uniqueConstraints": {}, 622 "checkConstraints": {} 623 }, 624 "quiz_attempts": { 625 "name": "quiz_attempts", 626 "columns": { 627 "id": { 628 "name": "id", 629 "type": "integer", 630 "primaryKey": true, 631 "notNull": true, 632 "autoincrement": true 633 }, 634 "user_id": { 635 "name": "user_id", 636 "type": "integer", 637 "primaryKey": false, 638 "notNull": true, 639 "autoincrement": false 640 }, 641 "quiz_id": { 642 "name": "quiz_id", 643 "type": "integer", 644 "primaryKey": false, 645 "notNull": true, 646 "autoincrement": false 647 }, 648 "score": { 649 "name": "score", 650 "type": "real", 651 "primaryKey": false, 652 "notNull": true, 653 "autoincrement": false 654 }, 655 "passed": { 656 "name": "passed", 657 "type": "integer", 658 "primaryKey": false, 659 "notNull": true, 660 "autoincrement": false 661 }, 662 "attempted_at": { 663 "name": "attempted_at", 664 "type": "text", 665 "primaryKey": false, 666 "notNull": true, 667 "autoincrement": false 668 } 669 }, 670 "indexes": {}, 671 "foreignKeys": { 672 "quiz_attempts_user_id_users_id_fk": { 673 "name": "quiz_attempts_user_id_users_id_fk", 674 "tableFrom": "quiz_attempts", 675 "tableTo": "users", 676 "columnsFrom": [ 677 "user_id" 678 ], 679 "columnsTo": [ 680 "id" 681 ], 682 "onDelete": "no action", 683 "onUpdate": "no action" 684 }, 685 "quiz_attempts_quiz_id_quizzes_id_fk": { 686 "name": "quiz_attempts_quiz_id_quizzes_id_fk", 687 "tableFrom": "quiz_attempts", 688 "tableTo": "quizzes", 689 "columnsFrom": [ 690 "quiz_id" 691 ], 692 "columnsTo": [ 693 "id" 694 ], 695 "onDelete": "no action", 696 "onUpdate": "no action" 697 } 698 }, 699 "compositePrimaryKeys": {}, 700 "uniqueConstraints": {}, 701 "checkConstraints": {} 702 }, 703 "quiz_options": { 704 "name": "quiz_options", 705 "columns": { 706 "id": { 707 "name": "id", 708 "type": "integer", 709 "primaryKey": true, 710 "notNull": true, 711 "autoincrement": true 712 }, 713 "question_id": { 714 "name": "question_id", 715 "type": "integer", 716 "primaryKey": false, 717 "notNull": true, 718 "autoincrement": false 719 }, 720 "option_text": { 721 "name": "option_text", 722 "type": "text", 723 "primaryKey": false, 724 "notNull": true, 725 "autoincrement": false 726 }, 727 "is_correct": { 728 "name": "is_correct", 729 "type": "integer", 730 "primaryKey": false, 731 "notNull": true, 732 "autoincrement": false 733 } 734 }, 735 "indexes": {}, 736 "foreignKeys": { 737 "quiz_options_question_id_quiz_questions_id_fk": { 738 "name": "quiz_options_question_id_quiz_questions_id_fk", 739 "tableFrom": "quiz_options", 740 "tableTo": "quiz_questions", 741 "columnsFrom": [ 742 "question_id" 743 ], 744 "columnsTo": [ 745 "id" 746 ], 747 "onDelete": "no action", 748 "onUpdate": "no action" 749 } 750 }, 751 "compositePrimaryKeys": {}, 752 "uniqueConstraints": {}, 753 "checkConstraints": {} 754 }, 755 "quiz_questions": { 756 "name": "quiz_questions", 757 "columns": { 758 "id": { 759 "name": "id", 760 "type": "integer", 761 "primaryKey": true, 762 "notNull": true, 763 "autoincrement": true 764 }, 765 "quiz_id": { 766 "name": "quiz_id", 767 "type": "integer", 768 "primaryKey": false, 769 "notNull": true, 770 "autoincrement": false 771 }, 772 "question_text": { 773 "name": "question_text", 774 "type": "text", 775 "primaryKey": false, 776 "notNull": true, 777 "autoincrement": false 778 }, 779 "question_type": { 780 "name": "question_type", 781 "type": "text", 782 "primaryKey": false, 783 "notNull": true, 784 "autoincrement": false 785 }, 786 "position": { 787 "name": "position", 788 "type": "integer", 789 "primaryKey": false, 790 "notNull": true, 791 "autoincrement": false 792 } 793 }, 794 "indexes": {}, 795 "foreignKeys": { 796 "quiz_questions_quiz_id_quizzes_id_fk": { 797 "name": "quiz_questions_quiz_id_quizzes_id_fk", 798 "tableFrom": "quiz_questions", 799 "tableTo": "quizzes", 800 "columnsFrom": [ 801 "quiz_id" 802 ], 803 "columnsTo": [ 804 "id" 805 ], 806 "onDelete": "no action", 807 "onUpdate": "no action" 808 } 809 }, 810 "compositePrimaryKeys": {}, 811 "uniqueConstraints": {}, 812 "checkConstraints": {} 813 }, 814 "quizzes": { 815 "name": "quizzes", 816 "columns": { 817 "id": { 818 "name": "id", 819 "type": "integer", 820 "primaryKey": true, 821 "notNull": true, 822 "autoincrement": true 823 }, 824 "lesson_id": { 825 "name": "lesson_id", 826 "type": "integer", 827 "primaryKey": false, 828 "notNull": true, 829 "autoincrement": false 830 }, 831 "title": { 832 "name": "title", 833 "type": "text", 834 "primaryKey": false, 835 "notNull": true, 836 "autoincrement": false 837 }, 838 "passing_score": { 839 "name": "passing_score", 840 "type": "real", 841 "primaryKey": false, 842 "notNull": true, 843 "autoincrement": false 844 } 845 }, 846 "indexes": {}, 847 "foreignKeys": { 848 "quizzes_lesson_id_lessons_id_fk": { 849 "name": "quizzes_lesson_id_lessons_id_fk", 850 "tableFrom": "quizzes", 851 "tableTo": "lessons", 852 "columnsFrom": [ 853 "lesson_id" 854 ], 855 "columnsTo": [ 856 "id" 857 ], 858 "onDelete": "no action", 859 "onUpdate": "no action" 860 } 861 }, 862 "compositePrimaryKeys": {}, 863 "uniqueConstraints": {}, 864 "checkConstraints": {} 865 }, 866 "users": { 867 "name": "users", 868 "columns": { 869 "id": { 870 "name": "id", 871 "type": "integer", 872 "primaryKey": true, 873 "notNull": true, 874 "autoincrement": true 875 }, 876 "name": { 877 "name": "name", 878 "type": "text", 879 "primaryKey": false, 880 "notNull": true, 881 "autoincrement": false 882 }, 883 "email": { 884 "name": "email", 885 "type": "text", 886 "primaryKey": false, 887 "notNull": true, 888 "autoincrement": false 889 }, 890 "role": { 891 "name": "role", 892 "type": "text", 893 "primaryKey": false, 894 "notNull": true, 895 "autoincrement": false 896 }, 897 "avatar_url": { 898 "name": "avatar_url", 899 "type": "text", 900 "primaryKey": false, 901 "notNull": false, 902 "autoincrement": false 903 }, 904 "bio": { 905 "name": "bio", 906 "type": "text", 907 "primaryKey": false, 908 "notNull": false, 909 "autoincrement": false 910 }, 911 "created_at": { 912 "name": "created_at", 913 "type": "text", 914 "primaryKey": false, 915 "notNull": true, 916 "autoincrement": false 917 } 918 }, 919 "indexes": { 920 "users_email_unique": { 921 "name": "users_email_unique", 922 "columns": [ 923 "email" 924 ], 925 "isUnique": true 926 } 927 }, 928 "foreignKeys": {}, 929 "compositePrimaryKeys": {}, 930 "uniqueConstraints": {}, 931 "checkConstraints": {} 932 }, 933 "video_watch_events": { 934 "name": "video_watch_events", 935 "columns": { 936 "id": { 937 "name": "id", 938 "type": "integer", 939 "primaryKey": true, 940 "notNull": true, 941 "autoincrement": true 942 }, 943 "user_id": { 944 "name": "user_id", 945 "type": "integer", 946 "primaryKey": false, 947 "notNull": true, 948 "autoincrement": false 949 }, 950 "lesson_id": { 951 "name": "lesson_id", 952 "type": "integer", 953 "primaryKey": false, 954 "notNull": true, 955 "autoincrement": false 956 }, 957 "event_type": { 958 "name": "event_type", 959 "type": "text", 960 "primaryKey": false, 961 "notNull": true, 962 "autoincrement": false 963 }, 964 "position_seconds": { 965 "name": "position_seconds", 966 "type": "real", 967 "primaryKey": false, 968 "notNull": true, 969 "autoincrement": false 970 }, 971 "created_at": { 972 "name": "created_at", 973 "type": "text", 974 "primaryKey": false, 975 "notNull": true, 976 "autoincrement": false 977 } 978 }, 979 "indexes": {}, 980 "foreignKeys": { 981 "video_watch_events_user_id_users_id_fk": { 982 "name": "video_watch_events_user_id_users_id_fk", 983 "tableFrom": "video_watch_events", 984 "tableTo": "users", 985 "columnsFrom": [ 986 "user_id" 987 ], 988 "columnsTo": [ 989 "id" 990 ], 991 "onDelete": "no action", 992 "onUpdate": "no action" 993 }, 994 "video_watch_events_lesson_id_lessons_id_fk": { 995 "name": "video_watch_events_lesson_id_lessons_id_fk", 996 "tableFrom": "video_watch_events", 997 "tableTo": "lessons", 998 "columnsFrom": [ 999 "lesson_id" 1000 ], 1001 "columnsTo": [ 1002 "id" 1003 ], 1004 "onDelete": "no action", 1005 "onUpdate": "no action" 1006 } 1007 }, 1008 "compositePrimaryKeys": {}, 1009 "uniqueConstraints": {}, 1010 "checkConstraints": {} 1011 } 1012 }, 1013 "views": {}, 1014 "enums": {}, 1015 "_meta": { 1016 "schemas": {}, 1017 "tables": {}, 1018 "columns": {} 1019 }, 1020 "internal": { 1021 "indexes": {} 1022 } 1023 }