Runddy

Tables (15)

BaseEntity (Untitled)

  • created_at (생성일자)
  • created_by (생성유저id)
  • updated_at (수정일자)
  • updated_by (수정유저id)

Bookmark (저장한코스)

  • id — Primary key — NOT NULL
  • usr_id (유저 id) — Foreign key → User.id — NOT NULL
  • crs_id (코드 ID) — Foreign key → Course.crs_id — NOT NULL — auto_increment
  • bmk_grp_id (북마크 그룹 id) — Foreign key → BookmarkGroup.id — NOT NULL
  • memo (메모)

BookmarkGroup (그룹)

  • id — Primary key — NOT NULL
  • usr_id (유저id) — Foreign key → User.id — NOT NULL
  • grp_nm (그룹명)

Comment (댓글)

  • Key — Primary key — NOT NULL
  • post_id (게시글 id) — Foreign key → Post.id — NOT NULL
  • usr_id (유저 id) — Foreign key → User.id — NOT NULL
  • cmt_seq (댓글 순서) — NOT NULL
  • cont (내용)

Course (코스)

  • crs_id (코드 ID) — Primary key — NOT NULL — auto_increment
  • crs_dcd (코스 구분코드)
  • crs_nm (코스명)
  • crs_typ (코스 타입)
  • crs_env_cd (코스 환경 코드)
  • crs_shp_cd (코스 형태 코드)
  • crs_grd (난이도)
  • strt_pt_adrs (시작지점주소)
  • end_pt_adrs (종료지점주소)
  • tot_dist (총 거리)
  • tot_ele (총 고도)
  • usr_id (원작자) — Foreign key → User.id

CourseLike (추천한 코스)

  • id — Primary key — NOT NULL
  • usr_id (유저id) — Foreign key → User.id — NOT NULL
  • crs_id (코드 ID) — Foreign key → Course.crs_id — NOT NULL — auto_increment

CoursePoint (코스 GPX)

  • gpx_seq — Primary key — NOT NULL
  • crs_id (코스 아이디) — Foreign key → Course.crs_id — NOT NULL
  • lat (위도)
  • lon (경도)
  • ele (높이)

CourseReview (Untitled2)

  • Key — Primary key — NOT NULL
  • crs_id (코드 ID) — Foreign key → Course.crs_id — NOT NULL — auto_increment
  • usr_id (유저 ID) — Foreign key → User.id — NOT NULL

CourseReviewKeyword (Untitled3)

  • Key — Primary key — NOT NULL
  • Field

Facility (편의시설)

  • fclt_id (Key) — Primary key — NOT NULL
  • crs_id (코스) — Foreign key → Course.crs_id — NOT NULL
  • fclt_cd (편의시설 코드)
  • fclt_yn (편의시설 존재 여부)
  • fclt_adrs (편의시설 주소)
  • lat (Field)
  • lon (Field2)

FeedBack (피드백)

  • Key — Primary key — NOT NULL
  • usr_id (유저id) — Foreign key → User.id — NOT NULL
  • fdbk_typ (피드백 타입) — WITHDRAWAL (”회원탈퇴 사유”), REPORT(”신고하기”), FEEDBACK(”개선제안”)
  • ttl (타이틀)
  • cnt (내용)

Post (게시글)

  • id — Primary key — NOT NULL
  • usr_id (유저id) — Foreign key → User.id — NOT NULL
  • post_id (코스 id)
  • ttl (제목)
  • cont (내용)
  • post_type (게시물 타입)

Record (기록)

  • rec_id (기록id) — Primary key — NOT NULL — auto_increment
  • rec_nm (기록명)
  • tot_dist (총 거리)
  • tot_tm (총 시간)
  • tot_ele (총 고도)
  • pace (페이스)

RecordPoint (기록 Point)

  • gpx_seq — Primary key — NOT NULL
  • rec_id (Key) — Foreign key → Record.rec_id — NOT NULL
  • lat (위도)
  • lon (경도)
  • ele (높이)
  • tm (시간)

User (유저)

  • id — Primary key — NOT NULL
  • email (Field)
  • usr_nm (유저명)
  • scl_dcd (소셜 코드) — 0001 : 카카오, 0002: 네이버
  • usr_dcd (유저구분코드)