import {
  AllowNull,
  Column,
  CreatedAt,
  DataType,
  Index,
  Model,
  PrimaryKey,
  Table,
  UpdatedAt,
} from 'sequelize-typescript';

@Table
export class SoftwareUpgradeProposal extends Model<SoftwareUpgradeProposal> {
  @PrimaryKey
  @Column(DataType.UUID)
  id: string;

  @AllowNull(true)
  @Column(DataType.STRING)
  title: string;

  @AllowNull(true)
  @Column(DataType.STRING)
  description: string;

  @Column(DataType.STRING)
  from: string;

  @Column(DataType.STRING)
  proposer: string;

  @Column(DataType.STRING)
  name: string;

  @Column(DataType.STRING)
  time: string;

  @Index({
    name: 'SUP-blockId-index',
    using: 'BTREE',
  })
  @Column(DataType.BIGINT)
  blockId: number;

  @Index({
    name: 'SUP-txHash-index',
    using: 'HASH',
  })
  @Column(DataType.STRING)
  txHash: string;

  @CreatedAt
  createdAt: Date;

  @UpdatedAt
  updatedAt: Date;
}