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)