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