ocean

Tables (46)

AccessLog

  • log_id — BIGINT
  • user_id — BIGINT
  • login_at — DATETIME
  • ip_address — VARCHAR(50)

Category

  • category_id — BIGINT
  • category_type_id — BIGINT
  • parent_id — BIGINT
  • name — VARCHAR(100)
  • order_no — INT

CategoryType

  • category_type_id — BIGINT
  • type_name — VARCHAR(50)

ChatbotMessage

  • msg_id — BIGINT
  • session_id — BIGINT
  • sender — VARCHAR(10)
  • message — TEXT
  • created_at — DATETIME

ChatbotSession

  • session_id — BIGINT
  • user_id — BIGINT
  • started_at — DATETIME

ChecklistAttachment

  • attachment_id — BIGINT
  • response_id — BIGINT
  • file_id — BIGINT

ChecklistEntry

  • entry_id — BIGINT
  • template_id — BIGINT
  • user_id — BIGINT
  • created_at — DATETIME
  • status — VARCHAR(20)

ChecklistItem

  • item_id — BIGINT
  • template_id — BIGINT
  • question — TEXT
  • item_type — VARCHAR(20)
  • required — BOOLEAN
  • order_no — INT

ChecklistItemResponse

  • response_id — BIGINT
  • entry_id — BIGINT
  • item_id — BIGINT
  • answer — TEXT
  • score — INT
  • created_at — DATETIME

ChecklistTemplate

  • template_id — BIGINT
  • creator_id — BIGINT
  • title — VARCHAR(200)
  • description — TEXT
  • created_at — DATETIME

Comment

  • comment_id — BIGINT
  • user_id — BIGINT
  • target_table — VARCHAR(50)
  • target_id — BIGINT
  • content — TEXT
  • created_at — DATETIME

Complaint

  • complaint_id — BIGINT
  • user_id — BIGINT
  • title — VARCHAR(200)
  • content — TEXT
  • status — VARCHAR(20)
  • created_at — DATETIME

ComplaintAttachment

  • attachment_id — BIGINT
  • complaint_id — BIGINT
  • file_id — BIGINT

ComplaintReply

  • reply_id — BIGINT
  • complaint_id — BIGINT
  • admin_id — BIGINT
  • reply_text — TEXT
  • created_at — DATETIME

FAQ

  • faq_id — BIGINT
  • question — VARCHAR(200)
  • answer — TEXT
  • category_id — BIGINT
  • created_at — DATETIME

FileStorage

  • file_id — BIGINT
  • file_name — VARCHAR(255)
  • file_path — VARCHAR(255)
  • file_type — VARCHAR(50)
  • file_size — BIGINT
  • created_at — DATETIME

Inquiry

  • inquiry_id — BIGINT
  • user_id — BIGINT
  • title — VARCHAR(200)
  • content — TEXT
  • status — VARCHAR(20)
  • created_at — DATETIME

InquiryAttachment

  • attachment_id — BIGINT
  • inquiry_id — BIGINT
  • file_id — BIGINT

InquiryReply

  • reply_id — BIGINT
  • inquiry_id — BIGINT
  • admin_id — BIGINT
  • reply_text — TEXT
  • created_at — DATETIME

InspectionComment

  • comment_id — BIGINT
  • inspection_id — BIGINT
  • user_id — BIGINT
  • comment — TEXT — EX

InspectionItemLog

  • item_log_id — BIGINT
  • inspection_id — BIGINT
  • item_id — BIGINT
  • result — VARCHAR(100)
  • comment — TEXT — EX

InspectionLog

  • inspection_id — BIGINT
  • entry_id — BIGINT
  • inspector_id — BIGINT
  • start_time — DATETIME
  • end_time — DATETIME
  • status — VARCHAR(20)

InspectionPhoto

  • photo_id — BIGINT
  • item_log_id — BIGINT
  • file_id — BIGINT

Issue

  • issue_id — BIGINT
  • user_id — BIGINT
  • title — VARCHAR(200)
  • content — TEXT
  • status — VARCHAR(20)
  • created_at — DATETIME

IssueAttachment

  • attachment_id — BIGINT
  • issue_id — BIGINT
  • file_id — BIGINT
  • uploaded_at — DATETIME

IssueComment

  • comment_id — BIGINT
  • issue_id — BIGINT
  • user_id — BIGINT
  • content — TEXT

Language

  • language_code — VARCHAR(10)
  • language_name — VARCHAR(50)

Notice

  • notice_id — BIGINT
  • admin_id — BIGINT
  • title — VARCHAR(200)
  • content — TEXT
  • is_top — BOOLEAN
  • created_at — DATETIME

NoticeAttachment

  • attachment_id — BIGINT
  • notice_id — BIGINT
  • file_id — BIGINT

Notification

  • notification_id — BIGINT
  • user_id — BIGINT
  • message — TEXT
  • type — VARCHAR(20)
  • status — VARCHAR(20)
  • created_at — DATETIME

NotificationLog

  • log_id — BIGINT
  • notification_id — BIGINT
  • sent_at — DATETIME
  • result — VARCHAR(20)

NotificationTemplate

  • template_id — BIGINT
  • title — VARCHAR(100)
  • content — TEXT
  • type — VARCHAR(20)

Organization

  • org_id — BIGINT
  • org_name — VARCHAR(100)
  • created_at — DATETIME

OrganizationMember

  • org_member_id — BIGINT
  • org_id — BIGINT
  • user_id — BIGINT
  • role_in_org — VARCHAR(50)
  • created_at — DATETIME

QRCode

  • qr_id — BIGINT
  • target_type — VARCHAR(50)
  • target_id — BIGINT
  • qr_value — TEXT
  • created_at — DATETIME

QnaAnswer

  • answer_id — BIGINT
  • qna_id — BIGINT
  • admin_id — BIGINT
  • content — TEXT
  • created_at — DATETIME

QnaAttachment

  • attachment_id — BIGINT
  • qna_id — BIGINT
  • file_id — BIGINT

QnaQuestion

  • qna_id — BIGINT
  • user_id — BIGINT
  • category_id — BIGINT
  • title — VARCHAR(200)
  • content — TEXT
  • status — VARCHAR(20)
  • created_at — DATETIME

RiskAnalysis

  • analysis_id — BIGINT
  • entry_id — BIGINT
  • risk_score — INT
  • summary — TEXT
  • created_at — DATETIME

RiskAnalysisItem

  • analysis_item_id — BIGINT
  • analysis_id — BIGINT
  • item_id — BIGINT
  • risk_level — INT
  • comment — TEXT — EX

Role

  • role_id — BIGINT
  • role_name — VARCHAR(50)

Translation

  • translation_id — BIGINT
  • target_table — VARCHAR(50)
  • target_id — BIGINT
  • language_code — VARCHAR(10)
  • translated_text — TEXT

User

  • user_id — BIGINT
  • username — VARCHAR(50)
  • password — VARCHAR(255)
  • name — VARCHAR(100)
  • email — VARCHAR(200)
  • phone — VARCHAR(20)
  • status — VARCHAR(20)
  • last_login_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME

UserPreference

  • pref_id — BIGINT
  • user_id — BIGINT
  • language_code — VARCHAR(10)
  • receive_email — BOOLEAN

UserRole

  • user_role_id — BIGINT
  • user_id — BIGINT
  • role_id — BIGINT

Worker

  • worker_id — BIGINT
  • user_id — BIGINT
  • name — VARCHAR(100)
  • phone — VARCHAR(20)
  • email — VARCHAR(200)