Skip to main content

Weather Entities

Entities for comprehensive weather tracking, lunar data, tides, and fishing conditions.

LocationWeatherHistory​

Purpose: Historical weather data for specific locations.

Key Fields:

  • Id (int): Unique identifier
  • Latitude, Longitude: Location coordinates
  • Date: Weather date
  • TemperatureC: Air temperature
  • FeelsLikeC: Feels-like temperature
  • BarometricPressureHpa: Barometric pressure
  • PressureTrend: Rising, Falling, Stable
  • WindSpeedKph, WindDirectionDeg: Wind data
  • WindGustKph: Wind gusts
  • PrecipitationMm: Precipitation amount
  • PrecipitationType: Rain, Snow, etc.
  • CloudCoverPercent: Cloud cover
  • HumidityPercent: Humidity
  • UVIndex: UV index
  • VisibilityKm: Visibility
  • Source: Weather data source

Relationships:

  • One-to-many: FishingConditionsRating

LunarData​

Purpose: Moon phase and solunar data.

Key Fields:

  • Id (int): Unique identifier
  • Date: Date
  • Latitude, Longitude: Location
  • MoonPhase: New, Full, Quarters, etc.
  • Moonrise, Moonset: Moon times
  • MoonIlluminationPercent: Illumination percentage
  • MajorFeedingTime1, MajorFeedingTime2: Major feeding times
  • MinorFeedingTime1, MinorFeedingTime2: Minor feeding times

Relationships:

  • One-to-many: FishingConditionsRating

TideData​

Purpose: Tide information for coastal/marine locations.

Key Fields:

  • Id (int): Unique identifier
  • Date: Date
  • Latitude, Longitude: Location
  • HighTideTime1, HighTideTime2: High tide times
  • LowTideTime1, LowTideTime2: Low tide times
  • HighTideHeightM, LowTideHeightM: Tide heights
  • TideRange: Spring, Neap, Normal
  • CurrentSpeedKts: Current speed
  • CurrentDirectionDeg: Current direction
  • IsIncomingTide: Incoming/outgoing flag

Relationships:

  • One-to-many: FishingConditionsRating

FishingConditionsRating​

Purpose: Calculated overall fishing conditions rating.

Key Fields:

  • Id (int): Unique identifier
  • LocationWeatherHistoryId: Weather data
  • LunarDataId: Lunar data
  • TideDataId: Tide data (optional)
  • OverallRating: Overall conditions rating (1-10)
  • WeatherRating: Weather rating
  • MoonRating: Moon phase rating
  • TideRating: Tide rating
  • PressureRating: Barometric pressure rating
  • WindRating: Wind rating
  • TemperatureRating: Temperature rating

Relationships:

  • Many-to-one: LocationWeatherHistory, LunarData, TideData (optional)

FishingSuperstition​

Purpose: Fishing superstitions and beliefs for pattern analysis.

Key Fields:

  • Id (int): Unique identifier
  • UserId: User who believes
  • SuperstitionType: Type of superstition
  • BeliefRating: User's belief rating
  • PatternVerified: Whether pattern verified
  • UsageCount: Usage tracking

Relationships:

  • Many-to-one: User