Digital Finance Portal
Tables (18)
Application (애플리케이션)
- id — Primary key — NOT NULL
- 이름 (name)
ApplicationVersion (애플리케이션 버전)
- id — Primary key — NOT NULL
- version
- is_available (Field)
- release_date (Field2)
- id (id2) — Foreign key → Application.id — NOT NULL
CustomUser (유저)
- 유저 id (user_id) — Primary key — NOT NULL
- 이름 (user_name)
- 이메일 (email)
- is_staff
- is_active
- date_joined
- last_login
- 회사id (company_id) — Foreign key → company.회사id — NOT NULL
DeviceAuthCode (디바이스 인증 코드)
- id — Primary key — NOT NULL
- application_name (Field)
- auth_code (Field2)
- uuid (Field3)
- hardware_hash (Field4)
- ip_address (Field5)
- is_login_completed (Field6)
- has_device_logged_in (Field7)
- created_at (Field8)
- expires_at (Field9)
- activated_at (Field10)
- 유저 id (user_id) — Foreign key → CustomUser.유저 id — NOT NULL
DeviceToken (디바이스 토큰)
- id — Primary key — NOT NULL
- user_email — VARCHAR(255)
- first_hardware_hash
- first_ip_address (Field)
- token (Field2)
- last_active (Field3)
- created_at (Field4)
- application_name (Field5)
- is_deactivated (Field6)
- 유저 id (user_id) — Foreign key → CustomUser.유저 id — NOT NULL
LoginInfo (Untitled)
- id — Primary key — NOT NULL
- user_email
- otp_code
- hardware_hash
- cpu_changed (Field) — Boolean
- disk_changed (Field2) — Boolean
- bios_changed (Field3) — Boolean
- ip_address (Field4)
- application_name (Field5)
- login_type (Field6)
- login_at (Field7)
- offline_login_count (Field8)
- id (id2) — Foreign key → DeviceToken.id — NOT NULL
- 유저 id (user_id) — Foreign key → CustomUser.유저 id — NOT NULL
OTPAuthCode (OTP 인증 코드)
- id — Primary key — NOT NULL
- application_name (Field)
- auth_code (Field2)
- ip_address (Field3)
- created_at (Field4)
- expires_at (Field5)
- used (Field6)
- attempts (Field7)
- 유저 id (user_id) — Foreign key → CustomUser.유저 id — NOT NULL
PersonalInfoAccessLog (개인정보 접근 로그)
- id (Key) — Primary key — NOT NULL
- user_name (Field)
- user_email (Field2)
- access_datetime (Field3)
- ip_address (Field4)
- action_type (Field5)
- target_table (Field6)
- target_pk (Field7)
- access_reason (Field8)
- 유저 id (user_id) — Foreign key → CustomUser.유저 id — NOT NULL
PersonalInfoManager (개인정보 관리자)
- id — Primary key — NOT NULL
- is_active
- is_manager
- 유저 id (user_id) — Foreign key → CustomUser.유저 id — NOT NULL
PersonalInfoManagerHistory (개인정보 관리자 이력)
- id — Primary key — NOT NULL
- manager_email (Field)
- manager_name (Field2)
- action (Field3)
- is_manager (Field4)
- action_by_email (Field5)
- action_at (Field6)
- reason (Field7)
- ip_address (Field8)
- id (id2) — Foreign key → PersonalInfoManager.id — NOT NULL
- 유저 id (user_id) — Foreign key → CustomUser.유저 id — NOT NULL
ServiceContract (서비스 계약)
- 서비스계약id (id) — Primary key — NOT NULL
- 계약 그룹 (contract_group)
- 계약 일시 (contract_at)
- 만료 일시 (expired_at)
- is_application_login_allowed (Field)
- is_portal_login_allowed (Field2)
- note1
- note2
- 회사id (company_id) — Foreign key → company.회사id — NOT NULL
- id (id2) — Foreign key → Application.id — NOT NULL
UserApplicationPermission (사용자-애플리케이션 권한)
- id — Primary key — NOT NULL
- 유저 id (user_id) — Foreign key → CustomUser.유저 id — NOT NULL
- id (id2) — Foreign key → Application.id — NOT NULL
company (회사)
- 회사id (company_id) — Primary key — NOT NULL
- 회사 이름 (company_name)
- 생성 일시 (created_at)
project (프로젝트)
- id — Primary key — NOT NULL
- name (Field)
user_application_role (사용자-애플리케이션 역할)
- id — Primary key — NOT NULL
- role (Field)
- created_at (Field2)
- updated_at (Field3)
- 유저 id (user_id) — Foreign key → CustomUser.유저 id — NOT NULL
- id (id2) — Foreign key → Application.id — NOT NULL
xbrl_wizard (xbrl 작업)
- uuid — Primary key — NOT NULL
- job_name (Field)
- request_content (Field2)
- job_type (Field3)
- is_consolidated (Field4)
- is_seperate (Field5)
- ixd_file (Field6)
- wizard_template_separated (Field7)
- wizard_template_consolidated (Field8)
- base_info_template (Field9)
- smart_xbrl_separated (Field10)
- smart_xbrl_consolidated (Field11)
- status (Field12)
- status_description (Field13)
- comment (Field14)
- selected_treeview (Field15)
- created_at (Field16)
- updated_at (Field17)
- is_deleted (Field18)
- requester (user_id) — Foreign key → CustomUser.유저 id — NOT NULL
- reviewer (user_id2) — Foreign key → CustomUser.유저 id — NOT NULL
xbrl_wizard_result_file (xbrl 결과 파일)
- id — Primary key — NOT NULL
- file_type (Field)
- file (Field2)
- created_at (Field3)
- is_deleted (Field4)
- job (uuid) — Foreign key → xbrl_wizard.uuid — NOT NULL
- created_by (user_id) — Foreign key → CustomUser.유저 id — NOT NULL
xbrl_wizard_status (xbrl 상태이력)
- id — Primary key — NOT NULL
- status (Field)
- status_description (Field2)
- created_at (Field3)
- is_deleted (Field4)
- created_by (user_id) — Foreign key → CustomUser.유저 id — NOT NULL
- job (uuid) — Foreign key → xbrl_wizard.uuid — NOT NULL