ureaca-cinemasys

Tables (6)

Untitled

    customer

    • custid — INT
    • name — VARCHAR(50) — NOT NULL
    • phone — VARCHAR(20)
    • email — VARCHAR(100)
    • age — INT — NOT NULL

    movie

    • movieid — INT
    • title — VARCHAR(100) — NOT NULL
    • genre — VARCHAR(50)
    • director — VARCHAR(50)
    • rating — VARCHAR(20)

    reservation

    • reservid — INT
    • custid — INT — Foreign key → customer.custid — NOT NULL
    • screenid — INT — Foreign key → screening.screenid — NOT NULL
    • seatno — VARCHAR(10) — NOT NULL
    • reservdate — DATE — NOT NULL

    screening

    • screenid — INT
    • movieid — INT — Foreign key → movie.movieid — NOT NULL
    • theaterid — INT — Foreign key → theater.theaterid — NOT NULL
    • showtime — DATETIME — NOT NULL
    • price — INT — NOT NULL

    theater

    • theaterid — INT
    • name — VARCHAR(50) — NOT NULL
    • total_seats — INT — NOT NULL