Raillo
Tables (6)
Booking (booking)
- id (Key) — Primary key — NOT NULL
- memberId (Field)
- orderId (Key2) — Foreign key → Order.id — NOT NULL
- trainSchedule (Field2)
- departureStop (Field3)
- arrivalStop (Field4)
- bookingStatus (Field5)
- totalFare (Field7)
Order (order)
- id (Key) — Primary key — NOT NULL
- memberId (Field)
- orderCode (Field3)
- orderStatus (Field6)
- totalAmount (Field5)
OrderBooking (orderBooking)
- id (Key) — Primary key — NOT NULL
- orderId (Key2) — Foreign key → Order.id — NOT NULL
- trainSchedule (Field2)
- departureStop (Field5)
- arrivalStop (Field6)
OrderSeatBooking (orderSeatBooking)
- id (Key) — Primary key — NOT NULL
- orderBookingId (Key2) — Foreign key → OrderBooking.id — NOT NULL
- seatId (Field2)
- passengerType (Field4)
- amount (Field)
Payment (payment)
- id (Key) — Primary key — NOT NULL
- memberId (Field)
- orderId (Key2) — Foreign key → Order.id — NOT NULL
- paymentKey (Field4)
- paymentMethod (Field6)
- paymentStatus (Field7)
- amount (Field5)
SeatBooking (seatBooking)
- id (Key) — Primary key — NOT NULL
- bookingId (Key2) — Foreign key → Booking.id — NOT NULL
- seatId (Field2)
- passengerType (Field4)