DeltaStream

Tables (41)

code

  • cd_gr — varchar(15) — Primary key — NOT NULL
  • cd — varchar(30) — Primary key — NOT NULL
  • val — varchar(200)
  • cmts — varchar(2000)
  • attr1 — varchar(2000)
  • attr2 — varchar(2000)
  • attr3 — varchar(2000)
  • cd_odr — integer
  • reg_dt — timestamp
  • reg_id — varchar(15)
  • mod_dt — timestamp
  • mod_id — varchar(15)
  • use_yn — char
  • msg_cd — varchar(300)
  • cd_gr (cd_gr2) — varchar(15) — Foreign key → code_gr.cd_gr — NOT NULL

code_gr

  • cd_gr — varchar(15) — Primary key — NOT NULL
  • cd_gr_val — varchar(200)
  • cmts — varchar(2000)
  • attr1 — varchar(2000)
  • attr2 — varchar(2000)
  • attr3 — varchar(2000)
  • reg_dt — timestamp
  • reg_id — varchar(15)
  • mod_dt — timestamp
  • mod_id — varchar(15)
  • sys_cd_yn — char

columns

  • id (Key) — Foreign key → columns_id_seq.id — NOT NULL
  • id — integer — NOT NULL — 식별아이디
  • datafield — varchar(30) — NOT NULL — 컬럼
  • text — varchar(30) — NOT NULL — 컬럼
  • tablename — varchar(30) — NOT NULL — 소속
  • hidden — boolean — 사용여부
  • headeralign — varchar(10) — 헤더컬럼
  • sort — boolean — 순차적용
  • align — varchar(10) — 데이터
  • classes — varchar(255) — 컬럼
  • description — varchar(255) — 컬럼
  • editable — boolean — 수정여부
  • formatter — text

columns_id_seq (Untitled)

  • id (Key) — Primary key — NOT NULL

dbms

  • name — varchar(255) — Primary key — NOT NULL — 데이터베이스
  • vendor — smallint — 데이터베이스
  • version — varchar(255) — 데이터베이스
  • io_type — smallint — 입출력
  • host — varchar(255) — 접속
  • port — integer — 접속
  • db_user — varchar(255) — 데이터베이스
  • db_password — varchar(255) — 데이터베이스
  • reg_dt — timestamp(6) — NOT NULL — 데이터베이스
  • mod_dt — timestamp(6) — 데이터베이스
  • description — text — 데이터베이스
  • sid — text — 데이터베이스
  • node_cnt — smallint — node
  • usage — smallint
  • file_path — varchar(3000) — 파일적재
  • file_save_time — bigint — 파일저장주기
  • file_save_unit — varchar(50) — 파일저장주기
  • file_delimiter — varchar(20) — 데이터
  • file_delimiter_type — integer — 데이터
  • owner_table_file_name — integer — 파일명
  • child_folder — integer — 하위폴더
  • update_export_type — integer — 업데이트
  • replace_char — varchar(20) — LF문자
  • replace_char_type — integer — LF문자
  • batch_loading_path — varchar(3000) — 일괄적재
  • id (Key) — Foreign key → project.id — NOT NULL

delta_user

  • user_id — Primary key — NOT NULL
  • user_nm — varchar(20)
  • user_pwd — varchar(200)
  • old_pwd — varchar(200)
  • pwd_chg_dt — timestamp — NOT NULL
  • dept_cd — varchar(50)
  • dept_nm — varchar(50)
  • rank_cd — varchar(15)
  • rank_nm — varchar(15)
  • fail_cnt — integer
  • cmts — varchar(2000)
  • session_id — varchar(50)
  • last_log_dt — timestamp
  • user_tel1 — varchar(20)
  • user_tel2 — varchar(4)
  • user_tel3 — varchar(4)
  • email_addr — varchar(50)
  • sso_id — varchar(50)
  • stat_cd — varchar(15)
  • reg_dt — timestamp
  • reg_id — varchar(15)
  • mod_dt — timestamp
  • mod_id — varchar(15)
  • is_account_non_expired — integer
  • is_account_non_locked — integer
  • is_credentials_non_expired — integer
  • is_enabled — integer

excel_form

  • menu_type — varchar(20) — 메뉴종류
  • header_col_code — varchar(50) — 항목코드
  • header_col_name — varchar(50) — 항목명
  • input_type — varchar(50) — 입력
  • limit_size — integer — 데이터
  • order_by — integer — 항목순서
  • sample_data — varchar(1000) — 예제
  • use_yn — char — 사용여부
  • mandatory — char — 필수값여부
  • comment — varchar(2000) — 항목
  • excel_type — integer — 엑셀

