중간고사 연습
테이블 (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