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