shoooong-erd

Tables (5)

FlightRecords (flight_records)

  • recordId (record_id) — NOT NULL — Primary key — NOT NULL
  • timeStamp (time_stamp) — NOT NULL
  • posX (Field) — NOT NULL
  • posY (Field2) — NOT NULL
  • posZ (Field3) — NOT NULL
  • rotX (Field4) — NOT NULL
  • rotY (Field5) — NOT NULL
  • rotZ (Field6) — NOT NULL
  • sequence (Field7) — NOT NULL
  • timestampUnixMs (Field8) — NOT NULL
  • elapsedTimeSeconds (Field9) — NOT NULL
  • flightId (flight_id) — NOT NULL — Foreign key → Flights.flightId — NOT NULL

Flights

  • flightId (flight_id) — NOT NULL — Primary key — NOT NULL
  • startedAt (created_at) — NOT NULL
  • finishedAt (Field)
  • flightStatus (flight_status) — NOT NULL
  • isCrashed (Field2) — NOT NULL
  • orderId (order_id) — NOT NULL — Foreign key → Orders.orderId — NOT NULL

Members (members)

  • memberId (member_id) — NOT NULL — Primary key — NOT NULL
  • name — NOT NULL
  • loginId (user_id) — NOT NULL
  • password — NOT NULL
  • createdAt — NOT NULL

Orders (orders)

  • orderId (order_id) — NOT NULL — Primary key — NOT NULL
  • rating
  • score
  • totalFlighTime (total_flight_time)
  • averageTilt (average_tilt)
  • remainWaypointCnt (Field) — NOT NULL
  • orderStatus (order_status) — NOT NULL
  • createdAt (created_at) — NOT NULL
  • memberId (member_id) — NOT NULL — Foreign key → Members.memberId — NOT NULL

WayPoints (way_points)

  • wayPointId (Key) — NOT NULL — Primary key — NOT NULL
  • passedTime (Field2)
  • orderId (order_id) — NOT NULL — Foreign key → Orders.orderId — NOT NULL
  • posX (Field) — NOT NULL
  • posY (Field3) — NOT NULL
  • posZ (Field4) — NOT NULL