보호구역통합관리
테이블 (49)
arc_entities_geometry
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4
- type — varchar(50)
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- handle — varchar(255)
- geom — public.geometry
blocks
- id — serial4 — 기본 키 — NOT NULL
- name — varchar(255) — NOT NULL
- base_point_x — float4
- base_point_y — float4
- base_point_z — float4
- x_scale — float4
- y_scale — float4
- z_scale — float4
- rotation — float4
- project_id — int4
circle_entities_geometry
- id — int4
- project_id — int4
- type — varchar(50)
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- handle — varchar(255)
- geom — public.geometry
dimension_entities_geometry
- id — int4
- project_id — int4
- type — varchar(50)
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- handle — varchar(255)
- geom — public.geometry
- dim_text — varchar(400)
- dim_type — int4
- dim_layer — varchar(400)
- dim_rotation — float4
- dim_defpoint_x — float4
- dim_defpoint_y — float4
- dim_defpoint_z — float4
- dim_defpoint2_x — float4
- dim_defpoint2_y — float4
- dim_defpoint2_z — float4
- dim_defpoint3_x — float4
- dim_defpoint3_y — float4
- dim_defpoint3_z — float4
- dim_defpoint4_x — float4
- dim_defpoint4_y — float4
- dim_defpoint4_z — float4
- dim_text_midpoint_x — float4
- dim_text_midpoint_y — float4
- dim_text_midpoint_z — float4
entities_3dface
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- v1_x — float4
- v1_y — float4
- v1_z — float4
- v2_x — float4
- v2_y — float4
- v2_z — float4
- v3_x — float4
- v3_y — float4
- v3_z — float4
- v4_x — float4
- v4_y — float4
- v4_z — float4
- handle — varchar(255)
entities_arc
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- center_x — float4
- center_y — float4
- center_z — float4
- radius — float4
- arc_start_angle — float4
- arc_end_angle — float4
- handle — varchar(255)
entities_circle
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- center_x — float4
- center_y — float4
- center_z — float4
- radius — float4
- handle — varchar(255)
entities_dimension
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- dim_type — int4
- dim_defpoint_x — float4
- dim_defpoint_y — float4
- dim_defpoint_z — float4
- dim_defpoint2_x — float4
- dim_defpoint2_y — float4
- dim_defpoint2_z — float4
- dim_defpoint3_x — float4
- dim_defpoint3_y — float4
- dim_defpoint3_z — float4
- dim_defpoint4_x — float4
- dim_defpoint4_y — float4
- dim_defpoint4_z — float4
- dim_text — varchar(400)
- dim_layer — varchar(400)
- dim_rotation — float4
- dim_text_midpoint_x — float4
- dim_text_midpoint_y — float4
- dim_text_midpoint_z — float4
- handle — varchar(255)
entities_ellipse
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- center_x — float4
- center_y — float4
- center_z — float4
- major_axis_x — float4
- major_axis_y — float4
- major_axis_z — float4
- ratio — float4
- start_param — float4
- end_param — float4
- handle — varchar(255)
entities_hatch
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- pattern — varchar(255)
- scale — float4
- angle — float4
- solid_fill — bool
- handle — varchar(255)
entities_image
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- insertion_point_x — float4
- insertion_point_y — float4
- insertion_point_z — float4
- u_vector_x — float4
- u_vector_y — float4
- u_vector_z — float4
- v_vector_x — float4
- v_vector_y — float4
- v_vector_z — float4
- image_name — varchar(255)
- handle — varchar(255)
entities_insert
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- block_name — varchar(255)
- insertion_point_x — float4
- insertion_point_y — float4
- insertion_point_z — float4
- scale_x — float4
- scale_y — float4
- scale_z — float4
- rotation — float4
- handle — varchar(255)
entities_leader
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- annotation_text — varchar(255)
- vertices — public.geometry(multipoint, 5179)
- handle — varchar(255)
entities_line
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- start_x — float4
- start_y — float4
- start_z — float4
- end_x — float4
- end_y — float4
- end_z — float4
- handle — varchar(255)
entities_lwpolyline
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- is_closed — bool
- vertices — public.geometry(multipoint, 5179)
- bulge_values — _float8
- start_width_values — _float8
- end_width_values — _float8
- handle — varchar(255)
entities_mline
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- vertices — public.geometry(multipoint, 5179)
- handle — varchar(255)
entities_mtext
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- x — float4
- y — float4
- z — float4
- text_value — text
- font — varchar(100)
- text_height — float4
- rotation — float4
- attachment_point — varchar(50)
- handle — varchar(255)
entities_point
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- x — float4
- y — float4
- z — float4
- point_size — float4
- handle — varchar(255)
entities_polyline
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- is_closed — bool
- polyline_vertices — public.geometry(multipoint, 5179)
- polyline_bulge_values — _float8
- polyline_start_width_values — _float8
- polyline_end_width_values — _float8
- handle — varchar(255)
entities_ray
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- start_x — float4
- start_y — float4
- start_z — float4
- direction_x — float4
- direction_y — float4
- direction_z — float4
- handle — varchar(255)
entities_region
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- vertices — public.geometry(multipolygon, 5179)
- handle — varchar(255)
entities_section
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- start_x — float4
- start_y — float4
- start_z — float4
- end_x — float4
- end_y — float4
- end_z — float4
- handle — varchar(255)
entities_solid
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- v1_x — float4
- v1_y — float4
- v1_z — float4
- v2_x — float4
- v2_y — float4
- v2_z — float4
- v3_x — float4
- v3_y — float4
- v3_z — float4
- v4_x — float4
- v4_y — float4
- v4_z — float4
- handle — varchar(255)
entities_spline
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- degree — int4
- control_points — public.geometry(multipoint, 5179)
- knots — _float8
- weights — _float8
- handle — varchar(255)
entities_text
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- x — float4
- y — float4
- z — float4
- text_value — text
- font — varchar(100)
- text_size — float4
- text_rotation — float4
- text_alignment — varchar(50)
- handle — varchar(255)
entities_tolerance
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- x — float4
- y — float4
- z — float4
- value — text
- handle — varchar(255)
entities_vertex
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- x — float4
- y — float4
- z — float4
- bulge — float4
- start_width — float4
- end_width — float4
- handle — varchar(255)
entities_viewport
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- center_x — float4
- center_y — float4
- center_z — float4
- width — float4
- height — float4
- view_target_x — float4
- view_target_y — float4
- view_target_z — float4
- view_direction_x — float4
- view_direction_y — float4
- view_direction_z — float4
- view_twist_angle — float4
- handle — varchar(255)
entities_xline
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- type — varchar(50) — NOT NULL
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- start_x — float4
- start_y — float4
- start_z — float4
- direction_x — float4
- direction_y — float4
- direction_z — float4
- handle — varchar(255)
handles
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4 — NOT NULL
- handle — varchar(255) — NOT NULL
- entity_type — varchar(50) — NOT NULL
insert_entities_geometry
- id — int4
- project_id — int4
- type — varchar(50)
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- handle — varchar(255)
- geom — public.geometry
- block_name — varchar(255)
- scale_x — float4
- scale_y — float4
- scale_z — float4
- rotation — float4
layers
- id — serial4 — 기본 키 — NOT NULL
- name — varchar(255) — NOT NULL
- color — int4
- linetype — varchar(50)
- lineweight — float4
- plot — bool
- transparency — float4
- locked — bool
- project_id — int4
- order_index — int4
leader_entities_geometry
- id — int4
- project_id — int4
- type — varchar(50)
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- handle — varchar(255)
- annotation_text — varchar(255)
- geom — public.geometry
line_entities_geometry
- id — int4
- project_id — int4
- type — varchar(50)
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- handle — varchar(255)
- geom — public.geometry
lwpolyline_entities_geometry
- id — int4
- project_id — int4
- type — varchar(50)
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- handle — varchar(255)
- geom — public.geometry
- is_closed — bool
mline_entities_geometry
- id — int4
- project_id — int4
- type — varchar(50)
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- handle — varchar(255)
- geom — public.geometry
mtext_entities_geometry
- id — int4
- project_id — int4
- type — varchar(50)
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- handle — varchar(255)
- text_value — text
- geom — public.geometry
- font — varchar(100)
- text_height — float4
- rotation — float4
- attachment_point — varchar(50)
point_entities_geometry
- id — int4
- project_id — int4
- type — varchar(50)
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- handle — varchar(255)
- geom — public.geometry
polyline_entities_geometry
- id — serial4 — 기본 키 — NOT NULL
- project_id — int4
- type — varchar(50)
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- handle — varchar(255)
- geom — public.geometry
- is_closed — bool
project_info
- id — serial4 — 기본 키 — NOT NULL
- name — varchar(255) — NOT NULL
- project_id — int4
- sigungu — varchar
region_entities_geometry
- id — int4
- project_id — int4
- type — varchar(50)
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- handle — varchar(255)
- geom — public.geometry
section_entities_geometry
- id — int4
- project_id — int4
- type — varchar(50)
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- handle — varchar(255)
- geom — public.geometry
solid_entities_geometry
- id — int4
- project_id — int4
- type — varchar(50)
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- handle — varchar(255)
- geom — public.geometry
spatial_ref_sys
- srid — int4 — 기본 키 — NOT NULL
- auth_name — varchar(256)
- auth_srid — int4
- srtext — varchar(2048)
- proj4text — varchar(2048)
text_entities_geometry
- id — int4
- project_id — int4
- type — varchar(50)
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- handle — varchar(255)
- text_value — text
- geom — public.geometry
- font — varchar(100)
- text_size — float4
- text_rotation — float4
- text_alignment — varchar(50)
threedface_entities_geometry
- id — int4
- project_id — int4
- type — varchar(50)
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- handle — varchar(255)
- geom — public.geometry
tolerance_entities_geometry
- id — int4
- project_id — int4
- type — varchar(50)
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- handle — varchar(255)
- geom — public.geometry
- value — text
vertex_entities_geometry
- id — int4
- project_id — int4
- type — varchar(50)
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- handle — varchar(255)
- geom — public.geometry
- bulge — float4
- start_width — float4
- end_width — float4
viewport_entities_geometry
- id — int4
- project_id — int4
- type — varchar(50)
- layer_id — int4
- block_id — varchar
- color — int4
- linetype — varchar(50)
- lineweight — float4
- handle — varchar(255)
- geom — public.geometry
- width — float4
- height — float4
- view_target_x — float4
- view_target_y — float4
- view_target_z — float4
- view_direction_x — float4
- view_direction_y — float4
- view_direction_z — float4
- view_twist_angle — float4