직고 서비스 ERD_파일관리 보완본

테이블 (24)

ADDRESS_BOOK_CONTACT

  • contact_id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → COMPANY.company_id — NOT NULL
  • company_name — VARCHAR(100)
  • contact_name — VARCHAR(100)
  • mobile_number — VARCHAR(30)
  • fax_number — VARCHAR(30)
  • email — VARCHAR(255)
  • memo — TEXT
  • created_by_user_id — BIGINT — 외래 키 → APP_USER.user_id
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

ADDRESS_BOOK_GROUP

  • group_id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → COMPANY.company_id — NOT NULL
  • group_name — VARCHAR(100) — NOT NULL
  • created_by_user_id — BIGINT — 외래 키 → APP_USER.user_id
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

ADDRESS_BOOK_GROUP_MEMBER

  • company_id — BIGINT — 외래 키 → COMPANY.company_id — NOT NULL
  • group_id — BIGINT — 외래 키 → ADDRESS_BOOK_GROUP.group_id — NOT NULL
  • contact_id — BIGINT — 외래 키 → ADDRESS_BOOK_CONTACT.contact_id — NOT NULL
  • created_at — TIMESTAMP

APP_USER

  • user_id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → COMPANY.company_id — NOT NULL
  • login_id — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • display_name — VARCHAR(100)
  • email — VARCHAR(255)
  • phone — VARCHAR(30)
  • mobile — VARCHAR(30)
  • address — TEXT
  • role_code — VARCHAR(30)
  • status_code — VARCHAR(30)
  • last_login_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

AUDIT_LOG

  • audit_log_id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → COMPANY.company_id — NOT NULL
  • user_id — BIGINT — 외래 키 → APP_USER.user_id
  • action_type — VARCHAR(50)
  • target_table — VARCHAR(100)
  • target_id — BIGINT
  • description — TEXT
  • ip_address — VARCHAR(50)
  • created_at — TIMESTAMP

AUTO_CLASSIFICATION_RULE

  • rule_id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → COMPANY.company_id — NOT NULL
  • channel_code — VARCHAR(30)
  • match_type — VARCHAR(30)
  • match_value — VARCHAR(255)
  • target_type — VARCHAR(30)
  • target_folder_type — VARCHAR(30)
  • target_user_id — BIGINT — 외래 키 → APP_USER.user_id
  • priority — INT
  • is_active — BOOLEAN
  • created_by_user_id — BIGINT — 외래 키 → APP_USER.user_id
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

BLOCKED_NUMBER

  • blocked_number_id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → COMPANY.company_id — NOT NULL
  • channel_code — VARCHAR(30)
  • blocked_number — VARCHAR(30) — NOT NULL
  • reason — VARCHAR(255)
  • created_by_user_id — BIGINT — 외래 키 → APP_USER.user_id
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

COMPANY

  • company_id — BIGINT — 기본 키 — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • status_code — VARCHAR(30)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

FAQ

  • faq_id — BIGINT — 기본 키 — NOT NULL
  • category_code — VARCHAR(30)
  • question — VARCHAR(500) — NOT NULL
  • answer — TEXT
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

FAX_DOCUMENT

  • fax_document_id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → COMPANY.company_id — NOT NULL
  • fax_tx_id — BIGINT — 외래 키 → FAX_TRANSMISSION.fax_tx_id — NOT NULL
  • file_id — BIGINT — 외래 키 → FILE_ASSET.file_id — NOT NULL
  • document_order — INT
  • created_at — TIMESTAMP

FAX_RECIPIENT

  • fax_recipient_id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → COMPANY.company_id — NOT NULL
  • fax_tx_id — BIGINT — 외래 키 → FAX_TRANSMISSION.fax_tx_id — NOT NULL
  • recipient_seq — INT
  • recipient_fax_number — VARCHAR(30)
  • recipient_name — VARCHAR(100)
  • delivery_status_code — VARCHAR(30)
  • error_code — VARCHAR(50)
  • point_used — INT
  • completed_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

FAX_TRANSMISSION

  • fax_tx_id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → COMPANY.company_id — NOT NULL
  • request_user_id — BIGINT — 외래 키 → APP_USER.user_id — NOT NULL
  • sender_fax_number — VARCHAR(30)
  • subject — VARCHAR(255)
  • send_type — VARCHAR(30)
  • scheduled_at — TIMESTAMP
  • status_code — VARCHAR(30)
  • used_point — INT
  • requested_at — TIMESTAMP
  • completed_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

