import { Model, DataTypes, CreationOptional, ForeignKey } from 'sequelize';
import { client as sequelize } from 'lib/DB/connection';
import type { DNC } from '../DNC';

export class Duplicate extends Model {
	declare id: number;
	declare createdAt: CreationOptional<Date>;
	declare updatedAt: CreationOptional<Date>;

	// ASSOCIATION
	declare DNCId: ForeignKey<DNC['id']>;
}

Duplicate.init(
	{
		id: {
			type: DataTypes.BIGINT,
			autoIncrement: true,
			primaryKey: true,
		},

		createdAt: DataTypes.DATE,

		updatedAt: DataTypes.DATE,

		deletedAt: DataTypes.DATE,
	},
	{
		sequelize,
		paranoid: true,
		timestamps: true,
		tableName: 'duplicates',
	}
);