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)