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 — 수정