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