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