kiaranote

Tables (6)

audit_log

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL — INDEX
  • action_type — VARCHAR(20) — NOT NULL — INDEX
  • action_target — VARCHAR(255) — NOT NULL — INDEX
  • create_dt — DATETIME — NOT NULL

comment

  • id — BIGINT — Primary key — NOT NULL
  • parent_id — BIGINT — Foreign key → comment.id
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • note_id — BIGINT — Foreign key → note.id — NOT NULL
  • content — TEXT — NOT NULL
  • create_dt — DATETIME — NOT NULL
  • update_dt — DATETIME — NOT NULL
  • delete_dt — DATETIME

note

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL — COMPOSITE_INDEX
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • is_private — BOOL — NOT NULL — COMPOSITE_INDEX
  • create_dt — DATETIME — NOT NULL
  • update_dt — DATETIME — NOT NULL
  • delete_dt — DATETIME

note_hierarchy

  • note_id — BIGINT — Foreign key → note.id — NOT NULL — COMPOSITE_UNIQUE
  • parent_note_id — BIGINT — Foreign key → note.id — NOT NULL — COMPOSITE_UNIQUE
  • order — BIGINT — NOT NULL

shared_note

  • id — VARCHAR(12) — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • note_id — BIGINT — Foreign key → note.id — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • create_dt — DATETIME — NOT NULL
  • expire_dt — DATETIME — NOT NULL

user

  • id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(20) — NOT NULL — UNIQUE, INDEX
  • password — VARCHAR(255) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • last_login_dt — DATETIME — NOT NULL
  • create_dt — DATETIME — NOT NULL
  • update_dt — DATETIME — NOT NULL
  • delete_dt — DATETIME — INDEX