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