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