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