publicdata
Tables (7)
Facility
- facility_id — INT
- name — VARCHAR(100) — NOT NULL
- type — VARCHAR(50) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- latitude — DECIMAL(10, 8) — NOT NULL
- longitude — DECIMAL(11, 8) — NOT NULL
- operation_hours — VARCHAR(100)
- is_indoor — BOOLEAN
- is_handicap_accessible — BOOLEAN
- homepage_url — VARCHAR(255)
Facility_Sport
- facility_sport_id — INT
- facility_id — INT — NOT NULL
- sport_id — INT — NOT NULL
Favorite
- favorite_id — INT
- user_id — INT — NOT NULL
- facility_id — INT — NOT NULL
- created_at — DATETIME
NFC100_Result
- nfc100_id — INT
- user_id — INT — NOT NULL
- measurement_date — DATE — NOT NULL
- fitness_grade — INT — NOT NULL
- recommend_sport_id — INT
Review
- review_id — INT
- user_id — INT — NOT NULL
- facility_id — INT — NOT NULL
- rating — DECIMAL(2, 1) — NOT NULL
- content — TEXT
- created_at — DATETIME
SportType
- sport_id — INT
- sport_name — VARCHAR(50) — NOT NULL
- difficulty_level — INT
User
- user_id — INT
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50)
- gender — CHAR(1) — NOT NULL
- age — INT — NOT NULL
- created_at — DATETIME