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)