중간고사 연습

테이블 (38)

Untitled (DESIGN)

  • Key (shoeID) — char(7) — 외래 키 → Untitled.Key — NOT NULL
  • Key (supplierID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Field (size) — int(2)
  • Field (style) — char(10)
  • Field (color) — char(10)

Untitled (DIRECTOR)

  • Key (directorID) — char(13) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field (biography) — text

Untitled (PRODUCER)

  • Key (prodID) — char(13) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field (address) — text
  • Field (phone) — char(11)

Untitled (ACTOR)

  • Key (actorID) — char(13) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field (biography) — text

Untitled (SHOES)

  • Key (shoeID) — char(7) — 기본 키 — NOT NULL
  • Key (supplierID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Field (quantity) — integer

Untitled (CLIENT2)

  • Key (clientID) — char(13) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field (phone) — char(11)
  • Field (address) — text

Untitled (Purchase)

  • Key (clientID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (shoeID) — char(7) — 외래 키 → Untitled.Key — NOT NULL
  • Key (supplierID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Field (quantity) — integer
  • Field (purchaseDate) — date
  • Key (salesID) — char(13) — 외래 키 → Untitled.Key — NOT NULL

Untitled (SUPPLIER)

  • Key (supplierID) — char(13) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field (phone) — char(11)
  • Field (address) — text

Untitled (Salesperson)

  • Key (salesID) — char(13) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field (phone) — char(11)
  • Field (address) — text
  • Field (fee) — integer
  • Field (objective) — text
  • Field (salary) — integer

Untitled (RENT)

  • Key (dvdID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (clientID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Field (rentDate) — date
  • Field

Untitled (BOOK)

  • Key (ISBN) — char(13) — 기본 키 — NOT NULL
  • Key (publisherID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (authorID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Field (title) — char(50)
  • Field (publishDate) — date

Untitled (PUBLISHER)

  • Key (publisherID) — char(13) — 기본 키 — NOT NULL
  • Field (publisherName) — char(20)
  • Field (address) — text

Untitled (AUTHOR)

  • Key (authorID) — char(13) — 기본 키 — NOT NULL
  • Field (authorName) — char(10)
  • Field (address) — text
  • Field (phone) — char(11)

Untitled (PRESS)

  • Key (pressID) — char(13) — 기본 키 — NOT NULL
  • Field (pressName) — char(20)
  • Field (availableQuantity) — integer
  • Field (address) — text
  • Field (phone) — char(11)
  • Field

Untitled (CONTRACT)

  • Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (publisherID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (authorID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Field (quantity) — integer
  • Field (dueDate) — date
  • Key (pressID) — char(13) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PROJECT)

  • Key (pID) — char(13) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (description) — text
  • Key (pmID) — char(13) — 외래 키 → Untitled2.Key — NOT NULL
  • Key (staffID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (loanID) — char(13) — 외래 키 → Untitled.Key — NOT NULL

Untitled (LOAN)

  • Key (loanID) — char(13) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (quantity) — integer
  • Field (amount) — integer
  • Key (pID) — char(13) — 외래 키 → Untitled.Key — NOT NULL

Untitled (STAFF)

  • Key (staffID) — char(13) — 기본 키 — NOT NULL
  • Field (staffName) — char(20)
  • Field (staffPhone) — char(11)
  • Field (staffAddress) — text
  • Field (department) — char(20)

Untitled (MEMBERS)

  • Key (memID) — char(13) — 기본 키 — NOT NULL
  • Key (classID) — char(11) — 외래 키 → Untitled.Key — NOT NULL
  • Key (actID) — char(11) — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — char(10)
  • Field (age) — int(3)
  • Field (address) — text
  • Field (memLevel) — int(2)
  • Field

Untitled (PRODUCT)

  • Key (productID) — char(13) — 기본 키 — NOT NULL
  • Field (price) — integer
  • Field (description) — text
  • Field (name) — char(10)

Untitled (PART)

  • Key (partID) — char(11) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field (price) — integer
  • Field (description) — text
  • Key (productID) — char(13) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PRODUCT_PART)

  • Key (partID) — char(11) — 외래 키 → Untitled.Key — NOT NULL
  • Key (prodID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Field (quantity) — integer

Untitled (ACTIVITIES)

  • Key (actID) — char(11) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field (description) — text

Untitled (REGISTERED CLASS)

  • Key (classID) — char(11) — 외래 키 → Untitled.Key — NOT NULL
  • Key (actID) — char(11) — 외래 키 → Untitled.Key — NOT NULL
  • Field (ruuningHours) — float
  • Field (registeredNumber) — int(2)

Untitled (CLASS)

  • Key (classID) — char(11) — 기본 키 — NOT NULL
  • Field (restrictedNumber) — int(2)
  • Field (classLevel) — int(2)

Untitled (MOVIE)

  • Key (movieID) — char(13) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field

Untitled (CLIENT)

  • Key (clientID) — char(13) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field (address) — text
  • Field (phone) — char(11)
  • Field

Untitled (DEPENDENT)

  • Key (depID) — char(13) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field (phone) — char(11)
  • Key (clientID) — char(13) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PROVIDER)

  • Key (provID) — char(13) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field (address) — text
  • Field (phone) — char(11)
  • Field (grade) — float(3)
  • Field (memo) — text

Untitled (SUBJECT)

  • Key (subjectID) — char(11) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field (memo) — text

Untitled (CLASS1)

  • Key (classID) — char(11) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field (level) — int(2)
  • Field (year) — int(4)
  • Field (month) — int(2)
  • Field (lecturer) — char(10)
  • Key (subjectID) — char(11) — 외래 키 → Untitled.Key — NOT NULL
  • Key (provID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (lecturerID) — char(11) — 외래 키 → Untitled.Key — NOT NULL

Untitled (REGISTERED)

  • Key (clientID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (classID) — char(11) — 외래 키 → Untitled.Key — NOT NULL
  • Field (date) — date

Untitled (LECTURER)

  • Key (lecturerID) — char(11) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field (phone) — char(11)
  • Field (email) — char(30)
  • Field (description) — text

Untitled (CLIENT1)

  • Key (clientID) — char(13) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field (address) — text
  • Field (phone) — char(11)
  • Field

Untitled (DVD)

  • Key (dvdID) — char(13) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field (copyNumber) — int(2)
  • Field (purchaseDate) — date
  • Field (rentNumber) — integer
  • Key (movieID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (actorID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (directorID) — char(13) — 외래 키 → Untitled.Key — NOT NULL

Untitled2 (PM)

  • Key (pmID) — char(13) — 기본 키 — NOT NULL
  • Field (pmName) — char(20)
  • Field (pmPhone) — char(11)
  • Field (pmAddress) — text
  • Field (department) — char(20)

Untitled3 (SUBCONTRACTOR)

  • Key (subID) — char(13) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (intimacy) — text
  • Key (profID) — char(13) — 외래 키 → Untitled4.Key — NOT NULL
  • Key (pID) — char(13) — 외래 키 → Untitled4.Key — NOT NULL

Untitled4 (PROFESSION)

  • Key (profID) — char(13) — 기본 키 — NOT NULL
  • Key (pID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Field (profName) — char(20)
  • Field (description) — text
  • Key (subID) — char(13) — 외래 키 → Untitled3.Key — NOT NULL