사우디 레이어

테이블 (28)

images_tile_file (Untitled17)

  • Key — 기본 키 — NOT NULL
  • images_tile_cd (Field)
  • original_filename (Field2)
  • size (Field3)
  • file_type (Field4)
  • file_path (Field5)
  • reg_nm (Field6)
  • reg_dt (Field7)

images_tile_hist (Untitled18)

  • Key — 기본 키 — NOT NULL
  • images_tile_info_id (Field)
  • opert_process_code (Field2)
  • opert_status_cd (Field3)
  • start_dt (Field4)
  • end_dt (Field5)
  • opert_desc (Field6)

images_tile_info (Untitled16)

  • Key — 기본 키 — NOT NULL
  • images_tile_nm (Field)
  • images_tile_type (Field2)
  • images_tile_fliming_date (Field3)
  • city (Field4)
  • use_yn (Field5)
  • reg_nm (Field6)
  • reg_dt (Field7)
  • up_nm (Field8)
  • up_dt (Field9)
  • images_tile_file_id (Field10)

ksa_layer_base_info (Untitled4)

  • id (key) — BIGSERIAL — 기본 키
  • ksa_resource_group_meta_id (Key) — NOT NULL
  • publish_name (Field)
  • base_date (Field5)
  • use_yn (Field3)
  • create_user (Field4)
  • created_at (Field7)
  • origin_delete_yn (Field2)
  • group_type (Field6)

ksa_layer_publish_history (Untitled9)

  • id (Key2) — 기본 키 — NOT NULL
  • ksa_layer_base_info_id (Field5)
  • layer_type (Field2)
  • schema_name (Field3)
  • table_name (Field)
  • process_code (Key) — NOT NULL
  • created_at (Field6)
  • create_user (Field7)
  • updated_at (Field4)
  • error_message (Field8)

ksa_layer_publish_info (Untitled23)

  • id (Key) — 기본 키 — NOT NULL
  • layer_publish_type (Field)
  • coord (Field2)
  • schema_name (Field3)
  • table_name (Field4)
  • target_table_name (Field8)
  • use_yn (Field7)
  • create_user (Field9)
  • create_at (Field10)
  • update_dt (Field11)
  • layer_style_name (Field5)

ksa_layer_publish_log (Untitled27)

  • id (Key) — 기본 키 — NOT NULL
  • layer_publish_id (Field)
  • process_code (Field2)
  • error_message (Field7)
  • success_yn (Field5)
  • create_at (Field3)

ksa_model_base_info (Untitled13)

  • Key — BIGSERIAL — 기본 키 — NOT NULL
  • dt_resource_group_meta_id (Field)
  • model_nm (Field2)
  • use_yn (Field4)
  • create_user (Field3)
  • created_at (Field6)
  • model_file_sn (Field5)

ksa_model_file (Untitled14)

  • Key — 기본 키 — NOT NULL
  • model_file_cd (Field)
  • original_filename (Field2)
  • size (Field3)
  • file_type (Field4)
  • file_path (Field5)
  • create_user (Field6)
  • created_at (Field7)

ksa_resource_group (Untitled15)

  • id (Key) — 기본 키 — NOT NULL
  • group_type (Field5)
  • parent_id (Field7)
  • group_name (Field)
  • description (Field6)
  • create_user (Field2)
  • use_yn (Field4)
  • sort (Field8)
  • created_at (Field3)
  • updated_at (Field9)

ksa_resource_group_meta (CopyOfUntitled3)

  • id (key) — BIGSERIAL — 기본 키
  • data_type (Field4) — varchar(100)
  • base_code (Field) — varchar(500)
  • coord (Field5) — int
  • schema_name (Field6)
  • table_name (Field7) — varchar(10)
  • group_id (Field2)

ksa_resource_service (Untitled22)

  • id (Key) — 기본 키 — NOT NULL
  • resource_name (Field)
  • resource_layer_name (Field2)
  • resource_type (Field3)
  • resource_url (Field4)
  • sort (Field5)
  • use_yn (Field6)
  • create_user (Field7)
  • create_at (Field8)
  • update_user (Field9)
  • update_dt (Field10)
  • layer_publish_id (Field11)
  • resource_admin_yn (Field12)

