Database - remaley5/queerhealth GitHub Wiki

User Profile:

• email - not accessible to anyone
• password
• username
• pronouns
• gender
• race / ethnicity
• sexuality
• relationship preference
• location (optional)
• optional (stretch) - open to messages

User__provider:

• User_id
• Provider_id

Health Care Provider:

• Title
• First Name
• Last Name
• Location
• Specialty
• Reviews

(join table) Review__tags:

• Tag_id
• Review_id
• Boolean good/ bad

Tags:

• id
• word
• related words

Comments:

• Good text
• Bad text
• Rating
• Tags

Provider__specialties:

• Provider
• Specialty

Specialties:

• Name

Provider__services:

• Provider
• Services

Services:

• Name