TaeSung
Tables (24)
Additional_Feature (Untitled)
- ID (idx) — Primary key — NOT NULL
- 이름 (name) — String
CAR_CSV (차량 csv)
- Key — Primary key — NOT NULL
- 차량 (detail_id) — Foreign key → CAR_Detail.Key — NOT NULL
- 화학물질명 (chemical_name)
- 화학물질값 (chemical_value)
- MSV (msv)
CAR_Detail (차량 세부)
- Key — Primary key — NOT NULL
- 차량ID (carId)
- 위도 (lat)
- 경도 (lon)
- DATE (date)
- 풍향 (windDirection)
- CSV파일명 (csv_filename)
- 차량코드 (car_code)
CAR_SIFT (차량 sift)
- Key — Primary key — NOT NULL
- 차량 (car_code) — Foreign key → CAR_Detail.Key — NOT NULL
- 위도 (lat)
- 경도 (lon)
- DATE (date)
- 등록날짜 (reg_date)
Company (사업장)
- Key — Primary key — NOT NULL
- 위도 (lat)
- 경도 (lon)
- 소스 Id (id)
- 사업장명 (name)
- CSV 파일명 (csv_filename)
- 악취명 (odor)
- 공정명 (outlet)
Company_CSV (CopyOf차량 csv)
- Key — Primary key — NOT NULL
- 사업장 (company_id) — Foreign key → Company.Key — NOT NULL
- 화학물질명 (chemical_name)
- 화학물질값 (chemical_value)
- MSV (msv)
Facility_Category (Untitled3)
- ID (idx) — Primary key — NOT NULL
- 이름 (name) — String
Interference_Condition (Untitled4)
- ID (idx) — Primary key — NOT NULL
- 방지시설 (facility) — Foreign key → Odor_Prevention_Facility.ID — NOT NULL
- 방해/입력인자 번호 (odor) — int
- 연산자 (operator) — String
- 상수 (operand) — double
Interference_Factor (Untitled5)
- ID (idx) — Primary key — NOT NULL
- 이름 (name) — String
MSV (msv)
- Key — Primary key — NOT NULL
- 이름 (name)
- MSV값 (msv)
Odor_Category (Untitled11)
- ID (idx) — Primary key — NOT NULL
- 이름 (name) — String
Odor_Condition (Untitled2)
- Key — Primary key — NOT NULL
- 방지시설 (facility) — Foreign key → Odor_Prevention_Facility.ID — NOT NULL
- 방해/입력인자 번호 (odor) — int
- 연산자 (operator) — String
- 상수 (operand) — double
Odor_Prevention_Facility (Untitled13)
- ID (idx) — Primary key — NOT NULL
- 카테고리 (category) — Foreign key → Facility_Category.ID — NOT NULL
- 추가사항 (requiredAdditional) — Foreign key → Additional_Feature.ID — NOT NULL
- 이름 (name) — String
- 우선순위 (priority) — int
- 기본 가격 (basePrice) — int
- 풍향별 가격 (priceByWind) — long
- 이미지 (image) — String
Odor_Substance (Untitled15)
- ID (idx) — Primary key — NOT NULL
- 카테고리 (category) — Foreign key → Odor_Category.ID — NOT NULL
- 수용성 (waterSolubility) — Foreign key → Water_Solubility.ID — NOT NULL
- 이름 (name) — String
- threshold — Double
Removal_Efficiency (Untitled14)
- ID (idx) — Primary key — NOT NULL
- 방지지설 (facility) — Foreign key → Odor_Prevention_Facility.ID — NOT NULL
- efficiency1 — float
- efficiency2 — float
- efficiency3 — float
Removal_Interference (Untitled16)
- ID (idx) — Primary key — NOT NULL
- 효용성 (efficiency) — Foreign key → Removal_Efficiency.ID — NOT NULL
- 간섭 (interference) — Foreign key → Interference_Factor.ID — NOT NULL
Removal_Odor (Untitled17)
- ID (idx) — Primary key — NOT NULL
- 방지시설 (facility) — Foreign key → Odor_Prevention_Facility.ID — NOT NULL
- 악취정보 (odor) — Foreign key → Odor_Substance.ID — NOT NULL
Removal_Water_Solubility (Untitled18)
- ID (idx) — Primary key — NOT NULL
- efficiency — Foreign key → Removal_Efficiency.ID — NOT NULL
- waterSolubility — Foreign key → Water_Solubility.ID — NOT NULL
Result (Untitled19)
- ID (idx) — Primary key — NOT NULL
- 이름 (name) — String
- 이론적 희석계수 (theoreticalDillutionFactor) — double
- 대상 희석계수 (targetDillutionFactor) — double
- 기대 희석계수 (expectedDillutionFactor) — double
- 바람 (wind) — double
- 저장시간 (storedAt) — date
Result_Additional (Untitled6)
- ID (idx) — Primary key — NOT NULL
- 추가사항 (additional) — Foreign key → Additional_Feature.ID — NOT NULL
- 결과 (result) — Foreign key → Result.ID — NOT NULL
- 가능여부 (available) — boolean
Result_Facility (Untitled10)
- ID (idx) — Primary key — NOT NULL
- 결과 (result) — Foreign key → Result.ID — NOT NULL
- 시설 (facility) — Foreign key → Odor_Prevention_Facility.ID — NOT NULL
Result_Interference (Untitled9)
- ID (idx) — Primary key — NOT NULL
- 결과 (result) — Foreign key → Result.ID — NOT NULL
- 간섭요인 (interference) — Foreign key → Interference_Factor.ID — NOT NULL
- 값 (value) — double
- 대상 값 (targetValue) — double
- 기대 값 (expectedValue) — double
Result_Odor (Untitled8)
- ID (idx) — Primary key — NOT NULL
- 결과 (result) — Foreign key → Result.ID — NOT NULL
- 악취정보 (odor) — Foreign key → Odor_Substance.ID — NOT NULL
- 값 (value) — double
- 기대값 (expectedValue) — double
Water_Solubility (Untitled7)
- ID (idx) — Primary key — NOT NULL
- 이름 (name) — String