erDiagram
    users ||--o{ authority : "권한"
    users {
        varchar user_id PK
        timestamp created_at
        varchar language_code
        varchar name
        varchar password
        integer remaining_leave_days
        varchar role
        varchar ship_yard_area
        boolean tts_enabled
        varchar work_shift
    }
    authority {
        bigint log_id PK
        smallint authority
        varchar member_id FK
    }
    refresh_token {
        varchar user_id PK
        varchar token
    }

erDiagram
    users ||--o{ absence_requests : "신청/결재"
    users ||--o{ attendance : "출퇴근"
    attendance {
        bigint id PK
        timestamp clock_in_time
        timestamp clock_out_time
        varchar in_location
        varchar out_location
        varchar status
        varchar total_work_time
        date work_date
        varchar user_id FK
    }
    work_calendar {
        date calendar_date PK
        varchar day_type
        varchar description
    }
    absence_requests {
        integer request_id PK
        varchar decision_comment
        varchar document_url
        date end_date
        timestamp processed_at
        varchar reason
        timestamp requested_at
        date start_date
        varchar status
        varchar request_type
        varchar user_id FK
        varchar processed_by FK
    }

erDiagram
    work_logs ||--o{ log_images : "첨부(구)"
    work_logs ||--o{ work_log_comments : "댓글"
    users ||--o{ work_log_comments : "작성자"
    work_logs ||--o{ work_log_images : "첨부"
    work_logs ||--o{ work_log_translations : "번역본"
    equipment ||--o{ work_logs : "대상 설비"
    users ||--o{ work_logs : "작성"
    work_logs {
        bigint log_id PK
        varchar audio_file_url
        timestamp created_at
        text log_text
        varchar title
        timestamp updated_at
        bigint equipment_id FK
        varchar user_id FK
    }
    work_log_translations {
        bigint translation_id PK
        timestamp created_at
        varchar language_code
        text original_text
        text original_title
        varchar trace_id
        text translated_text
        text translated_title
        timestamp updated_at
        varchar user_id
        bigint log_id FK
    }
    work_log_comments {
        bigint comment_id PK
        text content
        timestamp created_at
        timestamp updated_at
        bigint log_id FK
        varchar user_id FK
    }
    work_log_images {
        bigint id PK
        varchar image_url
        bigint work_log_id FK
    }
    log_images {
        bigint imgae_id PK
        varchar image_url
        bigint log_id FK
    }
    equipment {
        bigint equipment_id PK
        varchar name
        varchar nfc_tag
        varchar qr_code
    }

erDiagram
    document_chunks {
        bigint chunk_id PK
        integer chunk_index
        text content
        varchar content_hash
        timestamp created_at
        vector embedding
        integer embedding_dim
        varchar embedding_model
        varchar language_code
        varchar owner_user_id
        bigint source_id
        varchar source_type
        timestamp updated_at
        varchar visibility
    }
    chat_history {
        bigint id PK
        timestamp created_at
        text reply
        varchar retrieval_mode
        text source_chunk_ids
        varchar trace_id
        varchar user_id
        text user_query
    }

erDiagram
    chat_rooms ||--o{ chat_members : "참여"
    users ||--o{ chat_members : "참여자"
    chat_rooms ||--o{ chat_messages : "메시지"
    chat_rooms {
        integer room_id PK
        timestamp created_at
        varchar creator_id
        boolean is_group
        timestamp last_message_at
        varchar last_message_content
        varchar room_name
    }
    chat_members {
        integer id PK
        timestamp joined_at
        timestamp last_read_time
        integer room_id FK
        varchar user_id FK
    }
    chat_messages {
        bigint message_id PK
        text content
        varchar file_url
        varchar message_type
        varchar sender_id
        timestamp sent_at
        integer room_id FK
    }

erDiagram
    checklists ||--o{ checklist_items : "항목"
    checklist_items ||--o{ checklist_results : "점검 결과"
    users ||--o{ checklist_results : "점검자"
    equipment ||--o{ checklists : "점검 대상"
    safety_courses ||--o{ safety_enrollments : "과정"
    users ||--o{ safety_enrollments : "수강"
    safety_courses {
        integer course_id PK
        timestamp created_at
        varchar created_by
        text description
        integer duration_minutes
        varchar material_url
        varchar title
        varchar video_url
    }
    safety_enrollments {
        integer enrollment_id PK
        timestamp completion_date
        timestamp enrolled_at
        varchar status
        integer course_id FK
        varchar user_id FK
    }
    checklists {
        integer checklist_id PK
        timestamp created_at
        varchar phase
        varchar title
        timestamp updated_at
        bigint equipment_id FK
    }
    checklist_items {
        integer item_id PK
        varchar content
        integer sequence
        integer checklist_id FK
    }
    checklist_results {
        integer result_id PK
        timestamp checked_at
        boolean is_checked
        integer checklist_item_id FK
        varchar user_id FK
    }