kombo_test_jin

Tables (5)

City

  • id (Key) — Int — Primary key — NOT NULL
  • name (text) — Object
  • lat (Field7) — Float
  • lng (Field8) — Float
  • Stations (Field9) — Station
  • FromTickets (Field10) — Ticket
  • ToTickets (Field11) — Ticket

CityName (Untitled4)

  • fr (Field) — String
  • en (Field2) — String
  • es (Field3) — String
  • de (Field4) — String
  • nl (Field5) — String
  • it (Field6) — String
  • pt (Field7) — String
  • key (Key) — Int — Foreign key → City.id — NOT NULL

Station (Untitled)

  • id (Key) — Int — Primary key — NOT NULL
  • CityId (Key2) — Int — Foreign key → City.id — NOT NULL
  • name (Field) — String
  • address (Field2) — String
  • lat (Field3) — Float
  • lng (Field4) — Float
  • CityId (Field5) — Int
  • City (Field6) — City
  • FromTickets (Field7) — Ticket
  • ToTickets (Field8) — Ticket

Ticket (Untitled3)

  • id (Key4) — Int — Primary key — NOT NULL
  • ToCityId (Key) — Int — Primary key — NOT NULL
  • FromCityId (Key3) — Int — Foreign key → City.id — NOT NULL
  • FromStationId (Key2) — Int — Foreign key → Station.id — NOT NULL
  • ToStationId (Key22) — Int — Foreign key → Station.CityId — NOT NULL
  • OwnerId (Key5) — Int — Foreign key → User.Id — NOT NULL
  • traintype (Field10) — String
  • Owner (Field) — User
  • number (Field2) — Int
  • FromCity (Field3) — City
  • ToCity (Field4) — City
  • FromStation (Field5) — Station
  • ToStation (Field6) — Station
  • createdAt (Field7) — String
  • updatedAt (Field8) — String
  • deletedAt (Field9) — String

User (Untitled2)

  • Id (Key) — Int — Primary key — NOT NULL
  • email (Key2) — String — Primary key — NOT NULL
  • firstName (Field) — String
  • lastName (Field2) — String
  • Tickets (Field3) — Ticket
  • createdAt (Field4) — String
  • updatedAt (Field5) — String
  • deletedAt (Field6) — String