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