DataCatalog

Tables (47)

tb_account

  • user_id — varchar(50) — Primary key — NOT NULL
  • dept_id — varchar — Foreign key → tb_account_dept.dept_id — NOT NULL
  • user_name — varchar(50)
  • password — varchar(255)
  • user_type — int4 — NOT NULL
  • email — varchar(355)
  • create_time — timestamp
  • last_login_time — timestamp
  • menu_role — varchar(20)
  • group_id — int4
  • login_fail_cnt — int4
  • create_date — timestamp

tb_account_dept

  • dept_id — varchar — Primary key — NOT NULL
  • dept_name — varchar
  • parent_dept_id — varchar
  • description — varchar
  • dept_level — varchar
  • ord_no — int4

tb_account_history

  • id — serial4 — Primary key — NOT NULL
  • user_id — varchar(50) — Foreign key → tb_account.user_id — NOT NULL
  • user_name — varchar
  • login_date — timestamp
  • user_ip_addr — varchar(50) — NOT NULL
  • dept_name — varchar
  • login_type — varchar

tb_classification_info

  • id — varchar — Primary key — NOT NULL
  • dept_id — varchar — Foreign key → tb_account_dept.dept_id — NOT NULL
  • parent_id — varchar
  • level — varchar — NOT NULL
  • name — varchar — NOT NULL
  • description — varchar — NOT NULL
  • ord_no — int4
  • file_id — int4

tb_code

  • id — serial4 — Primary key — NOT NULL
  • parent_id — int4
  • level — varchar
  • name — varchar(30)
  • value — varchar(100)
  • description — varchar
  • type — varchar(30) — NOT NULL

tb_data_favorite

  • meta_id — varchar — Primary key — NOT NULL
  • user_id — varchar(50) — Foreign key → tb_account.user_id — NOT NULL
  • meta_name — varchar
  • meta_type — varchar
  • qualified_name — varchar
  • favorite_date — timestamp

tb_data_recommend

  • meta_id — varchar — Primary key — NOT NULL
  • user_id — varchar(50) — Foreign key → tb_account.user_id — NOT NULL
  • meta_name — varchar
  • meta_type — varchar
  • qualified_name — varchar
  • recommend_date — timestamp

tb_data_review

  • meta_id — varchar — Primary key — NOT NULL
  • review_id — int8 — Primary key — NOT NULL
  • user_id — varchar(50) — Foreign key → tb_account.user_id — NOT NULL
  • meta_name — varchar
  • meta_type — varchar
  • qualified_name — varchar
  • review — text
  • review_date — timestamp

tb_data_user_description

  • id — bigserial — Primary key — NOT NULL
  • user_id — varchar(50) — Foreign key → tb_account.user_id — NOT NULL
  • meta_id — varchar — NOT NULL
  • meta_name — varchar — NOT NULL
  • meta_type — varchar — NOT NULL
  • qualified_name — varchar — NOT NULL
  • user_name — varchar
  • user_description — text
  • create_date — timestamp
  • update_date — timestamp
  • favorite — int4 — NOT NULL

tb_data_user_description_favorite

  • id — serial4 — Primary key — NOT NULL
  • user_id — varchar(50) — Foreign key → tb_account.user_id — NOT NULL
  • favorite_date — timestamp

tb_diagram_node_info

  • node_id — varchar — Primary key — NOT NULL
  • node_name — varchar
  • reg_date — timestamp
  • node_type — int4
  • type_name — varchar
  • db_name — varchar
  • update_date — varchar
  • qualified_name — varchar
  • description — varchar

tb_diagram_node_link

  • link_id — int8 — Primary key — NOT NULL
  • to_node_id — varchar — Foreign key → tb_diagram_node_info.node_id — NOT NULL
  • from_node_id — varchar — Foreign key → tb_diagram_node_info.node_id — NOT NULL
  • link_name — varchar
  • reg_date — timestamp

tb_download_extract

  • extract_id — varchar — Primary key — NOT NULL
  • user_id — varchar(50) — Foreign key → tb_account.user_id — NOT NULL
  • meta_id — varchar
  • meta_name — varchar
  • status — int4
  • data_file — varchar
  • qualified_name — varchar
  • download_query — varchar
  • create_date — timestamp
  • start_time — timestamp
  • end_time — timestamp
  • download_limit_time — timestamp
  • minio_bucket — varchar
  • minio_object_name — varchar
  • share_url — varchar
  • user_name — varchar
  • dept_name — varchar
  • user_ip_addr — varchar(50)
  • err_description — varchar