ksa_role (Untitled24)

  • role_code (Key) — 기본 키 — NOT NULL
  • role_name (Field)
  • description (Field2)
  • use_yn (Field3)

ksa_role_themes (Untitled26)

  • role_code (Key) — 기본 키 — NOT NULL
  • theme_id (Key2) — 기본 키 — NOT NULL
  • resource_id (Key3) — 기본 키 — NOT NULL

ksa_themes (Untitled21)

  • id (Key) — 기본 키 — NOT NULL
  • parent_id (Field)
  • themes_type (Field2)
  • themes_name (Field3)
  • description (Field4)
  • sort (Field5)
  • use_yn (Field6)
  • create_user (Field7)
  • create_at (Field8)
  • update_user (Field9)
  • update_at (Field10)

ksa_user_role_relation_themes (Untitled25)

  • user_id (Key) — 기본 키 — NOT NULL
  • role_code (Key2) — 기본 키 — NOT NULL

layer_category (Untitled2)

  • id (key) — BIGSERIAL — 기본 키
  • layer_category_mstr_id (Field2)
  • parent_id (Key) — NOT NULL
  • info_nm (Field4) — varchar(100)
  • use_yn (Field)

layer_category_mstr (Untitled1)

  • id (Key) — 기본 키 — NOT NULL
  • layer_category_nm (Field) — varchar(100)
  • use_yn (Field2)
  • sort (Field3)
  • reg_nm (Field4)
  • reg_dt (Field5)

layer_source_meta (Untitled3)

  • id (key) — BIGSERIAL — 기본 키
  • layer_category_id (Field2)
  • info_type (Field4) — varchar(100)
  • info_cd (Field) — varchar(500)
  • info_coord (Field5) — int
  • info_scm_nm (Field6)
  • info_tbl (Field7) — varchar(10)
  • orgnl_del_yn (Field12)

lod_publish_info (Untitled19)

  • Key — 기본 키 — NOT NULL
  • category_meta_id (Field)
  • service_uri (Field7)
  • service_name (Field3)
  • lod_center (Field2)
  • use_yn (Field4)
  • geo_style (Field5)
  • color (Field6)
  • lod_publish_rel_id (Field8)

lod_publish_rel (Untitled20)

  • Key — 기본 키 — NOT NULL
  • lod_publish_info_id (Key2) — NOT NULL

model_category (Untitled11)

  • Key — 기본 키 — NOT NULL
  • model_category_mstr_id (Field)
  • parent_id (Field2)
  • info_nm (Field3)
  • use_yn (Field4)

model_category_mstr (Untitled10)

  • id (Key) — 기본 키 — NOT NULL
  • model_category_desc (Field) — varchar(100)
  • sort (Field2)
  • use_yn (Field3)
  • reg_nm (Field4)
  • reg_dt (Field5)

model_soure (Untitled12)

  • id (key) — BIGSERIAL — 기본 키
  • model_category_id (Field2)
  • info_type (Field4) — varchar(100)
  • info_cd (Field) — varchar(500)

user_layer_category (Untitled6)

  • id (key) — BIGSERIAL — 기본 키
  • user_layer_category_mstr_id (Field2)
  • parent_id (Key) — NOT NULL
  • info_nm (Field4) — varchar(100)
  • use_yn (Field)

user_layer_category_mstr (Untitled5)

  • id (Key) — 기본 키 — NOT NULL
  • user_layer_category_nm (Field) — varchar(100)
  • use_yn (Field2)
  • sort (Field3)
  • reg_nm (Field4)
  • reg_dt (Field5)

user_layer_publish_info (Untitled8)

  • id (key) — BIGSERIAL — 기본 키
  • category_meta_id (Key) — NOT NULL
  • layer_publish_nm (Field)
  • basedate (Field5)
  • ues_yn (Field7)
  • created_name (Field4)
  • created_at (Field6)
  • layer_publish_hist_id (Field8)

user_layer_source_meta (Untitled7)

  • id (key) — BIGSERIAL — 기본 키
  • user_layer_category_id (Field2)
  • info_type (Field4) — varchar(100)
  • info_cd (Field) — varchar(500)
  • info_coord (Field5) — int