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)