To Do List

Tables (4)

Card (card)

  • Card ID (id) — INT — Primary key — NOT NULL
  • User ID (user_id) — INT — Foreign key → User.User ID — NOT NULL
  • Image (card_img) — ImageField
  • Title (card_title) — CharField
  • Plain Text (card_text) — TextField
  • Created at (created_at) — DateTimeField
  • Updated at (updated_at) — DateTimeField

Check List (Untitled)

  • Check List ID (id) — INT — Primary key — NOT NULL
  • Card ID (card_id) — INT — Foreign key → Card.Card ID — NOT NULL
  • User ID (user_id) — INT — Foreign key → Card.User ID — NOT NULL
  • Content (checklist_content) — CharField
  • Completed (checklist_completed) — Boolean

Label (Untitled2)

  • Label ID (id) — INT — Primary key — NOT NULL
  • Label Name (label_name) — CharField
  • Label Color (label_color) — INT

User

  • User ID (id) — INT — Primary key — NOT NULL