test
Tables (10)
Actor
- id — SERIAL
- name — VARCHAR(100) — NOT NULL
AuthToken
- id — SERIAL
- user_id — INTEGER — NOT NULL
- token — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
Comment
- id — SERIAL
- post_id — INTEGER — NOT NULL
- user_id — INTEGER — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
Diary
- id — SERIAL
- user_id — INTEGER — NOT NULL
- date — DATE — NOT NULL
- mood_emoji — VARCHAR(10)
- content — TEXT
- movie_id — INTEGER
Follow
- id — SERIAL
- follower_id — INTEGER — NOT NULL
- following_id — INTEGER — NOT NULL
- created_at — TIMESTAMP
Like
- id — SERIAL
- user_id — INTEGER — NOT NULL
- post_id — INTEGER — NOT NULL
- created_at — TIMESTAMP
Movie
- id — SERIAL
- title — VARCHAR(255) — NOT NULL
- director — VARCHAR(100)
- genre — VARCHAR(100)
- release_date — DATE
- runtime — INTEGER
- poster_path — VARCHAR(255)
- overview — TEXT
- rating — FLOAT
- production_country — VARCHAR(100)
MovieActor
- id — SERIAL
- movie_id — INTEGER — NOT NULL
- actor_id — INTEGER — NOT NULL
Post
- id — SERIAL
- user_id — INTEGER — NOT NULL
- movie_id — INTEGER
- title — VARCHAR(255)
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- likes_count — INTEGER
- rating — INTEGER
- post_id — INTEGER
User
- id — SERIAL
- name — VARCHAR(100) — NOT NULL
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- phone_number — VARCHAR(15)
- email — VARCHAR(100) — NOT NULL
- address — VARCHAR(255)
- profile_image — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- stone — INTEGER