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)

Untitled

    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