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)