롱안성 swnm

테이블 (50)

alarm_history

  • alarm_id — integer — 알림
  • meter_id — integer — 경보가
  • alarm_type — varchar(50) — NOT NULL — 경보
  • alarm_message — varchar(255) — NOT NULL — 경보
  • alarm_time — timestamp — NOT NULL — 경보
  • is_resolved — boolean — NOT NULL — 경보
  • reg_date_time — timestamp — NOT NULL — 등록
  • update_date_time — timestamp — 수정
  • is_delete — boolean — NOT NULL — 삭제

anomaly_event

  • watch_id — bigserial
  • meter_id — bigint — NOT NULL
  • colt_date_time — timestamp — NOT NULL
  • accident_final_date_time — timestamp
  • sensor_type — varchar(20) — NOT NULL
  • water_quality_item — varchar(50)
  • type_code — varchar(2) — NOT NULL
  • abnormal_group_code — varchar(3)
  • abnormal_se_code — varchar(3)
  • measurement_value — numeric(10, 3)
  • stnd_min_value — numeric(10, 3)
  • stnd_max_value — numeric(10, 3)
  • result_code — varchar(2)
  • condition_code — varchar(2) — 01:미조치,
  • action_log — text
  • reg_date_time — timestamp
  • reg_id — varchar(50)
  • update_date_time — timestamp
  • update_id — varchar(50)

anomaly_event_buffer

  • colt_id — bigserial
  • meter_id — bigint — NOT NULL
  • measurement_date_time — timestamp — NOT NULL
  • sensor_type — varchar(20) — NOT NULL
  • water_quality_item — varchar(50)
  • measurement_value — numeric(10, 3)
  • original_value — numeric(10, 3)
  • stnd_min_value — numeric(10, 3)
  • stnd_max_value — numeric(10, 3)
  • abnormal_type — varchar(2) — AB:이상감지,
  • abnormal_group_code — varchar(3)
  • result_code — varchar(2)
  • reg_date_time — timestamp

anomaly_tag_config

  • tag_id — bigserial
  • meter_id — bigint — NOT NULL
  • sensor_type — varchar(20) — NOT NULL
  • water_quality_item — varchar(50)
  • stnd_min_rate — numeric(5, 2)
  • stnd_min_value — numeric(10, 3)
  • stnd_min_mtpl — numeric(6, 3)
  • stnd_max_rate — numeric(5, 2)
  • stnd_max_value — numeric(10, 3)
  • stnd_max_mtpl — numeric(6, 3)
  • stnd_caution_mtpl — numeric(6, 3) — 관심
  • stnd_critical_mtpl — numeric(6, 3) — 주의
  • stnd_over_value — numeric(10, 3)
  • wrong_max_mtpl — numeric(6, 3)
  • serial_co — integer
  • revis_co — integer
  • abnormal_period_code — varchar(2) — 기준
  • apply_start_date — timestamp — NOT NULL
  • apply_end_date — timestamp — NOT NULL
  • reg_id — varchar(50)
  • reg_date_time — timestamp
  • updt_id — varchar(50)
  • updt_date_time — timestamp

anomaly_threshold

  • stand_id — bigserial
  • meter_id — bigint — NOT NULL
  • sensor_type — varchar(20) — NOT NULL
  • water_quality_item — varchar(50)
  • abnor_min_value — numeric(10, 3)
  • abnor_max_value — numeric(10, 3)
  • wrong_min_value — numeric(10, 3)
  • wrong_max_value — numeric(10, 3)
  • serial_count — integer — 연속
  • apply_start_date — timestamp — NOT NULL
  • apply_end_date — timestamp
  • reg_date_time — timestamp
  • reg_id — varchar(50)
  • update_date_time — timestamp
  • update_id — varchar(50)
  • stnd_over_value — numeric(10, 3) — 관심
  • caution_min_value — numeric(10, 3) — 관심
  • caution_max_value — numeric(10, 3) — 관심
  • critical_min_value — numeric(10, 3) — 주의
  • critical_max_value — numeric(10, 3) — 주의
  • day_of_week — smallint
  • hour_bucket_start — smallint

