VWF
Tables (11)
3DModel (3D모델)
- id — int — Primary key — NOT NULL
- part_type (파트 종류) — char
- part_mtl (.mtl 파일) — file
- part_obj (.obj 파일) — file
ESS
- id — int — Primary key — NOT NULL
- name (이름) — char
- maker (제조사) — char
- capacity (용량 (kW)) — double
- is_ess (ESS여부) — bool
Simulation (시뮬레이션)
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- name (이름) — char
- turbine_array (터빈 정보 + 터빈 좌표 리스트(number, type, name, x, y, z)a) — array
- ess_array (ESS 정보 + ESS 좌표 리스트 (number, type, name, x, y, z)) — array
- connection (Line (number, start, end, line_type, distance, G)) — array
- line_spec (Field) — array
- start_time (시뮬레이션 시작 시각) — datetime
- end_time (시뮬레이션 종료 시각) — datetime
- wind_id (바람 ID) — int — Foreign key → Wind.id — NOT NULL
SimulationResult (시뮬레이션 결과)
- id (id2) — int — Foreign key → Simulation.id — NOT NULL
- user_id — int — Foreign key → Simulation.user_id — NOT NULL
- result_array (active power, reactive power result) — array
User (사용자)
- id — int — Primary key — NOT NULL
- name (이름) — char
- email — char
- Field
Wind (바람데이터)
- id — int — Primary key — NOT NULL
- name (이름) — char
- type (타입) — char
- wind_speed_avg (평균풍속) — double
- time_resolution (시간해상도 (초)) — int
- start_time (시작일시) — datetime
- end_time (종료일시) — datetime
WindFarm (풍력발전단지)
- id — int — Primary key — NOT NULL
- map_id (단지파일정보ID) — int — Foreign key → WindFarm_map_info.id — NOT NULL
- name (발전단지명) — char
- description (비고) — txt
- turbine_intensity (터빈 intensity) — float
- ccap — float
- pf — float
- address (주소) — char
- latitude (위도) — double
- longtitude (경도) — double
- base_turbine_array (터빈 정보 + 터빈 좌표 리스트(number, type, name, x, y, z)) — array
- base_ess_array (ESS 정보 + ESS 좌표 리스트 (number, type, name, x, y, z)) — array
- base_connection (Line (number, start, end, line_type, distance, G)) — array
- base_line_spec (line_type, R, L, C, T) — array
WindFarm_connection (풍력발전단지 연결정보)
- id — int — Primary key — NOT NULL
- windfarm_id (풍력발전단지ID) — int — Foreign key → WindFarm.id — NOT NULL
- from — char
- from_name — char
- to — char
- to_name — char
- R — double
- L — double
- C — double
- T — double
- G — double
- distance (거리) — double
WindFarm_map_info (단지맵파일정보)
- id — int — Primary key — NOT NULL
- map_width (발전단지 width) — double
- map_height (발전단지 height) — double
- dxf_file_name (Field) — char
- dxf_file_version (Field2) — int
- dxf_left (Field3) — double
- dxf_top (Field4) — double
- dxf_right (Field5) — double
- dxf_bottom (Field6) — double
- is_baseline (Field7) — bool
WindFarm_model (풍력발전단지 모델)
- id — int — Primary key — NOT NULL
- number — int
- x (x 위치) — double
- y (y 위치) — double
- z (z 위치) — double
WindTurbine (풍력발전기)
- id — int — Primary key — NOT NULL
- name (이름) — char
- capacity (용량 (kW)) — double
- max_sp (???) — double
- max_wind_speed (최대풍속) — double
- rotor_diameter (로터 지름 (m)) — double
- hub_height (허브 높이 (m)) — double
- nacelle_offset (나셀 오프셋) — double
- blade_offset (블레이드오프셋) — double
- maker (제조사) — char
- resolution (모델 해상도) — int
- is_ess (ESS 여부) — bool
- max_output (최대출력?) — double
- tower_model_id (3d_tower) — int — Foreign key → 3DModel.id — NOT NULL
- nacelle_model_id (3d_nacelle) — int — Foreign key → 3DModel.id — NOT NULL
- hub_model_id (3d_hub) — int — Foreign key → 3DModel.id — NOT NULL
- blade_model_id (3d_blade) — int — Foreign key → 3DModel.id — NOT NULL