경기별 지표 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)