module.exports = {
  tableName: 'travelogue_poi',

  attributes: {
    id: { type: 'number', autoIncrement: true, },

    title: {
      type: 'string',
    },

    latin: {
      type: 'string',
      allowNull: true
    },

    sortable: {
      type: 'string',
    },

    lon: {
      type: 'number',
    },

    lat: {
      type: 'number',
    },

    granularity: {
      type: 'number',
    },

    desc: {
      type: 'string',
      allowNull: true
    },

    flagAmbiguous: {
      columnName: 'flag_ambiguous',
      type: 'boolean',
      defaultsTo: false
    },

    flagRuined: {
      columnName: 'flag_ruined',
      type: 'boolean',
      defaultsTo: false
    },

    state: {
      type: 'string',
    },

    deleted: {
      type: 'boolean',
      defaultsTo: false
    },

    createdAt: { type: 'ref', columnName: 'created_at', columnType: 'timestamp', autoCreatedAt: true, },
    updatedAt: { type: 'ref', columnName: 'updated_at', columnType: 'timestamp', autoCreatedAt: true, },

    parent: {
      model: 'TraveloguePoi'
    },

    operator: {
      model: 'User'
    },

    revOf: {
      columnName: 'rev_of',
      model: 'TraveloguePoi'
    },

    head: {
      model: 'TraveloguePoi'
    },

    revisions: {
      collection: 'TraveloguePoi',
      via: 'revOf'
    },

    // notes: {
    //   collection: 'TravelogueNote',
    //   via: 'poi'
    // },

    altNames: {
      collection: 'TraveloguePoiName',
      via: 'poi'
    },
  },
};