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)