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