movie
Tables (7)
Follow (Untitled6)
- Field (follower_id) — INT (FK)
- Field2 (followee_id) — INT (FK)
- Field3 (created_at) — TIMESTAMP
Movie (Untitled)
- Field (movie_id) — INT(PK)
- Field2 (title) — VARCHAR(255)
- Field3 (poster_url) — VARCHAR(255)
- Field4 (release_date) — DATE
- Field5 (director) — VARCHAR(255)
- Field6 (synopsis) — TEXT
Post (Untitled3)
- Field (post_id) — INT (PK)
- Field2 (user_id) — INT (FK)
- Field3 (movie_id) — INT (FK)
- Field4 (region_id) — INT (FK)
- Field5 (content) — TEXT
- Field6 (created_at) — TIMESTAMP
Region (Untitled2)
- Field (region_id) — INT (PK)
- Field2 (name) — VARCHAR(255)
- Field3 (country) — VARCHAR(255)
- Field4 (latitude) — DECIMAL(9,6)
- Field5 (longitude) — DECIMAL(9,6)
Untitled7
- Field (movie_id) — INT (FK)
- Field2 (region_id) — INT (FK)
- Field
User (Untitled4)
- Field (user_id) — INT (PK)
- Field2 (username) — VARCHAR(255)
- Field3 (email) — VARCHAR(255)
- Field4 (password) — VARCHAR(255)
UserProfile (Untitled5)
- Field (user_id) — INT (FK)
- Field2 (profile_picture_url) — VARCHAR(255)
- Field3 (bio) — TEXT
- Field4 (website) — VARCHAR(255)
- Field5 (location) — VARCHAR(255)