Schema Redesign: Target Schema Definitions

import {
  boolean,
  index,
  integer,
  pgEnum,
  pgSchema,
  text,
  timestamp,
  uniqueIndex,
  uuid,
  varchar,
} from 'drizzle-orm/pg-core'
import { authUsers } from '../auth/schema'
import { organization } from '../orgs/schema'

const studioSchema = pgSchema('studio')

export const guide = studioSchema.table(
  'tour',
  {
    // Identity
    id: uuid('id').defaultRandom().primaryKey(),
    nanoId: varchar('nano_id', { length: 21 }).notNull().unique('unique_guide_nano_id'),

    // Ownership
    organizationId: uuid('organization_id')
      .notNull()
      .references(() => organization.id, { onDelete: 'cascade' }),

    // Lifecycle
    createdAt: timestamp('created_at', { withTimezone: true }).defaultNow().notNull(),
    createdBy: uuid('created_by')
      .notNull()
      .references(() => authUsers.id, { onDelete: 'cascade' }),
    updatedAt: timestamp('updated_at', { withTimezone: true })
      .defaultNow()
      .notNull()
      .$onUpdate(() => new Date()),
    updatedBy: uuid('updated_by')
      .notNull()
      .references(() => authUsers.id, { onDelete: 'cascade' }),

    // Soft delete
    archivedAt: timestamp('archived_at', { withTimezone: true }),
    deletedAt: timestamp('deleted_at', { withTimezone: true }),

    // Convenience (derived from locale rows, but cached here)
    availableLocales: text('available_locales').array().notNull().default(['en']),
  },
  (t) => ({
    guideOrgIdx: index('tour_org_idx').on(t.organizationId),
  }),
)

export const stop = studioSchema.table(
  'stop',
  {
    // Identity
    id: uuid('id').defaultRandom().primaryKey(),
    nanoId: varchar('nano_id', { length: 21 }).notNull().unique('unique_stop_nano_id'),

    // Ownership
    organizationId: uuid('organization_id')
      .notNull()
      .references(() => organization.id, { onDelete: 'cascade' }),

    // Lifecycle
    createdAt: timestamp('created_at', { withTimezone: true }).defaultNow().notNull(),
    createdBy: uuid('created_by')
      .notNull()
      .references(() => authUsers.id, { onDelete: 'cascade' }),
    updatedAt: timestamp('updated_at', { withTimezone: true })
      .defaultNow()
      .notNull()
      .$onUpdate(() => new Date()),
    updatedBy: uuid('updated_by')
      .notNull()
      .references(() => authUsers.id, { onDelete: 'cascade' }),

    // Soft delete
    archivedAt: timestamp('archived_at', { withTimezone: true }),
    deletedAt: timestamp('deleted_at', { withTimezone: true }),

    // Convenience
    availableLocales: text('available_locales').array().notNull().default(['en']),
  },
  (t) => ({
    stopOrgIdx: index('stop_org_idx').on(t.organizationId),
  }),
)

export const assetType = pgEnum('asset_type', ['image', 'audio', 'video'])

export const asset = studioSchema.table(
  'asset',
  {
    // Identity
    id: uuid('id').defaultRandom().primaryKey(),
    nanoId: varchar('nano_id', { length: 21 }).notNull().unique('unique_asset_nano_id'),

    // File metadata
    fileName: varchar('file_name', { length: 500 }).notNull(),
    fileSize: integer('file_size').notNull(),
    mimeType: varchar('mime_type', { length: 100 }).notNull(),
    type: assetType('type').notNull(),

    // Storage
    storagePath: text('storage_path').notNull(),
    publicUrl: text('public_url'),

    // Media metadata (optional)
    width: integer('width'),
    height: integer('height'),
    duration: integer('duration'), // seconds for audio/video

    // Ownership
    organizationId: uuid('organization_id')
      .notNull()
      .references(() => organization.id, { onDelete: 'cascade' }),
    uploadedBy: uuid('uploaded_by')
      .notNull()
      .references(() => authUsers.id, { onDelete: 'cascade' }),

    // Timestamps
    createdAt: timestamp('created_at', { withTimezone: true }).defaultNow().notNull(),
    updatedAt: timestamp('updated_at', { withTimezone: true })
      .defaultNow()
      .notNull()
      .$onUpdate(() => new Date()),
  },
  (t) => ({
    assetOrgIdx: index('asset_org_idx').on(t.organizationId),
    assetTypeOrgIdx: index('asset_type_org_idx').on(t.type, t.organizationId),
  }),
)

