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