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)