test
Tables (12)
Untitled3
ksa_layer_publish
- layer_publish_id — bigserial — Primary key — NOT NULL
- layer_publish_type — varchar(50) — NOT NULL
- layer_publish_name — varchar(200) — NOT NULL
- source_srid — int8
- source_file_name — varchar(500)
- source_file_path — varchar
- schema_name — varchar(200)
- table_name — varchar(200)
- workspace_name — varchar(200)
- store_name — varchar(200)
- geoserver_layer_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 — Primary key — NOT NULL
- layer_publish_id — int8 — Foreign key → ksa_layer_publish.layer_publish_id — NOT NULL
- process_code — varchar(100) — NOT NULL
- success_yn — bpchar(1) — NOT NULL
- error_message — text
- created_at — timestamp — NOT NULL
ksa_resource
- resource_id — bigserial — Primary key — NOT NULL
- layer_publish_id — int8 — Foreign key → 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 — Primary key — NOT NULL
- resource_id — int8 — Foreign key → ksa_resource.resource_id — NOT NULL
- user_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_group
- resource_group_id — bigserial — Primary key — NOT NULL
- resource_group_name — varchar(200) — NOT NULL
- description — varchar(1000)
- sort — int4 — NOT NULL
- city — varchar(100)
- default_yn — bpchar(1) — 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_group_resource_mapping
- resource_group_resource_mapping_id — int8 — Primary key — NOT NULL
- resource_group_id — int8 — Foreign key → ksa_resource_group.resource_group_id — NOT NULL
- resource_id — int8 — Foreign key → ksa_resource.resource_id — NOT NULL
- sort — int4 — 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_theme
- theme_id — bigserial — Primary key — NOT NULL
- parent_id — int8 — Foreign key → ksa_theme.theme_id
- theme_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_theme_resource_mapping
- theme_resource_mapping_id — bigserial — Primary key — NOT NULL
- theme_id — int8 — Foreign key → ksa_theme.theme_id — NOT NULL
- resource_id — int8 — Foreign key → ksa_resource.resource_id — NOT NULL
- sort — int4 — 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_theme_resource_user_mapping
- theme_resource_user_mapping_id — int8 — Primary key — NOT NULL
- theme_resource_mapping_id — int8 — Foreign key → ksa_theme_resource_mapping.theme_resource_mapping_id — NOT NULL
- user_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