123

Tables (5)

Book (Untitled2)

  • BookID (Key) — Primary key — NOT NULL
  • STR (Field)
  • INT (Field2)
  • HP (Field3)
  • PetID (Field6)
  • EvolutionLevel (Field4)
  • Illust (Field5)
  • Nature (성격)
  • Description (도감설명)
  • UserID (Key2) — Foreign key → User.UserID — NOT NULL
  • RaisedDate (키운날짜(진화까지 남은날짜 계산))

Friend (Untitled4)

  • FriendID (Key) — Primary key — NOT NULL
  • AreWeFriend (Field)
  • FromUserID (Field2)
  • UserID (Key2) — Foreign key → User.UserID — NOT NULL

User (Untitled)

  • UserID (Key) — Primary key — NOT NULL
  • ID (Field)
  • PW (Field2)
  • authentication (Field3)
  • coin (Field4)
  • attendanceDate (Field5)
  • BookID (현재 키우는 펫) — Foreign key → Book.BookID — NOT NULL
  • Nickname (Field6)
  • ProfileImage (Field7)

UsersPet (Untitled5)

    challenge (Untitled3)

    • ChallengeID (Key) — Primary key — NOT NULL
    • ChallengeDescription (Field)
    • IsSuccessed (Field2)