Event History
Tables (5)
DisplayHistory
- display_id — LONG — Primary key — NOT NULL
- user_id — LONG — Foreign key → User.user_id — NOT NULL
- displayName (screen_type) — ENUM('login', 'main', 'menu1', 'menu2_detail', 'content1', ...)
- createdAt — DATETIME
EventHistory
- event_id — LONG — Primary key — NOT NULL
- display_id — LONG — Foreign key → DisplayHistory.display_id — NOT NULL
- user_id — LONG — Foreign key → User.user_id — NOT NULL
- eventType — ENUM("scroll", "click", "save", "toggle")
- value (value_int) — INT
- Field (value_text) — VARCHAR(255)
- Field (value_bool) — BOOLEAN (1=ON/0=OFF)
- createdAt — DATETIME
LoginHistory
- login_id — LONG — Primary key — NOT NULL
- user_id — LONG — Foreign key → User.user_id — NOT NULL
- Field (createdAt) — DATETIME
MoveHistory
- move_id — LONG — Primary key — NOT NULL
- user_id — LONG — Foreign key → User.user_id — NOT NULL
- prevDisplay — ENUM("login", "main", "menu1", "content",...)
- nextDisplay — ENUM("login", "main", "menu1", "content"...)
- Field (navigation_type) — ENUM("push", "pop", "navigate")
- createdAt — DATETIME
User
- user_id — LONG — Primary key — NOT NULL
- name — VARCHAR(255)
- Field (password)
- Field (gender) — ENUM("male", "female", "unknown")
- Field (birth) — DATE
- Field (state) — ENUM("avtive", "inactive")
- Field (createdAt) — DATETIME
- event_id — LONG — Foreign key → EventHistory.event_id — NOT NULL