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