CrossfitRanker

Tables (5)

Box (박스)

  • code (코드) — Primary key — NOT NULL
  • name (박스 이름)
  • addr (주소)

Record (기록)

  • id (Key) — Primary key — NOT NULL
  • wod_id (와드id) — Foreign key → Wod.wod_id — NOT NULL
  • user_id (사용자id) — Foreign key → user.user_id — NOT NULL
  • record (기록)
  • reg_date (등록일자)

Wod (와드)

  • wod_id (id) — Primary key — NOT NULL
  • wod_type (와드 유형)
  • title (와드 제목)
  • wod (와드)
  • partner (파트너)
  • time_cap (제한시간)
  • group_code (그룹코드)
  • reg_date (등록일자)

challenge (챌린지)

  • id — Primary key — NOT NULL
  • user_id (사용자) — Foreign key → user.user_id — NOT NULL
  • work_type (운동타입)
  • record (기록)

user (사용자)

  • user_id (id) — Primary key — NOT NULL
  • nickname (닉네임)
  • code (박스코드) — Foreign key → Box.code — NOT NULL
  • sex (성별)