ㄱㄱㄱㄱ

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