import { City } from "src/modules/city/entities/city.entity"
import { Country } from "src/modules/country/entities/country.entity"
import { FleetManagement } from "src/modules/fleet-management/entities/fleet-management.entity"
import { Hospital } from "src/modules/hospitals/entities/hospital.entity"
import { Address } from "src/modules/team-member/entities/address.entity"
import { TeamMember } from "src/modules/team-member/entities/team_member.entity"
import {
  Entity,
  PrimaryGeneratedColumn,
  Column,
  ManyToOne,
  JoinColumn,
  CreateDateColumn,
  DeleteDateColumn,
  UpdateDateColumn,
  OneToMany,
  Index,
} from "typeorm"

@Entity("states")
export class State {
  @PrimaryGeneratedColumn()
  @Index()
  id: number

  @Column({ type: "varchar", nullable: false })
  @Index()
  name: string

  @Column({ type: "int" })
  country_id: number

  @DeleteDateColumn()
  deleted_at: Date

  @CreateDateColumn({ type: "timestamp", default: () => "NOW()" })
  created_at: Date

  @UpdateDateColumn({ type: "timestamp", default: () => "NOW()" })
  updated_at: Date

  @ManyToOne(() => Country, (country) => country.states, {
    onDelete: "RESTRICT",
  })
  @JoinColumn({ name: "country_id" })
  country: Country

  @OneToMany(() => City, (city) => city.state)
  cities: City[]

  @OneToMany(() => FleetManagement, (fleet) => fleet.state_details)
  fleet: FleetManagement

  @OneToMany(() => FleetManagement, (location) => location.vehicle_location)
  fleet_location: FleetManagement

  @OneToMany(() => Hospital, (hospital) => hospital.state)
  hospitals: Hospital[]

  @OneToMany(() => TeamMember, (team_member) => team_member.state)
  team_member: TeamMember

  @OneToMany(() => Address, (address) => address.state)
  addresses: Address[]
}