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)