todolist

Tables (3)

Task (Untitled2)

  • TodoSheetId (Foriegin Key) — VARCHAR(20) — Primary key — NOT NULL
  • dueDatetime (Field) — DATETIME
  • text (Field2) — VARCHAR(200)
  • completed (Field3) — BOOLEAN
  • id (Primary Key) — VARCHAR(40) — Foreign key → TodoSheet.id — NOT NULL
  • username (foriegin key) — VARCHAR(10) — Foreign key → TodoSheet.username — NOT NULL

TodoSheet (Untitled)

  • id (Primary Key) — VARCHAR(40) — Primary key — NOT NULL
  • username (foriegin key) — VARCHAR(10) — Primary key — NOT NULL
  • date (Field) — DATE

User

  • username (PrimaryKey) — VARCHAR(10) — Primary key — NOT NULL
  • password (Field) — VARCHAR(20)