fields

  • table_name — varchar(255) — Primary key — NOT NULL — 데이터베이스
  • owner — varchar(255) — Primary key — NOT NULL
  • db_id — varchar(255) — Primary key — NOT NULL — DBMS
  • column_id — integer — Primary key — NOT NULL — 데이터베이스
  • column_name — varchar(255) — Primary key — NOT NULL — 데이터베이스
  • data_type — varchar(255) — 데이터베이스
  • data_length — bigint — 데이터베이스
  • nullable — varchar(10) — 데이터베이스
  • key_type — varchar(10) — 데이터베이스
  • class_name — varchar(10)
  • data_precision — integer
  • data_scale — integer
  • name (name2) — varchar(255) — Foreign key → dbms.name — NOT NULL — 데이터베이스
  • id (Key) — Foreign key → columns.id — NOT NULL
  • table_name (table_name2) — varchar(255) — Foreign key → tables.table_name — NOT NULL
  • owner (owner2) — varchar(255) — Foreign key → tables.owner — NOT NULL
  • db_id (db_id2) — varchar(255) — Foreign key → tables.db_id — NOT NULL

labels

  • id (Key) — Foreign key → labels_id_seq.id — NOT NULL
  • id — integer — NOT NULL — 식별아이디
  • tablename — varchar(255) — 관련
  • val — smallint — NOT NULL — 식별
  • eng — varchar(30) — 영문
  • kor — varchar(30) — 한글

labels_id_seq (Untitled11)

  • id (Key) — Primary key — NOT NULL

mapping_id_seq (Untitled8)

  • id (Key) — Primary key — NOT NULL

menu

  • menu_id — Primary key — NOT NULL
  • menu_nm — varchar(30) — NOT NULL
  • menu_top_id — varchar(15)
  • menu_up_id — varchar(15)
  • menu_top_odr — integer
  • menu_lvl — integer
  • menu_odr — integer
  • cmd_cls_nm — varchar(100)
  • rtn_jsp_nm — varchar(100)
  • cmd_nm — varchar(20)
  • is_admin — char
  • cmts — varchar(2000)
  • attr1 — varchar(2000)
  • attr2 — varchar(2000)
  • attr3 — varchar(2000)
  • reg_dt — timestamp — NOT NULL
  • reg_id — varchar(15)
  • mod_dt — timestamp
  • mod_id — varchar(15)
  • url_path — varchar(100)
  • use_yn — varchar(3)
  • msg_cd (msg_cd2) — varchar(300) — Foreign key → msg_cd.msg_cd — NOT NULL

menu_pmt

  • menu_id — varchar(15) — Primary key — NOT NULL
  • wk_gr_id — varchar(15) — Primary key — NOT NULL
  • pmt_kind_cd — varchar(15)
  • wk_gr_id (wk_gr_id2) — Foreign key → wk_gr.wk_gr_id — NOT NULL
  • menu_id (menu_id2) — Foreign key → menu.menu_id — NOT NULL

msg_cd

  • lang_cd — varchar(30) — Primary key — NOT NULL
  • msg_cd — varchar(300) — Primary key — NOT NULL
  • msg_val — varchar(500) — NOT NULL
  • reg_dt — timestamp
  • reg_id — varchar(15)
  • mod_dt — timestamp
  • mod_id — varchar(15)
  • cmts — varchar(500)
  • use_yn — varchar(1)

project

  • id (Key) — Foreign key → project_id_seq.id — NOT NULL
  • id — integer — NOT NULL — 프로젝트
  • name — varchar(30) — NOT NULL — 프로젝트
  • authority — smallint — NOT NULL — 사용제한
  • group_id — integer — 프로젝트
  • start_dt — timestamp(6) — 최근
  • end_dt — timestamp(6) — 최근
  • owner — varchar(255) — 프로젝트
  • description — text — 비고
  • reg_dt — timestamp(6) — NOT NULL — 최초
  • mod_dt — timestamp(6) — 최근
  • load_type — smallint — NOT NULL — 프로젝트
  • target_type — smallint — NOT NULL — 출력타입
  • source_db — varchar(255) — 입력DB
  • target_db — varchar(255) — 출력DB
  • target_file_directory — varchar(255) — 출력파일
  • target_file_name — varchar(255) — 출력파일
  • target_file_type — smallint — 출력파일
  • target_schema — varchar(255) — 출력스키마
  • source_schema — varchar(255) — 입력스키마
  • cdc_interval — integer — NOT NULL — second
  • log_type — smallint — 로그타입
  • log_level — smallint — 로그레벨
  • extract_type — smallint — 추출형태
  • commit — integer — NOT NULL — 커밋
  • status — smallint — NOT NULL — 프로젝트
  • version — integer — NOT NULL — 프로젝트
  • source_vendor — integer — Source
  • target_vendor — integer — Target
  • target_schema_owner — varchar(255)
  • source_schema_owner — varchar(255)
  • id (Key3) — Foreign key → project_version.id — NOT NULL
  • id (Key2) — Foreign key → project_group.id — NOT NULL

