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