상황
Design a database to track costume rentals for theater productions and events, managing inventory, customer orders, and payments.
이 도면에 담긴 내용
그 이면의 의사결정을 읽어 보세요.
01
Included RentalLine to handle many-to-many between orders and costumes with quantity and rental days.
02
Separated Category entity to organize costumes.
03
Linked Payment as optional one-to-one to support unpaid orders.
This ERD pattern suits any rental business with item inventory, customer orders, and optional payment tracking, such as tool rental, equipment rental, or library systems.