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