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)