project-nomad/admin/app/models/map_marker.ts

import { DateTime } from 'luxon'
import { BaseModel, column, SnakeCaseNamingStrategy } from '@adonisjs/lucid/orm'

export default class MapMarker extends BaseModel {
  static namingStrategy = new SnakeCaseNamingStrategy()

  @column({ isPrimary: true })
  declare id: number

  @column()
  declare name: string

  @column()
  declare longitude: number

  @column()
  declare latitude: number

  @column()
  declare color: string

  // 'pin' for user-placed markers, 'waypoint' for route points (future)
  @column()
  declare marker_type: string

  // Groups markers into a route (future)
  @column()
  declare route_id: string | null

  // Order within a route (future)
  @column()
  declare route_order: number | null

  // Optional user notes for a location
  @column()
  declare notes: string | null

  @column()
  declare custom_color: string | null

  @column()
  declare icon: string | null

  @column()
  declare icon_color: string | null

  @column({
    // MySQL stores this as tinyint(1) and mysql2 hands back 1/0, not true/false.
    // Without this, strict comparisons (visible === false) silently never match.
    consume: (value: number | boolean) => Boolean(value),
  })
  declare visible: boolean

  @column.dateTime({ autoCreate: true })
  declare created_at: DateTime

  @column.dateTime({ autoCreate: true, autoUpdate: true })
  declare updated_at: DateTime
}