Stride_plus
Tables (4)
post_comments
- id — INT
- post_id — INT — NOT NULL
- user_id — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
post_likes
- id — INT
- post_id — INT — NOT NULL
- user_id — INT — NOT NULL
- created_at — DATETIME
- UNIQUE(post_id, — user_id)
posts
- id — INT
- user_id — INT — NOT NULL
- title — VARCHAR(100)
- image_url — VARCHAR(255)
- distance_km — DECIMAL(5,2)
- time_minutes — INT
- description — TEXT
- created_at — DATETIME
- lat — DOUBLE
- lng — DOUBLE
users
- id — INT
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- profile_image — VARCHAR(255)
- created_at — DATETIME