api_key_log

  • id — bigint — 로그
  • api_key_id — bigint — NOT NULL — api_keys.id
  • client_info — varchar(255) — 클라이언트
  • method — varchar(10) — NOT NULL — HTTP
  • request_path — varchar(500) — NOT NULL — 요청
  • requested_at — timestamp — NOT NULL — 요청
  • response_code — integer — NOT NULL — 응답
  • response_time_ms — integer — NOT NULL — 응답
  • request_ip — varchar(45) — 요청

api_keys

  • id — bigint — API
  • api_key — varchar(255) — NOT NULL — 실제
  • name — varchar(100) — NOT NULL — API
  • description — varchar(255) — API
  • api_status — varchar(20) — NOT NULL — 상태값
  • issued_to — varchar(100) — 발급
  • permission — varchar(100) — 권한
  • expired_at — timestamp — 만료
  • revoked_at — timestamp — 폐기
  • last_used_at — timestamp — 마지막
  • created_at — timestamp — NOT NULL — 생성
  • updated_at — timestamp — NOT NULL — 수정

aw_abnor_colt

  • colt_id — bigint
  • abnormal_group_code — varchar(3)
  • abnormal_type — varchar(2)
  • measurement_date_time — timestamp — NOT NULL
  • measurement_value — numeric(10, 3)
  • meter_id — bigint — NOT NULL
  • original_value — numeric(10, 3)
  • reg_date_time — timestamp
  • result_code — varchar(2)
  • sensor_type — varchar(20) — NOT NULL
  • stnd_max_value — numeric(10, 3)
  • stnd_min_value — numeric(10, 3)
  • water_quality_item — varchar(50)

aw_abnor_watch

  • watch_id — bigint
  • abnormal_group_code — varchar(3)
  • abnormal_se_code — varchar(3)
  • accident_final_date_time — timestamp
  • action_log — text
  • colt_date_time — timestamp — NOT NULL
  • condition_code — varchar(2)
  • measurement_value — numeric(10, 3)
  • meter_id — bigint — NOT NULL
  • reg_date_time — timestamp
  • reg_id — varchar(50)
  • result_code — varchar(2)
  • sensor_type — varchar(20) — NOT NULL
  • stnd_max_value — numeric(10, 3)
  • stnd_min_value — numeric(10, 3)
  • type_code — varchar(2) — NOT NULL
  • update_date_time — timestamp
  • update_id — varchar(50)
  • water_quality_item — varchar(50)

aw_incident

  • incident_id — bigint
  • closed_at — timestamp
  • escalated_at — timestamp
  • last_abnormal_at — timestamp — NOT NULL
  • meter_id — bigint — NOT NULL
  • reg_date_time — timestamp
  • reg_id — varchar(50)
  • sensor_type — varchar(20) — NOT NULL
  • started_at — timestamp — NOT NULL
  • status_code — varchar(20) — NOT NULL
  • update_date_time — timestamp
  • update_id — varchar(50)
  • water_quality_item — varchar(50)

block_info

  • block_id — bigint — 블록
  • block_name — varchar(100) — NOT NULL — 블록명
  • description — varchar(255) — 블록
  • parent_block_id — bigint — 상위
  • geometry — geometry(Polygon, 4326) — NOT NULL — 블록
  • reg_date_time — timestamp — NOT NULL — 등록
  • update_date_time — timestamp — 수정
  • is_delete — boolean — NOT NULL — 삭제
  • is_key_point_pressure — boolean
  • priority — integer
  • priority_note — text
  • is_included_report — boolean

