신규

테이블 (9)

ksa_group

  • group_id — bigserial — 기본 키 — NOT NULL
  • parent_id — int8 — 외래 키 → ksa_group.group_id
  • group_name — varchar(200) — NOT NULL
  • description — varchar(1000)
  • sort — int4 — NOT NULL
  • admin_yn — bpchar(1) — NOT NULL
  • city — varchar(100)
  • use_yn — bpchar(1) — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — int8 — NOT NULL
  • updated_at — timestamp
  • updated_by — int8
  • del_yn — bpchar(1) — NOT NULL

ksa_group_resource_mapping

  • group_resource_mapping_id — bigserial — 기본 키 — NOT NULL
  • group_id — int8 — 외래 키 → ksa_group.group_id — NOT NULL
  • resource_id — int8 — 외래 키 → ksa_resource.resource_id — NOT NULL
  • sort — int4 — NOT NULL
  • common_yn — bpchar(1) — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — int8 — NOT NULL
  • updated_at — timestamp
  • updated_by — int8
  • del_yn — bpchar(1) — NOT NULL

ksa_layer_publish

  • layer_publish_id — bigserial — 기본 키 — NOT NULL
  • layer_publish_type — varchar(100) — NOT NULL
  • layer_publish_name — varchar(200) — NOT NULL
  • source_srid — varchar(50)
  • source_file_name — varchar(500)
  • source_file_path — varchar(2000)
  • schema_name — varchar(200)
  • table_name — varchar(200)
  • workspace_name — varchar(200)
  • store_name — varchar(200)
  • geoserver_layer_name — varchar(300)
  • layer_publish_target_name — varchar(300)
  • admin_yn — bpchar(1) — NOT NULL
  • city — varchar(100)
  • use_yn — bpchar(1) — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — int8 — NOT NULL
  • updated_at — timestamp
  • updated_by — int8
  • del_yn — bpchar(1) — NOT NULL

ksa_layer_publish_log

  • publish_log_id — bigserial — 기본 키 — NOT NULL
  • layer_publish_id — int8 — 외래 키 → ksa_layer_publish.layer_publish_id — NOT NULL
  • process_code — varchar(100)
  • success_yn — bpchar(1)
  • error_message — text
  • created_at — timestamp — NOT NULL

ksa_resource

  • resource_id — bigserial — 기본 키 — NOT NULL
  • layer_publish_id — int8 — 외래 키 → ksa_layer_publish.layer_publish_id
  • resource_name — varchar(200) — NOT NULL
  • resource_layer_name — varchar(300)
  • resource_type — varchar(100) — NOT NULL
  • resource_url — varchar(2000)
  • resource_attrs — jsonb
  • sort — int4 — NOT NULL
  • admin_yn — bpchar(1) — NOT NULL
  • city — varchar(100)
  • use_yn — bpchar(1) — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — int8 — NOT NULL
  • updated_at — timestamp
  • updated_by — int8
  • del_yn — bpchar(1) — NOT NULL

ksa_resource_favorite

  • resource_favorite_id — bigserial — 기본 키 — NOT NULL
  • resource_id — int8 — 외래 키 → ksa_resource.resource_id — NOT NULL
  • member_id — int8 — NOT NULL
  • use_yn — bpchar(1) — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — int8 — NOT NULL
  • updated_at — timestamp
  • updated_by — int8
  • del_yn — bpchar(1) — NOT NULL

ksa_resource_role

  • resource_role_id — bigserial — 기본 키 — NOT NULL
  • resource_role_name — varchar(200) — NOT NULL
  • description — varchar(1000)
  • sort — int4 — NOT NULL
  • admin_yn — bpchar(1) — NOT NULL
  • city — varchar(100)
  • use_yn — bpchar(1) — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — int8 — NOT NULL
  • updated_at — timestamp
  • updated_by — int8
  • del_yn — bpchar(1) — NOT NULL

ksa_resource_role_resource_mapping

  • resource_role_resource_mapping_id — int8 — 기본 키 — NOT NULL
  • resource_role_id — int8 — 외래 키 → ksa_resource_role.resource_role_id — NOT NULL
  • resource_id — int8 — 외래 키 → ksa_resource.resource_id — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — int8 — NOT NULL
  • updated_at — timestamp
  • updated_by — int8
  • del_yn — bpchar(1) — NOT NULL

ksa_resource_role_user_mapping

  • resource_role_user_mapping_id — int8 — 기본 키 — NOT NULL
  • resource_role_id — int8 — 외래 키 → ksa_resource_role.resource_role_id — NOT NULL
  • user_id — int8 — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — int8 — NOT NULL
  • updated_at — timestamp
  • updated_by — int8
  • del_yn — bpchar(1) — NOT NULL