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