ㄱ

Tables (8)

Untitled

    ai_detection (기존 테이블)

    • idx (int) — int
    • json (text) — text
    • jsonsummary (varchar(50)) — varchar(50)
    • imgpath (varchar(150)) — varchar150
    • datetime (DATETIME) — DATETIME

    ai_detection (변경안 (Waterlevel 테이블 추가))

    • idx (int) — int
    • json (text) — text
    • jsonsummary (varchar(50)) — varchar(50)
    • imgpath (varchar(150)) — varchar150
    • datetime (DATETIME) — DATETIME
    • waterlevel (varchar(10)) — varchar(10)

    ai_detection_Day10 (10분 단위 일간)

    • idx (int) — int
    • maxWater (demical) — demical
    • minWater (demlcal) — demical
    • avgWater (demlcai) — demical
    • datetime (DATETIME) — DATETIME
    • imgPath (varchar(150) — varchar(150)

    ai_detection_Day30 (30분단위 일간)

    • idx (int) — int
    • maxWater (demical) — demical
    • minWater (demlcal) — demical
    • avgWater (demlcai) — demical
    • datetime (DATETIME) — DATETIME
    • imgPath (varchar(150) — varchar(150)

    ai_detection_Day60 (60분단위 일간)

    • idx (int) — int
    • maxWater (demical) — demical
    • minWater (demlcal) — demical
    • avgWater (demlcai) — demical
    • datetime (DATETIME) — DATETIME
    • imgPath (varchar(150) — varchar(150)

    ai_detection_month (년 단위)

    • idx (int) — int
    • minWater (demlcal) — demical
    • avgWater (demlcai) — demical
    • maxWater (demical) — demical
    • imgPath (varchar(150) — varchar(150)
    • datetime (DATETIME) — DATETIME
    • month (varchar(5)) — varchar(5)

    ai_detection_week (주 단위)

    • idx (int) — int
    • minWater (demlcal) — demical
    • avgWater (demlcai) — demical
    • maxWater (demical) — demical
    • imgPath (varchar(150) — varchar(150)
    • datetime (DATETIME) — DATETIME
    • week (varchar(5)) — varchar(5)