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