DOGRIP

Tables (11)

ChallengeTypes (챌린지타입)

  • challengeTypeNo (challenge_type_no) — INT — Primary key — NOT NULL
  • challengeTypeName (challenge_type_name) — VARCHAR(255)

Challenges (챌린지)

  • challengeNo (challenge_no) — INT — Primary key — NOT NULL
  • challengeTypeNo (challenge_type_no) — INT — Foreign key → ChallengeTypes.challengeTypeNo — NOT NULL
  • challengeName (challenge_name) — VARCHAR(255)
  • challengeDesc (challenge_desc) — VARCHAR(1000)
  • challengeCompleteCnt (challenge_complete_cnt) — INT
  • challengeImageUrl (challenge_image_url) — VARCHAR(1000)
  • challengeTriggerName (challenge_trigger_name) — VARCHAR(255)

Comments (댓글)

  • commentNo (comment_no) — INT — Primary key — NOT NULL
  • graveNo (grave_no) — INT — Foreign key → Graves.graveNo — NOT NULL
  • userNo (user_no) — INT — Foreign key → Users.userNo — NOT NULL
  • commentContent (comment_content) — VARCHAR — NOT NULL

CommonColumns (공통 속성)

  • creatDate (create_date) — TIMESTAMP
  • modifyDate (modify_date) — TIMESTAMP
  • canceled — INT

Dogs (강아지)

  • dogNo (dog_no) — INT — Primary key — NOT NULL
  • userNo (user_no) — INT — Foreign key → Users.userNo — NOT NULL
  • dogName (dog_name) — VARCHAR(255) — NOT NULL
  • dogBirthDate (dog_birth_date) — TIMESTAMP
  • dogBreed (dog_breed) — VARCHAR(255)
  • dogIsDead (dog_is_dead) — INT
  • dogDeathDate (dog_death_date) — TIMESTAMP
  • dogSex (dog_sex) — CHAR — NOT NULL
  • dogNFT (dog_nft) — VARCHAR(1000) — NOT NULL
  • dogImg (dog_img) — VARCHAR(1000)

Graves (무덤)

  • graveNo (grave_no) — INT — Primary key — NOT NULL
  • dogNo (dog_no) — INT — Foreign key → Dogs.dogNo — NOT NULL
  • userNo (user_no) — INT — Foreign key → Users.userNo — NOT NULL

Photos (사진)

  • photoNo (photo_no) — INT — Primary key — NOT NULL
  • dogNo (dog_no) — INT — Foreign key → Dogs.dogNo — NOT NULL
  • userNo (user_no) — INT — Foreign key → Users.userNo — NOT NULL
  • photoUrl (photo_url) — VARCHAR(1000)
  • photoComment (photo_comment) — VARCHAR(160)
  • photoIsGoat (photo_is_goat) — INT — NOT NULL

Reports (신고)

  • reportNo (report_no) — INT — Primary key — NOT NULL
  • userNo (user_no) — INT — NOT NULL
  • dogNo (dog_no) — INT — NOT NULL
  • commentNo (comment_no) — INT — NOT NULL
  • reportMessage (report_message) — VARCHAR(1000)

UserChallenges (사용자 챌린지)

  • userChallengeNo (user_challenge_no) — INT — Primary key — NOT NULL
  • challengeNo (challenge_no) — INT — Foreign key → Challenges.challengeNo — NOT NULL
  • userNo (user_no) — INT — Foreign key → Users.userNo — NOT NULL
  • userChallengeCnt (user_challenge_cnt) — INT — NOT NULL
  • userChallengeIscomplete (user_challenge_iscomplete) — INT — NOT NULL
  • completedDate (completed_date) — TIMESTAMP

Users (사용자)

  • userNo (user_no) — INT — Primary key — NOT NULL
  • userId (user_id) — NOT NULL
  • userToken (user_token) — VARCHAR(255) — NOT NULL
  • userName (user_name) — VARCHAR(255) — NOT NULL
  • userWallet (user_wallet) — VARCHAR(255)
  • userPrivateKey (user_private_key) — VARCHAR(255)
  • userMessage (user_message) — VARCHAR(100)

Walkings (산책)

  • walkingNo (walking_no) — INT — Primary key — NOT NULL
  • userNo (user_no) — INT — Foreign key → Users.userNo — NOT NULL
  • dogNo (dog_no) — INT — Foreign key → Dogs.dogNo — NOT NULL
  • walkingStartDate (walking_startdate) — TIMSTAMP — NOT NULL
  • walkingCount (walking_count) — INT
  • walkingTime (walking_time) — INT