optivs_erd

Tables (50)

abak_20250702_upload_raw_data_file

  • id — int4
  • file_name — varchar(200)
  • file_type — varchar(10)
  • size — varchar(24)
  • owner — varchar(100)
  • load_type — varchar(10)
  • description — varchar(300)
  • location — varchar(200)
  • create_at — timestamptz
  • update_at — timestamptz
  • is_preprocessing — bool
  • project_name — varchar(30)
  • cleansing — varchar(1)
  • standardization — varchar(1)

abak_header_column_20250819

  • id — int4
  • columns — varchar(10000)
  • raw_file_id — int4

abak_preprocessing_status_20250708

  • id — int4
  • owner — varchar(150)
  • preprocessing_id — varchar(150)
  • project_id — int4
  • is_preprocessing_running — bool
  • created_at — timestamp
  • updated_at — timestamp

abak_preprocessing_status_20250709

  • id — int4
  • owner — varchar(150)
  • preprocessing_id — varchar(150)
  • project_id — int4
  • is_preprocessing_running — bool
  • created_at — timestamptz
  • updated_at — timestamptz

abak_upload_raw_data_file_20250819

  • id — int4
  • file_name — varchar(200)
  • file_type — varchar(10)
  • size — varchar(24)
  • owner — varchar(100)
  • load_type — varchar(10)
  • description — varchar(300)
  • location — varchar(200)
  • create_at — timestamptz
  • update_at — timestamptz
  • is_preprocessing — bool
  • cleansing — varchar(1)
  • standardization — varchar(1)
  • is_create_table — bool

abak_upload_raw_data_file_record_20250819

  • upload_raw_data_file_id — int4
  • user_id — int4

access_log

  • id — int8 — Primary key — NOT NULL
  • event_time — timestamptz — Primary key — NOT NULL — 이벤트
  • user_id — varchar(100) — 사용자
  • ip_address — inet — 요청자
  • service — varchar(100) — 서비스
  • action — varchar(50) — NOT NULL — 수행
  • status — varchar(20) — NOT NULL — 수행
  • request_id — uuid — 트랜잭션/요청
  • user_agent — text — 클라이언트
  • details — text — 추가

access_log_2025

  • 2025-01-01 — 00:00:00+09')

access_log_2026

  • 2026-01-01 — 00:00:00+09')

application_log

  • id — int8 — Primary key — NOT NULL
  • event_time — timestamptz — Primary key — NOT NULL — 이벤트
  • user_id — varchar(100) — 행위
  • ip_address — inet — 요청자
  • service — varchar(100) — NOT NULL — 서비스
  • action — varchar(100) — NOT NULL — 수행
  • status — varchar(20) — NOT NULL — 수행
  • request_id — uuid — 트랜잭션/요청
  • details — text — 추가

application_log_2025

  • 2025-01-01 — 00:00:00+09')

application_log_2026

  • 2026-01-01 — 00:00:00+09')

audit_log

  • id — int8 — Primary key — NOT NULL
  • event_time — timestamptz — Primary key — NOT NULL — 이벤트
  • user_id — varchar(100) — NOT NULL — 행위
  • ip_address — inet — 요청자
  • service — varchar(100) — 서비스
  • action — varchar(100) — NOT NULL — 수행
  • resource — varchar(255) — NOT NULL — 대상
  • status — varchar(20) — NOT NULL — 수행
  • request_id — uuid — 트랜잭션/요청
  • details — text — 추가

audit_log_2025

  • 2025-01-01 — 00:00:00+09')

audit_log_2026

  • 2026-01-01 — 00:00:00+09')

auth_group

  • id — serial4 — Primary key — NOT NULL
  • name — varchar(150) — NOT NULL

auth_permission

  • id — serial4 — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • content_type_id — int4 — NOT NULL
  • codename — varchar(100) — NOT NULL

auth_user

  • id — serial4 — Primary key — NOT NULL
  • password — varchar(128) — NOT NULL
  • last_login — timestamptz
  • is_superuser — bool — NOT NULL
  • username — varchar(150) — NOT NULL
  • first_name — varchar(150) — NOT NULL
  • last_name — varchar(150) — NOT NULL
  • email — varchar(254) — NOT NULL
  • is_staff — bool — NOT NULL
  • is_active — bool — NOT NULL
  • date_joined — timestamptz — NOT NULL

auth_user_groups

  • id — bigserial — Primary key — NOT NULL
  • user_id — int4 — NOT NULL
  • group_id — int4 — NOT NULL

auth_user_user_permissions

  • id — bigserial — Primary key — NOT NULL
  • user_id — int4 — NOT NULL
  • permission_id — int4 — NOT NULL

company

  • id — serial4 — Primary key — NOT NULL
  • name — varchar(150) — NOT NULL — 회사명
  • domain — varchar(150) — 회사
  • address — text — 회사
  • is_active — bool — NOT NULL — 회사
  • created_at — timestamptz — NOT NULL — 생성일
  • updated_at — timestamptz — NOT NULL — 수정일

