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