weatherwear

Tables (6)

Clothes (tbl_clothes)

  • ClothesId (clothes_id) — BIGINT — Primary key — NOT NULL
  • ClothesCategory (clothes_category) — INT
  • TempCategory (temp_category) — INT
  • SkyCategory (sky_category) — INT
  • ClothesName (clothes_name) — VARCHAR
  • ClothesIcon (clothes_icon) — VARCHAR

Location (tbl_location)

  • LocationId (location_id) — BIGINT — Primary key — NOT NULL
  • LocationName (location_name) — VARCHAR
  • Longtitude (longtitue) — FLOAT
  • Latitude (latitude) — FLOAT

Member (tbl_member)

  • MemberId (member_id) — UUID — Primary key — NOT NULL
  • Email (email) — VARCHAR
  • Gender (gender) — VARCHAR
  • Password (password) — VARCHAR

Post (tbl_post)

  • PostId (post_id) — BIGINT — Primary key — NOT NULL
  • MemberId (member_id) — UUID — Foreign key → Member.MemberId — NOT NULL
  • UpdateDate (update_date) — DATETIME
  • Image1 (image1) — VARCHAR
  • Image2 (image2) — VARCHAR
  • Image3 (image3) — VARCHAR
  • Clothes (clothes) — VARCHAR
  • Review (review) — VARCHAR
  • Emoji (emoji) — INT
  • Date (date) — DATE
  • MinTemp (min_temp) — DOUBLE
  • MaxTemp (max_temp) — DOUBLE
  • Sky (sky) — INT

WeatherData (tbl_weather_data)

  • WeatherNo (weather_no) — BIGINT — Primary key — NOT NULL
  • LocationName (location) — VARCHAR
  • Temperature (temp) — FLOAT
  • FeelsLike (feels_like) — FLOAT
  • Sky (sky) — INT
  • Dust (dust) — INT
  • Rain (rain) — INT
  • LocationX (location_x) — FLOAT
  • LocationY (location_y) — FLOAT

Weekly (tbl_weekly)

  • WeeklyNo (weekly_no) — BIGINT — Primary key — NOT NULL
  • Date (date) — DATE
  • Temperature (temp) — FLOAT
  • Sky (sky) — INT
  • Rain (rain) — INT
  • MaxTemp (max_temp) — FLOAT
  • MinTemp (min_temp) — FLOAT