1
Tables (20)
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)
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
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
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
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
Role
- role_id — BIGINT
- role_name — VARCHAR(50)
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)