import { BaseEntity, Column, Entity, PrimaryGeneratedColumn } from 'typeorm';

@Entity('customer_savings')
export class CustomerSavings extends BaseEntity {
  @PrimaryGeneratedColumn({
    comment: 'the unique identifier',
  })
  idCustomer_Savings: number;

  @Column({
    type: 'int',
    nullable: false,
  })
  Customer_idCustomer: number;

  @Column({
    type: 'varchar',
    length: 45,
    nullable: true,
  })
  Saving_Account_No: string;

  @Column({
    type: 'varchar',
    length: 45,
    nullable: true,
  })
  Saving_Account_Balance: string;

  @Column({
    type: 'varchar',
    length: 45,
    nullable: false,
  })
  Created_Date_Time: string;

  @Column({
    type: 'varchar',
    length: 45,
    nullable: false,
  })
  Last_Updated_Time: string;

  @Column({
    type: 'varchar',
    length: 45,
    nullable: false,
  })
  Saving_TopUp_Type: string;

  @Column({
    type: 'varchar',
    length: 45,
    nullable: false,
  })
  Saving_TopUp_Value: string;

  @Column({
    type: 'varchar',
    length: 45,
    nullable: false,
  })
  Saving_Goal_Type: string;

  @Column({
    type: 'varchar',
    length: 45,
    nullable: false,
  })
  Saving_Goal_Duration: string;

  @Column({
    type: 'varchar',
    length: 45,
    nullable: false,
  })
  Saving_Goal_End_Date: string;

  @Column({
    type: 'varchar',
    length: 45,
    nullable: false,
  })
  Saving_Goal_Amount: string;
}