export const guideLocaleDraft = studioSchema.table(
  'tour_locale_draft',
  {
    id: uuid('id').defaultRandom().primaryKey(),

    // Parent
    guideId: uuid('tour_id')
      .notNull()
      .references(() => guide.id, { onDelete: 'cascade' }),
    locale: varchar('locale', { length: 10 }).notNull(),

    // Content
    title: varchar('title', { length: 500 }),
    description: text('description'),

    // Timestamps
    createdAt: timestamp('created_at', { withTimezone: true }).defaultNow().notNull(),
    updatedAt: timestamp('updated_at', { withTimezone: true })
      .defaultNow()
      .notNull()
      .$onUpdate(() => new Date()),
    updatedBy: uuid('updated_by').references(() => authUsers.id, { onDelete: 'set null' }),
  },
  (t) => ({
    uniqGuideLocaleDraft: uniqueIndex('uniq_guide_locale_draft').on(t.guideId, t.locale),
    guideIdx: index('tour_locale_draft_guide_idx').on(t.guideId),
  }),
)

export const guideLocale = studioSchema.table(
  'tour_locale',
  {
    id: uuid('id').defaultRandom().primaryKey(),

    // Parent
    guideId: uuid('tour_id')
      .notNull()
      .references(() => guide.id, { onDelete: 'cascade' }),
    locale: varchar('locale', { length: 10 }).notNull(),

    // Content (copied from draft on publish)
    title: varchar('title', { length: 500 }),
    description: text('description'),

    // Audit
    publishedAt: timestamp('published_at', { withTimezone: true }).defaultNow().notNull(),
    publishedBy: uuid('published_by').references(() => authUsers.id, { onDelete: 'set null' }),
  },
  (t) => ({
    uniqGuideLocale: uniqueIndex('uniq_guide_locale').on(t.guideId, t.locale),
    guideIdx: index('tour_locale_guide_idx').on(t.guideId),
  }),
)

export const stopLocaleDraft = studioSchema.table(
  'stop_locale_draft',
  {
    id: uuid('id').defaultRandom().primaryKey(),

    // Parent
    stopId: uuid('stop_id')
      .notNull()
      .references(() => stop.id, { onDelete: 'cascade' }),
    locale: varchar('locale', { length: 10 }).notNull(),

    // Content
    title: varchar('title', { length: 500 }),
    description: text('description'),
    transcription: text('transcription'),

    // Timestamps
    createdAt: timestamp('created_at', { withTimezone: true }).defaultNow().notNull(),
    updatedAt: timestamp('updated_at', { withTimezone: true })
      .defaultNow()
      .notNull()
      .$onUpdate(() => new Date()),
    updatedBy: uuid('updated_by').references(() => authUsers.id, { onDelete: 'set null' }),
  },
  (t) => ({
    uniqStopLocaleDraft: uniqueIndex('uniq_stop_locale_draft').on(t.stopId, t.locale),
    stopIdx: index('stop_locale_draft_stop_idx').on(t.stopId),
  }),
)

export const stopLocale = studioSchema.table(
  'stop_locale',
  {
    id: uuid('id').defaultRandom().primaryKey(),

    // Parent
    stopId: uuid('stop_id')
      .notNull()
      .references(() => stop.id, { onDelete: 'cascade' }),
    locale: varchar('locale', { length: 10 }).notNull(),

    // Content (copied from draft on publish)
    title: varchar('title', { length: 500 }),
    description: text('description'),
    transcription: text('transcription'),

    // Audit
    publishedAt: timestamp('published_at', { withTimezone: true }).defaultNow().notNull(),
    publishedBy: uuid('published_by').references(() => authUsers.id, { onDelete: 'set null' }),
  },
  (t) => ({
    uniqStopLocale: uniqueIndex('uniq_stop_locale').on(t.stopId, t.locale),
    stopIdx: index('stop_locale_stop_idx').on(t.stopId),
  }),
)

