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)