import {Entity, Column, RelationId, PrimaryGeneratedColumn, CreateDateColumn, UpdateDateColumn, ManyToOne, JoinColumn} from 'typeorm';
import Consumable from './ConsumableEntity';
import ConsumableGroup from './ConsumableGroupEntity';
import BaseModel from '../../model/common/interfaces/BaseModel';

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

    @ManyToOne(type => Consumable)
    @JoinColumn()
    consumable: Consumable;

    @RelationId((consumableTotal: ConsumableTotal) => consumableTotal.consumable)
    consumableId: number;

    @ManyToOne(type => ConsumableGroup)
    @JoinColumn()
    consumableGroup: ConsumableGroup;

    @RelationId((consumableTotal: ConsumableTotal) => consumableTotal.consumableGroup)
    consumableGroupId: number;

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

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

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