d
Tables (160)
adequacy_report_level
- report_lev_idx — bigint(20) — Primary key — NOT NULL
- project_id — varchar(36) — Foreign key
- data_id — varchar(36) — Foreign key → data.data_id — NOT NULL
- column_id — varchar(128) — NOT NULL
- column_name — varchar(255) — NOT NULL
- order_desc — mediumtext — NOT NULL
- remark — mediumtext — NOT NULL
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
admin_log
- log_idx — bigint(20) — Primary key — NOT NULL — 행위 로그 IDX
- action — varchar(200) — NOT NULL — 행위 내용
- menu_nm — varchar(200) — NOT NULL — 관련 메뉴 명
- user_id — varchar(36) — NOT NULL — 사용자 ID
- login_id — varchar(50) — NOT NULL — 로그인 ID
- user_name — varchar(1024) — NOT NULL — 사용자 명
- user_dept — varchar(100) — NOT NULL — 소속 부서
- user_grade — varchar(100) — NOT NULL — 직급
- user_position — varchar(100) — NOT NULL — 직책
- user_ip — varchar(128) — NOT NULL — 사용자 IP
- result — varchar(5) — NOT NULL — 결과코드 - CODE_PREFIX(2)/CODE(3)
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
admin_log_detail
- log_idx — bigint(20) — Foreign key → admin_log.log_idx — NOT NULL — 행위 로그 IDX
- log_detail_msg — mediumtext — NOT NULL — 프로젝트 key, 프로젝트 명을 담은 json
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
approval
- aprv_user_id — varchar(36) — Primary key — NOT NULL — 결재자 ID
- project_id — varchar(36) — Foreign key — NOT NULL — 프로젝트 ID
- menu_key — varchar(50) — Foreign key — NOT NULL — 메뉴 Key
- aprv_type — int(11) — 결재 종류
- aprv_user_name — varchar(1024) — 결재자 명
- aprv_status — int(11) — 결재 상태
- comments — mediumtext — 결재 의견
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
attribute
- attribute_idx — bigint(20) — Primary key — NOT NULL — 컬럼 속성 IDX
- attribute_name — varchar(100) — NOT NULL — 컬럼 속성 명
- regexp_value — mediumtext — NOT NULL — 정규식 패턴
- deid_type — int(11) — NOT NULL — 식별자 타입
- data_type — int(11) — NOT NULL — 데이터 타입
- risk_level_type — int(11) — NOT NULL — 위험도 타입
- threshold — int(11) — NOT NULL — 개인정보 탐지 임계치
- description — varchar(1024) — 속성 설명
- is_use — int(11) — NOT NULL — 사용 여부
- column_analysis_at — int(11) — NOT NULL — 가명처리 대상 여부
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
- is_delete — int(11) — NOT NULL — 삭제 여부
attribute_column_match
- project_id — varchar(36) — Primary key — NOT NULL — 프로젝트 ID
- column_id — varchar(128) — Primary key — NOT NULL — 컬럼 ID
- data_id — varchar(128) — Primary key — NOT NULL — 데이터 ID
- attribute_idx — bigint(20) — Foreign key → attribute.attribute_idx — NOT NULL — 컬럼속성 IDX
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
- is_use — int(11) — 적용 여부
attribute_column_name
- column_name — varchar(100) — Primary key — NOT NULL — 매칭 컬럼 명
- attribute_idx — bigint(20) — Foreign key → attribute.attribute_idx — NOT NULL — 컬럼속성 IDX
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
attribute_order_recipe
- attribute_idx — bigint(20) — Foreign key → attribute.attribute_idx — NOT NULL — 컬럼속성 IDX
- order_method — varchar(172) — NOT NULL — 처리 기법
- order_method_name — varchar(172) — NOT NULL — 처리 기법 명
- order_detail_json — mediumtext — NOT NULL — 처리 기법 상세 내용 (처리 수준)
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
checklist_item
- item_idx — bigint(20) — Primary key — NOT NULL — 체크리스트 항목 IDX
- item_type — int(11) — Primary key — NOT NULL — 체크리스트 구분 (위험도평가/자가점검/보안점검)
- name — varchar(50) — 항목 명
- score — int(11) — 항목 점수
data
- data_id — varchar(36) — Primary key — NOT NULL
- analysis_status — int(11) — 데이터 분석 진행 상태
- is_post — int(11)
- is_delete — int(11)
- is_clone — int(11)
- is_share — int(11)
- is_favorite — int(11)
- is_publish — int(11)
- data_type — int(11)
- data_name — varchar(512)
- data_disp_name — varchar(5212)
- data_desc — varchar(1024)
- data_reg_user_id — varchar(50)
- data_reg_user_name — varchar(1024)
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
- is_encrypt — int(11)
- is_decrypt — int(11)
- is_export — int(11)
- is_error — int(11)
- data_error_msg — varchar(100)
data_analysis_config
- project_id — varchar(36) — Foreign key — NOT NULL — 프로젝트 ID
- data_id — varchar(36) — Foreign key → data.data_id — NOT NULL — 데이터 ID
- analysis_target_data — int(11) — 분석 대상(전체/샘플)
- analysis_target_column — int(11) — 분석 대상 컬럼(일반정보/가명처리 대상)
- use_privacy_k — int(11) — k-익명성 분석 사용여부
- use_privacy_l — int(11) — l-다양성 분석 사용여부
- use_origin_analysis — int(11) — 식별 위험도 분석 여부
- use_risk_powerset — int(11) — 컬럼 조합 분석 여부
- k_value — int(11) — k-익명성 값
- l_value — bigint(20) — l-다양성 값
- threshold_risk — double — 위험도 임계치
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
data_db
- data_id — varchar(36) — Foreign key → data.data_id — NOT NULL
- db_row — int(11)
- db_col — int(11)
- file_size — bigint(20)
- src_conn_id — int(11)
- src_owner_name — varchar(255)
- src_table_name — varchar(255)
- src_direct_sql — text
- src_direct_sql_variable — text
- src_encoding — int(11)
- sql_variable — text
- data_reg_user_id — varchar(50)
- data_reg_user_name — varchar(100)
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
data_db_option
- data_id — varchar(36) — Foreign key → data.data_id — NOT NULL
- import_type — int(11)
- fetch_size — int(11)
- del_empty_column — int(11)
- del_empty_row — int(11)
- rep_empty_string — int(11)
- rep_empty_number — int(11)
- del_delimiter_number — int(11)
- sampling_type — int(11)
- sampling_extract_ratio — int(11)
- sampling_column_key — int(11)
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
- row_group_size — int(11)
data_delete_log
- log_idx — bigint(20) — Primary key — NOT NULL — 이력 IDX
- action_type — int(11) — NOT NULL — 행위 구분 (원본/가명/추가)
- project_id — varchar(36) — NOT NULL — 프로젝트 ID
- data_id — varchar(128) — 데이터 ID
- user_id — varchar(36) — NOT NULL — 수행자 ID
- user_dept — varchar(100) — 소속 부서
- user_grade — varchar(100) — 직급
- user_position — varchar(100) — 직책
- user_ip — varchar(300) — 사용자 IP
- action_reason — text — 작업 사유
- action_method — text — 작업 방법
- created_at — timestamp — NOT NULL — 생성 일시 (파기일)
- updated_at — timestamp — 변경 일시
data_export
- export_idx — bigint(20) — Primary key — NOT NULL — 반출 IDX
- etl_que_idx — int(11) — ETL 큐 IDX
- etl_proc_idx — int(11) — ETL 프로세스 IDX
- project_id — varchar(36) — NOT NULL — 프로젝트 ID
- export_type — varchar(50) — 반출 형태 (파일/DB)
- data_name — varchar(512) — 데이터명
- export_user_id — varchar(36) — 반출자 id
- export_user_name — varchar(36) — 반출자 명
- export_user_ip — varchar(128) — 반출자 ip
- export_reason — text — 반출 사유
- read_success_cnt — int(11) — 읽기 성공 건수
- read_fail_cnt — int(11) — 읽기 실패 건수
- write_success_cnt — int(11) — 쓰기 성공 건수
- write_fail_cnt — int(11) — 쓰기 실패 건수
- created_at — timestamp — NOT NULL — 생성 일시 (반출 요청 일시)
- updated_at — timestamp — 변경 일시 (반출 완료 일시)
data_file
- data_id — varchar(36) — Foreign key → data.data_id — NOT NULL
- file_type — int(11)
- file_name — varchar(512)
- file_row — bigint(20)
- file_col — int(11)
- file_size — bigint(20)
- disp_file_size — varchar(50)
- compression_password — varchar(50) — 압축 비밀번호(가명정보)
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
data_file_option
- data_id — varchar(36) — Foreign key → data.data_id — NOT NULL
- encoding — int(11)
- first_row — int(11)
- delimiter — int(11)
- delimiter_text — varchar(5)
- quotation — int(11)
- del_empty_column — int(11)
- del_empty_row — int(11)
- rep_empty_string — int(11)
- rep_empty_number — int(11)
- del_delimiter_number — int(11)
- sampling_type — int(11)
- sampling_extract_ratio — int(11)
- sampling_column_key — int(11)
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
data_process_error
- data_err_idx — bigint(20) — Primary key — NOT NULL
- project_id — varchar(36)
- data_id — varchar(36) — Foreign key → data.data_id — NOT NULL
- process_file_id — int(11)
- err_msg — mediumtext
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
data_share
- data_id — varchar(36) — Foreign key → data.data_id — NOT NULL
- user_id — varchar(50) — Foreign key — NOT NULL
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
db_backup
- backup_idx — bigint(20) — Primary key — NOT NULL
- backup_id — varchar(36) — NOT NULL
- backup_path — varchar(1024) — NOT NULL
- backup_db_type — varchar(100) — NOT NULL
- backup_db_name — varchar(200) — NOT NULL
- backup_db_host — varchar(100) — NOT NULL
- backup_db_port — int(11)
- backup_db_user — varchar(200)
- backup_db_pwd — varchar(64)
- backup_db_size — bigint(20)
- backup_time — timestamp
- backup_file_hash — varchar(64)
- backup_file_size — bigint(20)
- backup_status — int(11) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
db_backup_config
- backup_config_idx — bigint(20) — Primary key — NOT NULL
- backup_scheduler_use — int(11) — NOT NULL
- backup_scheduler_type — int(11) — NOT NULL
- backup_scheduler_hour_interval — int(11) — NOT NULL
- backup_scheduler_hour — int(11)
- backup_scheduler_week — int(11)
- backup_scheduler_day — int(11)
- created_at — timestamp — NOT NULL
- updated_at — timestamp
db_conn
- conn_idx — bigint(20) — Primary key — NOT NULL
- db_driver_type — int(11)
- db_driver_name — varchar(100) — NOT NULL
- db_conn_name — varchar(100) — NOT NULL
- db_host — varchar(100) — NOT NULL
- db_port — int(11)
- db_name — varchar(100) — NOT NULL
- db_schema — varchar(100)
- db_server — varchar(100)
- db_sid — varchar(100)
- db_user_id — varchar(100) — NOT NULL
- db_user_pw — varchar(172) — NOT NULL
- db_extra_info — varchar(200) — NOT NULL
- db_url_options — varchar(512)
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- db_service_sid — int(11)
- db_driver_id — int(11) — Foreign key → db_driver.driver_idx
- is_update_privileges — int(11)
db_driver
- driver_idx — bigint(20) — Primary key — NOT NULL
- driver_name — varchar(100) — NOT NULL
- class_name — varchar(100) — NOT NULL
- url — varchar(300) — NOT NULL
- driver_file_name — varchar(512) — NOT NULL
- driver_path — varchar(1000) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- driver_type — int(11)
deid_a_k
- project_id — varchar(36) — Foreign key — NOT NULL
- data_id — varchar(36) — Foreign key — NOT NULL
- k_val — int(11) — NOT NULL
- suppression — double
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
deid_a_lt
- column_id — varchar(128) — Primary key — NOT NULL
- project_id — varchar(36) — Foreign key — NOT NULL
- data_id — varchar(36) — Foreign key — NOT NULL
- lt_model — int(11)
- l_val — int(11) — NOT NULL
- t_val — double
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
deid_column_analysis
- column_id — varchar(512) — Primary key — NOT NULL — 컬럼 ID
- stat_type — int(11) — Primary key — NOT NULL
- data_id — varchar(36) — Foreign key — NOT NULL — 데이터 ID
- num_classes — double — NOT NULL — num_classes
- avg_class_size — double — NOT NULL — 평균
- highest_risk — double — NOT NULL — 최고 위험도
- lowest_risk — double — NOT NULL — 최저 위험도
- average_risk — double — NOT NULL — 평균 위험도
- records_at_risk — double — NOT NULL — 임계치 미만 레코드 비율
- num_at_risk — int(11) — NOT NULL — num_at_risk
- distinction — double — NOT NULL — 구별
- separation — double — NOT NULL — 분리
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
deid_histogram
- column_id — varchar(50) — Primary key — NOT NULL
- stat_type — int(11) — Primary key — NOT NULL
- project_id — varchar(36) — Foreign key — NOT NULL
- data_id — varchar(36) — Foreign key — NOT NULL
- stat_bin_freq — varchar(4096) — NOT NULL
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
deid_outlier
- outlier_idx — bigint(20) — Primary key — NOT NULL — 프로젝트 특이치 그룹별 특이치 IDX
- outlier_group_idx — bigint(20) — Foreign key → deid_outlier_group.outlier_group_idx — NOT NULL — 프로젝트 특이치 그룹 IDX
- outlier_value — mediumtext — NOT NULL — 특이치
deid_outlier_group
- outlier_group_idx — bigint(20) — Primary key — NOT NULL — 프로젝트 특이치 그룹 IDX
- project_id — varchar(36) — Foreign key — NOT NULL — 프로젝트 ID
- data_id — varchar(36) — Foreign key — NOT NULL — 데이터 ID
- column_id — varchar(128) — NOT NULL — 컬럼 ID
- stat_type — int(11) — NOT NULL
- column_data_type — varchar(50) — NOT NULL — 데이터 타입 (문자/숫자)
- lower_threshold — double — 하위 임계값 (수치형)
- upper_threshold — double — 상위 임계값 (수치형)
- frequency_threshold — int(11) — 빈도수 임계값 (문자형)
- threshold_method — int(11) — 특이치 임계값 산정 방식
- order_method — varchar(172) — 추가 가명처리 기법
- order_method_name — varchar(172) — 추가 가명처리 기법명
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
deid_stat
- column_id — varchar(50) — Primary key — NOT NULL
- stat_type — int(11) — Primary key — NOT NULL
- project_id — varchar(36) — Foreign key — NOT NULL
- data_id — varchar(36) — Foreign key — NOT NULL
- stat_min — varchar(255)
- stat_max — varchar(255)
- stat_sum — varchar(255)
- stat_row — varchar(255)
- stat_mean — varchar(255)
- stat_stddev — varchar(255)
- stat_l_quantile — varchar(255)
- stat_median — varchar(255)
- stat_u_quantile — varchar(255)
- stat_variance — varchar(255)
- stat_max_len — varchar(255)
- stat_min_len — varchar(255)
- stat_avg_len — varchar(255)
- stat_count_distinct — varchar(255)
- stat_sum_distinct — varchar(255)
- stat_kurtosis — varchar(255)
- stat_skewness — varchar(255)
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
deid_stat_occur
- stat_occur_idx — bigint(20) — Primary key — NOT NULL
- project_id — varchar(36) — Foreign key — NOT NULL
- data_id — varchar(36) — Foreign key — NOT NULL
- column_id — varchar(50) — NOT NULL
- row_data — text — NOT NULL
- stat_type — int(11) — NOT NULL
- row_data_cnt — double
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
deid_stat_unique
- column_id — varchar(50) — Primary key — NOT NULL
- unique_value — varchar(512) — Primary key — NOT NULL
- stat_type — int(11) — Primary key — NOT NULL
- data_id — varchar(36) — Foreign key — NOT NULL
- unique_cnt — double
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
domain
- domain_id — varchar(36) — Primary key — NOT NULL — 도메인 키
- domain_name — varchar(36) — NOT NULL — 도메인명
- is_use — int(11)
- created_at — timestamp — NOT NULL
- updated_at — timestamp
domain_group
- group_id — varchar(30) — Primary key — NOT NULL
- domain_id — varchar(36) — Foreign key → domain.domain_id — NOT NULL
- group_name — varchar(200) — NOT NULL
- parent_group_id — varchar(30)
- description — varchar(512)
- is_use — int(11) — NOT NULL
- seq — int(11)
- updated_at — timestamp
- created_at — timestamp
domain_group_member
- member_id — varchar(30) — Primary key — NOT NULL
- domain_id — varchar(36) — Foreign key → domain_group.domain_id — NOT NULL
- group_id — varchar(30) — Foreign key → domain_group.group_id — NOT NULL
- is_dept — int(11) — NOT NULL
- seq — int(11)
- updated_at — timestamp
- created_at — timestamp
domain_ip
- domain_ip — varchar(50) — Primary key — NOT NULL — 도메인 IP
- domain_id — varchar(36) — Foreign key → domain.domain_id — NOT NULL — 도메인 키
- domain_port — varchar(10) — 도메인 PORT
email_config
- mail_idx — bigint(20) — Primary key — NOT NULL — 메일 서버 설정 IDX
- send_type — int(11) — NOT NULL — 전송 방식
- mail_server_host — text — NOT NULL — 메일 서버 주소
- mail_port — bigint(20) — NOT NULL — 메일 포트
- auth_type — int(11) — NOT NULL — 인증 방식
- auth_account — text — 인증 계정
- auth_password — varchar(100) — 인증 비밀번호
- test_account — text — 테스트 계정
- sender_account — text — NOT NULL — 발신자 이메일
- sender_name — varchar(1024) — NOT NULL — 발신자명
- send_schedule_cycle — int(11) — NOT NULL — 전송 스케줄 주기
- use_security_protocol — int(11) — NOT NULL — 보안 연결 사용여부
- use_project_status_alert — int(11) — NOT NULL — 프로젝트 상태 알림 사용여부
- use_system_alert — int(11) — NOT NULL — 시스템 알림 사용여부
- is_use — int(11) — NOT NULL — 사용 여부
- use_relay — int(11) — NOT NULL — 릴레이 사용 여부
- relay_server_host — text — 릴레이 서버 주소
- relay_port — bigint(20) — 릴레이 포트
- use_relay_auth — int(11) — NOT NULL — 릴레이 인증 사용여부
- relay_account — text — 릴레이 인증 사용자
- relay_password — varchar(100) — 릴레이 인증 비밀번호
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
email_queue
- queue_idx — bigint(20) — Primary key — NOT NULL
- email_type — varchar(255)
- email_from_user — text
- email_to_user — text
- email_subject — text
- email_text — text
- attachment_path — text
- send_complete — int(11) — NOT NULL
- reservation_at — timestamp
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
email_template
- email_type — varchar(255) — Primary key — NOT NULL
- email_subject — text
- email_text — text
- use_notify — int(11) — NOT NULL
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
enc_dec_history
- id — varchar(36) — Primary key — NOT NULL
- encdec_type — int(11) — Primary key — NOT NULL
- encdec_func — int(11)
- master_key — text — NOT NULL
- rsa_pub — text
- rsa_pri — text
- created_at — timestamp — NOT NULL
- updated_at — timestamp
enc_dec_policy
- encdec_type — int(11) — Primary key — NOT NULL
- use_enc_dec — int(11)
- allow_change — int(11)
- encdec_func — int(11)
- master_key — text — NOT NULL
- rsa_pub — text
- rsa_pri — text
- created_at — timestamp — NOT NULL
- updated_at — timestamp
etl_clean_option
- etl_sum_idx — int(11) — Foreign key → etl_summary.etl_sum_idx — NOT NULL
- rep_empty_string — int(11)
- rep_empty_number — int(11)
- rep_empty_date — int(11)
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
etl_column
- etl_col_idx — bigint(20) — Primary key — NOT NULL
- etl_sum_idx — int(11) — Foreign key → etl_summary.etl_sum_idx
- src_column_name — varchar(1024)
- src_column_size — int(11)
- tgt_column_name — varchar(1024)
- tgt_column_size — int(11)
- tgt_column_sequence — varchar(1024)
- column_export — int(11)
- column_encrypt — int(11)
- column_encrypt_func — int(11)
- column_encrypt_pub_key — text
- column_encrypt_priv_key — text
- column_export_encrypt — int(11)
- column_export_encrypt_key — varchar(1024)
- column_export_decrypt — int(11)
- column_export_decrypt_key — varchar(1024)
- column_import_decrypt — int(11)
- column_import_decrypt_key — varchar(1024)
- column_import_encrypt — int(11)
- column_import_encrypt_key — varchar(1024)
- src_column_type — varchar(100)
- tgt_column_type — varchar(100)
- src_column_id — varchar(100)
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
etl_config
- etl_config_idx — bigint(20) — Primary key — NOT NULL
- sql_global_variable — mediumtext
- created_at — timestamp — NOT NULL
- updated_at — timestamp
etl_conn
- etl_sum_idx — int(11) — Foreign key → etl_summary.etl_sum_idx — NOT NULL
- src_conn_id — int(11)
- src_table_name — varchar(255)
- src_direct_sql — text
- src_encoding — int(11)
- tgt_conn_id — int(11)
- tgt_table_name — varchar(255)
- tgt_direct_sql — text
- tgt_encoding — int(11)
- src_owner_name — varchar(255)
- tgt_owner_name — varchar(255)
- src_pre_sql — text
- tgt_pre_sql — text
- src_direct_sql_variable — text
- tgt_direct_sql_variable — text
- src_pre_sql_variable — text
- tgt_pre_sql_variable — text
- sql_variable — text
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
etl_db_privileges
- privilege_idx — bigint(20) — Primary key — NOT NULL
- user_id — varchar(50) — NOT NULL
- etl_db_privileges_all_table — int(11)
- etl_db_privileges_target — int(11)
- etl_db_privileges_condition — int(11)
- etl_db_privileges_value — varchar(1024)
- is_allow — int(11)
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- db_conn_id — int(11)
etl_option
- etl_sum_idx — int(11) — Foreign key → etl_summary.etl_sum_idx — NOT NULL
- is_increment — int(11)
- tgt_truncate — int(11)
- dup_process — int(11)
- retry_cnt — int(11)
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
- retry_term — int(11)
- src_date_format — varchar(50)
- tgt_date_format — varchar(50)
- fetch_size — int(11)
- row_group_size — int(11)
- use_bulk_insert — int(11)
- use_hdfs_direct — int(11)
etl_process
- etl_proc_idx — bigint(20) — Primary key — NOT NULL
- etl_sum_idx — int(11) — Foreign key → etl_summary.etl_sum_idx — NOT NULL
- etl_read_status — int(11) — NOT NULL
- etl_write_status — int(11) — NOT NULL
- r_succ_cnt — int(11)
- r_fail_cnt — int(11)
- r_err_cnt — int(11)
- w_succ_cnt — int(11)
- w_i_succ_cnt — int(11)
- w_u_succ_cnt — int(11)
- w_fail_cnt — int(11)
- w_i_fail_cnt — int(11)
- w_u_fail_cnt — int(11)
- w_err_cnt — int(11)
- w_i_err_cnt — int(11)
- w_u_err_cnt — int(11)
- user_interrupt — int(11)
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
etl_process_error
- etl_err_idx — bigint(20) — Primary key — NOT NULL
- etl_proc_idx — int(11) — Foreign key → etl_process.etl_proc_idx — NOT NULL
- etl_sum_idx — int(11) — NOT NULL
- etl_file_idx — int(11)
- err_msg — mediumtext
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
etl_process_file
- etl_file_idx — bigint(20) — Primary key — NOT NULL
- etl_proc_idx — int(11) — Foreign key → etl_process.etl_proc_idx — NOT NULL
- etl_sum_idx — int(11) — Foreign key → etl_summary.etl_sum_idx — NOT NULL
- etl_read_status — int(11) — NOT NULL
- etl_write_status — int(11) — NOT NULL
- data_path — varchar(1024)
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
etl_query
- query_idx — bigint(20) — Primary key — NOT NULL
- db_type — int(11)
- query_type — int(11)
- query_text — mediumtext
- created_at — timestamp — NOT NULL
- updated_at — timestamp
etl_summary
- etl_sum_idx — bigint(20) — Primary key — NOT NULL
- project_id — varchar(36) — Foreign key — NOT NULL
- use_status — int(11)
- process_status — int(11)
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
- summary_name — varchar(100)
- data_id — varchar(36) — Foreign key → data.data_id — NOT NULL
etl_summary_queue
- etl_que_idx — bigint(20) — Primary key — NOT NULL
- etl_sum_idx — int(11) — Foreign key → etl_summary.etl_sum_idx
- etl_proc_idx — int(11) — Foreign key → etl_process.etl_proc_idx
- process_status — int(11)
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
- status_check_cnt — int(11)
flyway_schema_history
- installed_rank — int(11) — Primary key — NOT NULL
- version — varchar(50)
- description — varchar(200) — NOT NULL
- type — varchar(20) — NOT NULL
- script — varchar(1000) — NOT NULL
- checksum — int(11)
- installed_by — varchar(100) — NOT NULL
- installed_on — timestamp — NOT NULL
- execution_time — int(11) — NOT NULL
- success — tinyint(1) — NOT NULL
flyway_schema_history_add
- installed_rank — int(11) — Primary key — NOT NULL
- version — varchar(50)
- description — varchar(200) — NOT NULL
- type — varchar(20) — NOT NULL
- script — varchar(1000) — NOT NULL
- checksum — int(11)
- installed_by — varchar(100) — NOT NULL
- installed_on — timestamp — NOT NULL
- execution_time — int(11) — NOT NULL
- success — tinyint(1) — NOT NULL
hierarchy
- hier_idx — bigint(20) — Primary key — NOT NULL
- project_id — varchar(36) — Foreign key — NOT NULL
- data_id — varchar(36) — Foreign key — NOT NULL
- column_id — varchar(128) — NOT NULL
- level — int(11) — NOT NULL
- level_content — varchar(512) — NOT NULL
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
hierarchy_level
- hier_lev_idx — bigint(20) — Primary key — NOT NULL
- project_id — varchar(36) — Foreign key — NOT NULL
- data_id — varchar(36) — Foreign key — NOT NULL
- column_id — varchar(128) — NOT NULL
- level — int(11) — NOT NULL
- period — varchar(50) — NOT NULL
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
hierarchy_node
- column_id — varchar(128) — Primary key — NOT NULL
- k_val — int(11) — Primary key — NOT NULL
- project_id — varchar(36) — Foreign key — NOT NULL
- data_id — varchar(36) — Foreign key — NOT NULL
- column_name — varchar(255) — NOT NULL
- max_level — int(11) — NOT NULL
- active_level — int(11) — NOT NULL
- node_order — int(11) — NOT NULL
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
hierarchy_result
- k_val — int(11) — Primary key — NOT NULL
- node_name — varchar(128) — Primary key — NOT NULL
- project_id — varchar(36) — Foreign key — NOT NULL
- data_id — varchar(36) — Foreign key — NOT NULL
- node_name_hash — varchar(128) — NOT NULL
- bf_preview_data — mediumtext
- af_preview_data — mediumtext
- prec — varchar(100) — NOT NULL
- entropy — varchar(100) — NOT NULL
- information_loss — varchar(100) — NOT NULL
- bf_avg_class — varchar(50) — NOT NULL
- bf_max_class — varchar(50) — NOT NULL
- bf_min_class — varchar(50) — NOT NULL
- bf_suppression_rows — varchar(100) — NOT NULL
- af_avg_class — varchar(50) — NOT NULL
- af_max_class — varchar(50) — NOT NULL
- af_min_class — varchar(50) — NOT NULL
- af_suppression_rows — varchar(100) — NOT NULL
- prosecutor — varchar(100)
- journalist — varchar(100)
- maeketer — varchar(100)
- bf_p_record — varchar(100)
- bf_p_high — varchar(100)
- bf_p_avg — varchar(100)
- bf_j_record — varchar(100)
- bf_j_high — varchar(100)
- bf_j_avg — varchar(100)
- bf_m_avg — varchar(100)
- af_p_record — varchar(100)
- af_p_high — varchar(100)
- af_p_avg — varchar(100)
- af_j_record — varchar(100)
- af_j_high — varchar(100)
- af_j_avg — varchar(100)
- af_m_avg — varchar(100)
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
hr_db_conn
- conn_idx — bigint(20) — Primary key — NOT NULL
- db_driver_type — int(11)
- db_driver_name — varchar(100) — NOT NULL
- db_conn_name — varchar(100) — NOT NULL
- db_host — varchar(100) — NOT NULL
- db_port — int(11)
- db_name — varchar(100) — NOT NULL
- db_schema — varchar(100)
- db_server — varchar(100)
- db_sid — varchar(100)
- db_user_id — varchar(100) — NOT NULL
- db_user_pw — varchar(172) — NOT NULL
- db_extra_info — varchar(200) — NOT NULL
- db_url_options — varchar(512)
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- db_service_sid — int(11)
- db_driver_id — int(11)
- is_update_privileges — int(11)
hr_dept
- dept_id — varchar(30) — Primary key — NOT NULL
- dept_name — varchar(200)
- parent_dept_id — varchar(30)
- seq — int(11)
- dept_code — varchar(30)
- mngr_emp_code — varchar(50)
- updated_at — timestamp
- created_at — timestamp
hr_pos
- pos_id — varchar(30) — Primary key — NOT NULL
- pos_name — varchar(200)
- pos_code — varchar(30)
- seq — int(11)
hr_rank
- rank_id — varchar(30) — Primary key — NOT NULL
- rank_name — varchar(200)
- rank_code — varchar(30)
- seq — int(11)
hr_sync_history
- history_idx — bigint(20) — Primary key — NOT NULL
- sync_type — int(11)
- sync_status — int(11)
- sync_target_cnt — int(11)
- total_read_success_cnt — int(11)
- total_read_fail_cnt — int(11)
- total_write_success_cnt — int(11)
- total_write_fail_cnt — int(11)
- total_insert_cnt — int(11)
- total_update_cnt — int(11)
- total_delete_cnt — int(11)
- sync_user_id — varchar(36)
- sync_user_name — varchar(36)
- sync_user_ip — varchar(128)
- created_at — timestamp — NOT NULL
- updated_at — timestamp
hr_sync_history_target
- history_target_idx — bigint(20) — Primary key — NOT NULL
- history_idx — bigint(20) — Foreign key → hr_sync_history.history_idx — NOT NULL
- target_idx — bigint(20) — Foreign key — NOT NULL
- sync_sql — text
- sync_status — int(11)
- read_success_cnt — int(11)
- read_fail_cnt — int(11)
- write_success_cnt — int(11)
- write_fail_cnt — int(11)
- insert_cnt — int(11)
- update_cnt — int(11)
- delete_cnt — int(11)
- err_msg — mediumtext
- created_at — timestamp — NOT NULL
- updated_at — timestamp
hr_sync_scheduler_config
- scheduler_conf_idx — bigint(20) — Primary key — NOT NULL
- scheduler_use — int(11) — NOT NULL
- scheduler_type — int(11) — NOT NULL
- scheduler_time — varchar(10)
- scheduler_date — varchar(10)
- scheduler_week — varchar(10)
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
hr_sync_target
- target_idx — bigint(20) — Primary key — NOT NULL
- target_table_name — varchar(255)
- target_table_desc — varchar(1024)
- sync_sql — text
- created_at — timestamp — NOT NULL
- updated_at — timestamp
hr_user
- user_id — varchar(30) — Primary key — NOT NULL
- dept_id — varchar(30) — Foreign key
- rank_id — varchar(30) — Foreign key
- pos_id — varchar(30) — Foreign key
- user_name — varchar(200)
- parent_user_id — varchar(30)
- emp_code — varchar(30)
- picture_url — varchar(200)
- email — varchar(128)
- mobile_phone — varchar(30)
- office_phone — varchar(30)
- home_phone — varchar(30)
- gender — enum('M','F','O')
- business — varchar(512)
- birth_date — date
- seq — int(11)
- emp_status — enum('ACTIVE','INACTIVE','TERMINATED')
- updated_at — timestamp
- created_at — timestamp
id_report
- project_id — varchar(36) — Foreign key — NOT NULL — 프로젝트 ID
- id_review — mediumtext — 식별성 검토사항
- outlier_review — mediumtext — 특이정보 검토사항
- verify_review — mediumtext — 재식별시 영향도 검토사항
- use_provision_review — mediumtext — 이용 및 제공 검토사항
- location_review — mediumtext — 처리 장소 검토사항
- join_review — mediumtext — 다른 정보와 결합 시 검토사항
- final_comments — mediumtext — 최종 검토 의견
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
mapping_table_config
- map_table_id — varchar(36) — Primary key — NOT NULL
- table_name — varchar(200) — NOT NULL
- table_desc — varchar(1024)
- data_type — int(11)
- prefix — varchar(100)
- suffix — varchar(100)
- encKey — mediumtext
- auto_create_use — int(11)
- duplicate_data_accept — int(11)
- table_size — bigint(20)
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- data_length — int(11)
mapping_table_data
- map_data_idx — bigint(20) — Primary key — NOT NULL
- map_table_id — varchar(36) — Foreign key — NOT NULL
- mapping_data — text — NOT NULL
- origin_data — text — NOT NULL
masking_config
- role_key — varchar(50) — Foreign key — NOT NULL — 권한 Key
- is_mask_id — int(11) — NOT NULL — 식별자 마스킹 여부
- is_mask_qi — int(11) — NOT NULL — 준식별자 마스킹 여부
- is_mask_sa — int(11) — NOT NULL — 민감정보 마스킹 여부
- is_mask_nsa — int(11) — NOT NULL — 일반정보 마스킹 여부
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
menu
- menu_key — varchar(50) — Primary key — NOT NULL — 메뉴 Key
- upper_menu_key — varchar(50) — Foreign key → menu.menu_key — 상위 메뉴 Key
- menu_name — varchar(200) — NOT NULL — 메뉴 명
- menu_order — int(11) — NOT NULL — 정렬 순서
menu_report_field
- field_key — varchar(50) — Primary key — NOT NULL — 보고서 필드 Key
- menu_key — varchar(50) — Foreign key → menu.menu_key — NOT NULL — 메뉴 Key
menu_role
- menu_key — varchar(50) — Foreign key → menu.menu_key — NOT NULL — 메뉴 Key
- role_key — varchar(50) — Foreign key — NOT NULL — 권한 Key
menu_template_file
- file_id — varchar(36) — Primary key — NOT NULL — 파일 ID
- menu_key — varchar(50) — Foreign key → menu.menu_key — NOT NULL — 메뉴 Key
- file_name — varchar(512) — NOT NULL — 파일 명
- file_size — bigint(20) — NOT NULL — 파일 크기
- disp_file_size — varchar(50) — NOT NULL — 파일 크기(view)
- reg_user_id — varchar(50) — NOT NULL — 파일 등록 사용자 ID
- reg_user_name — varchar(100) — NOT NULL — 파일 등록 사용자 명
- created_at — timestamp — NOT NULL — 생성 일시
- updated_at — timestamp — 변경 일시
metadata
- meta_key — varchar(512) — Primary key — NOT NULL
- meta_name — varchar(512)
- meta_value — varchar(4096)
- meta_description — varchar(4096)
- meta_status — varchar(512)
- meta_source — varchar(512)
- meta_data_type — varchar(512)
- meta_data_format — varchar(4096)
- meta_data_length — varchar(512)
- meta_link_id — varchar(64) — Foreign key → metadata_link.link_id
- created_at — timestamp — NOT NULL
- updated_at — timestamp
metadata_link
- link_id — varchar(64) — Primary key — NOT NULL
- link_name — varchar(512)
- link_type — int(11)
- link_path — varchar(4096)
- org_file_name — varchar(4096)
- link_file_path — varchar(4096)
- link_status — int(11)
- schedule_cron — varchar(512)
- schedule_status — int(11)
- is_overwrite — int(11)
- is_delete — int(11)
- linked_at — timestamp
- created_at — timestamp — NOT NULL
- updated_at — timestamp
mon_cpu
- cpu_idx — bigint(20) — Primary key — NOT NULL
- instance_id — varchar(36) — NOT NULL — TYPE:IP:PORT MD5 HASH
- mon_type — int(11)
- cpu_row_size — int(11)
- cpu_num — int(11)
- cpu_load — varchar(10) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
mon_disk
- disk_idx — bigint(20) — Primary key — NOT NULL
- instance_id — varchar(36) — NOT NULL — TYPE:IP:PORT MD5 HASH
- disk_name — varchar(50)
- disk_row_size — int(11)
- used_disk_per — varchar(50)
- usable_disk — varchar(50)
- total_disk — varchar(50)
- usable_disk_unit — varchar(10)
- total_disk_unit — varchar(10)
- created_at — timestamp — NOT NULL
- updated_at — timestamp
and 80 more tables