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)