profile_photo_url
varchar
is_accepting_clients
bool
includes_live_sessions
bool
payment_methods
payment_methods
Documentation for project Fitness Influencer
Report
Generated
4/9/2026 | 4:05:03 PM
tables
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
first_name
varchar
last_name
varchar
email
varchar
phone
varchar
password_hash
varchar
role
varchar
instagram_handle
varchar
profile_photo_url
varchar
created_at
timestamp
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
user_id
uuid
bio
text
specializations
varchar
certifications
varchar
experience_years
varchar
is_accepting_clients
bool
Keys
TRAINER_PROFILE_pkey
Column in TRAINER_PROFILE_pkey
id
TRAINER_PROFILE_key
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
user_id
uuid
assigned_trainer_id
uuid
date_of_birth
date
gender
date
Keys
CLIENT_PROFILE_pkey
Column in CLIENT_PROFILE_pkey
id
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
trainer_id
uuid
title
varchar
description
text
plan_type
duration_weeks
integer
price
double precision
includes_diet
bool
includes_workout
bool
includes_live_sessions
bool
is_active
bool
Keys
COACHING_PLAN_pkey
Column in COACHING_PLAN_pkey
id
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
client_id
uuid
plan_id
uuid
trainer_id
uuid
start_date
timestamp
end_date
timestamp
status
timestamp
enrolled_at
timestamp
Keys
SUBSCRIPTION_pkey
Column in SUBSCRIPTION_pkey
id
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
trainer_id
uuid
client_id
uuid
subscription_id
uuid
session_type
varchar
platform_link
varchar
scheduled_at
timestamp
duration_minutes
integer
status
trainer_notes
text
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
client_id
uuid
subscription_id
uuid
week_number
integer
weight_kg
float8
energy_level
varchar
sleep_quality
varchar
adherence_rating
varchar
client_notes
text
submitted_at
timestamp
Keys
CHECK_IN_pkey
Column in CHECK_IN_pkey
id
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
client_id
uuid
subscription_id
uuid
weight_kg
float8
body_fat_pct
float8
chest_cm
float8
waist_cm
float8
hips_cm
float8
photo_url
varchar
recorded_on
timestamp
Keys
PROGRESS_RECORD_pkey
Column in PROGRESS_RECORD_pkey
id
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
subscription_id
uuid
client_id
uuid
amount
float8
payment_methods
status
transaction_ref
varchar
paid_at
timestamp
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
checkin_id
uuid
trainer_id
uuid
feedback_text
text
workout_adjustment
text
diet_adjustment
text
given_at
timestamp
Keys
TRAINER_FEEDBACK_pkey
Column in TRAINER_FEEDBACK_pkey
id
relationships
Name
TRAINER_PROFILE_user_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in USER
Column in TRAINER_PROFILE
USER_pkey
id
user_id
Name
CLIENT_PROFILE_user_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in USER
Column in CLIENT_PROFILE
USER_pkey
id
user_id
Name
COACHING_PLAN_trainer_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in TRAINER_PROFILE
Column in COACHING_PLAN
TRAINER_PROFILE_pkey
id
trainer_id
Name
SUBSCRIPTION_plan_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in COACHING_PLAN
Column in SUBSCRIPTION
COACHING_PLAN_pkey
id
plan_id
Name
SUBSCRIPTION_trainer_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in TRAINER_PROFILE
Column in SUBSCRIPTION
TRAINER_PROFILE_pkey
id
trainer_id
Name
SUBSCRIPTION_client_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in CLIENT_PROFILE
Column in SUBSCRIPTION
CLIENT_PROFILE_pkey
id
client_id
Name
SESSION_trainer_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in TRAINER_PROFILE
Column in SESSION
TRAINER_PROFILE_pkey
id
trainer_id
Name
SESSION_client_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in CLIENT_PROFILE
Column in SESSION
CLIENT_PROFILE_pkey
id
client_id
Name
SESSION_subscription_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in SUBSCRIPTION
Column in SESSION
SUBSCRIPTION_pkey
id
subscription_id
Name
CLIENT_PROFILE_assigned_trainer_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in TRAINER_PROFILE
Column in CLIENT_PROFILE
TRAINER_PROFILE_pkey
id
assigned_trainer_id
Name
CHECK_IN_subscription_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in SUBSCRIPTION
Column in CHECK_IN
SUBSCRIPTION_pkey
id
subscription_id
Name
CHECK_IN_client_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in CLIENT_PROFILE
Column in CHECK_IN
CLIENT_PROFILE_pkey
id
client_id
Name
PROGRESS_RECORD_client_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in CLIENT_PROFILE
Column in PROGRESS_RECORD
CLIENT_PROFILE_pkey
id
client_id
Name
PROGRESS_RECORD_subscription_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in SUBSCRIPTION
Column in PROGRESS_RECORD
SUBSCRIPTION_pkey
id
subscription_id
Name
TRAINER_FEEDBACK_checkin_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in CHECK_IN
Column in TRAINER_FEEDBACK
CHECK_IN_pkey
id
checkin_id
Name
TRAINER_FEEDBACK_trainer_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in TRAINER_PROFILE
Column in TRAINER_FEEDBACK
TRAINER_PROFILE_pkey
id
trainer_id
Name
PAYMENT_subscription_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in SUBSCRIPTION
Column in PAYMENT
SUBSCRIPTION_pkey
id
subscription_id
Name
PAYMENT_client_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in CLIENT_PROFILE
Column in PAYMENT
CLIENT_PROFILE_pkey
id
client_id
Lines
Line name
plan_type-plan_type
Line name
payment_methods-payment_methods
