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