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 — 프로필이미지