bookmark

  • bookmark_id — bigint
  • bookmark_desc — varchar(500)
  • bookmark_name — varchar(100) — NOT NULL
  • created_at — timestamp — NOT NULL
  • is_delete — boolean — NOT NULL
  • updated_at — timestamp
  • user_id — bigint

bookmark_tag

  • bookmark_tag_id — bigint
  • install_location — varchar(255)
  • meter_code — varchar(100) — NOT NULL
  • meter_type — varchar(50)
  • bookmark_id — bigint — NOT NULL

booster_pump_station_info

  • booster_pump_station_id — integer — 가압장
  • facility_id — integer — NOT NULL — 연결
  • booster_pump_station_code — varchar(100) — 가압장
  • water_supply_area — varchar(200) — 급수지역
  • managing_agency — varchar(200) — 관리기관
  • boosting_method — varchar(100) — 가압방식
  • location — varchar(500) — 설치
  • pump_count — integer — 펌프
  • pump_capacity — numeric(14, 2) — 펌프용량
  • max_boost_head_m — numeric(12, 2) — 최대가압
  • inlet_pipeline — varchar(200) — 유입관로
  • outlet_pipeline — varchar(200) — 유출관로
  • flow_meter — varchar(200) — 유량계
  • pressure_gauge — varchar(200) — 압력계
  • water_quality_sensor — varchar(200) — 수질측정기
  • automatic_control — varchar(200) — 자동제어
  • monitoring_system — varchar(200) — 감시시스템
  • inspection_items — text — 점검
  • remark — text — 비고
  • reg_date_time — timestamp — NOT NULL — 등록
  • update_date_time — timestamp — 수정
  • is_delete — boolean — NOT NULL — 삭제
  • has_flow_meter — varchar(255)

common_code

  • cd_grp — varchar(10) — 기본 키 — NOT NULL
  • cd_key — varchar(20) — 기본 키 — NOT NULL
  • cd_nm — varchar(100) — NOT NULL
  • use_yn — varchar(1)
  • disp_yn — varchar(1)
  • reserve01 — varchar(30)
  • reserve02 — varchar(30)
  • reserve03 — varchar(30)
  • ordr — integer
  • reg_id — varchar(20)
  • reg_dt — timestamp
  • updt_id — varchar(20)
  • updt_dt — timestamp

construction_project

  • id — bigserial
  • zone_id — bigint — NOT NULL
  • project_code — varchar(100)
  • project_name — varchar(200) — NOT NULL
  • execution_point — varchar(200)
  • status — varchar(20) — NOT NULL
  • (inprogress::character — varying)::text
  • (completed::character — varying)::text))
  • completion_rate — numeric(5, 2) — NOT NULL
  • start_date — date
  • end_date — date
  • manager_id — bigint
  • manager_name — varchar(200)
  • workforce_count — integer
  • summary — text
  • created_by — bigint
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

construction_report_attachment

  • id — bigserial
  • report_id — bigint — NOT NULL
  • category — varchar(30)
  • file_name — varchar(255) — NOT NULL
  • file_path — varchar(512) — NOT NULL
  • file_type — varchar(100)
  • file_size — bigint — NOT NULL
  • sort_order — integer — NOT NULL
  • created_at — timestamp — NOT NULL

construction_work_report

  • id — bigserial
  • author_id — bigint
  • author_name — varchar(100)
  • title — varchar(200) — NOT NULL
  • report_type — varchar(50) — NOT NULL
  • report_date — date — NOT NULL
  • details — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • zone_id — bigint — NOT NULL

construction_zone

  • id — bigserial
  • zone_code — varchar(50) — NOT NULL
  • zone_name — varchar(200) — NOT NULL
  • project_name — varchar(200)
  • client_name — varchar(200)
  • contractor_name — varchar(200)
  • manager_name — varchar(200)
  • status — varchar(20) — NOT NULL
  • (inprogress::character — varying)::text
  • (completed::character — varying)::text))
  • start_date — date
  • end_date — date
  • summary — text
  • created_by — bigint
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • plant_keyword — varchar(100)

