JoyRide

Tables (8)

Course (코스)

  • course_id (코스번호) — NOTNULL — Primary key — NOT NULL
  • name (코스이름) — NOTNULL
  • level (난이도) — NOTNULL
  • length (길이) — NOTNULL
  • time (소요시간) — NOTNULL
  • local (지역) — NOTNULL
  • image (이미지) — NOTNULL
  • intro (코스개요) — NOTNULL
  • info (코스설명) — NOTNULL
  • travel (관광포인트) — NOTNULL
  • 편의시설

CourseLike (코스좋아요)

  • cl_id (코스좋아요번호) — NOTNULL — Primary key — NOT NULL
  • user_id (유저번호) — NOTNULL — Foreign key → User.user_id — NOT NULL
  • course_id (코스번호) — NOTNULL — Foreign key → Course.course_id — NOT NULL

Group (모임)

  • group_id (모임번호) — NOTNULL — Primary key — NOT NULL
  • user_id (호스트) — NOTNULL — Foreign key → User.user_id — NOT NULL
  • course_id (코스번호) — NULL — Foreign key → Course.course_id — NOT NULL
  • name (모임이름) — NOTNULL
  • local (지역) — NOTNULL
  • level (코스난이도) — NOTNULL
  • speed (라이딩실력) — NOTNULL
  • image (이미지) — NOTNULL
  • sex (성별) — NOTNULL
  • bike (자전거기종) — NOTNULL
  • money (참가비유무) — NOTNULL
  • people (최대명수) — NOTNULL
  • date (모임날짜) — NOTNULL
  • due_date (마감일) — NOTNULL
  • intro (소개글) — NOTNULL
  • path (경로) — NOTNULL

GroupLike (그룹북마크)

  • gl_id (북마크번호) — NOTNULL — Primary key — NOT NULL
  • user_id (유저번호) — NOTNULL — Foreign key → User.user_id — NOT NULL
  • group_id (모임번호) — NOTNULL — Foreign key → Group.group_id — NOT NULL
  • user_id (호스트) — NOTNULL — Foreign key → Group.user_id — NOT NULL
  • course_id (코스번호) — NOTNULL — Foreign key → Group.course_id — NOT NULL

Group_comment (모임댓글)

  • gc_id (모임댓글번호) — NOTNULL — Primary key — NOT NULL
  • user_id (유저번호) — NOTNULL — Foreign key → User.user_id — NOT NULL
  • croup_id (모임번호) — NOTNULL — Foreign key → Group.group_id — NOT NULL
  • user_id (유저번호2) — NOTNULL — Foreign key → Group.user_id — NOT NULL
  • course_id (코스번호) — NOTNULL — Foreign key → Group.course_id — NOT NULL
  • content (댓글내용) — NOTNULL
  • created_at (생성날짜) — NOTNULL
  • updated_at (수정일) — NULL
  • status (삭제상태) — NOTNULL
  • gc_id (모임댓글번호2) — NOTNULL — Foreign key → Group_comment.gc_id — NOT NULL
  • user_id (유저번호3) — NOTNULL — Foreign key → Group_comment.user_id — NOT NULL
  • croup_id (모임번호2) — NOTNULL — Foreign key → Group_comment.croup_id — NOT NULL
  • user_id (유저번호22) — NOTNULL — Foreign key → Group_comment.user_id — NOT NULL

Join (모임참여)

  • join_id (참여번호) — NOTNULL — Primary key — NOT NULL
  • user_id (유저번호) — NOTNULL — Foreign key → User.user_id — NOT NULL
  • group_id (모임번호) — NOTNULL — Foreign key → Group.group_id — NOT NULL
  • user_id (호스트) — NOTNULL — Foreign key → Group.user_id — NOT NULL
  • course_id (코스번호) — NOTNULL — Foreign key → Group.course_id — NOT NULL

Review (리뷰)

  • review_id (리뷰번호) — NOTNULL — Primary key — NOT NULL
  • user_id (유저번호) — NOTNULL — Foreign key → User.user_id — NOT NULL
  • course_id (코스번호) — NOTNULL — Foreign key → Course.course_id — NOT NULL
  • total_star (총별점) — NOTNULL
  • total_coment (총평) — NOTNULL
  • safe_star (안전별점) — NOTNULL
  • scene_star (경관별점) — NOTNULL
  • facilities_star (편의시설별점) — NOTNULL
  • accessibility_star (접근성별점) — NOTNULL
  • safe_coment (안전코맨트) — NULL
  • scene_coment (경관코멘트) — NULL
  • facilities_coment (편의시설코멘트) — NULL
  • accessibility_coment (접근성코멘트) — NULL

User (유저)

  • user_id (유저번호) — NOTNULL — Primary key — NOT NULL
  • email (이메일) — NOTNULL
  • password (비밀번호) — NOTNULL
  • nickname (닉네임) — NOTNULL
  • image (프로필이미지) — NOTNULL
  • status (활성화) — NOTNULL
  • sex (성별) — NOTNULL
  • bike (자전거기종) — NOTNULL
  • age (생년) — NOTNULL
  • year (경력) — NOTNULL
  • manner (매너온도) — NOTNULL