project_exec_log

  • id (Key) — Foreign key → project_exec_log_id_seq.id — NOT NULL
  • id — bigint — NOT NULL — 식별아이디
  • reg_dt — timestamp — NOT NULL — 최초
  • status — smallint — NOT NULL — 구동상태
  • message — text — 실행
  • project_id — integer — 프로젝트
  • code — integer — 구동상태
  • editor — varchar(255) — 로그
  • id (Key2) — Foreign key → project.id — NOT NULL

project_exec_log_id_seq (Untitled5)

  • id (Key) — Primary key — NOT NULL

project_extract_log

  • id (Key) — Foreign key → project_extract_log_id_seq.id — NOT NULL
  • id — bigint — NOT NULL
  • reg_dt — timestamp — NOT NULL — 최초
  • project_id — integer — 프로젝트
  • scn — numeric — SCN
  • select_type — smallint — 선택유형
  • extract_type — smallint — 추출유형
  • sequence — numeric — SEQUENCE
  • thread — numeric — THREAD
  • first_time — timestamp — FIRST_TIME
  • mod_dt — timestamp — 수정일
  • id (Key2) — Foreign key → project.id — NOT NULL

project_extract_log_id_seq (Untitled6)

  • id (Key) — Primary key — NOT NULL

project_group

  • id (Key) — Foreign key → project_group_id_seq.id — NOT NULL
  • id — integer — NOT NULL
  • name — varchar(255) — NOT NULL
  • authority — smallint — NOT NULL
  • owner — varchar(255) — NOT NULL
  • description — text
  • reg_dt — timestamp — NOT NULL
  • mod_dt — timestamp
  • updater — varchar(255)

project_group_id_seq (Untitled4)

  • id (Key) — Primary key — NOT NULL

project_id_seq (Untitled2)

  • id (Key) — Primary key — NOT NULL

project_mapping

  • id (Key) — Foreign key → mapping_id_seq.id — NOT NULL
  • id — integer — NOT NULL — 식별아이디
  • project_id — integer — NOT NULL — 프로젝트
  • source_field — varchar(255) — 입력스키마
  • target_field — varchar(255) — 출력스키마
  • formula — varchar(255) — 변환식
  • reg_dt — timestamp(6) — 최초
  • mod_dt — timestamp(6) — 최근
  • no — integer — 필드
  • checked — boolean — NOT NULL — 맵핑여부
  • source_table — varchar(255) — 입력스키마
  • target_table — varchar(255) — 출력스키마
  • id (Key2) — Foreign key → project.id — NOT NULL
  • table_name — varchar(255) — Foreign key → tables.table_name — NOT NULL
  • column_name — varchar(255) — Foreign key → fields.column_name — NOT NULL — 데이터베이스
  • db_id (db_id3) — varchar(255) — Foreign key → fields.db_id — NOT NULL — DBMS

project_memo

  • id (Key) — Foreign key → project_memo_id_seq.id — NOT NULL
  • id — integer — NOT NULL — 식별아이디
  • editor — varchar(255) — 작성자
  • message — text — NOT NULL — 작성내용
  • project_id — integer — NOT NULL — 프로젝트
  • reg_dt — timestamp — NOT NULL — 최초
  • status — integer — 구동상태
  • code — integer — 구동상태
  • id (Key2) — Foreign key → project.id — NOT NULL

project_memo_id_seq (Untitled7)

  • id (Key) — Primary key — NOT NULL

project_rac_nodes

  • id (Key) — Foreign key → rac_nodes_id_seq.id — NOT NULL
  • id — bigint — NOT NULL — 식별키
  • rac_id — varchar(255) — NOT NULL — RAC
  • rac_password — varchar — NOT NULL — RAC
  • rac_tns — varchar(255) — NOT NULL — TNS
  • project_id — integer — NOT NULL — 프로젝트
  • no — integer — RAC
  • id (Key2) — Foreign key → project.id — NOT NULL
  • id (Key3) — Foreign key → project.id — NOT NULL

project_stats_log

  • id (Key) — Foreign key → project_stats_log_id_seq.id — NOT NULL
  • id — bigint — NOT NULL
  • reg_dt — timestamp — NOT NULL
  • project_id — integer
  • insert_cnt — bigint — NOT NULL
  • delete_cnt — bigint — NOT NULL
  • update_cnt — bigint — NOT NULL
  • etc_cnt — bigint — NOT NULL
  • id (Key2) — Foreign key → project.id — NOT NULL

