Hospitol
Tables (16)
article
- article_id — PK
- user_id — FK — Foreign key → users.user_id
- article_title — varchar(255)
- article_content — text
- created_at — datetime
- update_at — datetime
article_category
- article_id — FK — Foreign key → article.article_id
- article_category_id — FK — Foreign key → article_category_mst.article_category_id
article_category_mst
- article_category_id — PK
- article_category_name — varchar(255)
article_comment
- article_comment_id — PK
- article_id — FK — Foreign key → article.article_id
- user_id — FK — Foreign key → users.user_id
- article_comment_content — varchar(255)
- created_at — datetime
- update_at — datetime
hospital
- hospital_id — PK
- hospital_name — varchar(255)
- hospital_emergency — integer
- hospital_address — varchar(255)
- hospital_zipcode — integer
- hospital_detail — varchar(255)
- hospital_phone — varchar(255)
- hospital_Latitude — double
- hospital_longitude — double
- created_at — datetime
hospital_category
- hospital_id — FK — Foreign key → hospital.hospital_id
- category_id — FK — Foreign key → hospital_category_mst.category_id
hospital_category_mst
- category_id — FK
- category_name — varchar(255)
hospital_review
- review_id — PK
- hospital_id — FK — Foreign key → hospital.hospital_id
- user_id — FK — Foreign key → users.user_id
- review_content — text
- created_at — datetime
hospital_time
- hospital_id — FK — Foreign key → hospital.hospital_id
- mon — varchar(255)
- tue — varchar(255)
- wen — varchar(255)
- thu — varchar(255)
- fri — varchar(255)
- set — varchar(255)
- sun — varchar(255)
magazine
- magazine_id — PK
- magazine_title — varchar(255)
- magazine_content — text
- created_at — datetime
pharmcy
- pharmcy_id — PK
- pharmcy_name — varchar(255)
- pharmcy_category — varchar(255)
- pharmcy_emergency — integer
- pharmcy_address — varchar(255)
- pharmcy_zipcode — integer
- pharmcy_detail — varchar(255)
- pharmcy_phone — varchar(255)
- pharmcy_Latitude — double
- pharmcy_longitude — double
- created_at — datetime
pharmcy_time
- pharmcy_id — FK — Foreign key → pharmcy.pharmcy_id
- mon — varchar(255)
- tue — varchar(255)
- wen — varchar(255)
- thu — varchar(255)
- fri — varchar(255)
- set — varchar(255)
- sun — varchar(255)
- holiday — varchar(255)
user_detail
- user_id — FK
- user_address — varchar(255)
- user_phone — varchar(255)
- created_at — datetime
user_hospital_appointment
- user_id — FK — Foreign key → users.user_id
- hospital_id — FK — Foreign key → hospital.hospital_id
- appointment_time — datetime
- created_at — datetime
user_hospital_favorites
- user_id — FK — Foreign key → users.user_id
- hospital_id — FK — Foreign key → hospital.hospital_id
- created_at — datetime
users
- user_id — PK — Foreign key → user_detail.user_id
- username — varchar(255)
- nicname — varchar(255)
- gender — integer
- user_year — integer
- role — varchar(255)
- created_at — datetime
- update_at — datetime