WeBoulder
Tables (12)
ClimbingGym (클라이밍장)
- climbingGymId (pk) — INTEGER — Primary key — NOT NULL
- 클라이밍장 이름 (climbing_gym_name) — VARCHAR(15)
- 위치 주소 (location) — VARCHAR(50)
Comment (댓글)
- commentId (pk) — INTEGER — Primary key — NOT NULL
- 내용 (content) — VARCHAR(100)
- 생성날짜 (Field) — DATE
- 수정날짜 (edited) — DATE
Follow (팔로우)
- followId (pk) — INTEGER — Primary key — NOT NULL
- userId (follower) — INTEGER — Foreign key → User.userId — NOT NULL
- levelId (pk22) — INTEGER — Foreign key → User.levelId — NOT NULL
LikePosting (게시글 좋아요)
- userId (pk2) — INTEGER — Foreign key → User.userId — NOT NULL
- levelId (pk22) — INTEGER — Foreign key → User.levelId — NOT NULL
- postingId (pk3) — INTEGER — Foreign key → Posting.postingId — NOT NULL
- videoId (pk23) — INTEGER — Foreign key → Posting.videoId — NOT NULL
- userId (pk222) — INTEGER — Foreign key → Posting.userId — NOT NULL
- levelId (pk2222) — INTEGER — Foreign key → Posting.levelId — NOT NULL
- routeId (pk32) — INTEGER — Foreign key → Posting.routeId — NOT NULL
- climbingGymId (pk232) — INTEGER — Foreign key → Posting.climbingGymId — NOT NULL
Posting (게시글)
- postingId (pk) — INTEGER — Primary key — NOT NULL
- videoId (pk2) — INTEGER — Foreign key → Video.videoId — NOT NULL
- userId (pk22) — INTEGER — Foreign key → Video.userId — NOT NULL
- levelId (pk222) — INTEGER — Foreign key → Video.levelId — NOT NULL
- routeId (pk3) — INTEGER — Foreign key → Video.routeId — NOT NULL
- climbingGymId (pk23) — INTEGER — Foreign key → Video.climbingGymId — NOT NULL
- 내용 (content) — VARCHAR(200)
- 생성날짜 (first_created) — DATE
- 수정날짜 (edited) — DATE
Route (볼더링 문제)
- routeId (pk) — INTEGER — Primary key — NOT NULL
- climbingGymId (pk2) — INTEGER — Foreign key → ClimbingGym.climbingGymId — NOT NULL
- 레벨 (grade) — VARCHAR(10)
User (계정)
- userId (pk) — INTEGER — Primary key — NOT NULL
- levelId (pk2) — INTEGER — Foreign key → User Grade.levelId — NOT NULL
- 비밀번호 (password) — VARCHAR(40)
- 이름 (first_name) — VARCHAR(20)
- 성 (last_name) — VARCHAR(20)
- 닉네임 (nickname) — VARCHAR(20)
- 프로필사진 (profile_image) — IMAGE
- 이메일 (email) — VARCHAR(30)
- 폰번호 (phone) — INTEGER
User Grade (유저 등급)
- levelId (pk) — INTEGER — Primary key — NOT NULL
- 등급이름 (level_name) — VARCHAR(10)
Video (영상)
- videoId (pk) — INTEGER — Primary key — NOT NULL
- userId (pk2) — INTEGER — Foreign key → User.userId — NOT NULL
- levelId (pk22) — INTEGER — Foreign key → User.levelId — NOT NULL
- routeId (pk3) — INTEGER — Foreign key → Route.routeId — NOT NULL
- climbingGymId (pk23) — INTEGER — Foreign key → Route.climbingGymId — NOT NULL
- firebaseKey (FBkey) — INTEGER
hashTag (해시태그)
- hashtagId (pk) — INTEGER — Primary key — NOT NULL
- 해시태그 이름 (hashtag_name) — VARCHAR(20)
hashTaging (해시태그 적용)
- hashtagingId (pk) — INTEGER — Primary key — NOT NULL
- postingId (pk2) — INTEGER — Foreign key → Posting.postingId — NOT NULL
- videoId (pk22) — INTEGER — Foreign key → Posting.videoId — NOT NULL
- userId (pk222) — INTEGER — Foreign key → Posting.userId — NOT NULL
- levelId (pk2222) — INTEGER — Foreign key → Posting.levelId — NOT NULL
- routeId (pk3) — INTEGER — Foreign key → Posting.routeId — NOT NULL
- climbingGymId (pk23) — INTEGER — Foreign key → Posting.climbingGymId — NOT NULL
- hashtagId (pk4) — INTEGER — Foreign key → hashTag.hashtagId — NOT NULL