tb_event_log

  • event_id — int4 — Primary key — NOT NULL
  • meta_id — uuid — Foreign key → tb_meta_data.meta_id — NOT NULL
  • event_type — int2
  • event_status — int2
  • event_name — varchar — NOT NULL
  • event_time — timestamp
  • event_user_id — varchar
  • meta_name — varchar — NOT NULL
  • qualified_name — varchar — NOT NULL

tb_file

  • file_id — int4 — Primary key — NOT NULL
  • reg_user — varchar(50) — Foreign key → tb_account.user_id — NOT NULL
  • file_location — text
  • file_name — text
  • file_size — varchar(60)
  • reg_date — timestamp
  • post_id — int4
  • file_type — varchar(10) — NOT NULL

tb_mail_templates

  • template_id — varchar — Primary key — NOT NULL
  • template_title — varchar — NOT NULL
  • template_content — text
  • sender — _text — NOT NULL
  • receiver — _text — NOT NULL
  • cc_recipients — _text
  • bcc_recipients — _text
  • file_link — varchar
  • template_variables — _text
  • template_sms_content — varchar
  • use_yn — varchar(1)

tb_menu

  • menu_id — varchar(10) — Primary key — NOT NULL
  • menu_name — varchar(60) — NOT NULL
  • menu_path — varchar(60) — NOT NULL
  • parent_menu_id — varchar(60)
  • menu_depth — int4
  • order_num — int4
  • menu_visible — bool

tb_menu_history

  • id — serial4 — Primary key — NOT NULL
  • menu_id — varchar(10) — Foreign key → tb_menu.menu_id — NOT NULL
  • user_id — varchar(50) — Foreign key → tb_account.user_id — NOT NULL
  • dept_id — varchar — Foreign key → tb_account_dept.dept_id — NOT NULL
  • create_date — timestamp
  • user_name — varchar
  • dept_name — varchar

tb_menu_role

  • id — int4 — Primary key — NOT NULL
  • menu_id — varchar(10) — Foreign key → tb_menu.menu_id — NOT NULL
  • menu_role_name — varchar(60) — NOT NULL
  • order_num — int4

tb_meta_data

  • meta_id — uuid — Primary key — NOT NULL
  • system_id — varchar — Foreign key → tb_meta_system_info.system_id — NOT NULL
  • qualified_name — varchar — NOT NULL
  • system_type — varchar — NOT NULL
  • meta_type — varchar
  • meta_name — varchar — NOT NULL
  • display_name — varchar
  • description — varchar
  • user_description — varchar
  • classifications — _varchar
  • attributes — jsonb
  • business_attributes — jsonb
  • labels — _varchar
  • tags — _varchar
  • status — varchar
  • life_cycle — int4
  • create_time — timestamp
  • create_by — varchar
  • update_time — timestamp
  • update_by — varchar
  • last_access_time — timestamp
  • version — float8
  • meta_sync_time — timestamp
  • release — int4
  • create_time (create_time2) — timestamp — Foreign key → tb_meta_system_status.create_time — NOT NULL
  • system_id (system_id2) — varchar — Foreign key → tb_meta_system_status.system_id — NOT NULL

tb_meta_data_unstructured

  • meta_id — uuid — Foreign key → tb_meta_data.meta_id — NOT NULL
  • qualified_name — varchar — NOT NULL
  • system_type — varchar — NOT NULL
  • system_id — varchar — NOT NULL
  • meta_type — varchar
  • meta_name — varchar — NOT NULL
  • display_name — varchar
  • description — varchar
  • user_description — varchar
  • classifications — _varchar
  • attributes — jsonb
  • business_attributes — jsonb
  • labels — _varchar
  • tags — _varchar
  • status — varchar
  • life_cycle — int4
  • create_time — timestamp
  • create_by — varchar
  • update_time — timestamp
  • update_by — varchar
  • last_access_time — timestamp
  • version — float8
  • meta_sync_time — timestamp
  • release — int4

tb_meta_system_info

  • system_id — varchar — Primary key — NOT NULL
  • system_type — varchar — NOT NULL
  • system_name — varchar — NOT NULL
  • collect_flag — bool
  • host — varchar
  • port — int4
  • login — varchar
  • password — varchar
  • database — varchar
  • filter_config — jsonb
  • interval — varchar
  • create_date — timestamp — NOT NULL
  • create_user — varchar(50)
  • update_date — timestamp
  • update_user — varchar(50)
  • meta_sync_time — timestamp
  • status — varchar(30)
  • err_description — varchar
  • schema — varchar
  • hive_thrift_port — int4
  • catalog — varchar

