Mapdical

Tables (3)

Hospital (병원)

  • hpid — varchar(20) — Primary key — NOT NULL
  • dutyName — varchar(20) — NOT NULL
  • dgidIdName — varchar(20) — NOT NULL
  • dutyAddr (dutyAddt) — varhcar(255) — NOT NULL

Review (리뷰)

  • review_id — INT — Primary key — NOT NULL
  • hpid — varchar(20) — Foreign key → Hospital.hpid — NOT NULL
  • id (id2) — INT — Foreign key → User.id — NOT NULL — AUTO_INCREMENT
  • content — TEXT — NOT NULL
  • rating — TINYINT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

User (회원)

  • id — INT — Primary key — NOT NULL — AUTO_INCREMENT
  • user_id — varchar(20) — NOT NULL
  • user_password — varchar(255) — NOT NULL
  • nickname — varchar(20) — NOT NULL