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