롱안성 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)