ERD
Tables (5)
Budget (budget)
- userID — NOT NULL — Foreign key → User.userID — NOT NULL
- food (Field) — NULL
- medical (Field2) — NULL
- insurance (Field3) — NULL
- transportation (Field4) — NULL
- education (Field5) — NULL
- utilities (Field6) — NULL
- etc (Field7) — NULL
Card (card)
- cardNO (Key) — NOT NULL — Primary key — NOT NULL
- card_name (Field) — NOT NULL
- card_benefits (Field2) — NOT NULL
Diary (diary)
- date (Key) — NOT NULL — Primary key — NOT NULL
- userID — NOT NULL — Foreign key → User.userID — NOT NULL
- bookmark (Field) — NULL
- contents (Field2) — NULL
Goal (goal_list)
- date (Key) — NOT NULL — Primary key — NOT NULL
- userID — NOT NULL — Foreign key → User.userID — NOT NULL
- cardNO (Key2) — NOT NULL — Foreign key → User.cardNO — NOT NULL
- goal_title (Field) — NOT NULL
- goal_points (Field2) — NOT NULL
User (user)
- userID — NOT NULL — Primary key — NOT NULL
- cardNO (Key) — NOT NULL — Foreign key → Card.cardNO — NOT NULL
- userPWD (Field) — NOT NULL
- user_name (Field2) — NOT NULL
- user_img (Field3) — NULL
- user_points (Field4) — NOT NULL
- user_category (Field5) — NULL