running_crew

Tables (9)

Untitled (feeds)

  • Key (feed_id) — Primary key — NOT NULL
  • Field (content)
  • Field2 (created_at)
  • Field3 (updated_at)
  • Field4 (deleted_at)
  • Key (member_id) — Foreign key → Untitled4.Key — NOT NULL
  • Key (running_log_id) — Foreign key → Untitled.Key — NOT NULL

Untitled (followings)

  • Key (follower_id) — Foreign key → Untitled4.Key — NOT NULL
  • Key (following_id) — Foreign key → Untitled4.Key — NOT NULL
  • Field4 (created_at)

Untitled (running_logs)

  • Key (running_log_id) — Primary key — NOT NULL
  • Key (member_id) — Foreign key → Untitled4.Key — NOT NULL
  • Field (title)
  • Field2 (file_url)
  • Field (distance)
  • Field (time_record)
  • Field3 (created_at)
  • Field4 (updated_at)

Untitled (feed_files)

  • Key (feed_file_id) — Primary key — NOT NULL
  • Field2 (file_url)
  • Field3 (created_at)
  • Field4 (updated_at)
  • Field (deleted_at)
  • Key (feed_id) — Foreign key → Untitled.Key — NOT NULL

Untitled2 (running_crews)

  • Key (running_crew_id) — Primary key — NOT NULL
  • Field (name)
  • Field2 (thumbnail_url)
  • Field3 (description)
  • Field4 (regions)
  • Field (status)
  • Field (created_at)
  • Field (updated_at)
  • Field (deleted_at)

Untitled3 (schedules)

  • Key (schedule_id) — Primary key — NOT NULL
  • Field (type)
  • Field2 (start_time)
  • Field3 (end_time)
  • Field4 (is_private)
  • Field (status)
  • Field (created_at)
  • Field (updated_at)
  • Field (deleted_at)

Untitled4 (members)

  • Key (member_id) — Primary key — NOT NULL
  • Field (name)
  • Field2 (nickname)
  • Field3 (email)
  • Field4 (password)
  • Field (thumbnail_url)
  • Field (gender)
  • Field (description)
  • Field (phone_num)
  • Field (status)
  • Field (is_private)
  • Field (created_at)
  • Field (updated_at)
  • Field (deleted_at)

Untitled5 (my_running_crews)

  • Key (member_id) — Foreign key → Untitled4.Key — NOT NULL
  • Key (running_crew_id) — Foreign key → Untitled2.Key — NOT NULL
  • Field (role)
  • Field (status)
  • Field (created_at)
  • Field2 (updated_at)
  • Field3 (deleted_at)

Untitled6 (my_schedules)

  • Key (member_id) — Foreign key → Untitled4.Key — NOT NULL
  • Key (schedule_id) — Foreign key → Untitled3.Key — NOT NULL
  • Field (status)
  • Field (created_at)
  • Field2 (updated_at)