Karman

Tables (8)

Affiliation (소속 선수)

  • affiliation_id (선수 ID) — UUID — Primary key — NOT NULL
  • player_name (선수명) — VARCHAR — NOT NULL
  • back_number (등번호) — INT4 — NOT NULL
  • player_position (포지션) — VARCHAR — NOT NULL
  • match_count (출전 경기 수) — INT8 — NOT NULL
  • goal (득점) — INT8 — NOT NULL
  • assist (어시스트) — INT8 — NOT NULL
  • clear (걷어내기) — INT8 — NOT NULL
  • point (포인트) — NUMERIC — NOT NULL
  • player_role (클럽 권한) — VARCHAR — NOT NULL
  • join_status (가입상태) — VARCHAR — NOT NULL
  • created_at (생성일자) — TIMESTAMP
  • updated_at (수정일자) — TIMESTAMP
  • member_id (회원 ID) — UUID — Foreign key → Member.member_id
  • club_id (클럽ID) — UUID — Foreign key → Club.club_id — NOT NULL

Club (클럽(팀))

  • club_id (클럽ID) — UUID — Primary key — NOT NULL
  • club_name (클럽명) — VARCHAR — NOT NULL
  • area (지역) — VARCHAR — NOT NULL
  • club_age_group (연령대) — VARCHAR — NOT NULL
  • foundation_date (창단일) — TIMESTAMP — NOT NULL
  • created_at (생성일자) — TIMESTAMP
  • updated_at (수정일자) — TIMESTAMP
  • member_id (회원 ID) — UUID — Foreign key → Member.member_id — NOT NULL

Match (매치(경기))

  • match_id (매치ID) — UUID — Primary key — NOT NULL
  • opponent (매치 상대) — VARCHAR — NOT NULL
  • scored_goal (득점) — INT8 — NOT NULL
  • conceded_goal (실점) — INT8 — NOT NULL
  • location (경기 장소) — VARCHAR
  • match_date (경기 일자) — TIMESTAMP — NOT NULL
  • weather (날씨) — VARCHAR — NOT NULL
  • match_result (경기결과) — VARCHAR — NOT NULL
  • created_at (생성일자) — TIMESTAMP
  • updated_at (수정일자) — TIMESTAMP
  • club_id (클럽ID) — UUID — Foreign key → Club.club_id — NOT NULL

MatchGoal (골 기록)

  • match_goal_id (골 기록 ID) — UUID — Primary key — NOT NULL
  • scorer_name (득점자 명) — VARCHAR — NOT NULL
  • scorer_affiliation_id (득점 선수 ID) — UUID
  • assist_name (도움자 명) — VARCHAR
  • assist_affiliation_id (도움 선수 ID) — UUID
  • createdAt (생성일자) — TIMESTAMP
  • updatedAt (수정일자) — TIMESTAMP
  • match_id (매치 ID) — UUID — Foreign key → MatchQuarter.match_id — NOT NULL
  • quarter (쿼터) — INT4 — Foreign key → MatchQuarter.quarter — NOT NULL

MatchLineup (라인업)

  • match_lineup_id (라인업 ID) — UUID — Primary key — NOT NULL
  • name (이름) — VARCHAR — NOT NULL
  • affiliation_id (선수 ID) — UUID
  • position_number (포지션 위치 번호) — INT4 — NOT NULL
  • club_player_position (뛴 포지션) — VARCHAR — NOT NULL
  • is_sub (선발/후보 여부) — BOOLEAN — NOT NULL
  • createdAt (생성일자) — TIMESTAMP
  • updatedAt (수정일자) — TIMESTAMP
  • match_id (매치 ID) — UUID — Foreign key → MatchQuarter.match_id — NOT NULL
  • quarter (쿼터) — INT4 — Foreign key → MatchQuarter.quarter — NOT NULL

MatchQuarter (쿼터)

  • quarter (쿼터) — INT4 — Primary key — NOT NULL
  • match_id (매치 ID) — UUID — Foreign key → Match.match_id — NOT NULL
  • match_formation (포메이션) — VARCHAR — NOT NULL
  • scored_goal (득점) — INT8 — NOT NULL
  • conceded_goal (실점) — INT8 — NOT NULL
  • createdAt (생성일자) — TIMESTAMP
  • updatedAt (수정일자) — TIMESTAMP

Member (회원(선수))

  • member_id (회원 ID) — UUID — Primary key — NOT NULL
  • email (이메일) — VARCHAR — NOT NULL
  • password (비밀번호) — VARCHAR — NOT NULL
  • name (이름) — VARCHAR — NOT NULL
  • age (나이) — INT4 — NOT NULL
  • weight (몸무게) — NUMERIC — NOT NULL
  • height (신장) — NUMERIC — NOT NULL
  • role (권한) — VARCHAR — NOT NULL
  • created_at (생성일자) — TIMESTAMP
  • updated_at (수정일자) — TIMESTAMP

TacticalDocuments (전술 문서)

  • id (전술 문서 ID) — UUID — Primary key — NOT NULL
  • content (문서 텍스트 내용) — TEXT — NOT NULL
  • metadata (메타 데이터) — JSONB — NOT NULL
  • embedding (임베딩 데이터) — VECTOR — NOT NULL