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

    ksa_theme_role (Untitled2)

      ksa_theme_role_mapp (Untitled)