ERP Database Diagram

erDiagram
    account_menu_settings {
        int_unsigned id PK
        int_unsigned accounts_id
        int_unsigned menu_items_id
        tinyint is_visible
        enum access_level
    }
    accounts {
        int_unsigned id PK
        varchar user_id UK
        varchar user_password
        varchar name
        varchar department
        varchar position
        text memo
        smallint_unsigned roles_id
        varchar totp_secret
        tinyint totp_enabled
        text backup_codes
        tinyint is_active
        datetime last_login_at
        datetime pw_changed_at
        datetime created_at
        datetime updated_at
        varchar contact
        tinyint can_access_setting
    }
    activity_logs {
        bigint_unsigned id PK
        int_unsigned contract_id
        varchar activity_type
        varchar summary
        longtext detail
        int_unsigned account_id
        datetime created_at
    }
    admin_inquiries {
        int id PK
        varchar external_inquiry_key UK
        varchar inquiry_type
        varchar title
        text content
        varchar requester_name
        varchar requester_phone
        varchar requester_email
        enum status
        datetime created_at
        datetime updated_at
        datetime answered_at
        datetime last_viewed_at
    }
    admin_inquiry_meta {
        tinyint_unsigned id PK
        datetime last_checked_at
        datetime created_at
        datetime updated_at
    }
    admin_inquiry_replies {
        int id PK
        int inquiry_id
        enum author_type
        text reply_content
        int created_by_account_id
        varchar created_by_name
        datetime created_at
        datetime updated_at
    }
    alimtalk_reminder_log {
        int_unsigned id PK
        varchar ref_key UK
        datetime created_at
    }
    audit_logs {
        bigint_unsigned id PK
        varchar table_name
        int_unsigned record_id
        enum action
        varchar source
        int_unsigned account_id
        longtext changed_fields
        longtext old_values
        longtext new_values
        varchar ip_address
        datetime created_at
    }
    auth_remember_tokens {
        bigint_unsigned id PK
        int_unsigned accounts_id
        varchar token_hash
        datetime expires_at
        datetime created_at
    }
    burial_categories {
        int_unsigned id PK
        varchar name
        varchar spot_type
        text description
        smallint sort_order
        tinyint is_active
        datetime created_at
        datetime updated_at
    }
    burial_category_spot_types {
        int id PK
        int category_id
        varchar name
        int cols
        int capacity
        tinyint is_communal
        varchar bg_color
        int maintenance_fee
        varchar border_color
        int sort_order
        timestamp created_at
        timestamp updated_at
        datetime deleted_at
        int list_price
    }
    burial_contracts {
        int_unsigned id PK
        varchar contract_no UK
        int_unsigned spot_id
        varchar product_type
        tinyint_unsigned capacity
        varchar contractor_place
        varchar contractor_name
        varchar contractor_birth1
        varchar contractor_birth2
        varchar contractor_phone
        varchar contractor_phone2
        varchar contractor_address
        varchar contractor_zipcode
        varchar contractor_address_detail
        varchar contractor_relation
        date balance_paid_date
        varchar email
        int origin_price
        int total_price
        decimal discount_rate
        int discount_fee
        int deposit_price
        int middle_price
        int remaining_price
        date contract_date
        date middle_date
        date remaining_date
        varchar contract_period
        int mfee_cycle_years
        int mfee_amount
        date start_fee_date
        varchar anchi_state
        tinyint is_temp_anchi
        date temp_contract_date
        date temp_anchi_date
        varchar manager
        varchar consultant
        varchar sale_type
        tinyint state
        date del_date
        text del_content
        text text_memo
        text special_note
        int_unsigned accounts_id
        datetime created_at
        datetime updated_at
        int_unsigned cell_id
        tinyint_unsigned communal_slot
        varchar consultant_copy1
        varchar sign_status
        datetime sign_requested_at
        datetime signed_at
    }
    burial_deceased {
        int_unsigned id PK
        int_unsigned contract_id
        tinyint_unsigned slot_index
        varchar name
        varchar sex
        varchar birth1
        varchar birth2
        date anchi_date
        date death_date
        varchar death_place
        varchar death_cause
        varchar death_number
        varchar address
        varchar zipcode
        varchar address_detail
        varchar cremation_info
        varchar burial_type
        varchar burial_location
        text memo
        tinyint is_removed
        date removed_date
        varchar removed_reason
        datetime created_at
        datetime updated_at
    }
    burial_joint_contractors {
        int_unsigned id PK
        int_unsigned contract_id
        varchar name
        varchar birth1
        varchar birth2
        varchar phone
        varchar phone2
        varchar email
        varchar relation
        varchar zipcode
        varchar address
        varchar address_detail
        text memo
        datetime created_at
        datetime updated_at
    }
    burial_open_records {
        int_unsigned id PK
        int_unsigned contract_id
        date open_date
        varchar reason
        varchar checker
        varchar applicant
        varchar open_staff
        varchar manager
        text memo
        datetime created_at
    }
    burial_payments {
        int_unsigned id PK
        int_unsigned contract_id
        varchar pay_type
        varchar pay_method
        int amount
        date due_date
        date due_date_end
        date paid_date
        tinyint is_paid
        int arrears
        varchar manager
        varchar receipt_no
        varchar moree_payment_key UK
        datetime moree_synced_at
        varchar pg_tid
        varchar pg_order_no
        varchar pg_card_name
        varchar pg_status
        datetime pg_cancelled_at
        varchar pg_cancelled_by
        varchar pg_cancel_reason
        int pg_cancelled_amount
        datetime pg_approved_at
        text memo
        int_unsigned accounts_id
        datetime created_at
        datetime updated_at
        varchar payment_token
    }
    burial_spot_cells {
        int_unsigned id PK
        int_unsigned spot_id
        smallint section_idx
        smallint row_idx
        smallint col_idx
        varchar cell_type
        varchar label
        tinyint is_active
        timestamp created_at
    }
    burial_spot_custom_types {
        int_unsigned id PK
        int_unsigned spot_id
        int_unsigned source_type_id
        varchar name
        int cols
        int capacity
        tinyint is_communal
        int maintenance_fee
        varchar bg_color
        varchar border_color
        int sort_order
        timestamp created_at
        timestamp updated_at
        datetime deleted_at
        int list_price
    }
    burial_spot_fee_config {
        int_unsigned id PK
        int_unsigned spot_id
        int spot_type_id
        varchar spot_type_key
        int maintenance_fee
        datetime created_at
        datetime updated_at
    }
    burial_spots {
        int_unsigned id PK
        int_unsigned category_id
        int_unsigned templete_id
        varchar templete_name
        varchar spot_type
        varchar can_product_type
        varchar spot_no
        varchar spot_label
        varchar status
        text memo
        int sort_order
        longtext grid_data
        datetime created_at
        datetime updated_at
        datetime deleted_at
    }
    burial_successors {
        int_unsigned id PK
        int_unsigned contract_id
        varchar name
        varchar birth1
        varchar birth2
        varchar gender
        varchar phone
        varchar phone2
        varchar email
        varchar relation
        varchar zipcode
        varchar address
        varchar address_detail
        text memo
        datetime created_at
        datetime updated_at
    }
    contract_documents {
        int_unsigned id PK
        int_unsigned contract_id
        varchar doc_type
        text memo
        longtext image_paths
        datetime created_at
        datetime updated_at
    }
    contract_sign_tokens {
        int_unsigned id PK
        int_unsigned contract_id
        varchar token UK
        datetime expires_at
        datetime used_at
        int_unsigned issued_by
        varchar issued_ip
        datetime created_at
    }
    contract_signatures {
        int_unsigned id PK
        int_unsigned contract_id
        varchar token UK
        varchar status
        varchar signer_name
        varchar signer_phone
        int deposit_amount
        mediumtext signature_image
        datetime signed_at
        varchar signed_ip
        datetime paid_at
        int_unsigned payment_id
        varchar pg_order_no
        datetime expires_at
        varchar pdf_path
        text sign_display_config
        datetime created_at
        datetime updated_at
    }
    contract_vault_files {
        int id PK
        int contract_id
        varchar original_name
        varchar stored_name
        int file_size
        varchar file_ext
        datetime created_at
    }
    custom_field_defs {
        int id PK
        enum scope
        varchar section
        varchar label
        enum field_type
        text select_options
        tinyint is_required
        tinyint is_system
        varchar field_name
        enum col_span
        int sort_order
        tinyint is_active
        timestamp created_at
    }
    custom_field_sections {
        int id PK
        enum scope
        varchar section_key
        varchar section_title
        int sort_order
        tinyint is_active
        tinyint is_default
        timestamp created_at
        timestamp updated_at
    }
    custom_field_values {
        int id PK
        int field_id
        int record_id
        text value
    }
    menu_items {
        int_unsigned id PK
        varchar menu_type
        int_unsigned parent_id
        smallint sort_order
        varchar page_name
        varchar route_path
        varchar icon_class
        tinyint is_visible
        datetime created_at
        datetime updated_at
    }
    migration_batches {
        int_unsigned id PK
        varchar batch_id UK
        varchar file_name
        int total_rows
        enum status
        datetime uploaded_at
        int_unsigned uploaded_by_id
        varchar uploaded_by_name
        datetime executed_at
        int_unsigned executed_by_id
        varchar executed_by_name
        longtext inserted_summary
        longtext executed_tracker
        datetime rolled_back_at
        int_unsigned rolled_back_by_id
        varchar rolled_back_by_name
        longtext rollback_summary
        datetime created_at
        datetime updated_at
    }
    mms_result {
        int_unsigned id PK
        varchar refkey
        varchar site_domain
        varchar name
        varchar phone
        text message
        varchar message_type
        text image_paths
        varchar api_result
        text api_response
        int_unsigned accounts_id
        datetime created_at
    }
    moree_bridge_nonces {
        varchar nonce PK
        datetime created_at
    }
    moree_sso_nonces {
        varchar nonce PK
        datetime created_at
    }
    moree_sync_outbox {
        int_unsigned id PK
        int_unsigned contract_id
        varchar operation
        varchar status
        int_unsigned attempts
        text last_error
        datetime created_at
        datetime updated_at
    }
    role_menu_permissions {
        int_unsigned id PK
        smallint_unsigned roles_id
        int_unsigned menu_items_id
        tinyint can_access
        datetime created_at
    }
    roles {
        smallint_unsigned id PK
        varchar role_code UK
        varchar role_name
        varchar description
        tinyint_unsigned sort_order
        tinyint is_active
        datetime created_at
    }
    scheduler {
        int id PK
        date start_date
        date end_date
        text memo
        datetime created_at
        datetime updated_at
    }
    site_config {
        int_unsigned id PK
        varchar site_name
        varchar site_domain
        varchar ceo_name
        varchar company_tel
        varchar company_address
        varchar mms_key
        varchar sender_number
        varchar pg_key
        varchar company_name
        varchar company_name_en
        varchar business_no
        varchar fax
        varchar homepage
        varchar logo_path
        varchar stamp_path
        varchar bank_name
        varchar bank_account
        varchar bank_holder
        char setup_completed
        tinyint_unsigned setup_step
    }
    spot_table_cells {
        int id PK
        int template_id
        tinyint_unsigned section_idx
        smallint_unsigned row_idx
        smallint_unsigned col_idx
        varchar cell_type
        varchar label
        timestamp created_at
    }
    spot_tables {
        int_unsigned id PK
        varchar name
        int_unsigned category_id
        varchar description
        longtext grid_data
        longtext fee_config
        datetime created_at
        datetime updated_at
    }
    accounts ||--o{ auth_remember_tokens : "accounts_id"
    burial_contracts ||--o{ burial_deceased : "contract_id"
    menu_items ||--o{ role_menu_permissions : "menu_items_id"
    roles ||--o{ role_menu_permissions : "roles_id"
    burial_contracts ||--o{ burial_open_records : "contract_id"
    burial_contracts ||--o{ contract_sign_tokens : "contract_id"
    accounts ||--o{ burial_payments : "accounts_id"
    burial_contracts ||--o{ burial_payments : "contract_id"
    admin_inquiries ||--o{ admin_inquiry_replies : "inquiry_id"
    roles ||--o{ accounts : "roles_id"
    burial_contracts ||--o{ contract_signatures : "contract_id"
    burial_contracts ||--o{ burial_successors : "contract_id"
    accounts ||--o{ account_menu_settings : "accounts_id"
    menu_items ||--o{ account_menu_settings : "menu_items_id"
    menu_items ||--o{ menu_items : "parent_id"
    accounts ||--o{ burial_contracts : "accounts_id"
    burial_spot_cells ||--o{ burial_contracts : "cell_id"
    spot_tables ||--o{ burial_spots : "templete_id"
    burial_categories ||--o{ burial_spots : "category_id"
    burial_categories ||--o{ spot_tables : "category_id"
    burial_spots ||--o{ burial_spot_cells : "spot_id"
    burial_categories ||--o{ burial_category_spot_types : "category_id"
    spot_tables ||--o{ spot_table_cells : "template_id"