tb_meta_system_slow

  • create_time — timestamp
  • system_id — varchar — NOT NULL
  • system_type — varchar
  • system_name — varchar
  • query_string — varchar
  • query_time — int8
  • query_start_time — timestamp
  • query_end_time — timestamp

tb_meta_system_status

  • create_time — timestamp — Primary key — NOT NULL
  • system_id — varchar — Primary key — NOT NULL
  • system_type — varchar
  • system_name — varchar
  • connection_status — int4
  • response_time — int8
  • usage_cpu — int8
  • usage_memory — numeric(10, 2)
  • query_success_count — int4
  • query_fail_count — int4

tb_post

  • id — int4 — Primary key — NOT NULL
  • writer — varchar(50) — Foreign key → tb_account.user_id — NOT NULL
  • post_type — varchar(60) — NOT NULL
  • email — text
  • title — varchar(50) — NOT NULL
  • post_content — text — NOT NULL
  • upload_date — timestamp — NOT NULL
  • view_count — int4
  • category — varchar(60)
  • admin_reply — text
  • ord_no — int4
  • post_guid — varchar
  • file_link — varchar
  • is_open — bool
  • post_password — varchar(40)

tb_post_answer

  • answer_id — int4 — NOT NULL
  • id — int4
  • writer — varchar(60)
  • upload_date — timestamp — NOT NULL
  • process_status — varchar(10)
  • admin_reply — text
  • create_date — timestamp — NOT NULL

tb_post_data_request

  • id — int4 — Primary key — NOT NULL
  • writer — varchar(50) — Foreign key → tb_account.user_id — NOT NULL
  • request_type — int4 — NOT NULL
  • title — varchar(50) — NOT NULL
  • data_name — text — NOT NULL
  • contents — text — NOT NULL
  • request_start — timestamp
  • request_end — timestamp
  • benefit_content — text — NOT NULL
  • create_date — timestamp — NOT NULL
  • update_date — timestamp
  • process_status — int4 — NOT NULL
  • finish_date — timestamp

tb_post_data_request_answer

  • id — int4 — Primary key — NOT NULL
  • data_request_id — int4 — Foreign key → tb_post_data_request.id — NOT NULL
  • writer — varchar(50) — Foreign key → tb_account.user_id — NOT NULL
  • process_status — int4 — NOT NULL
  • admin_reply — text
  • create_date — timestamp — NOT NULL
  • update_date — timestamp

tb_post_share

  • id — int4 — Primary key — NOT NULL
  • writer — varchar(50) — Foreign key → tb_account.user_id — NOT NULL
  • title — varchar(50) — NOT NULL
  • contents — text — NOT NULL
  • create_date — timestamp — NOT NULL
  • update_date — timestamp

tb_profile_column

  • column_id — varchar — Primary key — NOT NULL
  • name — varchar
  • meta_type — varchar
  • qualified_name — varchar
  • status — varchar
  • db_name — varchar
  • table_name — varchar
  • update_date — timestamp
  • row_count — int8
  • null_count — int8
  • distinct_count — int8
  • min_value — float4
  • max_value — float4
  • avg_value — float4
  • var_value — float4
  • std_value — float4
  • err_description — varchar

tb_profile_db

  • meta_id — uuid — Foreign key → tb_meta_data.meta_id — NOT NULL
  • name — varchar
  • meta_type — varchar
  • qualified_name — varchar
  • status — varchar
  • update_date — timestamp
  • num_table — int4

tb_profile_table

  • meta_id — uuid — Foreign key → tb_meta_data.meta_id — NOT NULL
  • name — varchar
  • meta_type — varchar
  • qualified_name — varchar
  • status — varchar
  • db_name — varchar
  • update_date — timestamp
  • last_modified_time — varchar
  • total_size — int8
  • num_rows — int8
  • raw_data_size — int8
  • num_files — int4
  • err_description — varchar
  • sample_data_url — varchar

tb_recommend_meta

  • seq — int4 — Primary key — NOT NULL
  • meta_id — uuid — Foreign key → tb_meta_data.meta_id — NOT NULL
  • meta_name — varchar
  • meta_type — varchar
  • qualified_name — varchar
  • owner — varchar

tb_recommend_search

  • seq — varchar — Primary key — NOT NULL
  • search_word — varchar

tb_role

  • role_id — varchar(20) — Primary key — NOT NULL
  • role_type — int4 — NOT NULL
  • role_name — varchar(20)
  • role_description — text
  • role_auth — int4 — NOT NULL
  • etc — varchar(20)

