triplan

Tables (4)

Untitled (User)

  • Key (userid) — long int — Primary key — NOT NULL
  • Field (email) — string

Untitled (DayPlan)

  • Field (departure) — string
  • Field (placeList) — List<TripPlace>
  • Field (destination) — TripPlace

Untitled (TripPlace)

  • Field (name) — string
  • Field (location) — string
  • Field (transferTime) — int
  • Field (transport) — string
  • Field (fee) — int
  • Field (leadTime) — int

Untitled2 (Plan)

  • Key (planid) — long int — Primary key — NOT NULL
  • Key (userid) — long int — Foreign key → Untitled.Key — NOT NULL
  • Field (startDate) — DateTime
  • Field2 (endDate) — DateTime
  • Field3 (feedback) — int
  • Field (feedbackNumber) — int
  • Field (dayPlanList) — List<DayPlan>