gachaerd
Tables (8)
article (Untitled5)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → user.Key — NOT NULL
- Key (Key4) — Foreign key → comment.Key — NOT NULL
- Key (Key6) — Foreign key → user.Key — NOT NULL
- Key (Key7) — Foreign key → user.Key — NOT NULL
- title (Field)
- content (Field2)
- created_at (Field3)
- is_vs (Field4)
- movie1 (Field5)
- movie2 (Field6)
- like_users (Field7)
- Key (Key3) — Foreign key → movies.Key — NOT NULL
- user (Field8)
- Key (Key32) — Foreign key → movies.Key — NOT NULL
comment (Untitled6)
- Key — Primary key — NOT NULL
- user (Field)
- content (Field2)
- created_at (Field3)
- Field4
genres (Untitled4)
- genre_id (Key) — Primary key — NOT NULL
- genre_name (Field)
items (Untitled)
- Key — Primary key — NOT NULL
- user_id (Key2) — Primary key — NOT NULL
- movie_id (Key3) — Primary key — NOT NULL
- is_seen (Field)
- got_at (Field2)
movies (Untitled3)
- Key — Primary key — NOT NULL
- Key (Key3) — Foreign key → review.Key — NOT NULL
- title (Field)
- released_date (Field2)
- grade (Field3)
- genres (Field4)
- like_users (Field5)
- overview (Field6)
- genre_id (Key2) — Foreign key → genres.genre_id — NOT NULL
review (Untitled7)
- Key — Primary key — NOT NULL
- user (Field)
- movie (Field2)
- content (Field3)
- rank (Field4)
tickets (Untitled2)
- Key — Primary key — NOT NULL
- user_id (Key2) — Primary key — NOT NULL
- ticket_type (Field)
- ticket_name (Field2)
- is_used (Field3)
user
- Key — Primary key — NOT NULL
- Key (Key6) — Foreign key → comment.Key — NOT NULL
- Key (Key7) — Foreign key → review.Key — NOT NULL
- username (Field) — char
- password (Field2)
- last_login (Field3)
- pointt (Field4)
- following (Field5)
- Key (Key2) — Foreign key → items.Key — NOT NULL
- user_id (Key22) — Foreign key → items.user_id — NOT NULL
- movie_id (Key3) — Foreign key → items.movie_id — NOT NULL
- Key (Key4) — Foreign key → tickets.Key — NOT NULL
- user_id (Key23) — Foreign key → tickets.user_id — NOT NULL
- Key (Key5) — Foreign key → movies.Key — NOT NULL
- Key (Key32) — Foreign key → movies.Key — NOT NULL