체크리스트

테이블 (4)

checklist

  • ID (Key) — 기본 키 — NOT NULL
  • PUSH_TIME (Field)
  • LIST_TITLE (Field3)

checklist_completion (Untitled3)

  • CHECKLIST_TO_WORKER_ID (Key3) — 외래 키 → checklist_to_worker.ID — NOT NULL
  • ITEM_NUM (Field)
  • ITEM_CHECKED (Field2)

checklist_item (Untitled2)

  • CHECKLIST_ID (Key) — 외래 키 → checklist.ID — NOT NULL
  • ITEM_TITLE (Field)
  • ITEM_NUM (Field2)
  • ITEM_TYPE (Field3)
  • ITEM_DATA (Field4)

checklist_to_worker (Untitled)

  • ID (Key3) — 외래 키 → checklist.ID — NOT NULL
  • CHECKLIST_ID (Key) — 외래 키 → checklist.ID — NOT NULL
  • REG_DATE (Field)
  • EDIT_DATE (Field2)
  • SABUN (Field3)
  • COMPLETION (Field4)