ㄱㄱㄱㄱ
Tables (13)
ContentSections
- section_id — bigint(20) — Primary key — NOT NULL
- section_type — ENUM_SECTION_TYPE — NOT NULL
- title — varchar(200) — NOT NULL
- content — text — NOT NULL
- image_url — varchar(255)
- display_order — int
- is_active — boolean — NOT NULL
- created_at — datetime(12) — NOT NULL
- updated_at — datetime(12) — NOT NULL
ExpertAnsers
- ansserID — bigint(20) — Primary key — NOT NULL
- symptomID — bigint(20) — NOT NULL
- summary — text — NOT NULL
- fullContent — text — NOT NULL
- sourceUrl — varchar(255) — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
HospitalSymptoms
- symptomID — bigint(20) — NOT NULL
- hospitalID — bigint(20) — NOT NULL
Hospitals
- hospitalID — bigint(20) — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- address — varchar(255) — NOT NULL
- latitude — decimal — NOT NULL
- longitude — decimal — NOT NULL
- phone — varchar(20)
- specialty — varchar(100)
- homepageUrl — varchar(255)
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
LifestyleVideos
- videoID — bigint(20) — Primary key — NOT NULL
- symptomID — bigint(20) — NOT NULL
- description — text — NOT NULL
- title — varchar(200) — NOT NULL
- youtube_url — varchar(255) — NOT NULL
- thumbnail_url — varchar(255) — NOT NULL
- display_order — int — NOT NULL
- is_active — boolean — NOT NULL
- created_at — datetime(12) — NOT NULL
- updated_at — datetime(12) — NOT NULL
PainAreas
- painAreaID — bigint(20) — Primary key — NOT NULL
- name — varchar(50) — NOT NULL — UNIQUE
SymptomSteps
- stepID — bigint(20) — Primary key — NOT NULL
- symptomID — bigint(20) — NOT NULL
- step_number — int — NOT NULL
- title — varchar(200) — NOT NULL
- content — text — NOT NULL
- image_url — varchar(255) — NOT NULL
- created_at — datetime(12) — NOT NULL
- updated_at — datetime(12) — NOT NULL
Symptoms
- symptomID — bigint(20) — Primary key — NOT NULL
- painAreaID — bigint(20) — NOT NULL
- name — varchar(100) — NOT NULL
TemporaryCareGuides
- guideID — bigint(20) — Primary key — NOT NULL
- symptomID — bigint(20) — NOT NULL
- guide_type — ENUM_GUIDE_TYPE — NOT NULL
- title — varchar(200) — NOT NULL
- content — text — NOT NULL
- image_url — varchar(255) — NOT NULL
- display_order — int
- created_at — datetime(12) — NOT NULL
- updated_at — datetime(12) — NOT NULL
UsageGuides
- guide_id — bigint(20) — Primary key — NOT NULL
- card_number — int — NOT NULL
- title — varchar(200) — NOT NULL
- modal_content — text — NOT NULL
- image__url — varchar(255)
- display_order — int
- is_active — boolean — NOT NULL
- created_at — datetime(12) — NOT NULL
- updated_at — datetime(12) — NOT NULL
UserPainAreas
- user_ID — bigint(20) — NOT NULL
- painAreaID — bigint(20) — NOT NULL
UserSymptoms
- user_ID — bigint(20) — NOT NULL
- symptomID — bigint(20) — NOT NULL
Users
- user_ID — bigint(20) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
- email — varchar(100) — NOT NULL — UNIQUE
- password — varchar(100) — NOT NULL
- birth — datetime — NOT NULL
- gender — ENUM_GENDER — NOT NULL
- created_at — datetime(12) — NOT NULL
- updated_at — datetime(12) — NOT NULL
- deleted_at — datetime(12) — NOT NULL