FILE_ASSET

  • file_id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → COMPANY.company_id — NOT NULL
  • uploaded_by_user_id — BIGINT — 외래 키 → APP_USER.user_id
  • original_file_name — VARCHAR(255) — NOT NULL
  • stored_file_name — VARCHAR(255)
  • storage_uri — TEXT — NOT NULL
  • file_extension — VARCHAR(20)
  • mime_type — VARCHAR(100)
  • file_size — BIGINT
  • file_category — VARCHAR(50)
  • page_count — INT
  • checksum — VARCHAR(255)
  • status_code — VARCHAR(30)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

INBOX_ATTACHMENT

  • attachment_id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → COMPANY.company_id — NOT NULL
  • message_id — BIGINT — 외래 키 → INBOX_MESSAGE.message_id — NOT NULL
  • file_id — BIGINT — 외래 키 → FILE_ASSET.file_id — NOT NULL
  • attachment_type — VARCHAR(50)
  • created_at — TIMESTAMP

INBOX_MESSAGE

  • message_id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → COMPANY.company_id — NOT NULL
  • channel_code — VARCHAR(30)
  • folder_type — VARCHAR(30)
  • owner_user_id — BIGINT — 외래 키 → APP_USER.user_id
  • sender_info — VARCHAR(255)
  • recipient_info — VARCHAR(255)
  • title — VARCHAR(255)
  • message_body — TEXT
  • received_at — TIMESTAMP
  • read_at — TIMESTAMP
  • status_code — VARCHAR(30)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

NOTICE

  • notice_id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

PAYMENT_CHARGE

  • charge_id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → COMPANY.company_id — NOT NULL
  • requested_by_user_id — BIGINT — 외래 키 → APP_USER.user_id
  • charge_product_name — VARCHAR(100)
  • payment_amount — INT
  • charged_point — INT
  • payment_status_code — VARCHAR(30)
  • requested_at — TIMESTAMP
  • paid_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

POINT_TRANSACTION

  • point_tx_id — BIGINT — 기본 키 — NOT NULL
  • wallet_id — BIGINT — 외래 키 → POINT_WALLET.wallet_id — NOT NULL
  • company_id — BIGINT — 외래 키 → COMPANY.company_id — NOT NULL
  • tx_type — VARCHAR(30)
  • point_amount — INT
  • balance_after — INT
  • related_service_type — VARCHAR(30)
  • related_tx_id — BIGINT
  • description — VARCHAR(255)
  • created_at — TIMESTAMP

POINT_WALLET

  • wallet_id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → COMPANY.company_id — NOT NULL
  • free_point — INT
  • paid_point — INT
  • updated_at — TIMESTAMP

SENDER_NUMBER

  • sender_number_id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → COMPANY.company_id — NOT NULL
  • sender_number — VARCHAR(30) — NOT NULL
  • service_type — VARCHAR(30)
  • verification_status_code — VARCHAR(30)
  • verified_at — TIMESTAMP
  • created_by_user_id — BIGINT — 외래 키 → APP_USER.user_id
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

SMS_RECIPIENT

  • sms_recipient_id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → COMPANY.company_id — NOT NULL
  • sms_tx_id — BIGINT — 외래 키 → SMS_TRANSMISSION.sms_tx_id — NOT NULL
  • recipient_seq — INT
  • recipient_number — VARCHAR(30)
  • recipient_name — VARCHAR(100)
  • delivery_status_code — VARCHAR(30)
  • error_code — VARCHAR(50)
  • point_used — INT
  • delivered_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

SMS_TRANSMISSION

  • sms_tx_id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → COMPANY.company_id — NOT NULL
  • request_user_id — BIGINT — 외래 키 → APP_USER.user_id — NOT NULL
  • sender_number — VARCHAR(30)
  • message_type — VARCHAR(30)
  • title — VARCHAR(255)
  • message_text — TEXT
  • send_type — VARCHAR(30)
  • scheduled_at — TIMESTAMP
  • status_code — VARCHAR(30)
  • expected_point — INT
  • used_point — INT
  • requested_at — TIMESTAMP
  • completed_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

SUPPORT_INQUIRY

  • inquiry_id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → COMPANY.company_id
  • writer_name — VARCHAR(100)
  • email — VARCHAR(255)
  • mobile_number — VARCHAR(30)
  • title — VARCHAR(255)
  • inquiry_content — TEXT
  • status_code — VARCHAR(30)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

USER_SETTING

  • setting_key — VARCHAR(100) — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → APP_USER.user_id — NOT NULL
  • setting_value — TEXT
  • updated_at — TIMESTAMP