consumer_info

  • consumer_id — bigserial
  • stt — integer — 원본
  • consumer_name — varchar(200) — NOT NULL
  • consumer_type — varchar(20) — NOT NULL
  • (MANUAL::character — varying)::text))
  • tax_code — varchar(20)
  • address — varchar(500)
  • location — varchar(100)
  • contract_no — varchar(50)
  • geometry — geometry(Point, 4326) — EPSG:4326
  • is_delete — boolean — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp

crisis_junction_gis

  • id — bigint
  • created_at — timestamp
  • gis_object_id — bigint — NOT NULL
  • gis_table — varchar(255) — NOT NULL
  • junction_id — varchar(255) — NOT NULL
  • model_id — bigint — NOT NULL

crisis_model

  • id — bigint
  • area_code — varchar(255)
  • created_at — timestamp
  • created_by — varchar(255)
  • management_cd — varchar(255)
  • model_name — varchar(255) — NOT NULL
  • model_type — varchar(255) — NOT NULL
  • remark — varchar(255)
  • updated_at — timestamp
  • updated_by — varchar(255)
  • use_yn — boolean
  • file_id — bigint

crisis_model_file

  • id — bigint
  • content_type — varchar(255)
  • created_at — timestamp
  • description — varchar(255)
  • file_name — varchar(255) — NOT NULL
  • file_path — varchar(255) — NOT NULL
  • original_name — varchar(255)
  • size_bytes — bigint
  • updated_at — timestamp

crisis_scenario_result

  • id — bigint
  • close_pipe_ids — varchar(255)
  • created_at — timestamp
  • created_by — varchar(255)
  • negative_nodes — varchar(255)
  • result_summary — jsonb
  • scenario_name — varchar(255)
  • supply_pipe_ids — varchar(255)
  • model_id — bigint — NOT NULL

diagram

  • diagram_id — integer — 다이어그램
  • diagram_name — varchar(150) — NOT NULL — 다이어그램
  • remark — varchar(500) — 비고
  • data_json — jsonb — NOT NULL — 화면
  • version — integer — NOT NULL — 낙관적
  • zoom — numeric(6, 3) — NOT NULL — 화면
  • pan_x — numeric(10, 3) — NOT NULL — 뷰포트
  • pan_y — numeric(10, 3) — NOT NULL — 뷰포트
  • reg_date_time — timestamp — NOT NULL — 등록
  • update_date_time — timestamp — 수정
  • is_delete — boolean — NOT NULL — 삭제

display_range_settings

  • inp_number — varchar(50) — 기본 키 — NOT NULL
  • result_code — varchar(20) — 기본 키 — NOT NULL
  • result_type — varchar(20) — 기본 키 — NOT NULL
  • color1 — varchar(20)
  • color2 — varchar(20)
  • color3 — varchar(20)
  • color4 — varchar(20)
  • color5 — varchar(20)
  • range1 — varchar(50)
  • range2 — varchar(50)
  • range3 — varchar(50)
  • range4 — varchar(50)
  • range5 — varchar(50)
  • result_code_nm — varchar(100)

email_verification

  • id — integer — 인증코드
  • employee_number — varchar(50) — NOT NULL — 사번
  • email — varchar(100) — NOT NULL — 이메일
  • code — varchar(10) — NOT NULL — 인증코드
  • expires_at — timestamp — NOT NULL — 만료
  • verified_at — timestamp — 인증
  • created_at — timestamp — NOT NULL — 생성

entity_attachment

  • id — bigserial
  • entity_type — varchar(50) — NOT NULL — 엔티티
  • entity_id — bigint — NOT NULL — 대상
  • attachment_id — bigint — NOT NULL — file_attachment.id
  • display_order — integer — UI

