Open xma08 opened 2 years ago
CARDS: id nickname: str user_id number: str (encrpted) expiration_date: date csv_code: int card_type: enum (credit/debit) created_at: datetime
REWARDS: id card_id: (FK) name: discount: # 5% category: enum # (restaurant, gas, online shopping) valid_from: datetime valid_to: datetime create_at: datetime
Transaction: id card_id price: float category: enum transaction_at: datetime created_at: datetime
CARDS: id nickname: str user_id number: str (encrpted) expiration_date: date csv_code: int card_type: enum (credit/debit) created_at: datetime
REWARDS: id card_id: (FK) name: discount: # 5% category: enum # (restaurant, gas, online shopping) valid_from: datetime valid_to: datetime create_at: datetime
Transaction: id card_id price: float category: enum transaction_at: datetime created_at: datetime