직고 서비스 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