tb_role_dept

  • seq — serial4 — Primary key — NOT NULL
  • role_id — varchar(20) — Foreign key → tb_role.role_id — NOT NULL
  • dept_id — varchar(50)
  • etc — varchar(20)

tb_role_meta

  • seq — serial4 — Primary key — NOT NULL
  • role_id — varchar(20) — Foreign key → tb_role.role_id — NOT NULL
  • meta_id — uuid — Foreign key → tb_meta_data.meta_id — NOT NULL
  • etc — varchar(20)

tb_role_user

  • seq — serial4 — Primary key — NOT NULL
  • role_id — varchar(20) — Foreign key → tb_role.role_id — NOT NULL
  • user_id — varchar(50) — Foreign key → tb_account.user_id — NOT NULL
  • etc — varchar(20)

tb_search_meta_history

  • search_meta_id — serial4 — Primary key — NOT NULL
  • user_id — varchar(50) — Foreign key → tb_account.user_id — NOT NULL
  • system_id — varchar — Foreign key → tb_meta_system_info.system_id — NOT NULL
  • meta_id — uuid — Foreign key → tb_meta_data.meta_id — NOT NULL
  • system_name — varchar
  • system_type — varchar
  • meta_name — varchar
  • meta_type — varchar
  • qualified_name — varchar
  • search_date — timestamp — NOT NULL
  • description — varchar
  • user_name — varchar
  • dept_id — varchar
  • dept_name — varchar

tb_search_text_history

  • id — serial4 — Primary key — NOT NULL
  • user_id — varchar(50) — Foreign key → tb_account.user_id — NOT NULL
  • search_string — varchar
  • search_date — timestamp
  • etc — varchar
  • user_name — varchar
  • dept_id — varchar
  • dept_name — varchar

tb_standard_domain

  • id — uuid — Primary key — NOT NULL
  • name — varchar — NOT NULL
  • group_name — varchar
  • domain_classified_name — varchar
  • description — varchar — NOT NULL
  • data_type — varchar
  • data_size — int8
  • decimal_point_size — int8
  • save_format — varchar
  • expression_format — varchar
  • unit — varchar
  • permission_value — varchar
  • used — varchar
  • final_version_date — varchar
  • created_date — timestamptz
  • modified_date — timestamptz
  • creator — varchar
  • modifier — varchar

tb_standard_term

  • id — uuid — Primary key — NOT NULL
  • name — varchar — NOT NULL
  • english_sign — varchar — NOT NULL
  • description — varchar — NOT NULL
  • domain — varchar
  • permission_value — varchar
  • save_format — varchar
  • expression_format — varchar
  • admin_standard_code_name — varchar
  • competent_authority — varchar
  • used — varchar
  • final_version_date — varchar
  • created_date — timestamptz
  • modified_date — timestamptz
  • creator — varchar
  • modifier — varchar
  • synonym — varchar
  • english_name — varchar

tb_standard_word

  • id — uuid — Primary key — NOT NULL
  • name — varchar — NOT NULL
  • english_sign — varchar — NOT NULL
  • word_eng — varchar — NOT NULL
  • description — varchar — NOT NULL
  • form_checked — varchar
  • domain_classified_name — varchar
  • synonym — varchar
  • forbidden — varchar
  • used — varchar
  • final_version_date — varchar
  • created_date — timestamptz
  • modified_date — timestamptz
  • creator — varchar
  • modifier — varchar

tb_synonyms

  • id — bigserial — Primary key — NOT NULL
  • create_user — varchar(50) — Foreign key → tb_account.user_id — NOT NULL
  • update_user — varchar(50) — Foreign key → tb_account.user_id — NOT NULL
  • term — varchar — NOT NULL
  • synonym — varchar — NOT NULL
  • create_date — timestamp — NOT NULL
  • update_date — varchar

tb_synonyms_req

  • id — bigserial — Primary key — NOT NULL
  • term — varchar
  • type — int2
  • request — varchar
  • response — varchar
  • status — int2
  • req_date — timestamp
  • res_date — timestamp
  • req_user — varchar(50) — Foreign key → tb_account.user_id — NOT NULL
  • res_user — varchar(50) — Foreign key → tb_account.user_id — NOT NULL

tb_synonyms_req_item

  • id — bigserial — Primary key — NOT NULL
  • synonym_id — bigserial — Foreign key → tb_synonyms.id — NOT NULL
  • req_id — int8 — NOT NULL
  • synonym — varchar — NOT NULL

tb_tag_info

  • tag_name — varchar — Primary key — NOT NULL
  • etc — varchar
  • reg_user — varchar(20)
  • reg_date — timestamp