company_group

  • id — serial4 — Primary key — NOT NULL
  • company_id — int4 — NOT NULL — 소속
  • name — varchar(100) — NOT NULL — 그룹명
  • description — text — 그룹
  • is_system — bool — 시스템
  • created_at — timestamptz — NOT NULL — 생성일
  • updated_at — timestamptz — NOT NULL — 수정일
  • data_lake_permission_code — varchar(50) — 데이터레이크
  • preprocessing_permission_code — varchar(50) — 전처리
  • ml_permission_code — varchar(50) — 머신러닝

data_preprocessing_status

  • id — varchar(40) — Primary key — NOT NULL
  • start_at — timestamptz — NOT NULL
  • status — varchar(20) — NOT NULL

default_model_param

  • id — serial4 — Primary key — NOT NULL
  • model_name — varchar(50) — NOT NULL
  • param_name — varchar(50) — NOT NULL
  • param_value — varchar(100) — NOT NULL
  • description — text
  • created_at — timestamptz
  • updated_at — timestamptz

django_admin_log

  • id — serial4 — Primary key — NOT NULL
  • action_time — timestamptz — NOT NULL
  • object_id — text
  • object_repr — varchar(200) — NOT NULL
  • action_flag — int4 — NOT NULL
  • change_message — text — NOT NULL
  • content_type_id — int4
  • user_id — int4 — NOT NULL

django_content_type

  • id — serial4 — Primary key — NOT NULL
  • app_label — varchar(100) — NOT NULL
  • model — varchar(100) — NOT NULL

django_migrations

  • id — bigserial — Primary key — NOT NULL
  • app — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • applied — timestamptz — NOT NULL

django_session

  • session_key — varchar(40) — Primary key — NOT NULL
  • session_data — text — NOT NULL
  • expire_date — timestamptz — NOT NULL

email_send_log

  • id — serial4 — Primary key — NOT NULL
  • email — varchar(254) — NOT NULL — 이메일
  • auth_code — varchar(20) — NOT NULL — 인증
  • created_dt — timestamptz — NOT NULL — 생성일
  • verified — bool — NOT NULL — 인증완료여부
  • verified_dt — timestamptz — 인증완료일

execution_param

  • id — int4 — Primary key — NOT NULL
  • label — varchar(50) — NOT NULL
  • param_name — varchar(50) — NOT NULL
  • default_value — varchar(100) — NOT NULL
  • param_type — varchar(10) — NOT NULL
  • min — varchar(10)
  • max — varchar(10)
  • allow_list — text
  • user_id — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

feature_metadata

  • id — serial4 — Primary key — NOT NULL
  • name — varchar(50) — NOT NULL
  • group_name — varchar(100)
  • type — varchar(20)
  • min — varchar(10)
  • max — varchar(10)
  • interval — varchar(10)
  • example — varchar(200)

header_column

  • id — serial4 — Primary key — NOT NULL
  • columns — varchar(10000) — NOT NULL
  • raw_file_id — int4 — NOT NULL

ml_manage

  • id — serial4 — Primary key — NOT NULL
  • user_name — varchar(150) — NOT NULL — 사용자
  • ml_task_id — varchar(150) — NOT NULL — ML
  • created_at — timestamptz — NOT NULL — 생성일
  • updated_at — timestamptz — NOT NULL — 수정일
  • is_ml_running — bool — ML
  • current_status — varchar(50) — ML

ml_manage_logistic_unique_group_id

  • id — serial4 — Primary key — NOT NULL
  • user_name — varchar(150) — NOT NULL — 사용자
  • ml_task_id — varchar(150) — NOT NULL — ml_manage의
  • group_name — varchar(150) — NOT NULL — 그룹명
  • table_name — varchar(150) — 테이블명
  • created_at — timestamptz — NOT NULL — 생성일

ml_manage_preprocessing_info

  • id — serial4 — Primary key — NOT NULL
  • ml_manage_id — int4 — NOT NULL — ML
  • preprocessing_id — varchar(150) — NOT NULL — 전처리
  • created_at — timestamptz — NOT NULL — 생성일
  • updated_at — timestamptz — NOT NULL — 수정일

ml_manage_test_unique_group_id

  • id — serial4 — Primary key — NOT NULL
  • user_name — varchar(150) — NOT NULL — 사용자
  • ml_task_id — varchar(150) — NOT NULL — ml_manage의
  • group_name — varchar(150) — NOT NULL — 그룹명
  • table_name — varchar(150) — 테이블명
  • created_at — timestamptz — NOT NULL — 생성일

ml_manage_unique_model_id

  • id — serial4 — Primary key — NOT NULL
  • user_name — varchar(150) — NOT NULL — 사용자
  • ml_task_id — varchar(150) — NOT NULL — ml_manage의
  • group_name — varchar(150) — NOT NULL — 그룹명
  • model_name — varchar(150) — NOT NULL — 모델명
  • table_name — varchar(150) — 테이블명
  • created_at — timestamptz — NOT NULL — 생성일

