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

@Entity({ name: 'clients__clientdatas' })
export class ClientDataEntity {
  @PrimaryGeneratedColumn()
  id: number; // Primary Key

  @Column({ type: 'int', nullable: false })
  user_id: number;

  @Column({ type: 'int', nullable: true })
  location: number;

  @Column({ type: 'text', nullable: true })
  standard_name: string;

  @Column({ type: 'int', nullable: true })
  client_type: number;

  @Column({ type: 'int', nullable: true })
  country_name: number;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  @Column({ nullable: true })
  signed_docs: string;
  
  @Column({ nullable: true })
  signeddocsname: string;

  @Column({ type: 'tinyint', nullable: true, default: 0 })
  status: number;

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

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