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