export const guideSettingsDraft = studioSchema.table(
  'tour_settings_draft',
  {
    id: uuid('id').defaultRandom().primaryKey(),

    // Parent (1:1)
    guideId: uuid('tour_id')
      .notNull()
      .references(() => guide.id, { onDelete: 'cascade' }),

    // Settings
    themeId: uuid('theme_id'), // FK to theme table if exists
    settingsJson: text('settings_json'), // JSON string for flexibility

    // Audit
    updatedAt: timestamp('updated_at', { withTimezone: true })
      .defaultNow()
      .notNull()
      .$onUpdate(() => new Date()),
    updatedBy: uuid('updated_by').references(() => authUsers.id, { onDelete: 'set null' }),
  },
  (t) => ({
    uniqGuideSettingsDraft: uniqueIndex('uniq_guide_settings_draft').on(t.guideId),
  }),
)

export const guideSettings = studioSchema.table(
  'tour_settings',
  {
    id: uuid('id').defaultRandom().primaryKey(),

    // Parent (1:1)
    guideId: uuid('tour_id')
      .notNull()
      .references(() => guide.id, { onDelete: 'cascade' }),

    // Settings (same as draft)
    themeId: uuid('theme_id'),
    settingsJson: text('settings_json'),

    // Audit
    publishedAt: timestamp('published_at', { withTimezone: true }).defaultNow().notNull(),
    publishedBy: uuid('published_by').references(() => authUsers.id, { onDelete: 'set null' }),
  },
  (t) => ({
    uniqGuideSettings: uniqueIndex('uniq_guide_settings').on(t.guideId),
  }),
)

export const stopSettingsDraft = studioSchema.table(
  'stop_settings_draft',
  {
    id: uuid('id').defaultRandom().primaryKey(),

    // Parent (1:1)
    stopId: uuid('stop_id')
      .notNull()
      .references(() => stop.id, { onDelete: 'cascade' }),

    // Settings
    coordinates: varchar('coordinates', { length: 100 }), // "lat,lng" or JSON
    settingsJson: text('settings_json'),

    // Audit
    updatedAt: timestamp('updated_at', { withTimezone: true })
      .defaultNow()
      .notNull()
      .$onUpdate(() => new Date()),
    updatedBy: uuid('updated_by').references(() => authUsers.id, { onDelete: 'set null' }),
  },
  (t) => ({
    uniqStopSettingsDraft: uniqueIndex('uniq_stop_settings_draft').on(t.stopId),
  }),
)

export const stopSettings = studioSchema.table(
  'stop_settings',
  {
    id: uuid('id').defaultRandom().primaryKey(),

    // Parent (1:1)
    stopId: uuid('stop_id')
      .notNull()
      .references(() => stop.id, { onDelete: 'cascade' }),

    // Settings (same as draft)
    coordinates: varchar('coordinates', { length: 100 }),
    settingsJson: text('settings_json'),

    // Audit
    publishedAt: timestamp('published_at', { withTimezone: true }).defaultNow().notNull(),
    publishedBy: uuid('published_by').references(() => authUsers.id, { onDelete: 'set null' }),
  },
  (t) => ({
    uniqStopSettings: uniqueIndex('uniq_stop_settings').on(t.stopId),
  }),
)

export const guideStopDraft = studioSchema.table(
  'tour_stop_draft',
  {
    id: uuid('id').defaultRandom().primaryKey(),

    // Parent
    guideId: uuid('tour_id')
      .notNull()
      .references(() => guide.id, { onDelete: 'cascade' }),
    stopId: uuid('stop_id')
      .notNull()
      .references(() => stop.id, { onDelete: 'cascade' }),

    // Order & visibility
    position: integer('position').notNull(),
    visible: boolean('visible').notNull().default(true),

    // Timestamps
    createdAt: timestamp('created_at', { withTimezone: true }).defaultNow().notNull(),
  },
  (t) => ({
    uniqGuideStopDraft: uniqueIndex('uniq_guide_stop_draft').on(t.guideId, t.stopId),
    guideIdx: index('tour_stop_draft_guide_idx').on(t.guideId),
    stopIdx: index('tour_stop_draft_stop_idx').on(t.stopId),
    positionIdx: index('tour_stop_draft_position_idx').on(t.guideId, t.position),
  }),
)

