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