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