export const guideStop = studioSchema.table(
  'tour_stop',
  {
    id: uuid('id').defaultRandom().primaryKey(),

    // Parent
    guideId: uuid('tour_id')
      .notNull()
      .references(() => guide.id, { onDelete: 'cascade' }),
    stopId: uuid('stop_id')
      .notNull()
      .references(() => stop.id, { onDelete: 'cascade' }),

    // Order & visibility (same as draft)
    position: integer('position').notNull(),
    visible: boolean('visible').notNull().default(true),

    // Audit
    publishedAt: timestamp('published_at', { withTimezone: true }).defaultNow().notNull(),
  },
  (t) => ({
    uniqGuideStop: uniqueIndex('uniq_guide_stop').on(t.guideId, t.stopId),
    guideIdx: index('tour_stop_guide_idx').on(t.guideId),
    stopIdx: index('tour_stop_stop_idx').on(t.stopId),
    positionIdx: index('tour_stop_position_idx').on(t.guideId, t.position),
  }),
)

export const guideAssetDraft = studioSchema.table(
  'tour_asset_draft',
  {
    id: uuid('id').defaultRandom().primaryKey(),

    // Parent
    guideId: uuid('tour_id')
      .notNull()
      .references(() => guide.id, { onDelete: 'cascade' }),
    assetId: uuid('asset_id')
      .notNull()
      .references(() => asset.id, { onDelete: 'cascade' }),

    // Assignment context
    channel: varchar('channel', { length: 50 }).notNull(), // e.g., 'images.hero'
    locale: varchar('locale', { length: 10 }), // NULL = global
    position: integer('position').notNull().default(0),

    // Timestamps
    createdAt: timestamp('created_at', { withTimezone: true }).defaultNow().notNull(),
  },
  (t) => ({
    // One asset per channel+locale+position (or just channel+locale if position should be unique)
    uniqGuideAssetDraft: uniqueIndex('uniq_guide_asset_draft').on(
      t.guideId,
      t.assetId,
      t.channel,
      t.locale,
    ),
    guideIdx: index('tour_asset_draft_guide_idx').on(t.guideId),
    channelIdx: index('tour_asset_draft_channel_idx').on(t.guideId, t.channel),
    assetIdx: index('tour_asset_draft_asset_idx').on(t.assetId),
  }),
)

export const guideAsset = studioSchema.table(
  'tour_asset',
  {
    id: uuid('id').defaultRandom().primaryKey(),

    // Parent
    guideId: uuid('tour_id')
      .notNull()
      .references(() => guide.id, { onDelete: 'cascade' }),
    assetId: uuid('asset_id')
      .notNull()
      .references(() => asset.id, { onDelete: 'cascade' }),

    // Assignment context (same as draft)
    channel: varchar('channel', { length: 50 }).notNull(),
    locale: varchar('locale', { length: 10 }),
    position: integer('position').notNull().default(0),

    // Audit
    publishedAt: timestamp('published_at', { withTimezone: true }).defaultNow().notNull(),
  },
  (t) => ({
    uniqGuideAsset: uniqueIndex('uniq_guide_asset').on(t.guideId, t.assetId, t.channel, t.locale),
    guideIdx: index('tour_asset_guide_idx').on(t.guideId),
    channelIdx: index('tour_asset_channel_idx').on(t.guideId, t.channel),
    assetIdx: index('tour_asset_asset_idx').on(t.assetId),
  }),
)

export const stopAssetDraft = studioSchema.table(
  'stop_asset_draft',
  {
    id: uuid('id').defaultRandom().primaryKey(),

    // Parent
    stopId: uuid('stop_id')
      .notNull()
      .references(() => stop.id, { onDelete: 'cascade' }),
    assetId: uuid('asset_id')
      .notNull()
      .references(() => asset.id, { onDelete: 'cascade' }),

    // Assignment context
    channel: varchar('channel', { length: 50 }).notNull(),
    locale: varchar('locale', { length: 10 }),
    position: integer('position').notNull().default(0),

    // Timestamps
    createdAt: timestamp('created_at', { withTimezone: true }).defaultNow().notNull(),
  },
  (t) => ({
    uniqStopAssetDraft: uniqueIndex('uniq_stop_asset_draft').on(
      t.stopId,
      t.assetId,
      t.channel,
      t.locale,
    ),
    stopIdx: index('stop_asset_draft_stop_idx').on(t.stopId),
    channelIdx: index('stop_asset_draft_channel_idx').on(t.stopId, t.channel),
    assetIdx: index('stop_asset_draft_asset_idx').on(t.assetId),
  }),
)

