schema.prisma

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

generator client {
  provider = "prisma-client-js"
}

model Continent {
  id        String   @id @default(cuid())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  name String
  code String @unique

  countries Country[]
}

model Currency {
  id        String   @id @default(cuid())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  code           String @unique
  name           String
  name_plural    String
  symbol         String
  symbol_native  String
  decimal_digits Int
  rounding       Int

  countries Country[]
}

model Country {
  id        Int      @id
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  name            String
  alpha2Code      String
  alpha3Code      String
  numberCode      Int
  nativeName      String
  continentCode   String
  capital         String
  phoneNumberCode String
  currencyCode    String?
  timezone        String[]

  flag      Flag?
  states    State[]
  languages Language[]
  currency  Currency?  @relation(fields: [currencyCode], references: [code])
  continent Continent  @relation(fields: [continentCode], references: [code])
}

model Flag {
  id        String   @id @default(cuid())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  countryId Int    @unique
  emoji     String
  unicode   String
  image     String

  country Country @relation(fields: [countryId], references: [id])
}

model State {
  id        String   @id @default(cuid())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  countryId Int
  name      String

  country Country @relation(fields: [countryId], references: [id])
}

model Language {
  id        String   @id @default(cuid())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  countryId  Int
  name       String
  ianaCode   String
  alpha2Code String
  nativeName String

  country Country @relation(fields: [countryId], references: [id])
}