HOOHA
Tables (7)
Button_options (button_options)
- btn_option_no — number — Primary key — NOT NULL
- prompt_no — number — Foreign key → Prompts.prompt_no — NOT NULL
- question_no — number — Foreign key → Question_to_ai.question_no — NOT NULL
- button_text — varchar
Prompts (prompts)
- prompt_no — number — Primary key — NOT NULL
- prompt_text — varchar
Question_to_ai (Untitled)
- question_no — number — Primary key — NOT NULL
- question_text — varchar
Response_from_ai (response_from_ai)
- response_no — number — Primary key — NOT NULL
- question_no — number — Foreign key → Question_to_ai.question_no — NOT NULL
- response_text — varchar
Review_options
- review_option_no — number — Primary key — NOT NULL
- option_text — varchar
- is_positive — number
Reviews (reviews)
- review_no — number — Primary key — NOT NULL
- reviewer_id — varchar — Foreign key → Users.user_id — NOT NULL
- selected_option_no — number — Foreign key → Review_options.review_option_no — NOT NULL
- review_date — datetime
Users (users)
- user_id — varchar — Primary key — NOT NULL
- pwd — varchar
- name — varchar
- age — number
- user_type — varchar
- smoke_start — datetime
- no_smoke_start — datetime
- goal — varchar