export const stopAsset = studioSchema.table(
  'stop_asset',
  {
    id: uuid('id').defaultRandom().primaryKey(),

    // Parent
    stopId: uuid('stop_id')
      .notNull()
      .references(() => stop.id, { onDelete: 'cascade' }),
    assetId: uuid('asset_id')
      .notNull()
      .references(() => asset.id, { onDelete: 'cascade' }),

    // Assignment context (same as draft)
    channel: varchar('channel', { length: 50 }).notNull(),
    locale: varchar('locale', { length: 10 }),
    position: integer('position').notNull().default(0),

    // Audit
    publishedAt: timestamp('published_at', { withTimezone: true }).defaultNow().notNull(),
  },
  (t) => ({
    uniqStopAsset: uniqueIndex('uniq_stop_asset').on(t.stopId, t.assetId, t.channel, t.locale),
    stopIdx: index('stop_asset_stop_idx').on(t.stopId),
    channelIdx: index('stop_asset_channel_idx').on(t.stopId, t.channel),
    assetIdx: index('stop_asset_asset_idx').on(t.assetId),
  }),
)

import { relations } from 'drizzle-orm'

// Guide relations
export const guideRelations = relations(guide, ({ many, one }) => ({
  locales: many(guideLocale),
  settingsDraft: one(guideSettingsDraft, {
    fields: [guide.id],
    references: [guideSettingsDraft.guideId],
  }),
  settings: one(guideSettings, {
    fields: [guide.id],
    references: [guideSettings.guideId],
  }),
  stopsDraft: many(guideStopDraft),
  stops: many(guideStop),
  assetsDraft: many(guideAssetDraft),
  assets: many(guideAsset),
  creator: one(authUsers, {
    fields: [guide.createdBy],
    references: [authUsers.id],
    relationName: 'tour_creator',
  }),
  updater: one(authUsers, {
    fields: [guide.updatedBy],
    references: [authUsers.id],
    relationName: 'tour_updater',
  }),
}))

// Stop relations
export const stopRelations = relations(stop, ({ many, one }) => ({
  locales: many(stopLocale),
  settingsDraft: one(stopSettingsDraft, {
    fields: [stop.id],
    references: [stopSettingsDraft.stopId],
  }),
  settings: one(stopSettings, {
    fields: [stop.id],
    references: [stopSettings.stopId],
  }),
  guideStopsDraft: many(guideStopDraft),
  guideStops: many(guideStop),
  assetsDraft: many(stopAssetDraft),
  assets: many(stopAsset),
  creator: one(authUsers, {
    fields: [stop.createdBy],
    references: [authUsers.id],
    relationName: 'stop_creator',
  }),
  updater: one(authUsers, {
    fields: [stop.updatedBy],
    references: [authUsers.id],
    relationName: 'stop_updater',
  }),
}))

// Guide locale relations (staging pattern)
export const guideLocaleDraftRelations = relations(guideLocaleDraft, ({ one }) => ({
  guide: one(guide, {
    fields: [guideLocaleDraft.guideId],
    references: [guide.id],
  }),
  updater: one(authUsers, {
    fields: [guideLocaleDraft.updatedBy],
    references: [authUsers.id],
  }),
}))

export const guideLocaleRelations = relations(guideLocale, ({ one }) => ({
  guide: one(guide, {
    fields: [guideLocale.guideId],
    references: [guide.id],
  }),
  publisher: one(authUsers, {
    fields: [guideLocale.publishedBy],
    references: [authUsers.id],
  }),
}))

// Stop locale relations (staging pattern)
export const stopLocaleDraftRelations = relations(stopLocaleDraft, ({ one }) => ({
  stop: one(stop, {
    fields: [stopLocaleDraft.stopId],
    references: [stop.id],
  }),
  updater: one(authUsers, {
    fields: [stopLocaleDraft.updatedBy],
    references: [authUsers.id],
  }),
}))

export const stopLocaleRelations = relations(stopLocale, ({ one }) => ({
  stop: one(stop, {
    fields: [stopLocale.stopId],
    references: [stop.id],
  }),
  publisher: one(authUsers, {
    fields: [stopLocale.publishedBy],
    references: [authUsers.id],
  }),
}))

// Settings relations
export const guideSettingsDraftRelations = relations(guideSettingsDraft, ({ one }) => ({
  guide: one(guide, {
    fields: [guideSettingsDraft.guideId],
    references: [guide.id],
  }),
  updater: one(authUsers, {
    fields: [guideSettingsDraft.updatedBy],
    references: [authUsers.id],
  }),
}))

