CheckMate

Tables (10)

category

  • category_id (카테고리 id) — PK — Primary key — NOT NULL
  • name — NOT NULL

checklist_image

  • checklist_image_id (체크리스트 이미지 id) — PK — Primary key — NOT NULL
  • checklist_id (체크리스트 id) — FK — Foreign key — NOT NULL
  • image_id — UUID — NOT NULL
  • created_at — TIMESTAMP

checklist_result

  • checklist_result_id (체크리스트 결과 id) — PK — Primary key — NOT NULL
  • checklist_id (체크리스트 id) — FK — Foreign key — NOT NULL
  • template_item_id (템플릿아이템 id) — FK — Foreign key → template_item.template_item_id — NOT NULL
  • value
  • comment — EX
  • created_at
  • updated_at

conversion_task

  • conversion_task_id (Key) — PK — Primary key — NOT NULL
  • user_id (유저 ID) — FK — Foreign key → user.user_id — NOT NULL
  • file_id (파일 id) — FK — Foreign key → file.file_id — NOT NULL
  • status — NOT NULL
  • progress
  • result
  • error
  • started_at
  • completed_at
  • Field

file

  • file_id (파일 id) — PK — Primary key — NOT NULL
  • user_id (유저 ID) — FK — Foreign key → user.user_id — NOT NULL
  • file_name — NOT NULL
  • original_name — NOT NULL
  • file_type — NOT NULL
  • file_size — NOT NULL
  • mime_type — NOT NULL
  • path — NOT NULL
  • url — NOT NULL
  • description
  • uploaded_at
  • Field

notification

  • notification_id (알림 id) — PK — Primary key — NOT NULL
  • user_id (유저 ID) — PK — Foreign key → user.user_id — NOT NULL
  • title — NOT NULL
  • message — NOT NULL
  • type — NOT NULL
  • is_read
  • created_at
  • Field

template

  • template_id (템플릿 id) — PK — Primary key — NOT NULL
  • user_id (유저 ID) — FK — Foreign key → user.user_id — NOT NULL
  • title — NOT NULL
  • description
  • category — NOT NULL
  • is_official
  • created_at
  • updated_at

template_category

  • template_category_id (템플릿 카테고리 ID) — PK — Primary key — NOT NULL
  • template_id (템플릿 id) — FK — Foreign key → template.template_id — NOT NULL
  • category_id (카테고리 id) — FK — Foreign key → category.category_id — NOT NULL
  • created_at (생성시간) — TIMESTAMP

template_item

  • template_item_id (템플릿아이템 id) — PK — Primary key — NOT NULL
  • template_id (템플릿 id) — FK — Foreign key → template.template_id — NOT NULL
  • title — NOT NULL
  • description
  • type — NOT NULL
  • required
  • options
  • order — NOT NULL
  • created_at

user

  • user_id (유저 ID) — PK — Primary key — NOT NULL
  • name — NOT NULL
  • email — NOT NULL
  • password_hash
  • company
  • department
  • position
  • profile_image
  • is_active — ('ACTIVE', 'DELETE')
  • auth_provider — NOT NULL
  • created_at