kotlin-movie

Tables (4)

movie_reservations (CopyOfUntitled2)

  • id (Key) — INT — Primary key — NOT NULL
  • seat (Field) — VARCHAR(2) — NOT NULL
  • screening_id (Key2) — INT — Foreign key → movie_screenings.id — NOT NULL
  • payment_id (Key3) — INT — Foreign key → payment.id — NOT NULL

movie_screenings (Untitled2)

  • id (Key) — INT — Primary key — NOT NULL
  • stat_time (Field) — DATETIME
  • movie_id (ID) — INT — Foreign key → movies.id — NOT NULL
  • screen_id (Field2) — INT

movies (Untitled)

  • id (ID) — INT — Primary key — NOT NULL
  • title (Field) — VARCHAR(255)
  • running_time (Field2) — INT

payment (CopyOfUntitled22)

  • id (Key) — INT — Primary key — NOT NULL
  • used_points (Field) — INT
  • payType (Field2) — INT