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