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)