사우디 레이어
테이블 (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