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