assignment

Tables (5)

Benefits (Untitled3)

  • Brand (Card_Brand) — Primary key — NOT NULL
  • Category — Primary key — NOT NULL
  • Card_id — Foreign key → Credit_Card.Card_id — NOT NULL
  • Client_id — Int(11)Key — Foreign key → Credit_Card.Client_id — NOT NULL
  • Card_id (Card_id2) — Foreign key → Payment Record.Card_id — NOT NULL
  • Client_id (Client_id2) — Int(11)Key — Foreign key → Payment Record.Client_id — NOT NULL
  • Discount_amount
  • Discount_rate
  • Milage_rate
  • Benefit_Ceiling

Client (Untitled)

  • Client_id — Int(11)Key — Primary key — NOT NULL
  • Name
  • Age
  • Sex
  • Regist_Date

Credit_Card (Untitled2)

  • Card_id — Primary key — NOT NULL
  • Client_id — Int(11)Key — Foreign key → Client.Client_id — NOT NULL
  • Card_name
  • Card_co
  • Annual_fee
  • Contract_period

Franchisee (Untitled4)

  • Franchise_id — Primary key — NOT NULL
  • Card_id — Foreign key → Credit_Card.Card_id — NOT NULL
  • Client_id — Int(11)Key — Foreign key → Credit_Card.Client_id — NOT NULL
  • Franchisee_name
  • Brand_name
  • Franchise_Category

Payment Record (Untitled5)

  • Card_id — Foreign key → Credit_Card.Card_id — NOT NULL
  • Client_id — Int(11)Key — Foreign key → Credit_Card.Client_id — NOT NULL
  • Payment_amount
  • Payment_date