checklist
Tables (7)
CATEGORY (Untitled3)
- id (category_id) — BIGINT — Primary key — NOT NULL
- id (chicklist_item_id) — BIGINT — Foreign key → CHECKLIST_ITEM.id — NOT NULL
- name (category_name) — VARCHAR — tag
- description — TEXT
CHECKLIST (Untitled)
- id (checklist_id) — BIGINT — Primary key — NOT NULL
- id (member_id) — BIGINT — Foreign key → MEMBER.id — NOT NULL
- checklist_title — VARCHAR
- is_publlic (checklist_is_publlic) — BOOLEAN
- completion_rate — DECIMAL
CHECKLIST_ITEM (Untitled4)
- id (chicklist_item_id) — BIGINT — Primary key — NOT NULL
- id (checklist_id) — BIGINT — Foreign key → CHECKLIST.id — NOT NULL
- id (template_id) — BIGINT — Foreign key → TEMPLATE.id — NOT NULL
- content — VARCHAR
- is_completed — BOOLEAN
- display_order — TINYINT
- saved_amount — DECIMAL
- is_public (item_is_public) — BOOLEAN
CHECKLIST_ITEM_MEMO (Untitled5)
- id (memo_id) — BIGINT — Primary key — NOT NULL
- id (chicklist_item_id) — BIGINT — Foreign key → CHECKLIST_ITEM.id — NOT NULL
- content — TEXT
CHECKLIST_TYPE (Untitled2)
- id (checklist_type_id) — BIGINT — Primary key — NOT NULL
- id (checklist_id) — BIGINT — Foreign key → CHECKLIST.id — NOT NULL
- type_name — ENUM — DAILY/WEEKLY/MONTHLY
- reset_period
MEMBER (Untitled7)
- id (member_id) — BIGINT — Primary key — NOT NULL
TEMPLATE (Untitled6)
- id (template_id) — BIGINT — Primary key — NOT NULL
- id (member_id) — BIGINT — Foreign key → MEMBER.id — NOT NULL
- title (template_title) — VARCHAR
- is_public — BOOLEAN
- usage_count — INT