miniprojectV1
Tables (3)
Customer (고객클래스)
- customerId (고객식별번호) — NOTNULL — Primary key — NOT NULL
- customerName (고객이름) — NOTNULL
- customerPhoneNumber (고객전화번호) — NOTNULL
Item (상품클래스)
- itemId (상품식별번호) — NOTNULL — Primary key — NOT NULL
- managerId (관리자식별번호) — NOTNULL — Foreign key → Manager.managerId — NOT NULL
- customerId (고객식별번호) — NOTNULL — Foreign key → Customer.customerId — NOT NULL
- barcodeNumber (바코드) — NOTNULL
- itemName (상품이름) — NOTNULL
- itemManufacturer (상품제조사) — NOTNULL
Manager (관리자클래스)
- managerId (관리자식별번호) — NOTNULL — Primary key — NOT NULL
- managerName (관리자이름) — NOTNULL
- managerPhoneNumber (관리자전화번호) — NOTNULL