test
Tables (46)
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_group_permissions
- id — bigserial — Primary key — NOT NULL
- group_id — int4 — NOT NULL
- permission_id — int4 — 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) — 머신러닝
- Field
- Field2
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 — 수정일
user_profile
- id — serial4 — Primary key — NOT NULL
- user_id — int4 — auth_user.id와
- created_at — timestamptz — NOT NULL — 생성일
- updated_at — timestamptz — NOT NULL — 수정일
- full_name — varchar(150) — 사용자
- position — varchar(150) — 사용자의
- login_fail_count — int4 — NOT NULL — 연속
- lock_expires_at — timestamptz — 계정
- is_locked — bool — NOT NULL — 임시
- password_changed_at — timestamptz — 최근
- user_image — bytea — 사용자
- company_id — int4 — NOT NULL — 소속