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