S-Feed back
Tables (17)
Untitled (customer_interest)
- Key (customer_interest_id) — Primary key — NOT NULL
- Key (customer_id) — Foreign key → customer.Key — NOT NULL
- Field (name)
Untitled (inquiry_image)
- Key (inquiry_image_id) — Primary key — NOT NULL
- Key (inquiry_id) — Foreign key → Untitled.Key — NOT NULL
- Field (image_url)
Untitled (inquiry)
- Key (inquiry_id) — Primary key — NOT NULL
- Field (type) — enum
- Field2 (title)
- Field3 (content)
Untitled (feedback_price)
- Key — Primary key — NOT NULL
- Field (feedback_type)
- Field (price)
- Key (trainer_id) — Foreign key → trainer.Key — NOT NULL
Untitled (trainer_intro)
- Key — Primary key — NOT NULL
- Key (trainer_id) — Foreign key → trainer.Key — NOT NULL
Untitled (career)
- Key (career_id) — Primary key — NOT NULL
- Key (certificate_id) — Foreign key → certificate.Key — NOT NULL
- Field (start_date)
- Field2 (end_date) — nullable
- Field3 (description)
- Field (title)
Untitled (customer_profile_image)
- Key (customer_profile_image_id) — Primary key — NOT NULL
- Key (customer_id) — Foreign key → customer.Key — NOT NULL
- Field (image_url)
Untitled (trainer_profile_image)
- Key (trainer_profile_image_id) — Primary key — NOT NULL
- Key (trainer_id) — Foreign key → trainer.Key — NOT NULL
- Field (image_url)
Untitled (workout_weight)
- Key (workout_weight_id) — Primary key — NOT NULL
- Field (name)
- Field (weight)
- Key (trainer_id) — Foreign key → trainer.Key — NOT NULL
Untitled (feedback)
- Key (feedback_id) — Primary key — NOT NULL
- Field (video_url)
- Key (sender_id) — Foreign key → trainer.Key — NOT NULL
- Key (receiver_id) — Foreign key → customer.Key — NOT NULL
Untitled (feedback_request)
- Key (feedback_request_id) — Primary key — NOT NULL
- Field (video_url)
- Key (sender_id) — Foreign key → customer.Key — NOT NULL
- Key (receiver_id) — Foreign key → trainer.Key — NOT NULL
- Field (title)
- Field2 (content)
certificate
- Key (certificate_id) — Primary key — NOT NULL
- Key (trainer_id) — Foreign key → trainer.Key — NOT NULL
- Field (name)
- Field (picture_url)
chat_room (room)
- Key (room_id) — Primary key — NOT NULL
- Key (sender_id) — Foreign key → user.Key — NOT NULL
- Key (receiver_id) — Foreign key → user.Key — NOT NULL
customer
- Key (customer_id) — Primary key — NOT NULL
- Key (user_id) — Foreign key → user.Key — NOT NULL
- Field
message
- Key (message_id) — Primary key — NOT NULL
- Key (room_id) — Foreign key → chat_room.Key — NOT NULL
- Field (text)
- Field2 (is_read) — bool
- Key (sender_id) — Foreign key → user.Key — NOT NULL
- Key (receiver_id) — Foreign key → user.Key — NOT NULL
trainer
- Key (trainer_id) — Primary key — NOT NULL
- Key (user_id) — Foreign key → user.Key — NOT NULL
user
- Key (user_id) — Primary key — NOT NULL
- username (email)
- social_type
- role