Receipt

Tables (5)

CEO (ceo)

  • CEO_ID (ceo_id) — int — Primary key — NOT NULL
  • Name (name) — nvarchar
  • Age (age) — int
  • Phone (phone) — int

Card (card)

  • Card_ID (card_id) — int — Primary key — NOT NULL
  • CardMaker (cardmaker) — nvarchar
  • Cash (cash) — double

Cuntomer (customer)

  • Cumtomer_ID (cumtomer_id) — int — Primary key — NOT NULL
  • Card_ID (card_id) — int — Foreign key → Card.Card_ID — NOT NULL
  • Name (name) — nvarchar
  • Age (age) — int
  • Phone (phone) — int

Manufacturer (manufacturer)

  • Manufacturer_ID (manufacturer_id) — int — Primary key — NOT NULL
  • CEO_ID (ceo_id) — int — Foreign key → CEO.CEO_ID — NOT NULL
  • Name (name) — nvarchar
  • Bnumber (bnumber) — int

Receipt (receipt)

  • Receipt_ID (receipt_id) — int — Primary key — NOT NULL
  • Manufacturer_ID (manufacturer_id) — int — Foreign key → Manufacturer.Manufacturer_ID — NOT NULL
  • CEO_ID (ceo_id) — int — Foreign key → Manufacturer.CEO_ID — NOT NULL
  • Cumtomer_ID (cumtomer_id) — int — Foreign key → Cuntomer.Cumtomer_ID — NOT NULL
  • Card_ID (card_id) — int — Foreign key → Cuntomer.Card_ID — NOT NULL
  • Product (product) — nvarchar
  • Price (price) — int