Moviepedia
Bootstrap

WELCOME TO DATABASE

Tables

Card Image
MovieCast

  • CAST_ID VARCHAR(10) PRIMARY KEY
  • DIR_ID VARCHAR(10)
  • ACT1_ID VARCHAR(10)
  • ACT1_NAME VARCHAR(100)
  • ACT1_GENDER CHAR(1)
  • ACT2_ID VARCHAR(10)
  • ACT2_NAME VARCHAR(100)
  • ACT2_GENDER CHAR(1)
  • ACT3_ID VARCHAR(10)
  • ACT3_NAME VARCHAR(100)
  • ACT3_GENDER CHAR(1)
  • FOREIGN KEY(DIR_ID) REFERENCES Directors(DIR_ID)

Explore
Card Image
MoviesData

  • MOV_ID VARCHAR(10) PRIMARY KEY
  • MOV_TITLE VARCHAR(250)
  • MOV_YEAR INT(4)
  • MOV_LANG VARCHAR(12)
  • DIR_ID VARCHAR(10)
  • MOV_DURATION INT(5)
  • MOV_CAST_ID VARCHAR(10)
  • MOV_GENRE_ID VARCHAR(20)
  • FOREIGN KEY(DIR_ID) REFERENCES Directors(DIR_ID)
  • FOREIGN KEY(MOV_GENRE_ID) REFERENCES Genres(GENRE_ID)
  • FOREIGN KEY(MOV_CAST_ID) REFERENCES movieCast(CAST_ID)

Explore
Card Image
Movie_Direction

  • MOV_ID VARCHAR(10)
  • DIR_ID VARCHAR(10)
  • PRIMARY KEY(MOV_ID, DIR_ID)
  • FOREIGN KEY(MOV_ID) REFERENCES MoviesData(MOV_ID)
  • FOREIGN KEY(DIR_ID) REFERENCES Directors(DIR_ID)

Explore
Card Image
Directors

  • DIR_ID VARCHAR(10) PRIMARY KEY
  • DIR_NAME VARCHAR(200)
  • DIR_GENDER CHAR(20)

Explore
Card Image
Performance

  • MOV_ID VARCHAR(10)
  • RATINGS FLOAT(10,2)
  • REVENUE FLOAT(10,5)
  • NO_OF_AWARDS INT(3)
  • FOREIGN KEY(MOV_ID) REFERENCES MoviesData(MOV_ID)

Explore
Card Image
Movie_Genres

  • MOV_ID VARCHAR(10)
  • GENRE_ID VARCHAR(10)
  • PRIMARY KEY(MOV_ID, GENRE_ID)
  • FOREIGN KEY(GENRE_ID) REFERENCES Genres(GENRE_ID)

Explore