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>