project_stats_log_id_seq (Untitled10)

  • id (Key) — Primary key — NOT NULL

project_version

  • id (Key) — Foreign key → project_version_id_seq.id — NOT NULL
  • id — integer — NOT NULL — 프로젝트
  • project_id — integer — NOT NULL — 프로젝트
  • name — varchar(30) — NOT NULL — 프로젝트
  • authority — smallint — NOT NULL — 사용제한
  • group_id — integer — 프로젝트
  • start_dt — timestamp(6) — 최근
  • end_dt — timestamp(6) — 최근
  • owner — varchar(255) — NOT NULL — 프로젝트
  • description — text — 비고
  • reg_dt — timestamp(6) — NOT NULL — 최초
  • mod_dt — timestamp(6) — 최근
  • status — smallint — NOT NULL — 프로젝트
  • load_type — smallint — NOT NULL — 프로젝트
  • target_type — smallint — NOT NULL — 출력타입
  • source_db — varchar(255) — 입력DB
  • target_db — varchar(255) — 출력DB
  • target_file_directory — varchar(255) — 출력파일
  • target_file_name — varchar(255) — 출력파일
  • target_file_type — smallint — 출력파일
  • target_schema — varchar(255) — 출력스키마
  • source_schema — varchar(255) — 입력스키마
  • cdc_interval — integer — second
  • log_type — smallint — 로그타입
  • log_level — smallint — 로그레벨
  • extract_type — smallint — 추출형태
  • commit — integer — 커밋
  • version_reg_dt — timestamp(6) — NOT NULL — 프로젝트
  • version_no — integer — 업데이트시
  • mappings — text — mappings
  • rac_nodes — text — rac_nodes
  • source_vendor — integer — Source
  • target_vendor — integer — Target
  • target_schema_owner — varchar(255)
  • source_schema_owner — varchar(255)

project_version_id_seq (Untitled3)

  • id (Key) — Primary key — NOT NULL

rac_nodes_id_seq (Untitled9)

  • id (Key) — Primary key — NOT NULL

redoinfo

  • id (Key) — Foreign key → redoinfo_id_seq.id — NOT NULL
  • id — bigint — NOT NULL
  • agent_ip — varchar(40) — NOT NULL
  • savepath — varchar(256) — NOT NULL
  • redotype — varchar(20) — NOT NULL
  • sequence_no — numeric — NOT NULL
  • scn_low — numeric
  • scn_next — numeric
  • mod_dt — timestamp

redoinfo_id_seq (Untitled12)

  • id (Key) — Primary key — NOT NULL

redolog

  • id (Key) — Foreign key → redolog_idx_seq.id — NOT NULL
  • idx — integer — NOT NULL — 순차번호
  • agent — varchar(20) — NOT NULL — DSAgent
  • status — numeric — NOT NULL — 0
  • sequence — numeric — NOT NULL
  • scn_low — bigint — NOT NULL
  • scn_next — bigint — NOT NULL
  • date_low — timestamp — NOT NULL
  • date_next — timestamp — NOT NULL
  • path — varchar — NOT NULL — 저장위치
  • mod_dt — timestamp — NOT NULL — 수정
  • id (Key2) — Foreign key → redoinfo.id — NOT NULL

redolog_idx_seq (Untitled14)

  • id (Key) — Primary key — NOT NULL

redolog_stats_log

  • id (Key) — Foreign key → redolog_stats_log_id_seq.id — NOT NULL
  • id — bigint — NOT NULL
  • reg_dt — timestamp — NOT NULL
  • agent — varchar(255) — NOT NULL
  • datasize — bigint — NOT NULL

redolog_stats_log_id_seq (Untitled13)

  • id (Key) — Primary key — NOT NULL

server_log

  • log_time — timestamp — NOT NULL
  • process — varchar(20) — NOT NULL
  • level — varchar(10) — NOT NULL
  • content — varchar(2048) — NOT NULL

tables

  • table_name — varchar(255) — Primary key — NOT NULL
  • owner — varchar(255) — Primary key — NOT NULL
  • db_id — varchar(255) — Primary key — NOT NULL
  • tablespace_name — varchar(255)
  • object_id — integer
  • name (name2) — varchar(255) — Foreign key → dbms.name — NOT NULL — 데이터베이스

user_pmt

  • user_id — varchar(15) — Primary key — NOT NULL
  • wk_gr_id — varchar(15) — Primary key — NOT NULL
  • wk_gr_id (wk_gr_id2) — Foreign key → wk_gr.wk_gr_id — NOT NULL
  • user_id (user_id2) — Foreign key → delta_user.user_id — NOT NULL

wk_gr

  • wk_gr_id — Primary key — NOT NULL
  • wk_gr_nm — varchar(30) — NOT NULL
  • cmts — varchar(2000)