export const guideSettingsRelations = relations(guideSettings, ({ one }) => ({
  guide: one(guide, {
    fields: [guideSettings.guideId],
    references: [guide.id],
  }),
  publisher: one(authUsers, {
    fields: [guideSettings.publishedBy],
    references: [authUsers.id],
  }),
}))

export const stopSettingsDraftRelations = relations(stopSettingsDraft, ({ one }) => ({
  stop: one(stop, {
    fields: [stopSettingsDraft.stopId],
    references: [stop.id],
  }),
  updater: one(authUsers, {
    fields: [stopSettingsDraft.updatedBy],
    references: [authUsers.id],
  }),
}))

export const stopSettingsRelations = relations(stopSettings, ({ one }) => ({
  stop: one(stop, {
    fields: [stopSettings.stopId],
    references: [stop.id],
  }),
  publisher: one(authUsers, {
    fields: [stopSettings.publishedBy],
    references: [authUsers.id],
  }),
}))

// Structure relations
export const guideStopDraftRelations = relations(guideStopDraft, ({ one }) => ({
  guide: one(guide, {
    fields: [guideStopDraft.guideId],
    references: [guide.id],
  }),
  stop: one(stop, {
    fields: [guideStopDraft.stopId],
    references: [stop.id],
  }),
}))

export const guideStopRelations = relations(guideStop, ({ one }) => ({
  guide: one(guide, {
    fields: [guideStop.guideId],
    references: [guide.id],
  }),
  stop: one(stop, {
    fields: [guideStop.stopId],
    references: [stop.id],
  }),
}))

// Asset relations
export const assetRelations = relations(asset, ({ one }) => ({
  uploader: one(authUsers, {
    fields: [asset.uploadedBy],
    references: [authUsers.id],
  }),
  org: one(organization, {
    fields: [asset.organizationId],
    references: [organization.id],
  }),
}))

export const guideAssetDraftRelations = relations(guideAssetDraft, ({ one }) => ({
  guide: one(guide, {
    fields: [guideAssetDraft.guideId],
    references: [guide.id],
  }),
  asset: one(asset, {
    fields: [guideAssetDraft.assetId],
    references: [asset.id],
  }),
}))

export const guideAssetRelations = relations(guideAsset, ({ one }) => ({
  guide: one(guide, {
    fields: [guideAsset.guideId],
    references: [guide.id],
  }),
  asset: one(asset, {
    fields: [guideAsset.assetId],
    references: [asset.id],
  }),
}))

export const stopAssetDraftRelations = relations(stopAssetDraft, ({ one }) => ({
  stop: one(stop, {
    fields: [stopAssetDraft.stopId],
    references: [stop.id],
  }),
  asset: one(asset, {
    fields: [stopAssetDraft.assetId],
    references: [asset.id],
  }),
}))

export const stopAssetRelations = relations(stopAsset, ({ one }) => ({
  stop: one(stop, {
    fields: [stopAsset.stopId],
    references: [stop.id],
  }),
  asset: one(asset, {
    fields: [stopAsset.assetId],
    references: [asset.id],
  }),
}))

// Base entities
export type Guide = typeof guide.$inferSelect
export type NewGuide = typeof guide.$inferInsert
export type Stop = typeof stop.$inferSelect
export type NewStop = typeof stop.$inferInsert
export type Asset = typeof asset.$inferSelect
export type NewAsset = typeof asset.$inferInsert
export type AssetType = (typeof assetType.enumValues)[number]

// Locale text (staging)
export type GuideLocaleDraft = typeof guideLocaleDraft.$inferSelect
export type GuideLocale = typeof guideLocale.$inferSelect
export type StopLocaleDraft = typeof stopLocaleDraft.$inferSelect
export type StopLocale = typeof stopLocale.$inferSelect

// Settings (staging)
export type GuideSettingsDraft = typeof guideSettingsDraft.$inferSelect
export type GuideSettings = typeof guideSettings.$inferSelect
export type StopSettingsDraft = typeof stopSettingsDraft.$inferSelect
export type StopSettings = typeof stopSettings.$inferSelect

// Structure (staging)
export type GuideStopDraft = typeof guideStopDraft.$inferSelect
export type GuideStop = typeof guideStop.$inferSelect

// Assets (staging)
export type GuideAssetDraft = typeof guideAssetDraft.$inferSelect
export type GuideAsset = typeof guideAsset.$inferSelect
export type StopAssetDraft = typeof stopAssetDraft.$inferSelect
export type StopAsset = typeof stopAsset.$inferSelect