import { Entity, Column, PrimaryGeneratedColumn, CreateDateColumn, UpdateDateColumn, DeleteDateColumn, OneToMany, ManyToOne, JoinColumn, OneToOne } from 'typeorm';
import { Exclude, Expose } from 'class-transformer';
import { Users } from './users.entity';
import { Subscription } from './subscription.entity';

@Entity({ name: 'user_permissions' })
export class UserPermissions {
  @PrimaryGeneratedColumn('uuid')
  id: string;

  @ManyToOne(() => Users, (user) => user.permissions)
  users: Users;

  @ManyToOne(() => Subscription, (subscription) => subscription.id)
  subscription: Subscription;

  @Column({ nullable: true })
  type: string;

  @Column({ type: 'int', default: 0 })
  limit: number;

  @Column({ type: 'int', default: 0 })
  used: number;

  @Column({ type: 'int', default: 0 })
  remaining: number;

  @Column({ type: 'varchar', length: 255, nullable: true })
  time_period: string;

  @Column({ type: 'timestamp', nullable: true })
  expires_at: Date;

  @Exclude()
  @CreateDateColumn({ type: 'timestamp', precision: 0, default: () => 'CURRENT_TIMESTAMP' })
  created_at: Date;
}
