5~7
Tables (18)
Untitled (PRINTER)
- Key (printerId) — Primary key — NOT NULL
- Field (name)
- Field (address)
- Field (maxCapacity) — int
Untitled (PROJECT_SUBCONTRACTOR)
- Key (projectId) — Foreign key → Untitled.Key — NOT NULL
- Key (subcontractorId) — Foreign key → Untitled.Key — NOT NULL
Untitled (LOAN)
- Key (loanId) — Primary key — NOT NULL
- Field (loanAmount)
- Field (loanDate)
- Field (interestDate)
- Key (projectId) — Foreign key → Untitled.Key — NOT NULL
Untitled (SPECIALTY)
- Key (specialtyId) — Primary key — NOT NULL
- Field (name)
- Field (description)
Untitled (SUBCONTRACTOR)
- Key (subcontractorId) — Primary key — NOT NULL
- Field (companyName)
- Field (address)
- Field (phone)
- Key (specialtyId) — Foreign key → Untitled.Key — NOT NULL
Untitled (PM)
- Key (PMId) — Primary key — NOT NULL
- Field (name)
- Field (phone)
- Field (eMail)
Untitled (PROJECT)
- Key (projectId) — Primary key — NOT NULL
- Field (name)
- Field (startDate)
- Field (endDate)
- Field (budget)
- Key (PMId) — Foreign key → Untitled.Key — NOT NULL
Untitled (BOOK_AUTHOR)
- Key (ISBN) — char — Foreign key → Untitled.Key — NOT NULL
- Key (authorId) — Foreign key → Untitled.Key — NOT NULL
Untitled (CONTRACT)
- Key (ISBN) — char — Foreign key → Untitled.Key — NOT NULL
- Key (printerId) — Foreign key → Untitled.Key — NOT NULL
- Field (numberOfCopies) — int
- Field (dueDate) — date
Untitled (SHOE(신발))
- Key (shoeId) — char — Primary key — NOT NULL
- Field (style) — text
- Field (size) — int(1)
- Field (color) — char
- Field (quantity) — int
- Key (supplierId) — char — Foreign key → Untitled.Key — NOT NULL
Untitled (AUTHOR)
- Key (authorId) — Primary key — NOT NULL
- Field (socialSecurityNumber)
- Field (mane)
- Field (address)
Untitled (PUBLISHER)
- Key (publisherId) — char — Primary key — NOT NULL
- Field (name)
- Field (address)
Untitled (BOOK(책))
- Key (ISBN) — char — Primary key — NOT NULL
- Field (title)
- Field (publicationDate) — date
- Key (publisherId) — char — Foreign key → Untitled.Key — NOT NULL
Untitled (SALE_DETAIL(판매상세))
- Key (shoeId) — char — Foreign key → Untitled.Key — NOT NULL
- Key (saleId) — Foreign key → Untitled.Key — NOT NULL
- Field (quantity) — int
Untitled (EMPLOYEE(영업사원))
- Key (employeeId) — char — Primary key — NOT NULL
- Field (name)
- Field (phone)
- Field (commissionRate)
- Field (salesTarget)
Untitled (SALE(판매))
- Key (saleId) — Primary key — NOT NULL
- Field (saleDate) — date
- Field (paymentType)
- Key (customerId) — char — Foreign key → Untitled.Key — NOT NULL
- Key (employeeId) — char — Foreign key → Untitled.Key — NOT NULL
Untitled (CUSTOMER(고객))
- Key (customerId) — char — Primary key — NOT NULL
- Field (name)
- Field (address)
- Field (phone)
Untitled (SUPPLIER(공급자))
- Key (supplierId) — char — Primary key — NOT NULL
- Field (supplierName) — char
- Field (address)
- Field (phone)