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