cloud
Tables (4)
note_summary
- id (note_summary id) — BIGINT — Primary key — NOT NULL
- note_id (note id) — BIGINT — Foreign key → notes.id — NOT NULL
- summary — TEXT
- keywords — TEXT
- created_at — DATETIME
notes
- id (note id) — BIGINT — Primary key — NOT NULL
- user_id (user id) — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(100)
- subject — VARCHAR(50)
- content — TEXT
- created_at — DATETIME
- updated_at — DATETIME
todos
- id (todo id) — BIGINT — Primary key — NOT NULL
- user_id (user id) — BIGINT — Foreign key → users.id — NOT NULL
- note_id (note id) — BIGINT — Foreign key → notes.id — NOT NULL
- content — VARCHAR(255)
- due_date — DATETIME
- priority — INT
- is_done — TINYINT
- created_at — DATETIME
users
- id (user id) — BIGINT — Primary key — NOT NULL
- username — VARCHAR(50)
- password — VARCHAR(255)
- name — VARCHAR(50)
- created_at — DATETIME