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