Sequelize existing database fields mapping

sequelize-field-mapping.ts

/*
    How to map fields from an existing database to a Sequelize model with:
    - @Table({ tableName: '...' })
    - @Column({ field: '...' })
*/

import {
  Sequelize,
  Table,
  Model,
  Column,
  PrimaryKey,
  AllowNull,
  IsInt,
  IsUUID,
  DataType,
  Default
} from "sequelize-typescript";

@Table({ tableName: "QWFPG" })
class CustomerModel extends Model<CustomerModel> {
  @PrimaryKey
  @IsUUID(4)
  @Default(DataType.UUIDV4)
  @Column
  id: string;

  @IsInt
  @AllowNull(false)
  @Column({ field: "ARSTD" })
  soldTo: number;

  @AllowNull(false)
  @Column({ field: "ZXCVB" })
  name: string;
}

const sequelize = new Sequelize({
  logging: false,
  dialect: "sqlite",
  storage: "./database.sqlite"
});
sequelize.addModels([CustomerModel]);

sequelize.sync().then(async () => {
  console.log("model synced");
  const customer = new CustomerModel({ name: "test", soldTo: 123 });
  await customer.save();
});