humpback

Tables (4)

folder

  • Key (folder_id) — BIGINT — Primary key — NOT NULL
  • Field (name) — VARCHAR(100)

note

  • Key (note_id) — BIGINT — Primary key — NOT NULL
  • Field (title) — VARCHAR(100)
  • Field2 (content) — TEXT
  • Field (created_at) — DATETIME
  • Field (updated_at) — DATETIME
  • Key (user_id) — BIGINT — Foreign key → user.Key — NOT NULL
  • Key (folder_id) — BIGINT — Foreign key → folder.Key — NOT NULL

note_relation

  • Key (note_relation_id) — BIGINT — Primary key — NOT NULL
  • Field (child_note_id) — BIGINT
  • Field (start_offset) — INT
  • Field (end_offset) — INT
  • Key (parent_note_id) — BIGINT — Foreign key → note.Key — NOT NULL

user

  • Key (user_id) — BIGINT — Primary key — NOT NULL
  • Field (email) — VARCHAR(100)