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`