Skip to content

Project NOMAD is an offline-first knowledge and education server. Wikipedia, thousands of books, courses, maps, and optional local AI, all running on hardware you own with no internet required.

TypeScript
1.3 KB
Raw Blame
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
}