1015

Tables (17)

Untitled (감독)

  • Key (내부코드) — char(10) — Primary key — NOT NULL
  • Field (감독이름) — char(20)
  • Field (전기정보) — text

Untitled (CASTING)

  • Key (roleID) — inti(3) — Foreign key → Untitled.Key — NOT NULL
  • Key (personID) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (movieID) — int(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (CLIENT)

  • Key (clientID) — int(100) — Primary key — NOT NULL
  • Field (name) — char(30)

Untitled (ROLE)

  • Key (roleID) — inti(3) — Primary key — NOT NULL
  • Field (roleTitle) — char(30)
  • Field (descrition)

Untitled (PERSON)

  • Key (personID) — int(10) — Primary key — NOT NULL
  • Field (fname) — char(30)
  • Field (minit) — char(1)
  • Field (Iname) — char(30)
  • Field (description) — text
  • Field (award)

Untitled (GENRE)

  • Key (genreID) — int(5) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (description) — longtext

Untitled (RENT)

  • Key (rentID) — int(1000) — Primary key — NOT NULL
  • Field (rentDate) — date
  • Field (returnDate) — date
  • Key (clientID) — int(100) — Foreign key → Untitled.Key — NOT NULL
  • Key (itemID) — int(100) — Foreign key → Untitled.Key — NOT NULL

Untitled (DVDITEM)

  • Key (itemID) — int(100) — Primary key — NOT NULL
  • Field (buyingDate) — date
  • Field (price) — int(10)
  • Field (statusLevel) — char(1)
  • Key (movieID) — int(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (MOVIE)

  • Key (movieID) — int(10) — Primary key — NOT NULL
  • Field (title) — char(30)
  • Field (pubYear) — int(4)
  • Field (pubMonti) — int(2)
  • Field (description) — text

Untitled (ACTIVITY)

  • Key (actCode) — char(10) — Primary key — NOT NULL
  • Field (actName) — char(20)
  • Field (description) — text

Untitled (배우)

  • Key (내부코드) — char(10) — Primary key — NOT NULL
  • Field (배우이름) — char(20)
  • Field (전기정보) — text

Untitled (영화)

  • Key (식별자) — char(10) — Primary key — NOT NULL
  • Field (제목) — char(20)
  • Field (제작년도) — date

Untitled (DVD)

  • Key (식별코드) — char(10) — Primary key — NOT NULL
  • Field (구입일) — date
  • Field (대여일) — date
  • Field (대여시간) — time
  • Field (복사본여부) — char(3)

Untitled (회원)

  • Key (회원ID) — char(10) — Primary key — NOT NULL
  • Field (회원이름) — char(20)
  • Field (회원주소) — char(50)

Untitled (ENROLL)

  • Key (classID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (actCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (memID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (MEMBER)

  • Key (memID) — char(10) — Primary key — NOT NULL
  • Field (memName) — char(20)
  • Field (address) — char(50)
  • Field (phone) — char(11)
  • Field (birthDate) — date
  • Field (gender) — char(1)

Untitled (CLASS)

  • Key (classID) — char(10) — Primary key — NOT NULL
  • Key (actCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (className) — char(20)
  • Field (time) — cha(50)
  • Field (classSize) — int(3)
  • Field (level) — char(4)
  • Field (lecturer) — char(10)
  • Field (price) — int(6)
  • Field (location) — char(20)
  • Field (year) — char(4)
  • Field (month) — char(2)