facility

  • f1_business_division — text
  • f1_business_division_name — text
  • f2_management_group — text
  • f2_management_group_name — text
  • f3_supply_unit — text
  • f3_supply_unit_name — text
  • f4_facility_location — text
  • f4_facility_location_name — text
  • l1_equipment_number — text
  • l1_equipment_name — text
  • l2_equipment_number — text
  • l2_equipment_name — text
  • l3_equipment_number — text
  • l3_equipment_name — text
  • l4_equipment_number — text
  • l4_equipment_name — text
  • equipment_number — text
  • equipment_name — text
  • parent_equipment_number — text
  • parent_equipment_name — text
  • group — text
  • process — text
  • equipment_level — text
  • subcategory — text
  • subcategory_name — text
  • plant_name — text
  • planner_group_name — text
  • installation_year — text
  • service_life — text
  • acquisition_cost_idr_legacy — text
  • specification_data — text
  • f5_section — text
  • f5_section_name — text
  • last_inspection_date — text
  • remark — text
  • end_x — text
  • end_y — text
  • address — text
  • inlet_pipeline — text
  • outlet_pipeline — text
  • geometry_json — text
  • flow_meter_equipment_number — text
  • pressure_gauge_equipment_number — text
  • water_quality_meter_equipment_number — text
  • acquisition_cost_idr — text
  • automatic_control — text
  • monitoring_system — text

facility_info

  • facility_id — integer — 시설물
  • facility_code — varchar(100) — NOT NULL — 시설물
  • facility_name — varchar(100) — NOT NULL — 시설물
  • facility_type — varchar(50) — NOT NULL — 시설물
  • block_id — integer — NOT NULL — 소속
  • location — varchar(255) — 상세
  • geometry — geometry(Point, 4326) — NOT NULL — 시설물의
  • install_date_time — timestamp — 설치
  • last_inspection_date_time — timestamp — 최근
  • reg_date_time — timestamp — NOT NULL — 등록
  • update_date_time — timestamp — 수정
  • is_delete — boolean — NOT NULL — 삭제

feature_info

  • feature_id — integer
  • feature_code — varchar(10) — NOT NULL — 기능
  • feature_name — varchar(200) — NOT NULL — 기능명
  • is_active — boolean — NOT NULL — 개발통제
  • display_order — integer — NOT NULL
  • is_delete — boolean — NOT NULL
  • reg_date_time — timestamp — NOT NULL
  • update_date_time — timestamp

feature_menu_mapping

  • mapping_id — integer
  • feature_id — integer — NOT NULL
  • menu_id — integer — NOT NULL

file_attachment

  • id — bigserial
  • original_file_name — varchar(500) — 업로드
  • stored_file_name — varchar(500) — 디스크
  • file_path — varchar(1000) — 디스크
  • file_size — bigint — bytes
  • file_type — varchar(200) — MIME
  • uploaded_by_type — varchar(50) — 업로더
  • uploaded_by_id — bigint — 업로더
  • is_delete — boolean — NOT NULL — soft
  • created_at — timestamp — NOT NULL

hourly_summary

  • hourly_id — integer — 시간별
  • meter_id — integer — NOT NULL — 계측기
  • summary_date — date — NOT NULL — 집계
  • hour — integer — NOT NULL — 집계
  • avg_measurement — numeric(10, 3) — 시간당
  • min_measurement — numeric(10, 3) — 시간당
  • max_measurement — numeric(10, 3) — 시간당
  • water_quality_item — varchar(50) — 수질
  • reg_date_time — timestamp — NOT NULL — 등록
  • update_date_time — timestamp — 수정
  • is_delete — boolean — NOT NULL — 삭제

if_miss_tag

  • miss_tag_id — bigint
  • active_yn — boolean — NOT NULL
  • collect_interval_min — integer — NOT NULL
  • meter_id — bigint — NOT NULL
  • reg_date_time — timestamp
  • sensor_type — varchar(20) — NOT NULL
  • water_quality_item — varchar(50)

