Entity Relationship Diagram

Movie_Ticket_Booking_Platform_ERD.drawio.svg

Legend

1. UserDetails

Attribute Datatype Relationship Description
userId String Primary Key Unique user identifier
username String Display name
email String Email address
password String Encrypted password
userRole Enum USER / THEATER_OWNER
phoneNumber String Contact number
dateOfBirth LocalDate Date of birth
createdAt Long Creation timestamp
updatedAt Long Last update timestamp

2. User

Attribute Datatype Relationship Description
userId String FK to UserDetails Inherits user details

3. TheaterOwner

Attribute Datatype Relationship Description
userId String FK to UserDetails Owner's user ID

4. Theater

Attribute Datatype Relationship Description
theaterId String Primary Key Unique theater identifier
name String Theater name
address String Full address
city String City location
landmark String Nearby landmark
createdAt Long Created timestamp
updatedAt Long Last update timestamp
createdBy String FK to User Creator (User)

5. Screen

Attribute Datatype Relationship Description
screenId String Primary Key Unique screen identifier
screenType Enum 2D, 3D, IMAX, etc.
capacity Integer Seating capacity
noOfRows Integer Number of seat rows
createdAt Long Created timestamp
updatedAt Long Last update timestamp
createdBy String FK to User Creator (User)
theaterId String FK to Theater Belongs to this theater