sf

Tables (6)

Product Description

  • id — VARCHAR(20) — Primary key — NOT NULL
  • itemID — VARCHAR(20) — Foreign key → item.itemID — NOT NULL
  • description — VARCHAR(1000)
  • price — VARCHAR(20)

Register

  • id — VARCHAR(20) — Primary key — NOT NULL
  • storeID — VARCHAR(20) — Foreign key → store.storeID — NOT NULL

SalesLineItem

  • id — VARCHAR(20) — Primary key — NOT NULL
  • itemID — VARCHAR(20) — Foreign key → item.itemID — NOT NULL
  • saleID — VARCHAR(20) — Foreign key → sale.saleID — NOT NULL
  • quantity — VARCHAR(20) — NOT NULL

item

  • itemID — VARCHAR(20) — Primary key — NOT NULL
  • storeID — VARCHAR(20) — Foreign key → store.storeID — NOT NULL
  • quantity — VARCHAR(20)

sale

  • saleID — VARCHAR(20) — Primary key — NOT NULL
  • id — VARCHAR(20) — Foreign key → Register.id — NOT NULL
  • dateTime — VARCHAR(30)
  • total — VARCHAR(20)

store

  • storeID — VARCHAR(20) — Primary key — NOT NULL
  • name — VARCHAR(20)
  • address — VARCHAR(30)