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

Notification

    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)

    Reviews

      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)