신규
테이블 (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