import {
  Column,
  CreateDateColumn,
  DeleteDateColumn,
  Entity,
  JoinColumn,
  ManyToOne,
  PrimaryGeneratedColumn,
  UpdateDateColumn,
} from 'typeorm';
import { Application } from './application.entity';

/**
 * Family members / relations listed in an application
 * Maps to old table: application_relations
 */
@Entity({ name: 'application_relations' })
export class ApplicationRelation {
  @PrimaryGeneratedColumn('uuid')
  id!: string;

  @Column({ type: 'varchar', name: 'application_id' })
  applicationId!: string;

  @ManyToOne(() => Application, (a) => a.relations, { onDelete: 'CASCADE' })
  @JoinColumn({ name: 'application_id' })
  application!: Application;

  // savings subscription reference
  @Column({ type: 'varchar', name: 'subscription_id', nullable: true })
  subscriptionId?: string;

  // 'father' | 'mother' | 'spouse' | 'son' | 'daughter' | 'brother' | 'sister' | 'other'
  @Column({ type: 'varchar', nullable: true })
  relation?: string;

  @Column({ type: 'varchar', nullable: true })
  name?: string;

  @Column({ type: 'varchar', nullable: true })
  gender?: string;

  @Column({ type: 'varchar', name: 'marital_status', nullable: true })
  maritalStatus?: string;

  @Column({ type: 'varchar', name: 'citizenship_number', nullable: true })
  citizenshipNumber?: string;

  @Column({ type: 'varchar', name: 'citizenship_issue_district', nullable: true })
  citizenshipIssueDistrict?: string;

  @Column({ type: 'varchar', name: 'citizenship_issue_date_bs', length: 20, nullable: true })
  citizenshipIssueDateBs?: string;

  @Column({ type: 'varchar', name: 'citizenship_issue_date', length: 20, nullable: true })
  citizenshipIssueDate?: string;

  @Column({ type: 'varchar', name: 'contact_number', nullable: true })
  contactNumber?: string;

  @Column({ type: 'varchar', nullable: true })
  age?: string;

  @Column({ type: 'varchar', nullable: true })
  occupation?: string;

  @Column({ type: 'varchar', name: 'second_generation', nullable: true })
  secondGeneration?: string;

  @Column({ type: 'varchar', name: 'second_generation_name', nullable: true })
  secondGenerationName?: string;

  @Column({ type: 'varchar', name: 'third_generation', nullable: true })
  thirdGeneration?: string;

  @Column({ type: 'varchar', name: 'third_generation_name', nullable: true })
  thirdGenerationName?: string;

  @Column({ default: 0 })
  order!: number;

  @Column({ type: 'varchar', name: 'created_by', nullable: true })
  createdBy?: string;

  @Column({ type: 'varchar', name: 'updated_by', nullable: true })
  updatedBy?: string;

  @CreateDateColumn({ name: 'created_at' })
  createdAt!: Date;

  @UpdateDateColumn({ name: 'updated_at' })
  updatedAt!: Date;

  @DeleteDateColumn({ name: 'deleted_at' })
  deletedAt?: Date;
}