|
|
@@ -11,6 +11,7 @@ import {
|
|
|
|
unique,
|
|
|
|
unique,
|
|
|
|
uuid,
|
|
|
|
uuid,
|
|
|
|
} from "drizzle-orm/pg-core";
|
|
|
|
} from "drizzle-orm/pg-core";
|
|
|
|
|
|
|
|
import type { MedicalAlert } from "@groombook/types";
|
|
|
|
|
|
|
|
|
|
|
|
// ─── Enums ────────────────────────────────────────────────────────────────────
|
|
|
|
// ─── Enums ────────────────────────────────────────────────────────────────────
|
|
|
|
|
|
|
|
|
|
|
@@ -164,6 +165,10 @@ export const pets = pgTable(
|
|
|
|
specialCareNotes: text("special_care_notes"),
|
|
|
|
specialCareNotes: text("special_care_notes"),
|
|
|
|
coatType: coatTypeEnum("coat_type"),
|
|
|
|
coatType: coatTypeEnum("coat_type"),
|
|
|
|
petSizeCategory: petSizeCategoryEnum("pet_size_category"),
|
|
|
|
petSizeCategory: petSizeCategoryEnum("pet_size_category"),
|
|
|
|
|
|
|
|
temperamentScore: integer("temperament_score"),
|
|
|
|
|
|
|
|
temperamentFlags: jsonb("temperament_flags").$type<string[]>().default([]),
|
|
|
|
|
|
|
|
medicalAlerts: jsonb("medical_alerts").$type<MedicalAlert[]>().default([]),
|
|
|
|
|
|
|
|
preferredCuts: jsonb("preferred_cuts").$type<string[]>().default([]),
|
|
|
|
customFields: jsonb("custom_fields").$type<Record<string, string>>().notNull().default({}),
|
|
|
|
customFields: jsonb("custom_fields").$type<Record<string, string>>().notNull().default({}),
|
|
|
|
photoKey: text("photo_key"),
|
|
|
|
photoKey: text("photo_key"),
|
|
|
|
photoUploadedAt: timestamp("photo_uploaded_at"),
|
|
|
|
photoUploadedAt: timestamp("photo_uploaded_at"),
|
|
|
|