final-2-4
Tables (15)
Category (운동용품 카테고리)
- id — int — Primary key — NOT NULL
- name — varchar
Comment (커뮤니티 댓글)
- id — int — Primary key — NOT NULL
- commu_id (Community.id) — int — Foreign key → Community.id — NOT NULL
- comment_reply (self) — int — Foreign key → Comment.id — NOT NULL
- content — text
- created_at — datetime
Comment (운동용품 댓글)
- id — int — Primary key — NOT NULL
- recommend_id (Recommend.id) — int — Foreign key → Recommend.id — NOT NULL
- comment_reply (self) — int — Foreign key → Comment.id — NOT NULL
- content — text
- created_at — datetime
Community (커뮤니티 게시판)
- id — int — Primary key — NOT NULL
- record_id (Recod.id) — int — Foreign key → Record.id — NOT NULL
- user_id (User.id) — int — Foreign key → Record.user_id — NOT NULL
- title — varchar
- content — text
- created_at — datetime
- views — int
Course (달리기코스 게시판)
- id — int — Primary key — NOT NULL
- record_id (Record.id) — int — Foreign key → Record.id — NOT NULL
- user_id (User.id) — int — Foreign key → Record.user_id — NOT NULL
- title — varchar
- content — text
- created_at — datetime
- views — int
- likes — int
- tags (Tag) — int — Foreign key → Tag.id — NOT NULL
Kind (운동 분류)
- id — int — Primary key — NOT NULL
- name — varchar
Like (좋아요)
- id — int — Primary key — NOT NULL
- commu_id (Community.id) — int — Foreign key → Community.id — NOT NULL
- user_id (User.id) — int — Foreign key → Community.user_id — NOT NULL
- like — int
Like (좋아요-운동용품)
- id — int — Primary key — NOT NULL
- recommend_id (Recommend.id) — int — Foreign key → Recommend.id — NOT NULL
- user_id (User.id) — int — Foreign key → Recommend.user_id — NOT NULL
- like — int
Like (좋아요-달리기코스)
- id — int — Primary key — NOT NULL
- course_id (Course.id) — int — Foreign key → Course.record_id — NOT NULL
- user_id (User.id) — int — Foreign key → Course.user_id — NOT NULL
- like — int
Photo (인증샷)
- id — int — Primary key — NOT NULL
- record_id (Record.id) — int — Foreign key → Record.id — NOT NULL
- user_id (User.id) — int — Foreign key → Record.user_id — NOT NULL
- image — Image
Recommend (운동용품 추천 게시판)
- id — int — Primary key — NOT NULL
- user_id (User.id) — int — Foreign key → User.id — NOT NULL
- title — varchar
- content — text
- created_at — datetime
- views — int
- likes — int
- image — Image
- category (category.id) — int — Foreign key → Category.id — NOT NULL
Record (운동 Master)
- id — int — Primary key — NOT NULL
- user_id (User.id) — int — Foreign key → User.id — NOT NULL
- created_at — datetime
- last_update — datetime
- finished_at — datetime
- map — varchar — 정적지도 경로
- distance — varchar — 거리
- kind (Kind.id) — int — Foreign key → Kind.id — NOT NULL
RecordDetail (운동)
- id — int — Primary key — NOT NULL
- record_id (Record) — int — Foreign key → Record.id — NOT NULL
- id (id2) — int — Foreign key → Record.user_id — NOT NULL
- latitude — float — 위도
- longitude — float — 경도
- created_at — datetime
Tag (달리키코스 태그)
- id — int — Primary key — NOT NULL
- name — varchar
User (사용자)
- id — int — Primary key — NOT NULL
- email — email
- password — varchar
- nickname — varchar
- image — Image — 프로필이미지