manual_meter_reading

  • reading_id — bigserial — PK
  • customer_name — varchar(200) — NOT NULL — 고객명
  • tax_code — varchar(20) — 사업자등록번호
  • address — varchar(500) — 주소
  • meter_serial — varchar(50) — 계량기
  • meter_type — varchar(50) — 계량기
  • area — varchar(100) — 지역/구역
  • reading_period — integer — 검침
  • reading_year — integer — NOT NULL — 검침
  • start_date — date — 검침
  • end_date — date — 검침
  • current_reading — numeric(15, 2) — 현재
  • previous_reading — numeric(15, 2) — 이전
  • consumption — numeric(15, 2) — 사용량
  • upload_batch_id — varchar(50) — 엑셀
  • source_file_name — varchar(200) — 원본
  • reg_date_time — timestamp — 등록일시
  • update_date_time — timestamp — 수정일시
  • is_delete — boolean — 삭제

mass_balance_monthly

  • report_month — integer — 기본 키 — NOT NULL
  • report_year — integer — 기본 키 — NOT NULL
  • adjustment_deduction — numeric(19, 2)
  • agreed_volume — numeric(19, 2)
  • authorized_nrw — numeric(19, 2)
  • created_at — timestamp — NOT NULL
  • excluded_import — numeric(19, 2)
  • excluded_production — numeric(19, 2)
  • external_supply — numeric(19, 2)
  • fountain_use — numeric(19, 2)
  • illegal_use — numeric(19, 2)
  • imported_treated_water — numeric(19, 2)
  • inflow_from_other — numeric(19, 2)
  • leakage — numeric(19, 2)
  • local_plant_production — numeric(19, 2)
  • loss_nrw — numeric(19, 2)
  • meter_error — numeric(19, 2)
  • metered_volume — numeric(19, 2)
  • nrw_total — numeric(19, 2)
  • om_revenue_ratio — numeric(19, 2)
  • other_billed — numeric(19, 2)
  • other_production — numeric(19, 2)
  • outflow_to_other — numeric(19, 2)
  • produced_water — numeric(19, 2)
  • public_use — numeric(19, 2)
  • regional_water_supply — numeric(19, 2)
  • revenue_agreed_volume — numeric(19, 2)
  • revenue_water — numeric(19, 2)
  • stats_revenue_ratio — numeric(19, 2)
  • total_water_supply — numeric(19, 2)
  • unmetered_volume — numeric(19, 2)
  • updated_at — timestamp — NOT NULL
  • utility_use — numeric(19, 2)
  • inflow_from_other_auto — numeric(19, 2)
  • inflow_from_other_manual — numeric(19, 2)
  • outflow_to_other_auto — numeric(19, 2)
  • outflow_to_other_manual — numeric(19, 2)

menu_info

  • menu_id — integer — 메뉴
  • parent_menu_id — integer — 상위
  • menu_name — varchar(100) — NOT NULL — 메뉴
  • menu_path — varchar(255) — 메뉴
  • menu_order — integer — NOT NULL — 메뉴
  • is_visible — boolean — NOT NULL — 메뉴
  • reg_date_time — timestamp — NOT NULL — 등록
  • update_date_time — timestamp — 수정
  • is_delete — boolean — NOT NULL — 삭제

mnf_daily_result

  • result_id — bigint
  • block_id — bigint — NOT NULL
  • flux_min_valu — numeric(10, 3)
  • leak_type — varchar(3)
  • mnf_accept_val — numeric(10, 3)
  • mnf_gap_cnt — integer
  • mnf_trend_cnt — integer
  • reg_date_time — timestamp
  • result_date — date — NOT NULL
  • rslt_cd — varchar(2)
  • update_date_time — timestamp

