DayWeather
테이블 (5)
날씨 (WEATHER)
- id — int — 기본 키 — NOT NULL — 플랫폼 별로 테이블을 따로 파기
- location — varchar(50) — NOT NULL
- 강수량 (precipitation_amount) — int — NOT NULL
- 온도 (temperature) — int — NOT NULL
- 자외선 (uv) — int — NOT NULL
- 강수확률 (precipitation_probablitiy) — int — NOT NULL
- 풍량 (wind_speed) — int — NOT NULL
- 습도 (humidity) — int — NOT NULL
- 미세먼지 (dust) — int — NOT NULL
- 안개(가시거리) (visibility) — int — NOT NULL
- 오존 (ozone) — float — NOT NULL
- 풍향 (wind_direction) — varchar(5) — NOT NULL
- createdAt (created_at) — timestamp — NOT NULL
- updatedAt (updated_at) — timestamp
- deletedAt (deleted_at) — timestamp
- 코멘트 (comment) — varchar(100)
유저 (USER)
- id — int — 기본 키 — NOT NULL — autoincreasement
- 이름 (name) — varchar(10) — NOT NULL
- 이메일 (email) — vharchar(50) — NOT NULL
- 비밀번호 (password) — varchar(50) — NOT NULL
- 닉네임 (nickname) — varchar(20) — NOT NULL
- 프로필 이미지 (profile_image) — varchar(100) — NOT NULL
- 소셜로그인 (provider) — varchar(10) — NOT NULL
- 위치 (location) — vharchar(20)
- 가입날짜 (created_at) — timestamp — NOT NULL — now()
- 수정날짜 (updated_at) — timestamp
- 탈퇴날짜 (deleted_at) — timestamp
좋아요 로그 (USERLIKESOOTD)
- id — int — 기본 키 — NOT NULL
- createdAt (created_at) — timestamp — NOT NULL
- updatedAt (updated_at) — timestamp
- deletedAt (deleted_at) — timestamp
- user_id — int — 외래 키 → 유저.id — NOT NULL — autoincreasement
- ootd_id — int — 외래 키 → 코디.id — NOT NULL
코디 (OOTD)
- id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → 유저.id — NOT NULL — autoincreasement
- title — varchar(100) — NOT NULL
- content — varchar(200) — NOT NULL
- 좋아요수 (likes) — int — NOT NULL
- 조회수 (views) — int — NOT NULL
- createdAt (created_at) — timestamp — NOT NULL
- updatedAt (updated_at) — timestamp
- deletedAt (deleted_at) — timestamp
특보 (SPECIALREPORT)
- id — int — 기본 키 — NOT NULL
- location — varchar(50) — NOT NULL
- 특보종류 (special_weather) — varchar(20) — NOT NULL
- createdAt (created_at) — timestamp — NOT NULL
- updatedAt (updated_at) — timestamp
- deletedAt (deleted_at) — timestamp
- 코멘트 (comment) — varchar(100)