ㅁ
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