ㅁ

Tables (6)

app_users

  • id — bigint(20) — Primary key — NOT NULL
  • login_id — varchar(30) — NOT NULL
  • password — varchar(100) — NOT NULL
  • name — varchar(50) — NOT NULL
  • email — varchar(254) — NOT NULL
  • birthdate — date — NOT NULL
  • gender — enum('F','M','N') — NOT NULL
  • created_at — datetime(6) — NOT NULL

cancers

  • cancer_id — int(11) — Primary key — NOT NULL
  • cancer_name — varchar(255) — NOT NULL
  • description — text
  • symptoms — text

chat_messages

  • message_id — int(11) — Primary key — NOT NULL
  • diagnosis_id — int(11) — NOT NULL
  • login_id — varchar(30) — NOT NULL
  • message_text — text — NOT NULL
  • sender — enum('user','chatbot') — NOT NULL
  • created_at — datetime — NOT NULL

diagnoses

  • diagnosis_id — int(11) — Primary key — NOT NULL
  • login_id — varchar(30) — NOT NULL
  • cancer_id — int(11) — NOT NULL
  • image_url — varchar(255)
  • certainty_score — float
  • diagnosed_at — datetime — NOT NULL

email_verification_codes

  • id — bigint(20) — Primary key — NOT NULL
  • email — varchar(254) — NOT NULL
  • code — varchar(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • expires_at — datetime(6) — NOT NULL
  • attempt_count — int(11) — NOT NULL

health_news

  • article_id — bigint(20) — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL
  • original_link — text — NOT NULL
  • link — text — NOT NULL
  • description — text — NOT NULL
  • pub_date — datetime — NOT NULL
  • created_at — datetime — NOT NULL