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