waither

Tables (10)

BaseEntity (Untitled2)

  • createdAt (생성일자) — NOTNULL
  • updatedAt (수정일자) — NULLABLE

Member_Data (Untitled4)

  • id — NOTNULL — Primary key — NOT NULL
  • userId (Key) — Primary key — NOT NULL
  • veryCold (매우추움(평균)) — DEFAULT
  • cold (추움(평균)) — DEFAULT
  • good/normal (좋음/보통(평균)) — DEFAULT
  • hot (더움(평균)) — DEFAULT
  • veryHot (매우더움(평균)) — DEFAULT
  • season (계절)

Notification (Untitled6)

  • id — NOTNULL — Primary key — NOT NULL
  • userId (Key) — Primary key — NOT NULL
  • title (알림제목)
  • content (알림내용)

Notification_Settings (Untitled3)

  • id — NOTNULL — Primary key — NOT NULL
  • userId (Key) — Primary key — NOT NULL
  • outTime (외출시간) — NOTNULL
  • outAlert (외출알림)
  • climateAlert (기상특보알림)
  • userAlert (사용자맞춤알림)
  • snowAlert (강설정보알림)
  • windAlert (바람세기알림)
  • windDegree (바람세기)
  • precipitation (강수량보기)
  • wind (풍량/풍속보기)
  • dust (미세먼지보기)
  • sun (Field)
  • mon (Field2)
  • tue (Field3)
  • wed (Field4)
  • thu (Field5)
  • fri (Field6)
  • sat (Field7)
  • regionReport (직장지역 리포트)
  • Field8

Region (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • userId (Key2) — Primary key — NOT NULL
  • region (Field)
  • latitude (위도)
  • logitude (경도)

Survey (Untitled5)

  • id — NOTNULL — Primary key — NOT NULL
  • temp (온도) — 온도
  • ans (답변)
  • season (계절)

User (Untitled)

  • id — NOTNULL — Primary key — NOT NULL
  • name (이름) — NOTNULL
  • email (이메일) — NOTNULL
  • password (비밀번호) — NOTNULL
  • status (상태) — NOTNULL
  • image (프로필이미지) — NULLABLE
  • custom (사용자 맞춤 허용여부) — TRUE
  • Field

User_Median (CopyOfUntitled4)

  • id — NOTNULL — Primary key — NOT NULL
  • userId (Key) — Primary key — NOT NULL
  • season (계절)
  • very_cold_median (매우추움_추움_중간값)
  • cold_good_median (추움_적당함_중간값)
  • good_hot_median (적당함_더움_중간값)
  • very_hot_median (매우더움_더움_중간값)

Weight (Untitled9)

  • Key — Primary key — NOT NULL
  • userId (Key2) — Primary key — NOT NULL
  • weight (Double)
  • season (ENUM)

report (Untitled8)

  • Key — Primary key — NOT NULL
  • userId (Key2) — Primary key — NOT NULL