경기별 지표 DW

테이블 (8)

Activity (Untitled3)

  • activity_id (Key) — 기본 키 — NOT NULL
  • team_id (Key3) — 외래 키 → Team.team_id — NOT NULL
  • stadium_id (Key2) — 외래 키 → Stadium.stadium_id — NOT NULL
  • team_id (Field2)
  • activity_type (Field3)
  • activity_name (Field4)
  • activity_start_time (Field6)
  • activity_end_time (Field7)
  • service (Field)

Activity Data Summary (Untitled7)

  • data_id (Key2) — 외래 키 → Activity-Data-Player.data_id — NOT NULL
  • activity_id (Key3) — 외래 키 → Activity-Data-Player.activity_id — NOT NULL
  • player_id (Key4) — 외래 키 → Activity-Data-Player.player_id — NOT NULL
  • player_id (Field2)
  • total_distance (Field4)
  • ... (Field5)
  • service (Field)

Activity-Data-Player (Untitled4)

  • data_id (Key2) — 기본 키 — NOT NULL
  • activity_id (Key3) — 외래 키 → Activity.activity_id — NOT NULL
  • player_id (Key) — 외래 키 → Player.player_id — NOT NULL
  • service (Field3)

Player (Untitled2)

  • player_id (Key) — 기본 키 — NOT NULL
  • playe_name (Field2)
  • player_number (Field3)
  • nationality (Field4)
  • position (Field5)
  • service (Field)

Session (Untitled5)

  • session_id (Key) — 기본 키 — NOT NULL
  • activity_id (Key2) — 외래 키 → Activity.activity_id — NOT NULL
  • session_name (Field2)
  • session_start_time (Field3)
  • session_end_time (Field4)
  • service (Field)

Session Data Summary (Untitled6)

  • data_id (Key2) — 외래 키 → Activity-Data-Player.data_id — NOT NULL
  • activity_id (Key3) — 외래 키 → Activity-Data-Player.activity_id — NOT NULL
  • player_id (Key4) — 외래 키 → Activity-Data-Player.player_id — NOT NULL
  • session_id (Field3)
  • total_distance (Field5)
  • ... (Field6)
  • service (Field2)

Stadium (Untitled8)

  • stadium_id (Key) — 기본 키 — NOT NULL
  • stadium_name (Field)
  • service (Field2)

Team (Untitled)

  • team_id (Key) — 기본 키 — NOT NULL
  • team_name (Field2)
  • team_country (Field3)
  • team_division (Field4)
  • team_gender (Field5)
  • team_age_group (Field6)
  • service (Field)