import {Entity, Column, RelationId, PrimaryGeneratedColumn, CreateDateColumn, UpdateDateColumn, ManyToOne, JoinColumn} from 'typeorm';
import Personnel from './PersonnelEntity';
import PersonnelSub from './PersonnelSubEntity';
import BaseModel from '../../model/common/interfaces/BaseModel';

@Entity()
export default class PersonnelTotal extends BaseModel {
    @PrimaryGeneratedColumn()
    id: number;

    @ManyToOne(type => Personnel)
    @JoinColumn()
    personnel: Personnel;

    @RelationId((personnelTotal: PersonnelTotal) => personnelTotal.personnel)
    personnelId: number;

    @ManyToOne(type => PersonnelSub)
    @JoinColumn()
    personnelSub: PersonnelSub;

    @RelationId((personnelTotal: PersonnelTotal) => personnelTotal.personnelSub)
    personnelSubId: number;

    @Column({
        type: 'integer'
    })
    month: number;

    @Column({
        type: 'integer'
    })
    year: number;

    @Column({
        type: 'integer'
    })
    value: number;
}