Index: database/migrations/0000_fancy_mojo.sql =================================================================== --- database/migrations/0000_fancy_mojo.sql (revision 9e9293aee4e405cff06144fc8a7d23e306b8adc8) +++ database/migrations/0000_fancy_mojo.sql (revision 9e9293aee4e405cff06144fc8a7d23e306b8adc8) @@ -0,0 +1,242 @@ +CREATE TABLE "build_component" ( + "build_id" integer NOT NULL, + "component_id" integer NOT NULL, + CONSTRAINT "build_component_build_id_component_id_pk" PRIMARY KEY("build_id","component_id") +); +--> statement-breakpoint +CREATE TABLE "build" ( + "id" serial PRIMARY KEY NOT NULL, + "user_id" integer NOT NULL, + "name" text NOT NULL, + "created_at" date NOT NULL, + "description" text, + "total_price" numeric NOT NULL, + "is_approved" boolean NOT NULL +); +--> statement-breakpoint +CREATE TABLE "favorite_build" ( + "build_id" integer NOT NULL, + "user_id" integer NOT NULL, + CONSTRAINT "favorite_build_build_id_user_id_pk" PRIMARY KEY("build_id","user_id") +); +--> statement-breakpoint +CREATE TABLE "rating_build" ( + "build_id" integer NOT NULL, + "user_id" integer NOT NULL, + "value" numeric NOT NULL, + CONSTRAINT "rating_build_build_id_user_id_pk" PRIMARY KEY("build_id","user_id"), + CONSTRAINT "check_value" CHECK ("rating_build"."value" BETWEEN 1 AND 5) +); +--> statement-breakpoint +CREATE TABLE "review" ( + "id" serial PRIMARY KEY NOT NULL, + "build_id" integer NOT NULL, + "user_id" integer NOT NULL, + "content" text NOT NULL, + "created_at" date NOT NULL, + CONSTRAINT "review_build_id_user_id_unique" UNIQUE("build_id","user_id") +); +--> statement-breakpoint +CREATE TABLE "cpu" ( + "component_id" integer PRIMARY KEY NOT NULL, + "socket" text NOT NULL, + "cores" integer NOT NULL, + "threads" integer NOT NULL, + "base_clock" numeric NOT NULL, + "boost_clock" numeric, + "tdp" numeric NOT NULL +); +--> statement-breakpoint +CREATE TABLE "gpu" ( + "component_id" integer PRIMARY KEY NOT NULL, + "vram" numeric NOT NULL, + "tdp" numeric NOT NULL, + "base_clock" numeric, + "boost_clock" numeric, + "chipset" text NOT NULL, + "length" numeric NOT NULL +); +--> statement-breakpoint +CREATE TABLE "cables" ( + "component_id" integer PRIMARY KEY NOT NULL, + "length_cm" numeric NOT NULL, + "type" text NOT NULL +); +--> statement-breakpoint +CREATE TABLE "case_mobo_form_factors" ( + "case_id" integer NOT NULL, + "form_factor" text NOT NULL, + CONSTRAINT "case_mobo_form_factors_case_id_form_factor_pk" PRIMARY KEY("case_id","form_factor") +); +--> statement-breakpoint +CREATE TABLE "case_ps_form_factors" ( + "case_id" integer NOT NULL, + "form_factor" text NOT NULL, + CONSTRAINT "case_ps_form_factors_case_id_form_factor_pk" PRIMARY KEY("case_id","form_factor") +); +--> statement-breakpoint +CREATE TABLE "case_storage_form_factors" ( + "case_id" integer NOT NULL, + "form_factor" text NOT NULL, + "num_slots" integer NOT NULL, + CONSTRAINT "case_storage_form_factors_case_id_form_factor_pk" PRIMARY KEY("case_id","form_factor") +); +--> statement-breakpoint +CREATE TABLE "components" ( + "id" serial PRIMARY KEY NOT NULL, + "name" text NOT NULL, + "brand" text NOT NULL, + "price" numeric NOT NULL, + "img_url" text, + "type" text NOT NULL, + CONSTRAINT "check_type" CHECK ("components"."type" in + ('cpu', 'gpu', 'memory', 'storage', 'power_supply', 'motherboard', 'case', 'cooler', 'memory_card', 'optical_drive', 'sound_card', 'cables', 'network_adapter', 'network_card')) +); +--> statement-breakpoint +CREATE TABLE "cooler_cpu_sockets" ( + "cooler_id" integer NOT NULL, + "socket" text NOT NULL, + CONSTRAINT "cooler_cpu_sockets_cooler_id_socket_pk" PRIMARY KEY("cooler_id","socket") +); +--> statement-breakpoint +CREATE TABLE "cooler" ( + "component_id" integer PRIMARY KEY NOT NULL, + "type" text NOT NULL, + "height" numeric NOT NULL, + "max_tdp_supported" numeric NOT NULL +); +--> statement-breakpoint +CREATE TABLE "memory_card" ( + "component_id" integer PRIMARY KEY NOT NULL, + "num_slots" integer NOT NULL, + "interface" text NOT NULL +); +--> statement-breakpoint +CREATE TABLE "memory" ( + "component_id" integer PRIMARY KEY NOT NULL, + "type" text NOT NULL, + "speed" numeric NOT NULL, + "capacity" numeric NOT NULL, + "modules" integer NOT NULL +); +--> statement-breakpoint +CREATE TABLE "motherboard" ( + "component_id" integer PRIMARY KEY NOT NULL, + "socket" text NOT NULL, + "chipset" text NOT NULL, + "form_factor" text NOT NULL, + "ram_type" text NOT NULL, + "num_ram_slots" integer NOT NULL, + "max_ram_capacity" numeric NOT NULL, + "pci_express_slots" numeric NOT NULL +); +--> statement-breakpoint +CREATE TABLE "network_adapter" ( + "component_id" integer PRIMARY KEY NOT NULL, + "wifi_version" text NOT NULL, + "interface" text NOT NULL, + "num_antennas" integer NOT NULL +); +--> statement-breakpoint +CREATE TABLE "network_card" ( + "component_id" integer PRIMARY KEY NOT NULL, + "num_ports" integer NOT NULL, + "speed" numeric NOT NULL, + "interface" text NOT NULL +); +--> statement-breakpoint +CREATE TABLE "optical_drive" ( + "component_id" integer PRIMARY KEY NOT NULL, + "form_factor" text NOT NULL, + "type" text NOT NULL, + "interface" text NOT NULL, + "write_speed" numeric NOT NULL, + "read_speed" numeric NOT NULL +); +--> statement-breakpoint +CREATE TABLE "pc_case" ( + "component_id" integer PRIMARY KEY NOT NULL, + "cooler_max_height" numeric NOT NULL, + "gpu_max_length" numeric NOT NULL +); +--> statement-breakpoint +CREATE TABLE "power_supply" ( + "component_id" integer PRIMARY KEY NOT NULL, + "type" text NOT NULL, + "wattage" numeric NOT NULL, + "form_factor" text NOT NULL +); +--> statement-breakpoint +CREATE TABLE "sound_card" ( + "component_id" integer PRIMARY KEY NOT NULL, + "sample_rate" numeric NOT NULL, + "bit_depth" numeric NOT NULL, + "chipset" text NOT NULL, + "interface" text NOT NULL, + "channel" text NOT NULL +); +--> statement-breakpoint +CREATE TABLE "storage" ( + "component_id" integer PRIMARY KEY NOT NULL, + "type" text NOT NULL, + "capacity" numeric NOT NULL, + "form_factor" text NOT NULL +); +--> statement-breakpoint +CREATE TABLE "admins" ( + "user_id" integer PRIMARY KEY NOT NULL +); +--> statement-breakpoint +CREATE TABLE "suggestions" ( + "id" serial PRIMARY KEY NOT NULL, + "user_id" integer NOT NULL, + "admin_id" integer, + "link" text NOT NULL, + "admin_comment" text, + "description" text, + "status" text DEFAULT 'pending' NOT NULL, + "component_type" text NOT NULL, + CONSTRAINT "check_status" CHECK ("suggestions"."status" in ('pending', 'approved', 'rejected')), + CONSTRAINT "check_type" CHECK ("suggestions"."component_type" in + ('cpu', 'gpu', 'memory', 'storage', 'power_supply', 'motherboard', 'case', 'cooler', 'memory_card', 'optical_drive', 'sound_card', 'cables', 'network_adapter', 'network_card')) +); +--> statement-breakpoint +CREATE TABLE "users" ( + "id" serial PRIMARY KEY NOT NULL, + "username" text NOT NULL, + "password" text NOT NULL, + "email" text NOT NULL, + CONSTRAINT "users_username_unique" UNIQUE("username"), + CONSTRAINT "users_email_unique" UNIQUE("email") +); +--> statement-breakpoint +ALTER TABLE "build_component" ADD CONSTRAINT "build_component_build_id_build_id_fk" FOREIGN KEY ("build_id") REFERENCES "public"."build"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "build_component" ADD CONSTRAINT "build_component_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "build" ADD CONSTRAINT "build_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "favorite_build" ADD CONSTRAINT "favorite_build_build_id_build_id_fk" FOREIGN KEY ("build_id") REFERENCES "public"."build"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "favorite_build" ADD CONSTRAINT "favorite_build_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "rating_build" ADD CONSTRAINT "rating_build_build_id_build_id_fk" FOREIGN KEY ("build_id") REFERENCES "public"."build"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "rating_build" ADD CONSTRAINT "rating_build_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "review" ADD CONSTRAINT "review_build_id_build_id_fk" FOREIGN KEY ("build_id") REFERENCES "public"."build"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "review" ADD CONSTRAINT "review_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "cpu" ADD CONSTRAINT "cpu_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "gpu" ADD CONSTRAINT "gpu_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "cables" ADD CONSTRAINT "cables_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "case_mobo_form_factors" ADD CONSTRAINT "case_mobo_form_factors_case_id_pc_case_component_id_fk" FOREIGN KEY ("case_id") REFERENCES "public"."pc_case"("component_id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "case_ps_form_factors" ADD CONSTRAINT "case_ps_form_factors_case_id_pc_case_component_id_fk" FOREIGN KEY ("case_id") REFERENCES "public"."pc_case"("component_id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "case_storage_form_factors" ADD CONSTRAINT "case_storage_form_factors_case_id_pc_case_component_id_fk" FOREIGN KEY ("case_id") REFERENCES "public"."pc_case"("component_id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "cooler_cpu_sockets" ADD CONSTRAINT "cooler_cpu_sockets_cooler_id_cooler_component_id_fk" FOREIGN KEY ("cooler_id") REFERENCES "public"."cooler"("component_id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "cooler" ADD CONSTRAINT "cooler_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "memory_card" ADD CONSTRAINT "memory_card_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "memory" ADD CONSTRAINT "memory_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "motherboard" ADD CONSTRAINT "motherboard_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "network_adapter" ADD CONSTRAINT "network_adapter_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "network_card" ADD CONSTRAINT "network_card_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "optical_drive" ADD CONSTRAINT "optical_drive_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "pc_case" ADD CONSTRAINT "pc_case_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "power_supply" ADD CONSTRAINT "power_supply_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "sound_card" ADD CONSTRAINT "sound_card_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "storage" ADD CONSTRAINT "storage_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "admins" ADD CONSTRAINT "admins_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "suggestions" ADD CONSTRAINT "suggestions_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "suggestions" ADD CONSTRAINT "suggestions_admin_id_admins_user_id_fk" FOREIGN KEY ("admin_id") REFERENCES "public"."admins"("user_id") ON DELETE set null ON UPDATE cascade; Index: database/migrations/meta/0000_snapshot.json =================================================================== --- database/migrations/meta/0000_snapshot.json (revision 9e9293aee4e405cff06144fc8a7d23e306b8adc8) +++ database/migrations/meta/0000_snapshot.json (revision 9e9293aee4e405cff06144fc8a7d23e306b8adc8) @@ -0,0 +1,1575 @@ +{ + "id": "294407f5-3396-43fc-ace1-814badc53535", + "prevId": "00000000-0000-0000-0000-000000000000", + "version": "7", + "dialect": "postgresql", + "tables": { + "public.build_component": { + "name": "build_component", + "schema": "", + "columns": { + "build_id": { + "name": "build_id", + "type": "integer", + "primaryKey": false, + "notNull": true + }, + "component_id": { + "name": "component_id", + "type": "integer", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "build_component_build_id_build_id_fk": { + "name": "build_component_build_id_build_id_fk", + "tableFrom": "build_component", + "tableTo": "build", + "columnsFrom": [ + "build_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + }, + "build_component_component_id_components_id_fk": { + "name": "build_component_component_id_components_id_fk", + "tableFrom": "build_component", + "tableTo": "components", + "columnsFrom": [ + "component_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": { + "build_component_build_id_component_id_pk": { + "name": "build_component_build_id_component_id_pk", + "columns": [ + "build_id", + "component_id" + ] + } + }, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.build": { + "name": "build", + "schema": "", + "columns": { + "id": { + "name": "id", + "type": "serial", + "primaryKey": true, + "notNull": true + }, + "user_id": { + "name": "user_id", + "type": "integer", + "primaryKey": false, + "notNull": true + }, + "name": { + "name": "name", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "created_at": { + "name": "created_at", + "type": "date", + "primaryKey": false, + "notNull": true + }, + "description": { + "name": "description", + "type": "text", + "primaryKey": false, + "notNull": false + }, + "total_price": { + "name": "total_price", + "type": "numeric", + "primaryKey": false, + "notNull": true + }, + "is_approved": { + "name": "is_approved", + "type": "boolean", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "build_user_id_users_id_fk": { + "name": "build_user_id_users_id_fk", + "tableFrom": "build", + "tableTo": "users", + "columnsFrom": [ + "user_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.favorite_build": { + "name": "favorite_build", + "schema": "", + "columns": { + "build_id": { + "name": "build_id", + "type": "integer", + "primaryKey": false, + "notNull": true + }, + "user_id": { + "name": "user_id", + "type": "integer", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "favorite_build_build_id_build_id_fk": { + "name": "favorite_build_build_id_build_id_fk", + "tableFrom": "favorite_build", + "tableTo": "build", + "columnsFrom": [ + "build_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + }, + "favorite_build_user_id_users_id_fk": { + "name": "favorite_build_user_id_users_id_fk", + "tableFrom": "favorite_build", + "tableTo": "users", + "columnsFrom": [ + "user_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": { + "favorite_build_build_id_user_id_pk": { + "name": "favorite_build_build_id_user_id_pk", + "columns": [ + "build_id", + "user_id" + ] + } + }, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.rating_build": { + "name": "rating_build", + "schema": "", + "columns": { + "build_id": { + "name": "build_id", + "type": "integer", + "primaryKey": false, + "notNull": true + }, + "user_id": { + "name": "user_id", + "type": "integer", + "primaryKey": false, + "notNull": true + }, + "value": { + "name": "value", + "type": "numeric", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "rating_build_build_id_build_id_fk": { + "name": "rating_build_build_id_build_id_fk", + "tableFrom": "rating_build", + "tableTo": "build", + "columnsFrom": [ + "build_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + }, + "rating_build_user_id_users_id_fk": { + "name": "rating_build_user_id_users_id_fk", + "tableFrom": "rating_build", + "tableTo": "users", + "columnsFrom": [ + "user_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": { + "rating_build_build_id_user_id_pk": { + "name": "rating_build_build_id_user_id_pk", + "columns": [ + "build_id", + "user_id" + ] + } + }, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": { + "check_value": { + "name": "check_value", + "value": "\"rating_build\".\"value\" BETWEEN 1 AND 5" + } + }, + "isRLSEnabled": false + }, + "public.review": { + "name": "review", + "schema": "", + "columns": { + "id": { + "name": "id", + "type": "serial", + "primaryKey": true, + "notNull": true + }, + "build_id": { + "name": "build_id", + "type": "integer", + "primaryKey": false, + "notNull": true + }, + "user_id": { + "name": "user_id", + "type": "integer", + "primaryKey": false, + "notNull": true + }, + "content": { + "name": "content", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "created_at": { + "name": "created_at", + "type": "date", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "review_build_id_build_id_fk": { + "name": "review_build_id_build_id_fk", + "tableFrom": "review", + "tableTo": "build", + "columnsFrom": [ + "build_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + }, + "review_user_id_users_id_fk": { + "name": "review_user_id_users_id_fk", + "tableFrom": "review", + "tableTo": "users", + "columnsFrom": [ + "user_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": { + "review_build_id_user_id_unique": { + "name": "review_build_id_user_id_unique", + "nullsNotDistinct": false, + "columns": [ + "build_id", + "user_id" + ] + } + }, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.cpu": { + "name": "cpu", + "schema": "", + "columns": { + "component_id": { + "name": "component_id", + "type": "integer", + "primaryKey": true, + "notNull": true + }, + "socket": { + "name": "socket", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "cores": { + "name": "cores", + "type": "integer", + "primaryKey": false, + "notNull": true + }, + "threads": { + "name": "threads", + "type": "integer", + "primaryKey": false, + "notNull": true + }, + "base_clock": { + "name": "base_clock", + "type": "numeric", + "primaryKey": false, + "notNull": true + }, + "boost_clock": { + "name": "boost_clock", + "type": "numeric", + "primaryKey": false, + "notNull": false + }, + "tdp": { + "name": "tdp", + "type": "numeric", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "cpu_component_id_components_id_fk": { + "name": "cpu_component_id_components_id_fk", + "tableFrom": "cpu", + "tableTo": "components", + "columnsFrom": [ + "component_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.gpu": { + "name": "gpu", + "schema": "", + "columns": { + "component_id": { + "name": "component_id", + "type": "integer", + "primaryKey": true, + "notNull": true + }, + "vram": { + "name": "vram", + "type": "numeric", + "primaryKey": false, + "notNull": true + }, + "tdp": { + "name": "tdp", + "type": "numeric", + "primaryKey": false, + "notNull": true + }, + "base_clock": { + "name": "base_clock", + "type": "numeric", + "primaryKey": false, + "notNull": false + }, + "boost_clock": { + "name": "boost_clock", + "type": "numeric", + "primaryKey": false, + "notNull": false + }, + "chipset": { + "name": "chipset", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "length": { + "name": "length", + "type": "numeric", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "gpu_component_id_components_id_fk": { + "name": "gpu_component_id_components_id_fk", + "tableFrom": "gpu", + "tableTo": "components", + "columnsFrom": [ + "component_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.cables": { + "name": "cables", + "schema": "", + "columns": { + "component_id": { + "name": "component_id", + "type": "integer", + "primaryKey": true, + "notNull": true + }, + "length_cm": { + "name": "length_cm", + "type": "numeric", + "primaryKey": false, + "notNull": true + }, + "type": { + "name": "type", + "type": "text", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "cables_component_id_components_id_fk": { + "name": "cables_component_id_components_id_fk", + "tableFrom": "cables", + "tableTo": "components", + "columnsFrom": [ + "component_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.case_mobo_form_factors": { + "name": "case_mobo_form_factors", + "schema": "", + "columns": { + "case_id": { + "name": "case_id", + "type": "integer", + "primaryKey": false, + "notNull": true + }, + "form_factor": { + "name": "form_factor", + "type": "text", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "case_mobo_form_factors_case_id_pc_case_component_id_fk": { + "name": "case_mobo_form_factors_case_id_pc_case_component_id_fk", + "tableFrom": "case_mobo_form_factors", + "tableTo": "pc_case", + "columnsFrom": [ + "case_id" + ], + "columnsTo": [ + "component_id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": { + "case_mobo_form_factors_case_id_form_factor_pk": { + "name": "case_mobo_form_factors_case_id_form_factor_pk", + "columns": [ + "case_id", + "form_factor" + ] + } + }, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.case_ps_form_factors": { + "name": "case_ps_form_factors", + "schema": "", + "columns": { + "case_id": { + "name": "case_id", + "type": "integer", + "primaryKey": false, + "notNull": true + }, + "form_factor": { + "name": "form_factor", + "type": "text", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "case_ps_form_factors_case_id_pc_case_component_id_fk": { + "name": "case_ps_form_factors_case_id_pc_case_component_id_fk", + "tableFrom": "case_ps_form_factors", + "tableTo": "pc_case", + "columnsFrom": [ + "case_id" + ], + "columnsTo": [ + "component_id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": { + "case_ps_form_factors_case_id_form_factor_pk": { + "name": "case_ps_form_factors_case_id_form_factor_pk", + "columns": [ + "case_id", + "form_factor" + ] + } + }, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.case_storage_form_factors": { + "name": "case_storage_form_factors", + "schema": "", + "columns": { + "case_id": { + "name": "case_id", + "type": "integer", + "primaryKey": false, + "notNull": true + }, + "form_factor": { + "name": "form_factor", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "num_slots": { + "name": "num_slots", + "type": "integer", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "case_storage_form_factors_case_id_pc_case_component_id_fk": { + "name": "case_storage_form_factors_case_id_pc_case_component_id_fk", + "tableFrom": "case_storage_form_factors", + "tableTo": "pc_case", + "columnsFrom": [ + "case_id" + ], + "columnsTo": [ + "component_id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": { + "case_storage_form_factors_case_id_form_factor_pk": { + "name": "case_storage_form_factors_case_id_form_factor_pk", + "columns": [ + "case_id", + "form_factor" + ] + } + }, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.components": { + "name": "components", + "schema": "", + "columns": { + "id": { + "name": "id", + "type": "serial", + "primaryKey": true, + "notNull": true + }, + "name": { + "name": "name", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "brand": { + "name": "brand", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "price": { + "name": "price", + "type": "numeric", + "primaryKey": false, + "notNull": true + }, + "img_url": { + "name": "img_url", + "type": "text", + "primaryKey": false, + "notNull": false + }, + "type": { + "name": "type", + "type": "text", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": {}, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": { + "check_type": { + "name": "check_type", + "value": "\"components\".\"type\" in \n ('cpu', 'gpu', 'memory', 'storage', 'power_supply', 'motherboard', 'case', 'cooler', 'memory_card', 'optical_drive', 'sound_card', 'cables', 'network_adapter', 'network_card')" + } + }, + "isRLSEnabled": false + }, + "public.cooler_cpu_sockets": { + "name": "cooler_cpu_sockets", + "schema": "", + "columns": { + "cooler_id": { + "name": "cooler_id", + "type": "integer", + "primaryKey": false, + "notNull": true + }, + "socket": { + "name": "socket", + "type": "text", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "cooler_cpu_sockets_cooler_id_cooler_component_id_fk": { + "name": "cooler_cpu_sockets_cooler_id_cooler_component_id_fk", + "tableFrom": "cooler_cpu_sockets", + "tableTo": "cooler", + "columnsFrom": [ + "cooler_id" + ], + "columnsTo": [ + "component_id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": { + "cooler_cpu_sockets_cooler_id_socket_pk": { + "name": "cooler_cpu_sockets_cooler_id_socket_pk", + "columns": [ + "cooler_id", + "socket" + ] + } + }, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.cooler": { + "name": "cooler", + "schema": "", + "columns": { + "component_id": { + "name": "component_id", + "type": "integer", + "primaryKey": true, + "notNull": true + }, + "type": { + "name": "type", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "height": { + "name": "height", + "type": "numeric", + "primaryKey": false, + "notNull": true + }, + "max_tdp_supported": { + "name": "max_tdp_supported", + "type": "numeric", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "cooler_component_id_components_id_fk": { + "name": "cooler_component_id_components_id_fk", + "tableFrom": "cooler", + "tableTo": "components", + "columnsFrom": [ + "component_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.memory_card": { + "name": "memory_card", + "schema": "", + "columns": { + "component_id": { + "name": "component_id", + "type": "integer", + "primaryKey": true, + "notNull": true + }, + "num_slots": { + "name": "num_slots", + "type": "integer", + "primaryKey": false, + "notNull": true + }, + "interface": { + "name": "interface", + "type": "text", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "memory_card_component_id_components_id_fk": { + "name": "memory_card_component_id_components_id_fk", + "tableFrom": "memory_card", + "tableTo": "components", + "columnsFrom": [ + "component_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.memory": { + "name": "memory", + "schema": "", + "columns": { + "component_id": { + "name": "component_id", + "type": "integer", + "primaryKey": true, + "notNull": true + }, + "type": { + "name": "type", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "speed": { + "name": "speed", + "type": "numeric", + "primaryKey": false, + "notNull": true + }, + "capacity": { + "name": "capacity", + "type": "numeric", + "primaryKey": false, + "notNull": true + }, + "modules": { + "name": "modules", + "type": "integer", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "memory_component_id_components_id_fk": { + "name": "memory_component_id_components_id_fk", + "tableFrom": "memory", + "tableTo": "components", + "columnsFrom": [ + "component_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.motherboard": { + "name": "motherboard", + "schema": "", + "columns": { + "component_id": { + "name": "component_id", + "type": "integer", + "primaryKey": true, + "notNull": true + }, + "socket": { + "name": "socket", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "chipset": { + "name": "chipset", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "form_factor": { + "name": "form_factor", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "ram_type": { + "name": "ram_type", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "num_ram_slots": { + "name": "num_ram_slots", + "type": "integer", + "primaryKey": false, + "notNull": true + }, + "max_ram_capacity": { + "name": "max_ram_capacity", + "type": "numeric", + "primaryKey": false, + "notNull": true + }, + "pci_express_slots": { + "name": "pci_express_slots", + "type": "numeric", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "motherboard_component_id_components_id_fk": { + "name": "motherboard_component_id_components_id_fk", + "tableFrom": "motherboard", + "tableTo": "components", + "columnsFrom": [ + "component_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.network_adapter": { + "name": "network_adapter", + "schema": "", + "columns": { + "component_id": { + "name": "component_id", + "type": "integer", + "primaryKey": true, + "notNull": true + }, + "wifi_version": { + "name": "wifi_version", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "interface": { + "name": "interface", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "num_antennas": { + "name": "num_antennas", + "type": "integer", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "network_adapter_component_id_components_id_fk": { + "name": "network_adapter_component_id_components_id_fk", + "tableFrom": "network_adapter", + "tableTo": "components", + "columnsFrom": [ + "component_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.network_card": { + "name": "network_card", + "schema": "", + "columns": { + "component_id": { + "name": "component_id", + "type": "integer", + "primaryKey": true, + "notNull": true + }, + "num_ports": { + "name": "num_ports", + "type": "integer", + "primaryKey": false, + "notNull": true + }, + "speed": { + "name": "speed", + "type": "numeric", + "primaryKey": false, + "notNull": true + }, + "interface": { + "name": "interface", + "type": "text", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "network_card_component_id_components_id_fk": { + "name": "network_card_component_id_components_id_fk", + "tableFrom": "network_card", + "tableTo": "components", + "columnsFrom": [ + "component_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.optical_drive": { + "name": "optical_drive", + "schema": "", + "columns": { + "component_id": { + "name": "component_id", + "type": "integer", + "primaryKey": true, + "notNull": true + }, + "form_factor": { + "name": "form_factor", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "type": { + "name": "type", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "interface": { + "name": "interface", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "write_speed": { + "name": "write_speed", + "type": "numeric", + "primaryKey": false, + "notNull": true + }, + "read_speed": { + "name": "read_speed", + "type": "numeric", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "optical_drive_component_id_components_id_fk": { + "name": "optical_drive_component_id_components_id_fk", + "tableFrom": "optical_drive", + "tableTo": "components", + "columnsFrom": [ + "component_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.pc_case": { + "name": "pc_case", + "schema": "", + "columns": { + "component_id": { + "name": "component_id", + "type": "integer", + "primaryKey": true, + "notNull": true + }, + "cooler_max_height": { + "name": "cooler_max_height", + "type": "numeric", + "primaryKey": false, + "notNull": true + }, + "gpu_max_length": { + "name": "gpu_max_length", + "type": "numeric", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "pc_case_component_id_components_id_fk": { + "name": "pc_case_component_id_components_id_fk", + "tableFrom": "pc_case", + "tableTo": "components", + "columnsFrom": [ + "component_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.power_supply": { + "name": "power_supply", + "schema": "", + "columns": { + "component_id": { + "name": "component_id", + "type": "integer", + "primaryKey": true, + "notNull": true + }, + "type": { + "name": "type", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "wattage": { + "name": "wattage", + "type": "numeric", + "primaryKey": false, + "notNull": true + }, + "form_factor": { + "name": "form_factor", + "type": "text", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "power_supply_component_id_components_id_fk": { + "name": "power_supply_component_id_components_id_fk", + "tableFrom": "power_supply", + "tableTo": "components", + "columnsFrom": [ + "component_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.sound_card": { + "name": "sound_card", + "schema": "", + "columns": { + "component_id": { + "name": "component_id", + "type": "integer", + "primaryKey": true, + "notNull": true + }, + "sample_rate": { + "name": "sample_rate", + "type": "numeric", + "primaryKey": false, + "notNull": true + }, + "bit_depth": { + "name": "bit_depth", + "type": "numeric", + "primaryKey": false, + "notNull": true + }, + "chipset": { + "name": "chipset", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "interface": { + "name": "interface", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "channel": { + "name": "channel", + "type": "text", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "sound_card_component_id_components_id_fk": { + "name": "sound_card_component_id_components_id_fk", + "tableFrom": "sound_card", + "tableTo": "components", + "columnsFrom": [ + "component_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.storage": { + "name": "storage", + "schema": "", + "columns": { + "component_id": { + "name": "component_id", + "type": "integer", + "primaryKey": true, + "notNull": true + }, + "type": { + "name": "type", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "capacity": { + "name": "capacity", + "type": "numeric", + "primaryKey": false, + "notNull": true + }, + "form_factor": { + "name": "form_factor", + "type": "text", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "storage_component_id_components_id_fk": { + "name": "storage_component_id_components_id_fk", + "tableFrom": "storage", + "tableTo": "components", + "columnsFrom": [ + "component_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.admins": { + "name": "admins", + "schema": "", + "columns": { + "user_id": { + "name": "user_id", + "type": "integer", + "primaryKey": true, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "admins_user_id_users_id_fk": { + "name": "admins_user_id_users_id_fk", + "tableFrom": "admins", + "tableTo": "users", + "columnsFrom": [ + "user_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + }, + "public.suggestions": { + "name": "suggestions", + "schema": "", + "columns": { + "id": { + "name": "id", + "type": "serial", + "primaryKey": true, + "notNull": true + }, + "user_id": { + "name": "user_id", + "type": "integer", + "primaryKey": false, + "notNull": true + }, + "admin_id": { + "name": "admin_id", + "type": "integer", + "primaryKey": false, + "notNull": false + }, + "link": { + "name": "link", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "admin_comment": { + "name": "admin_comment", + "type": "text", + "primaryKey": false, + "notNull": false + }, + "description": { + "name": "description", + "type": "text", + "primaryKey": false, + "notNull": false + }, + "status": { + "name": "status", + "type": "text", + "primaryKey": false, + "notNull": true, + "default": "'pending'" + }, + "component_type": { + "name": "component_type", + "type": "text", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": { + "suggestions_user_id_users_id_fk": { + "name": "suggestions_user_id_users_id_fk", + "tableFrom": "suggestions", + "tableTo": "users", + "columnsFrom": [ + "user_id" + ], + "columnsTo": [ + "id" + ], + "onDelete": "cascade", + "onUpdate": "cascade" + }, + "suggestions_admin_id_admins_user_id_fk": { + "name": "suggestions_admin_id_admins_user_id_fk", + "tableFrom": "suggestions", + "tableTo": "admins", + "columnsFrom": [ + "admin_id" + ], + "columnsTo": [ + "user_id" + ], + "onDelete": "set null", + "onUpdate": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "policies": {}, + "checkConstraints": { + "check_status": { + "name": "check_status", + "value": "\"suggestions\".\"status\" in ('pending', 'approved', 'rejected')" + }, + "check_type": { + "name": "check_type", + "value": "\"suggestions\".\"component_type\" in \n ('cpu', 'gpu', 'memory', 'storage', 'power_supply', 'motherboard', 'case', 'cooler', 'memory_card', 'optical_drive', 'sound_card', 'cables', 'network_adapter', 'network_card')" + } + }, + "isRLSEnabled": false + }, + "public.users": { + "name": "users", + "schema": "", + "columns": { + "id": { + "name": "id", + "type": "serial", + "primaryKey": true, + "notNull": true + }, + "username": { + "name": "username", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "password": { + "name": "password", + "type": "text", + "primaryKey": false, + "notNull": true + }, + "email": { + "name": "email", + "type": "text", + "primaryKey": false, + "notNull": true + } + }, + "indexes": {}, + "foreignKeys": {}, + "compositePrimaryKeys": {}, + "uniqueConstraints": { + "users_username_unique": { + "name": "users_username_unique", + "nullsNotDistinct": false, + "columns": [ + "username" + ] + }, + "users_email_unique": { + "name": "users_email_unique", + "nullsNotDistinct": false, + "columns": [ + "email" + ] + } + }, + "policies": {}, + "checkConstraints": {}, + "isRLSEnabled": false + } + }, + "enums": {}, + "schemas": {}, + "sequences": {}, + "roles": {}, + "policies": {}, + "views": {}, + "_meta": { + "columns": {}, + "schemas": {}, + "tables": {} + } +} Index: database/migrations/meta/_journal.json =================================================================== --- database/migrations/meta/_journal.json (revision 9e9293aee4e405cff06144fc8a7d23e306b8adc8) +++ database/migrations/meta/_journal.json (revision 9e9293aee4e405cff06144fc8a7d23e306b8adc8) @@ -0,0 +1,13 @@ +{ + "version": "7", + "dialect": "postgresql", + "entries": [ + { + "idx": 0, + "version": "7", + "when": 1766862496340, + "tag": "0000_fancy_mojo", + "breakpoints": true + } + ] +}