Oops

Tables (4)

community_posts

  • id — BIGINT
  • author_id — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — VARCHAR(2000) — NOT NULL
  • image_url — VARCHAR(300)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

foot_measurements

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • left_foot_length — DOUBLE — NOT NULL
  • right_foot_length — DOUBLE — NOT NULL
  • left_foot_width — DOUBLE — NOT NULL
  • right_foot_width — DOUBLE — NOT NULL
  • left_foot_height — DOUBLE — NOT NULL
  • right_foot_height — DOUBLE — NOT NULL
  • left_arch_height — DOUBLE
  • right_arch_height — DOUBLE
  • foot_type — VARCHAR(50)
  • measurement_method — VARCHAR(100)
  • notes — TEXT
  • measured_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

running_records

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • distance_km — DOUBLE — NOT NULL
  • duration_seconds — BIGINT — NOT NULL
  • terrain_type — VARCHAR(100) — NOT NULL
  • proof_image_url — VARCHAR(300)
  • recorded_at — TIMESTAMP
  • created_at — TIMESTAMP

users

  • id — BIGINT — Primary key
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(100)
  • profile_image — VARCHAR(500)
  • bio — VARCHAR(200)
  • gender — VARCHAR(10)
  • age — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP