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