DoctorWait
Tables (11)
ActivityRecommendation (activity_recommendation)
- id — BIGSERIAL — Primary key
- user_id — BIGINT
- category — VARCHAR(50)
- place_name — VARCHAR(100)
- address — VARCHAR(255)
- latitude — DOUBLE PRECISION
- longitude — DOUBLE PRECISION
- estimated_time — INTEGER
- distance — DOUBLE PRECISION
- rating — DOUBLE
FamilyGroup
- id — BIGSERIAL — Primary key
- name — VARCHAR(100)
FamilyMember
- id — BIGSERIAL — Primary key
- user_id — BIGINT
- family_group_id — BIGINT
- role — VARCHAR(20)
- confirmed — BOOLEAN
Hospital
- id — BIGINT — Primary key
- name — VARCHAR(255)
- department — VARCHAR(255)
- address — VARCHAR(255)
- latitude — DOUBLE PRECISION
- longitude — DOUBLE PRECISION
- waiting (Field) — BIGINT
- rating (Field2) — DOUBLE
Membership (membership)
- user_id — BIGINT
- plan — VARCHAR(20)
- start_date — DATE
- end_date — DATE
Reservation
- id — BIGINT — Primary key
- user_id — BIGINT
- hospital_id — BIGINT
- reservation_time — TIMESTAMP
- symptom — VARCHAR(255)
- is_completed — BOOLEAN
- first_visit (Field) — BOOLEAN
- message (Field2) — VARCHAR(1000)
Symptoms
- name — VARCHAR(225)
- Hospital_department — VARCHAR(225)
User
- id — BIGINT — Primary key
- username — VARCHAR(50)
- login_id — VARHCAR(50)
- login_password — VARCHAR(255)
- role — VARCHAR(50)
- email — VARCHAR(320)
- phone_number — VARCHAR(20)
- id (id2) — BIGINT — Foreign key → UserProfile.id
UserProfile
- id (id2) — BIGINT — Foreign key → User.id
- user_id — BIGINT
- resident_registration_number — VARCHAR(20)
- current_address (current-address) — VARCHAR(255)
- latitude — DOUBLE PRECISION
- longitude — DOUBLE PRECISION
- profile_image_url (Field) — VARCHAR(255)
- payment — VARCHAR(255)