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 (유저구분코드)