skyXReal

Tables (6)

Building

  • buildingID — VARCHAR(36) — Primary key — NOT NULL
  • buildingName — VARCHAR(50)
  • latitude — DECIMAL(13,10)
  • longitude — DECIMAL(13,10)
  • radius — INT
  • height — INT

Favorite

  • favoriteID — VARCHAR(36) — Primary key — NOT NULL
  • buildingID (buildingID2) — VARCHAR(36) — Foreign key → Building.buildingID — NOT NULL
  • id — VARCHAR(20) — Foreign key → User.id — NOT NULL
  • favoriteName — VARCHAR(20)
  • updatedAt — DATETIME

Flight

  • flightID — VARCHAR(36) — Primary key — NOT NULL
  • id — VARCHAR(20) — Foreign key → User.id — NOT NULL
  • originID — VARCHAR(36) — Foreign key → Building.buildingID — NOT NULL
  • destinationID — VARCHAR(36) — Foreign key → Building.buildingID — NOT NULL
  • updatedAt — DATETIME

FlightLog

  • flightLogID — VARCHAR(36) — Primary key — NOT NULL
  • flightID — VARCHAR(36) — Foreign key → Flight.flightID — NOT NULL
  • latitude — DECIMAL(13,10)
  • longitude — DECIMAL(13,10)
  • altitude — INT
  • speed — INT

Recent

  • recentID — VARCHAR(36) — Primary key — NOT NULL
  • buildingID — VARCHAR(36) — Foreign key → Building.buildingID — NOT NULL
  • id — VARCHAR(20) — Foreign key → User.id — NOT NULL
  • updatedAt — DATETIME

User

  • id — VARCHAR(20) — Primary key — NOT NULL
  • password — VARCHAR(100)
  • nickname — VARCHAR(20)
  • profileURL — VARCHAR(100)
  • updatedAt — DATETIME