datalab
Tables (29)
comm_code_dtl
- idx — int8 — Primary key — NOT NULL — 공통
- group_code — varchar(3) — NOT NULL — 그룹
- comm_code_dtl — varchar(6) — NOT NULL — dtl
- comm_code_name — varchar(50) — NOT NULL — dtl
- created_at — timestamp — NOT NULL — 생성
- modified_at — timestamp — NOT NULL — 수정
comm_group_code
- group_code — varchar(3) — Primary key — NOT NULL — 그룹
- idx — int8 — NOT NULL — 그룹
- group_code_name — varchar(50) — NOT NULL — 그룹
- created_at — timestamp — NOT NULL — 등록
- modified_at — timestamp — NOT NULL — 수정
dataset_basic_info
- idx — int8 — Primary key — NOT NULL — 데이터셋
- dataset_name — varchar(100) — NOT NULL — 데이터셋
- dataset_description — varchar(1000) — NOT NULL — 데이터셋
- dataset_privacy_bounds — varchar(50) — NOT NULL — 데이터셋
- dataset_recommend_use — varchar(10) — NOT NULL — 데이터셋
- dataset_components — varchar(50) — NOT NULL — 데이터셋
- creator_user_idx — int8 — 등록
- created_at — timestamp — 등록
- modified_user_idx — int8 — 수정
- modified_at — timestamp — 수정
- del_yn — varchar — 삭제
- table_comment — varchar(1000) — archar(1000) NUL
dataset_db_data
- idx — int8 — Primary key — NOT NULL — db
- dataset_basic_info_idx — int8 — Foreign key → dataset_basic_info.idx — NOT NULL — 데이터셋
- master_db_data_basic_info_idx — int8 — NOT NULL — 관리자
- dataset_db_seq — int4 — NOT NULL — 데이터셋
- creator_user_idx — int8 — 등록
- created_at — timestamp — 등록
- modified_user_idx — int8 — 수정
- modified_at — timestamp — 수정
- del_yn — varchar — 삭제
dataset_file
- idx — int8 — Primary key — NOT NULL — 데이터셋
- dataset_basic_info_idx — int8 — Foreign key → dataset_basic_info.idx — NOT NULL — 데이터셋
- dataset_file_seq — int4 — NOT NULL — 데이터셋
- original_file_name — varchar(200) — 원본
- saving_file_name — varchar(200) — 저장
- file_path — varchar(200) — 파일
- file_extension — varchar(30) — 파일
- file_size — int8 — 파일
- creator_user_idx — int8 — 등록
- created_at — timestamp — 등록
- modified_user_idx — int8 — 수정
- modified_at — timestamp — 수정
- detail_dataset_name — varchar — NOT NULL — 세부
- del_yn — varchar — 삭제
db_connect_info
- idx — int4 — Primary key — NOT NULL
- mngt_nm — varchar(100) — NOT NULL — 관리명칭
- use_yn — varchar(1) — 사용여부
- db_svc_ip — varchar — NOT NULL — db
- db_nm — varchar — NOT NULL — db명
- db_port_num — varchar — NOT NULL — 포트번호
- db_schema — varchar — NOT NULL — db스키마
- db_desc — varchar — 설명
- creator_user_idx — varchar — 생성자idx
- created_at — timestamp — 등록일자
- modified_user_idx — varchar — 수정자idx
- modified_at — timestamp — 수정일자
- db_id — varchar(20) — 아이디
- db_passwd — varchar(20) — 패스워드
- del_yn — varchar — 삭제
master_db_data_basic_info
- idx — int8 — Primary key — NOT NULL — DB
- master_db_data_name — varchar(50) — NOT NULL — DB
- db_data_description — varchar(50) — NOT NULL — DB
- db_data_privacy_bounds — varchar(10) — NOT NULL — DB
- db_ip — varchar(50) — DB
- db_port — int8 — DB
- db_name — varchar(50) — DB
- db_password — varchar(50) — DB
- db_user_name — varchar(50) — DB
- db_schema — varchar(50) — DB
- creator_user_idx — int8 — 등록
- created_at — timestamp — 등록
- modified_user_idx — int8 — 수정
- modified_at — timestamp — 수정
- db_connect_info_idx — int8
- db_data_type — varchar(50)
- del_yn — varchar — 삭제
- db_data_detail_description — varchar(2000)
master_db_data_detail
- idx — int8 — Primary key — NOT NULL — DB
- master_db_data_basic_info_idx — int8 — Foreign key → master_db_data_basic_info.idx — NOT NULL — DB
- db_data_table_name — varchar(100) — NOT NULL — DB
- column_name — varchar(100) — NOT NULL — DB
- column_type — varchar(100) — NOT NULL — DB
- connect_column_yn — varchar(1) — NOT NULL — DB
- creator_user_idx — int8 — 등록
- created_at — timestamp — 등록
- modified_user_idx — int8 — 수정
- modified_at — timestamp — 수정
- first_value — varchar — 해당
- group_code — varchar(20) — 상위
- column_comment — varchar(2000) — DB
master_db_map_code
- map_schema — varchar — Primary key — NOT NULL
- map_table — varchar — Primary key — NOT NULL
- map_column — varchar — Primary key — NOT NULL
- map_code — varchar
master_docker_basic_info
- idx — int8 — Primary key — NOT NULL — 도커
- docker_name — varchar(100) — NOT NULL — 도커
- docker_description — varchar(30) — NOT NULL — 도커
- original_file_name — varchar — 원본
- saving_file_name — varchar — 저장
- file_path — varchar — 파일
- file_extension — varchar — 파일
- file_size — int8 — 파일
- docker_disabled_yn — varchar(1) — NOT NULL — 도커
- creator_user_idx — int8 — 등록
- created_at — timestamp — 등록
- modified_user_idx — int8 — 수정
- modified_at — timestamp — 수정
- del_yn — varchar — 삭제
master_docker_program
- idx — int8 — Primary key — NOT NULL — 도커
- master_docker_basic_info_idx — int8 — Foreign key → master_docker_basic_info.idx — NOT NULL — 도커
- program_name — varchar — NOT NULL — 프로그램
- program_version — varchar — NOT NULL — 프로그램
- program_port_yn — varchar(1) — NOT NULL — 프로그램
- program_basic_port — int8 — 프로그램
- program_open_yn — varchar(1) — 프로그램
- program_description — varchar — NOT NULL — 프로그램
- creator_user_idx — int8 — 등록
- created_at — timestamp — 등록
- modified_user_idx — int8 — 수정
- modified_at — timestamp — 수정
master_sandbox_enroll_env_port
- idx — int8 — Primary key — NOT NULL — 샌드박스
- sandbox_enroll_basic_info_idx — int8 — Foreign key → sandbox_enroll_basic_info.idx — 샌드박스
- sandbox_enroll_env_idx — int8 — 샌드박스
- master_docker_program_idx — int8 — 도커
- master_server_port_idx — int8 — 서버
- master_server_port_port_num — int8 — 서버
- creator_user_idx — int8 — 등록
- created_at — timestamp — 등록
- modified_user_idx — int8 — 수정
- modified_at — timestamp — 수정
master_server_basic_info
- idx — int8 — Primary key — NOT NULL — 서버자원
- server_ip — varchar(30) — NOT NULL — 서버IP
- server_name — varchar(30) — NOT NULL — 서버이름
- server_description — varchar(50) — NOT NULL — 서버
- server_memory_size — int8 — NOT NULL — MEMORY
- server_disk_size — int8 — NOT NULL — DISK
- server_cpu_size — int8 — NOT NULL — CPU
- server_disabled_yn — varchar(1) — NOT NULL — 서버
- creator_user_idx — int8 — 등록
- created_at — timestamp — 등록
- modified_user_idx — int8 — 수정
- modified_at — timestamp — 수정
- server_enroll_memory_size — int8 — NOT NULL — 서버등록시
- server_enroll_disk_size — int8 — NOT NULL — 서버등록시
- server_enroll_cpu_size — int8 — NOT NULL — 서버등록시
- del_yn — varchar — 삭제
master_server_port
- idx — int8 — Primary key — NOT NULL — 포트정보
- master_server_basic_info_idx — int8 — Foreign key → master_server_basic_info.idx — NOT NULL — 서버자원idx
- port_num — int8 — NOT NULL — 포트
- port_status — varchar(10) — NOT NULL — 상태
- creator_user_idx — int8 — 등록
- created_at — timestamp — 등록
- modified_user_idx — int8 — 수정
- modified_at — timestamp — 수정
sandbox_detail_setup_list
- mem_idx — int8 — Primary key — NOT NULL — 사용자
- sandbox_idx — int8 — Primary key — NOT NULL — 샌드박스
- dataset_idx — int4 — Primary key — NOT NULL — 데이터셋
- sel_fields — varchar — 선택필드
- cond_col1 — varchar — cond
- cond_col2 — varchar — cond
- cond_col3 — varchar — cond
- cond_col4 — varchar — cond
- cond_col5 — varchar — cond
- cond_col6 — varchar — cond
- cond_col7 — varchar — cond
- created_at — timestamp — 등록
- modified_at — timestamp — 수정
- gubun — varchar — ecap
sandbox_enroll_basic_info
- idx — int8 — Primary key — NOT NULL — 샌드박스
- sandbox_kr_name — varchar(100) — NOT NULL — 샌드박스
- sandbox_eng_name — varchar(100) — 샌드박스
- sandbox_description — varchar(1000) — NOT NULL — 샌드박스
- sandbox_privacy_bounds — varchar(50) — NOT NULL — 샌드박스
- sandbox_status_code — varchar(50) — NOT NULL — 샌드박스
- sandbox_reject_reason — varchar(200) — 샌드박스
- creator_user_idx — int8 — 등록
- created_at — timestamp — 등록
- modified_user_idx — int8 — 수정
- modified_at — timestamp — 수정
- del_yn — varchar — 삭제
- sandbox_analysis_status — varchar — 1:디폴트
- sandbox_analysis_code — varchar — 샌드박스
- run_yn — varchar — 작동
sandbox_enroll_dataset_connection
- idx — int8 — Primary key — NOT NULL — 데이터셋연계조건
- sandbox_enroll_basic_info_idx — int8 — Foreign key → sandbox_enroll_basic_info.idx — NOT NULL — 샌드박스
- dataset_basic_info_idx — int8 — NOT NULL — 데이터셋
- sandbox_dataset_condition — varchar(50) — NOT NULL — 사용자
- creator_user_idx — int8 — 등록
- created_at — timestamp — 등록
- modified_user_idx — int8 — 수정
- modified_at — timestamp — 수정
- del_yn — varchar — 삭제
sandbox_enroll_env
- idx — int8 — Primary key — NOT NULL — 샌드박스
- sandbox_enroll_basic_info_idx — int8 — Foreign key → sandbox_enroll_basic_info.idx — NOT NULL — 샌드박스
- master_docker_basic_info_idx — int8 — NOT NULL — 도커
- req_master_server_basic_info_idx — int8 — NOT NULL — 사용자
- master_server_basic_info_idx — int8 — 관리자
- req_ram — int8 — 신청
- req_cpu — int8 — 신청
- req_volume — int8 — 신청
- creator_user_idx — int8 — 등록
- created_at — timestamp — 등록
- modified_user_idx — int8 — 수정
- modified_at — timestamp — 수정
sandbox_enroll_essential_dataset
- idx — int8 — Primary key — NOT NULL — 샌드박스
- sandbox_enroll_basic_info_idx — int8 — Foreign key → sandbox_enroll_basic_info.idx — NOT NULL — 샌드박스
- dataset_basic_info_idx — int8 — NOT NULL — 데이터셋
- sandbox_essential_dataset_user_condition — varchar(50) — NOT NULL — 샌드박스
- creator_user_idx — int8 — 등록
- created_at — timestamp — 등록
- modified_user_idx — int8 — 수정
- modified_at — timestamp — 수정
- dataset_file_seq — int8 — NOT NULL — 데이터셋
- del_yn — varchar — 삭제
sandbox_enroll_operate
- idx — int8 — Primary key — NOT NULL — 샌드박스
- sandbox_enroll_basic_info_idx — int8 — Foreign key → sandbox_enroll_basic_info.idx — NOT NULL — 샌드박스
- sandbox_operate_type — varchar(10) — NOT NULL — 샌드박스
- sandbox_operate_period — varchar(10) — 샌드박스
- sandbox_operate_specific_time — varchar(10) — 샌드박스
- sandbox_operate_month — varchar(10) — 샌드박스
- sandbox_operate_day — varchar(10) — 샌드박스
- sandbox_operate_date — varchar(10) — 샌드박스
- sandbox_operate_hour — varchar(10) — 샌드박스
- sandbox_operate_minute — varchar(10) — 샌드박스
- sandbox_operate_interval — varchar(10) — 샌드박스
- sandbox_operate_interval_hour — varchar(10) — 샌드박스
- sandbox_operate_interval_minute — varchar(10) — 샌드박스
- creator_user_idx — int8 — 등록
- created_at — timestamp — 등록
- modified_user_idx — int8 — 수정
- modified_at — timestamp — 수정
- del_yn — varchar — 삭제
sandbox_enroll_user_dataset
- idx — int8 — Primary key — NOT NULL — 샌드박스
- sandbox_enroll_basic_info_idx — int8 — Foreign key → sandbox_enroll_basic_info.idx — NOT NULL — 샌드박스
- dataset_basic_info_idx — int8 — NOT NULL — 샌드박스
- sandbox_user_dataset_user_condition — varchar(50) — 샌드박스
- creator_user_idx — int8 — 등록
- created_at — timestamp — 등록
- modified_user_idx — int8 — 수정
- modified_at — timestamp — 수정
- del_yn — varchar — 삭제
- dataset_code_dtl — varchar
sandbox_file
- idx — int8 — Primary key — NOT NULL
- sandbox_enroll_basic_info_idx — int8 — NOT NULL
- sandbox_file_seq — int4 — NOT NULL
- original_file_name — varchar(200)
- saving_file_name — varchar(200)
- file_path — varchar(200)
- file_extension — varchar(30)
- file_size — int8
- creator_user_idx — int8
- created_at — timestamp
- modified_user_idx — int8
- modified_at — timestamp
- detail_dataset_name — varchar — NOT NULL
- del_yn — varchar
- gubun — varchar — 1:데이터셋파일
sandbox_user_data_export_request
- idx — serial — Primary key — NOT NULL
- sandbox_name — varchar(1000) — NOT NULL — 데이터랩이름
- user_id — varchar(200) — NOT NULL — 사용자아이디
- status_code — varchar(10) — NOT NULL — 반출상태코드
- data_export_description — varchar(1000) — NOT NULL — 반출신청상세설명
- reject_reason — varchar(1000) — 반려사유
- created_at — timestamp — 생성일시
- modified_at — timestamp — 수정일시
- del_yn — bpchar(1) — NOT NULL — 삭제여부
sandbox_user_dataset
- sandbox_idx — int4 — NOT NULL — 샌드박스
- sandbox_name — varchar(1000) — NOT NULL — 샌드박스
- dataset_name — varchar(200) — NOT NULL — 데이터셋
- dataset_from_date — varchar(50) — NOT NULL — 데이터셋
- dataset_to_date — varchar(50) — NOT NULL — 데이터셋
- created_at — timestamp — 등록
- modified_at — timestamp — 수정
- del_yn — varchar(10) — NOT NULL — 삭제
sandbox_user_dataset_detail
- idx — serial — Primary key — NOT NULL — idx
- sandbox_idx — int4 — NOT NULL — 샌드박스
- sandbox_name — varchar(1000) — NOT NULL — 샌드박스
- dataset_name — varchar(200) — NOT NULL — 데이터셋
- column_name — varchar(200) — NOT NULL — 칼럼
- del_yn — varchar(10) — NOT NULL — 삭제
- created_at — timestamp — 등록
- modified_at — timestamp — 수정
sandbox_user_request
- idx — serial — Primary key — NOT NULL — idx
- sandbox_name — varchar(1000) — NOT NULL — 샌드박스
- user_id — varchar(200) — NOT NULL — 유저
- sandbox_user_description — varchar(1000) — 샌드박스
- sandbox_dataset — varchar(1000) — 샌드박스
- sandbox_use_from_date — varchar(50) — NOT NULL — 샌드박스
- sandbox_use_to_date — varchar(50) — NOT NULL — 샌드박스
- sandbox_user_status_code — varchar(10) — NOT NULL — 샌드박스
- sandbox_reject_reason — varchar(1000) — 샌드박스
- created_at — timestamp — 등록
- modified_at — timestamp — 수정
- del_yn — varchar(10) — NOT NULL — 삭제
target_dataset
- idx — int8 — Primary key — NOT NULL — 데이터셋
- dataset_basic_info_idx — int8 — Foreign key → dataset_basic_info.idx — NOT NULL — 데이터셋
- target_dataset_seq — int4 — NOT NULL — 데이터셋
- target_dataset_aff — varchar(10) — 데이터셋
- target_dataset_de — varchar(10) — 데이터셋
- creator_user_idx — int8 — 등록
- created_at — timestamp — 등록
- modified_user_idx — int8 — 수정
- modified_at — timestamp — 수정
- del_yn — varchar — 삭제
target_db
- idx — int8 — Primary key — NOT NULL
- master_db_data_basic_info_idx — int8 — Foreign key → master_db_data_basic_info.idx — NOT NULL
- target_db_seq — int4 — NOT NULL
- target_db_aff — varchar(10)
- target_db_de — varchar(10)
- creator_user_idx — int8
- created_at — timestamp
- modified_user_idx — int8
- modified_at — timestamp
target_sandbox
- idx — int8 — Primary key — NOT NULL — 샌드박스
- sandbox_enroll_basic_info_idx — int8 — Foreign key → sandbox_enroll_basic_info.idx — NOT NULL — 샌드박스
- target_sandbox_seq — int4 — NOT NULL — 샌드박스
- target_sandbox_aff — varchar(10) — 샌드박스
- target_sandbox_de — varchar(10) — 샌드박스
- creator_user_idx — int8 — 등록
- created_at — timestamp — 등록
- modified_user_idx — int8 — 수정
- modified_at — timestamp — 수정