KDT3_CardMonkey

Tables (5)

Cards (카드)

  • card_id — Long — Primary key — NOT NULL
  • name — String
  • company — String
  • lastMonthPaid — Int
  • annualFee — Int
  • cardType — enum
  • imageURL — String
  • applyURL — String
  • coffee — String
  • transportation — String
  • movie — String
  • delivery — String
  • phone — String
  • gas — String
  • simplePayment — String
  • tax — String
  • shopping — String

Favor (찜목록)

  • favor_id — Long — Primary key — NOT NULL
  • member_id — Long — Foreign key → Member.member_id — NOT NULL
  • card_id — Long — Foreign key → Cards.card_id — NOT NULL

Member (회원)

  • member_id — Long — Primary key — NOT NULL
  • user_id — String
  • password — String
  • name — String
  • role — String
  • coffee — String
  • transportation — String
  • movie — String
  • delivery — String
  • phone — String
  • gas — String
  • simplePayment — String
  • tax — String
  • shopping — String

Paid (신청목록)

  • paid_id — Long — Primary key — NOT NULL
  • member_id — Long — Foreign key → Member.member_id — NOT NULL
  • card_id — Long — Foreign key → Cards.card_id — NOT NULL

Token (만료된 토큰저장)

  • token — String