kombo_test_jin - 2021-11-11 21:25:34

Tables (4)

City

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

Station (Untitled)

  • id (Key) — Int — Primary key — NOT NULL
  • CityId (Key2) — Int — Foreign key — 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 — NOT NULL
  • FromStationId (Key2) — Int — Foreign key — NOT NULL
  • ToStationId (Key22) — Int — Foreign key — NOT NULL
  • OwnerId (Key5) — Int — Foreign key — 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