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