Data Types

This section describes the data types and fields in the database of the template

The budget amount for the job, either as a total for a Fixed Price or an hourly rate for an Hourly Rate.See Bubble manual information when working with data: https://manual.bubble.io/help-guides/working-with-data & https://manual.bubble.io/core-resources/data.

Data Types

User

Field	Type	Notes
Address	Geographic address	Location of the user
Company Description	Text	Short summary of freelancer’s company
Company Employees	Number	Number of employees in client's company.
Company Industry	Text	Industry in which Client's company operates.
Company Name	Text	Name of client's company.
First Name	Text	User's first name
Freelancer Bio	Text	Short description of freelancer
Freelancer Category	Category	Field of expertise of freelancer.
Freelancer Hourly Rate	Number	Freelancer’s hourly rate in currency.
Freelancer Rating	Number	Numerical rating for Freelancer based on reviews.
Freelancer Registration	yes/no	Indicates if Freelancer is registered.
Freelancer Skills	List of Skills	List of skills freelancer has.
Freelancer Title	Text	Job title of freelancer.
Last Name	Text	User's last name
Phone	Number	User's phone number
Picture	Image	User's profile picture
Role	Text	User's role (client or freelancer)
Saved Jobs	List of Jobs	List of jobs user has saved.
Website	Text	Client's personal or company website.
Modified Date	Date	Built-in field
Created Date	Date	Built-in field
Slug	Text	Built-in field
email	Text	Built-in field

Category

Field	Type	Notes
Name	Text	Category's name
Creator	User	Built-in field
Modified Date	Date	Built-in field
Created Date	Date	Built-in field
Slug	Text	Built-in field

Skill

Field	Type	Notes
Name	Text	Skill's name
Creator	User	Built-in field
Modified Date	Date	Built-in field
Created Date	Date	Built-in field
Slug	Text	Built-in field

Language

Field	Type	Notes
Language	Text	Language's name
Proficiency	Text	Proficiency level ('Basic', 'Conversational', 'Fluent', 'Native or Bilingual')
Creator	User	Built-in field
Modified Date	Date	Built-in field
Created Date	Date	Built-in field
Slug	Text	Built-in field

Work Experience

Field	Type	Notes
Company	Text	Language's name
Currently working	yes/no	If yes, no End Date necessary
Description	Text	Description of the work experience
Start Date	Date	Date work experience began
End Date	Date	Date work experience ended
Location	Geographic address	Location of the work experience
Title	Text	Name of the position/job/activity
Creator	User	Built-in field
Modified Date	Date	Built-in field
Created Date	Date	Built-in field
Slug	Text	Built-in field

Education History

Field	Type	Notes
Degree	Text	Name of the degree
Description	Text	Description of the degree/courses
Start Date	Date	Date education began
End Date	Date	Date education ended
Field of Study	Text	Description of the field of study
School	Text	Name of the school/university
Creator	User	Built-in field
Modified Date	Date	Built-in field
Created Date	Date	Built-in field
Slug	Text	Built-in field

Job

Field	Type	Notes
Budget	Number	Nudget amount for the job, either as a total for a Fixed Price or an hourly rate for an Hourly Rate.
Budget Type	Text	Type of Budget ('Hourly' or 'Fixed')
Category	Category	Job's category
Description	Text	Description of the Job
Duration	Text	Duration of the Job ('Less than 1 month', '1 to 3 months', '3 to 6 months')
Start Date	Date	Date the Freelancer begins working
End Date	Date	Date the Job is marked as Completed
Experience Level	Text	Experience required for this Job ('Entry-level', 'Intermediate', 'Expert')
Freelancer	User	Freelancer assigned to the job. This field is empty when the job status is "Pending."
Name	Text	Name of the Job
Paid	yes/no	Indicates if the Client has paid the Freelancer for this Job
Paid Amount	Number	Amount paid by the Client for this Job
Paid Date	Date	Date the payment was made
Paid Hourly Rate	Number	Hourly rate used to calculate payment when the job's budget type is 'Hourly'
Paid Hours	Number	Total number of hours for which payment was mad
Posted	yes/no	Indicates if the Job has been posted.
Rating	Number	The client's rating of the job, from 0 to 5, given after completion
Review	Text	Feedback or review of the job provided by the client after completion
Skills	List of Skills	List of Skills required for this Job
Status	Text	Status of the Job ('Pending', 'Active', 'Completed')
Creator	User	Built-in field
Modified Date	Date	Built-in field
Created Date	Date	Built-in field
Slug	Text	Built-in field

Proposals

Field	Type	Notes
Freelancer	User	Freelancer to whom the client sent an offer for this job
Job	Job	Job associated with this proposal/offer
Status	Text	Current status of the Proposal ('Pending' when created by freelancer, 'Offer' when created by client, 'Accepted', 'Rejected')
Creator	User	Built-in field
Modified Date	Date	Built-in field
Created Date	Date	Built-in field
Slug	Text	Built-in field

Conversation

Field	Type	Notes
Members	List of Users	Users involved in the conversation
Creator	User	Built-in field
Modified Date	Date	Built-in field
Created Date	Date	Built-in field
Slug	Text	Built-in field

Messages

Field	Type	Notes
Content	Text	Content of the Message
Conversation	Conversation	Conversation to which this message is connected
Creator	User	Built-in field
Modified Date	Date	Built-in field
Created Date	Date	Built-in field
Slug	Text	Built-in field

Platform Fee

Field	Type	Notes
Fee	Number	Fee set by the app owner
Creator	User	Built-in field
Modified Date	Date	Built-in field
Created Date	Date	Built-in field
Slug	Text	Built-in field