solar power plant

Tables (8)

DailyYield (일별 발전량)

  • PK (id) — INT — Primary key — NOT NULL
  • FK (inverter_id) — INT — Foreign key → Inverter.PK — NOT NULL
  • Field (plant) — uuid
  • Field (date) — date
  • Field2 (daily_yield) — BigINT
  • Field4 (created_at) — timestamp
  • Field5 (updated_at) — timestamp

HourlyYield (일일 시간별 발전량)

  • PK (id) — INT — Primary key — NOT NULL
  • FK (inverter_id) — INT — Foreign key → Inverter.PK — NOT NULL
  • Field (plant) — uuid
  • Field (date) — date
  • Field (hour) — INT
  • Field2 (hour_yield) — BigINT
  • Field3 (daily_yield) — BigINT
  • Field (timestamp) — timestamp
  • Field4 (created_at) — timestamp

Inverter (인버터)

  • PK (id) — INT — Primary key — NOT NULL
  • FK (plant_id) — INT — Foreign key → Plant.PK — NOT NULL
  • Field (number) — int
  • Field2 (capacity) — BigINT
  • Field3 (status) — boolean
  • Field (setup_date) — date
  • Field (note) — text
  • Field (created_at) — timestamp
  • Field2 (updated_at) — timestamp

MonthlyYield (월별 발전량)

  • PK (id) — Primary key — NOT NULL
  • FK (inverter_id) — INT — Foreign key → Inverter.PK — NOT NULL
  • Field (plant) — uuid
  • Field (year) — INT
  • Field (month) — INT
  • Field2 (monthly_yield) — BigINT
  • Field3 (daily_avg_yield) — BigINT
  • Field4 (daily_avg_time) — BigINT
  • Field5 (created_at) — timestamp
  • Field6 (updated_at) — timestamp

Plant (발전소)

  • PK (id) — uuid — Primary key — NOT NULL
  • Field (name) — varchar
  • Field (address) — varchar
  • Field (latitude) — float
  • Field (longitude) — float
  • Field (x_location) — int
  • Field (y_location) — int
  • Field (rule) — enum
  • Field (total_capacity) — bigint
  • Field (status) — enum
  • Field (note) — text
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Rtu (RTU)

  • PK (id) — uuid — Primary key — NOT NULL
  • FK (plant_id) — INT — Foreign key → Plant.PK — NOT NULL
  • Field (pecking_order) — int
  • Field (hw_serial_number) — text
  • Field (hw_board_name) — text
  • Field (hw_cpu) — int
  • Field (hw_memory) — int
  • Field (hw_disk_size_in_byte) — int
  • Field (sw_os_name) — text
  • Field (sw_code_ver) — text
  • Field (setup_date) — date
  • Field (note) — text
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

UserRole (유저)

  • PK (id) — INT — Primary key — NOT NULL
  • Field (oid) — uuid
  • Field5 (name) — varchar
  • Field4 (phonenumber) — varchar
  • Field (role) — enum
  • FK (plant) — uuid — Foreign key → Plant.PK — NOT NULL
  • Field7 (created_at) — timestamp
  • Field8 (updated_at) — timestamp

Weather (날씨)

  • PK (id) — int — Primary key — NOT NULL
  • FK (plant_id) — uuid — Foreign key → Plant.PK — NOT NULL
  • Field (date) — date
  • Field (hour) — int
  • Field (sky) — enum
  • Field (temperature) — float
  • Field (precipitation) — enum
  • Field (rainfall) — float
  • Field (east_west_wind_speed) — float
  • Field (north_south_wind_speed) — float
  • Field (wind_direction) — float
  • Field (relative_humidity) — float
  • Field (lightning_strike) — float
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp