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