TEST

Tables (7)

CONTENT_SCREEN

  • id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • content_id — INT — NOT NULL
  • popup_menu — INT
  • next_button_count — INT
  • back_button_count — INT
  • done_button_count — INT
  • scroll_count — INT

MAIN_SCREEN

  • id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • content_id — INT
  • access_code — VARCHAR(20)
  • current_screen — VARCHAR(10)
  • update_time — TIMESTAMP

MENU_SCREEN

  • id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • menu_type — VARCHAR(10)
  • scroll_count — INT
  • back_button_count — INT
  • save_button_count — INT
  • next_button_count — INT
  • on_button_selected — BOOLEAN
  • off_button_selected — BOOLEAN

START_SCREEN

  • id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • access_code — VARCHAR(20)
  • auto_login_enabled — BOOLEAN
  • login_time — TIMESTAMP
  • login_in — BOOLEAN

USER

  • id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • access_code — VARCHAR(20) — NOT NULL
  • user_name — VARCHAR(20)
  • created_date — TIMESTAMP
  • field — VARCHAR(255)

USER_ACTION_LOG

  • id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • screen_name — VARCHAR(20)
  • button_name — VARCHAR(20)
  • action_type — VARCHAR(50)
  • from_screen — VARCHAR(20)
  • to_screen — VARCHAR(20)
  • additional_data — TEXT
  • action_time — TIMESTAMP

USER_SCREEN_SESSION

  • id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • screen_name — VARCHAR(20)
  • enter_time — TIMESTAMP
  • exit_time — TIMESTAMP
  • exit_reason — VARCHAR(50)