model_manage

  • id — serial4 — Primary key — NOT NULL
  • user_name — varchar(150) — NOT NULL — 사용자
  • created_at — timestamptz — NOT NULL — 생성일
  • updated_at — timestamptz — NOT NULL — 수정일
  • group_name — varchar(150) — NOT NULL — 그룹
  • size — varchar(24) — 파일
  • model_image — bytea — 모델
  • model_setting — text — 모델
  • is_favorite — bool — NOT NULL — 즐겨찾기
  • keyword — text
  • description — text

permission_type

  • id — serial4 — Primary key — NOT NULL
  • code — varchar(50) — NOT NULL — 권한
  • name — varchar(100) — NOT NULL — 권한명
  • description — text — 권한
  • created_at — timestamptz — NOT NULL — 생성일
  • updated_at — timestamptz — NOT NULL — 수정일

preprocessing_complete_list

  • id — serial4 — Primary key — NOT NULL
  • user_name — varchar(150) — 사용자
  • table_name — varchar(250) — 전처리
  • original_table_name — varchar(250) — 전처리
  • size — varchar(24) — 파일
  • description — varchar(100) — 설명
  • created_at — timestamptz — NOT NULL — 생성일
  • updated_at — timestamptz — NOT NULL — 수정일

preprocessing_status

  • id — serial4 — Primary key — NOT NULL
  • owner — varchar(150) — NOT NULL — 사용자아이디
  • preprocessing_id — varchar(150) — NOT NULL — 전처리
  • project_id — int4 — 프로젝트
  • created_at — timestamptz — NOT NULL — 레코드
  • updated_at — timestamptz — NOT NULL — 레코드
  • is_preprocessing_running — bool — 전처리
  • current_status — varchar(50) — 전처리

project_manage

  • id — serial4 — Primary key — NOT NULL
  • project_name — varchar(30) — 프로젝트명
  • keyword — text — 프로젝트
  • description — text — 프로젝트
  • owner — varchar(150) — NOT NULL — 사용자아이디
  • created_at — timestamptz — NOT NULL — 생성일
  • updated_at — timestamptz — NOT NULL — 수정일
  • size — varchar(24) — 프로젝트
  • report_image — bytea — 리포트
  • model_image — bytea — 모델
  • is_favorite — bool — NOT NULL — 즐겨찾기
  • features — _text — 프로젝트

project_manage_data_lake

  • id — serial4 — Primary key — NOT NULL
  • project_manage_id — int4 — NOT NULL — project_manage의
  • upload_raw_data_file_id — int4 — NOT NULL — upload_raw_data_file의
  • created_at — timestamptz — NOT NULL — 생성일

report_manage

  • id — serial4 — Primary key — NOT NULL
  • user_name — varchar(150) — NOT NULL — 사용자
  • created_at — timestamptz — NOT NULL — 생성일
  • updated_at — timestamptz — NOT NULL — 수정일
  • group_name — varchar(150) — NOT NULL
  • size — varchar(24) — 파일
  • report_image — bytea — 리포트
  • report_setting — text — 리포트
  • is_favorite — bool — NOT NULL — 즐겨찾기
  • keyword — text
  • description — text

template_feature

  • id — serial4 — Primary key — NOT NULL
  • template_name — varchar(200) — NOT NULL
  • feature_name_id — int4 — NOT NULL

upload_chunk_file

  • id — serial4 — Primary key — NOT NULL
  • unique_file_name — varchar(100) — NOT NULL
  • chunk_index — int4 — NOT NULL
  • data — bytea — NOT NULL
  • create_at — timestamptz — NOT NULL

upload_raw_data_file

  • id — serial4 — Primary key — NOT NULL
  • file_name — varchar(200) — NOT NULL
  • file_type — varchar(10) — NOT NULL
  • size — varchar(24) — NOT NULL
  • owner — varchar(100) — NOT NULL
  • load_type — varchar(10) — NOT NULL
  • description — varchar(300)
  • location — varchar(200) — NOT NULL
  • create_at — timestamptz — NOT NULL
  • update_at — timestamptz — NOT NULL
  • is_preprocessing — bool — NOT NULL
  • cleansing — varchar(1)
  • standardization — varchar(1)
  • is_create_table — bool — NOT NULL — 테이블

upload_raw_data_file_record

  • upload_raw_data_file_id — int4 — Primary key — NOT NULL
  • user_id — int4 — NOT NULL

user

  • id — serial4 — Primary key — NOT NULL
  • name — varchar(50) — NOT NULL
  • password — varchar(30) — NOT NULL
  • create_at — timestamptz — NOT NULL
  • email — varchar(254) — NOT NULL
  • position — varchar(50) — NOT NULL
  • update_at — timestamptz — NOT NULL

user_group_mapping

  • id — serial4 — Primary key — NOT NULL
  • user_id — int4 — NOT NULL — 사용자
  • company_id — int4 — NOT NULL — 회사
  • company_group_id — int4 — NOT NULL — 그룹
  • created_at — timestamptz — NOT NULL — 생성일
  • updated_at — timestamptz — NOT NULL — 수정일