model_coordinate

  • inp_number — varchar(50) — 기본 키 — NOT NULL
  • node_id — varchar(100) — 기본 키 — NOT NULL
  • created_at — timestamp
  • x_coord — varchar(50)
  • y_coord — varchar(50)

model_junction

  • inp_number — varchar(50) — 기본 키 — NOT NULL
  • junction_id — varchar(100) — 기본 키 — NOT NULL
  • base_demand — varchar(50)
  • created_at — timestamp
  • elevation — varchar(50)
  • pattern_id — varchar(100)
  • x_coord — varchar(50)
  • y_coord — varchar(50)

model_label

  • id — bigint
  • anchor_node — varchar(50)
  • color — varchar(20)
  • created_at — timestamp
  • font_size — integer
  • label_id — varchar(50) — NOT NULL
  • label_text — varchar(255) — NOT NULL
  • model_file_path — varchar(500) — NOT NULL
  • updated_at — timestamp
  • x_coord — double — NOT NULL
  • y_coord — double — NOT NULL

model_node_profile

  • inp_number — varchar(50) — 기본 키 — NOT NULL
  • node_id — varchar(100) — 기본 키 — NOT NULL
  • profile_se_cd — varchar(20) — 기본 키 — NOT NULL
  • created_at — timestamp
  • length — numeric(19, 2)
  • node_type — varchar(50)
  • profile_syn — varchar(1)
  • start_id — varchar(100)
  • updated_at — timestamp

model_node_tag

  • inp_number — varchar(50) — 기본 키 — NOT NULL
  • node_id — varchar(100) — 기본 키 — NOT NULL
  • tag_code — varchar(50) — 기본 키 — NOT NULL
  • created_at — timestamp
  • sensor_type — varchar(50)
  • tag_name — varchar(200)

model_pipe

  • inp_number — varchar(50) — 기본 키 — NOT NULL
  • pipe_id — varchar(100) — 기본 키 — NOT NULL
  • created_at — timestamp
  • diameter — varchar(50)
  • length — varchar(50)
  • minor_loss — varchar(50)
  • node1 — varchar(100)
  • node2 — varchar(100)
  • roughness — varchar(50)
  • status — varchar(20)

model_pump

  • inp_number — varchar(50) — 기본 키 — NOT NULL
  • pump_id — varchar(100) — 기본 키 — NOT NULL
  • created_at — timestamp
  • node1 — varchar(100)
  • node2 — varchar(100)
  • parameters — text

model_reservoir

  • inp_number — varchar(50) — 기본 키 — NOT NULL
  • reservoir_id — varchar(100) — 기본 키 — NOT NULL
  • created_at — timestamp
  • head — varchar(50)
  • pattern_id — varchar(100)
  • x_coord — varchar(50)
  • y_coord — varchar(50)

model_result_range

  • inp_number — varchar(50) — NOT NULL
  • created_at — timestamp
  • max_demand — varchar(50)
  • max_flow — varchar(50)
  • max_head — varchar(50)
  • max_pressure — varchar(50)
  • max_velocity — varchar(50)
  • min_demand — varchar(50)
  • min_flow — varchar(50)
  • min_head — varchar(50)
  • min_pressure — varchar(50)
  • min_velocity — varchar(50)
  • updated_at — timestamp

model_tank

  • inp_number — varchar(50) — 기본 키 — NOT NULL
  • tank_id — varchar(100) — 기본 키 — NOT NULL
  • created_at — timestamp
  • diameter — varchar(50)
  • elevation — varchar(50)
  • init_level — varchar(50)
  • max_level — varchar(50)
  • min_level — varchar(50)
  • min_vol — varchar(50)
  • volume_curve — varchar(100)
  • x_coord — varchar(50)
  • y_coord — varchar(50)

spatial_ref_sys

  • srid — integer — NOT NULL
  • auth_name — varchar(256)
  • auth_srid — integer
  • srtext — varchar(2048)
  • proj4text — varchar(2048)