import { Entity, Column, PrimaryGeneratedColumn } from "typeorm";

@Entity("EMPLOYEE")
export class EMPLOYEE {
  @PrimaryGeneratedColumn()
  id!: number;

  //   @Column({
  //     nullable: true,
  //     type: "text",
  //     default: null,
  //   })
  //   RET_YEAR: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  ID: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  CIT: string;

  // @Column({
  //   nullable: true,
  //   type: "text",
  //   default: null,
  // })
  // MP_CATEGORY: string;

  // @Column({
  //   nullable: true,
  //   type: "text",
  //   default: null,
  // })
  // MP_LEVEL: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  BORN: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  RANK_NAME: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  FNAME: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  LNAME: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  BEGIN_ENTRY_DATE: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  SEX: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  WORK_LINE_NAME: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  SALARY: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  DEPARTMENT_NAME: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  DEPARTMENT_CODE: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  DIVISION_NAME: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  DIVISION_CODE: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  SECTION_NAME: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  SECTION_CODE: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  JOB_NAME: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  JOB_CODE: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  POS_NUM_CODE: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  POS_NUM_NAME: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  CATEGORY_SAL_CODE: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  SALARY_LEVEL_CODE: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  LEVEL_NAME: string;

  @Column({
    nullable: true,
    type: "text",
    default: null,
  })
  WORK_LEVEL: string;
}
