sub1

Tables (3)

UnicostArticle (단가 물품)

  • articleId (물품id) — VARCHAR — Primary key — NOT NULL
  • articleName (물품 이름) — VARCHAR
  • cost (물품 단가) — INT

UnicostArticlePurchase (단가물품구매)

  • listId (단가물품구매 id) — VARCHAR — Primary key — NOT NULL
  • purchaseRequestor (구매 신청자id) — VARCHAR — Foreign key → employee.employeeId — NOT NULL
  • articleList (단가물품 구매 목록) — VARCHAR — Foreign key → UnicostArticle.articleId — NOT NULL
  • totalCost (총 단가) — INT
  • purchaseDate (구매 일시) — DATE

employee (직원)

  • employeeId (직원id) — VARCHAR — Primary key — NOT NULL