banksalad
Tables (6)
Brand_Benefit (CopyOfUntitled5)
- Card_Id (Key) — Foreign key → Card.Card_Id — NOT NULL
- Brand (Field5)
- Discount_Price (Field)
- Discount_Rate (Field2)
- Milage (Field3)
Card (Untitled2)
- Card_Id (Key) — Primary key — NOT NULL
- Customer_Id (Key2) — Foreign key → Customer.Customer_Id — NOT NULL
- Name (Field)
- Company (Field2)
- Fee (Field3)
- Exp_date (Field4)
- Benefit_Limit (Field5)
Category_Benefit (Untitled5)
- Card_Id (Key) — Foreign key → Card.Card_Id — NOT NULL
- Category (Field6)
- Discount_Price (Field)
- Discount_Rate (Field2)
- Milage (Field3)
Customer (Untitled)
- Customer_Id (Key) — Primary key — NOT NULL
- Name (Field)
- Age (Field2)
- Sex (Field3)
- Join (Field4)
Store (Untitled3)
- Store_Id (Key) — Primary key — NOT NULL
- Name (Field)
- Brand (Field2)
- Category (Field3)
Transaction (Untitled4)
- Card_Id (Key2) — Foreign key → Card.Card_Id — NOT NULL
- Store_Id (Key3) — Foreign key → Store.Store_Id — NOT NULL
- Customer_Id (Key) — Foreign key → Customer.Customer_Id — NOT NULL
- Date (Field)
- Time (Field2)
- Price (Field3)