peakle

테이블 (9)

게시판 (boards)

  • id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → 유저.id — NOT NULL
  • title — VARCHAR(45) — NOT NULL
  • writer — VARCHAR(45) — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • view_cnt — INT — NOT NULL
  • created — TIMESTAMP
  • INDEX — `fk_board_user_idx`

게시판 댓글 (board_reviews)

  • id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → 유저.id — NOT NULL
  • board_id — INT — 외래 키 → 게시판.id — NOT NULL
  • writer — VARCHAR(45) — NOT NULL
  • content — VARCHAR(200) — NOT NULL
  • created — TIMESTAMP
  • INDEX — `fk_board_review_user_idx`
  • INDEX — `fk_board_review_board_idx`

리뷰(클라이밍장) (reviews)

  • id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → 유저.id — NOT NULL
  • facility_id — INT — 외래 키 → 클라이밍장.id — NOT NULL
  • title — VARCHAR(45) — NOT NULL
  • writer — VARCHAR(45) — NOT NULL
  • content — VARCHAR(200) — NOT NULL
  • rating — INT — NOT NULL
  • created — TIMESTAMP
  • INDEX — `fk_user_has_facility_facility2_idx`
  • INDEX — `fk_user_has_facility_user2_idx`

운동 기록 (my_records)

  • id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → 유저.id — NOT NULL
  • facility_id — INT — 외래 키 → 클라이밍장.id — NOT NULL
  • title — VARCHAR(45) — NOT NULL
  • writer — VARCHAR(45) — NOT NULL
  • content — VARCHAR(200) — NOT NULL
  • created — TIMESTAMP
  • record — VARCHAR(200)
  • rating — INT
  • INDEX — `fk_user_has_facility_facility3_idx`
  • INDEX — `fk_user_has_facility_user3_idx`

유저 (users)

  • id — INT — 기본 키 — NOT NULL
  • user_id — VARCHAR(45) — NOT NULL
  • password — VARCHAR(45) — NOT NULL
  • name — VARCHAR(45) — NOT NULL
  • email — VARCHAR(45) — NOT NULL
  • phone_number — VARCHAR(45) — NOT NULL
  • birth — DATE — NOT NULL
  • manager — INT — NOT NULL
  • created — TIMESTAMP

좋아요(클라이밍장) (likes)

  • facility_id — INT — 외래 키 → 클라이밍장.id — NOT NULL
  • user_id — INT — 외래 키 → 유저.id — NOT NULL
  • INDEX — `fk_user_has_facility_facility1_idx`
  • INDEX — `fk_user_has_facility_user1_idx`

클라이밍장 (facilities)

  • id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(45) — NOT NULL
  • lat — DECIMAL(10,8) — NOT NULL
  • lng — DECIMAL(11,8) — NOT NULL
  • address — VARCHAR(250) — NOT NULL
  • phone_number — VARCHAR(45) — NOT NULL
  • is_closed — INT — NOT NULL
  • img — VARCHAR(500)
  • created — TIMESTAMP
  • updated — DATETIME
  • user_id — INT — 외래 키 → 유저.id — NOT NULL
  • INDEX — `fk_facility_user1_idx`

클라이밍장 세부정보 (facility_features)

  • facility_id — INT — 외래 키 → 클라이밍장.id — NOT NULL
  • difficulty — INT
  • bouldering — INT
  • leads — INT
  • footwash — INT
  • bodywash — INT
  • INDEX — `fk_facility_feature_facility1_idx`

혼잡도 (crowds)

  • id — INT — 기본 키 — NOT NULL
  • rating — INT
  • created — TIMESTAMP
  • manager — INT — NOT NULL
  • facility_id — INT — 외래 키 → 클라이밍장.id — NOT NULL
  • user_id — INT — 외래 키 → 유저.id — NOT NULL
  • INDEX — `fk_evaluation_facility_idx`
  • INDEX — `fk_crowd_user_idx`