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