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