2차

테이블 (6)

Category

  • category_id — INT
  • category_name — VARCHAR(50) — NOT NULL

HealthTips

  • post_id — INT
  • title — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATE — NOT NULL
  • updated_at — DATE — NOT NULL
  • hit — INT — NOT NULL
  • likes — INT — NOT NULL
  • image_file_path — VARCHAR(100)

Hospital

  • category_id — INT — NOT NULL
  • hospital_id — INT
  • hospital_name — VARCHAR(50) — NOT NULL
  • address — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(50)
  • hours — VARCHAR(50)
  • average_rating — FLOAT — NOT NULL
  • female_doctor — BOOLEAN
  • night_care — BOOLEAN
  • weekend_care — BOOLEAN
  • partnership — BOOLEAN
  • favorites — BOOLEAN

Review

  • user_id — INT — NOT NULL
  • hospital_id — INT — NOT NULL
  • review_id — INT
  • created_at — DATE — NOT NULL
  • updated_at — DATE — NOT NULL
  • content — TEXT — NOT NULL
  • rating — FLOAT — NOT NULL
  • photo_review_path — VARCHAR(100)
  • likes — INT — NOT NULL

User

  • user_id — INT
  • user_name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(50)
  • phone_number — VARCHAR(50)
  • birth_date — DATE
  • profile_picture_path — VARCHAR(100)
  • login_state — BOOLEAN — NOT NULL

리뷰 (Commnet)

  • Key — 기본 키 — NOT NULL