vidio_library

Tables (5)

ANIMAL (Untitled5)

  • speciesNo (Key) — char(10) — Primary key — NOT NULL
  • species (Field) — char(30)
  • vidioNo (Field2) — int(10)
  • movieNo (Field3) — int(10)

LIBRARY_USER (Untitled4)

  • userID (Key) — char(20) — Primary key — NOT NULL
  • name (Field) — char(20)
  • phone (Field2) — char(11)
  • email (Field3) — char(30)
  • adress (Field4) — char(30)
  • age (Field5) — int(3)

MOVIE (Untitled2)

  • movieNo (Key) — int(10) — Primary key — NOT NULL
  • speciesNo (Key2) — char(10) — Foreign key → ANIMAL.speciesNo — NOT NULL
  • title (Field) — char(50)
  • originalTitle (Field2) — char(50)
  • filmDirector (Field3) — char(50)
  • productYear (Field4) — int(4)
  • movieType (Field5) — char(20)
  • runTime (Field6) — int(3)
  • movieRate (Field7) — char(2)

VIDEO (Untitled)

  • videoNo (Key) — int(10) — Primary key — NOT NULL
  • userID (Key4) — char(20) — Foreign key → LIBRARY_USER.userID — NOT NULL
  • libraryNo (Key5) — int10) — Foreign key → VIDEO_LIBRARY.libraryNo — NOT NULL
  • speciesNo (Key3) — char(10) — Foreign key → ANIMAL.speciesNo — NOT NULL
  • title (Field) — char(50)
  • originalTitle (Field2) — char(50)
  • filmDirector (Field3) — char(30)
  • videoStandard (Field4) — char(10)
  • dateCode (Field5) — int(4)
  • language (Field6) — char(30)
  • movieType (Field7) — char(20)
  • movieRate (Field8) — char(2)
  • manufactCompany (Field10) — char(10)
  • runTime (Field11) — int(3)
  • movieNo (Key2) — int(10) — Foreign key → MOVIE.movieNo — NOT NULL

VIDEO_LIBRARY (Untitled3)

  • libraryNo (Key) — int10) — Primary key — NOT NULL
  • userID (Key2) — char(20) — Foreign key → LIBRARY_USER.userID — NOT NULL
  • videoNo (Field) — int(10)