Air

Tables (5)

AnalysisInputData (분석 데이터)

  • 데이터_id (MeasuringData_id) — Primary key — NOT NULL
  • 로그_ID (Upload_id) — Foreign key → UploadLog.로그_ID — NOT NULL
  • 멤버_id (Member_id) — Foreign key → UploadLog.멤버_id — NOT NULL
  • 관측시간 (measuringTime)
  • Field (CO2)
  • Field (CH4)
  • Field (SO2)
  • Field (NO2)
  • Field2 (O3)
  • Field (CO)
  • Field (PM10)
  • Field (PM2.5)
  • Field (NO)
  • 풍향 (windDirection)
  • 풍속 (windSpeed)
  • 온도 (temperature)
  • 숩도 (humidity)

MeasuringCenter (측정소)

  • 코드명 (MeasuringCenger_code) — Primary key — NOT NULL
  • 협의체기관 (consultative_group)
  • 센터명 (MeasuringCenterName)
  • 측정항목 (Measuring_type)
  • 위치 (MeasuringCenterLocation)
  • 코드명 (Code)
  • 위도 (latitude)
  • 경도 (longitude)

MeasuringData (측정 데이터)

  • 데이터_id (MeasuringData_id) — Primary key — NOT NULL
  • 코드명 (MeasuringCenger_code) — Foreign key → MeasuringCenter.코드명 — NOT NULL
  • 관측시간 (measuringTime)
  • Field (CO2)
  • Field (CH4)
  • Field (SO2)
  • Field (NO2)
  • Field2 (O3)
  • Field (CO)
  • Field (PM10)
  • Field (PM2.5)
  • Field (NO)
  • 풍향 (windDirection)
  • 풍속 (windSpeed)
  • 온도 (temperature)
  • 숩도 (humidity)

Member (Untitled)

  • 멤버_id (Member_id) — Primary key — NOT NULL
  • 이름 (Username)
  • 비밀번호 (Password)
  • 이메일 (Email)
  • 로그인타입 (Login_type)
  • Field (Oauth)

UploadLog (업로드로그)

  • 로그_ID (Upload_id) — Primary key — NOT NULL
  • 멤버_id (Member_id) — Foreign key → Member.멤버_id — NOT NULL
  • 파일명 (file_name)
  • 파일경로 (file_path)