db

Tables (3)

City (Untitled4)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • nation_id (Key2) — NOT NULL — Foreign key → Nation.id — NOT NULL
  • name (Field) — NOT NULL
  • city_img_url (Field2) — NOT NULL

Nation (Untitled3)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • name (Field) — NOT NULL
  • flag_img_url (Field2) — NOT NULL
  • border_level (Field3) — INTEGER
  • border_description (Field4) — NOT NULL

Review (Untitled2)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • nation_id (Key3) — NOT NULL — Foreign key → Nation.id — NOT NULL
  • author (Key2) — NOT NULL — NOT NULL
  • title (Field) — NOT NULL
  • content (Field2) — NOT NULL
  • rating (Field3) — NOT NULL
  • covid_after (Field4) — NOT NULL