test
Tables (9)
ATTENDANCE (출석)
- id (출석 ID) — bigserial — Primary key
- match_id (매치 ID) — bigint
- player_id (시합 ID) — bigint
- attend_status (출석상태) — varchar
- note (비고) — varchar
- created_at (생성일) — timestamp
- updated_at (수정일) — timestamp
- use_yn (사용여부) — varchar
FEE (회비)
- id (회비 ID) — bigserial — Primary key
- player_id (선수 ID) — bigint
- fee_amount (납부 금액) — int
- fee_date (납부 일자) — date
- status (납부 상태) — varchar
- note (비고) — varchar
- created_at (생성일) — timestamp
- updated_at (수정일) — timestamp
- use_yn (사용여부) — varchar
- Field
GROUND (구장)
- id (구장 ID) — bigserial — Primary key
- name (구장 이름) — varchar
- location (위치(주소/지역)) — varchar
- field_width (경기장 너비(m)) — int
- field_length (경기장 길이(m)) — int
- players_per_team (팀당 인원수) — int
- rental_fee (구장대여비) — int
- created_at (생성일) — timestamp
- updated_at (수정일) — timestamp
- use_yn (사용여부) — varchar
MATCH (경기)
- id (매치 ID) — bigserial — Primary key
- team_id (팀 ID) — bigint — Foreign key → TEAM.id
- ground_id (구장 ID) — bitint — Foreign key → GROUND.id
- opponent_team_id (상대팀 ID) — bigint — Foreign key → OPPONENT_TEAM.id
- match_at (매치 일시) — timestamp
- status (경기 상태) — varchar
- our_score (우리팀 점수) — int
- opponent_score (상대팀 점수) — int
- created_at (생성일) — timestamp
- updated_at (수정일) — timestamp
- result (경기 결과) — varchar
- use_yn (사용여부) — varchar
MATCH_VIDEO (매치영상)
- id (매치영상 ID) — bigserial — Primary key
- match_id (시합 ID) — bigint
- video_url (영상 URL) — varchar
- created_at (생성일) — timestamp
- use_yn (사용여부) — varchar
MEMBER (회원)
- id (멤버ID) — bigserial — Primary key
- email (사용자ID) — varchar
- password (비밀번호) — varchar
- name (이름) — varchar
- birth_date (생년월일) — date
- phone (핸드폰번호) — varchar
- role (권한) — varchar
- created_at (생성일) — timestamp
- updated_at (수정일) — timestamp
- created_id (생성자) — varchar
- updated_at (수정자) — varchar
- withdrawn_at (탈퇴일) — timestamp
- login_fail_cnt (로그인 실패 횟수) — int
- locked (잠금여부) — bool
- locked_at (잠금시간) — timestamp
OPPONENT_TEAM (상대팀)
- id (상대팀 ID) — bigserial — Primary key
- name (상대팀 명) — varchar
- contact_info (연락처 정보) — varchar
- skill_level (체감 실력) — varchar
- note (비고) — varchar
- created_at (생성일) — timestamp
- updated_at (수정일) — timestamp
- use_yn (사용여부) — varchar
PLAYER (선수)
- id (플레이어 ID) — bigserial — Primary key
- team_id (팀 ID) — bigint — Foreign key → TEAM.id
- member_id (멤버ID) — bigint — Foreign key → MEMBER.id
- name (선수명) — varchar
- birth_date (생년월일) — DATE
- position (포지션) — varchar
- back_number (등번호) — int
- status (선수상태) — varchar
- last_attended_at (마지막 출석일) — date
- joined_at (팀 합류일) — date
- plyaer_type (선수 유형) — varchar
- created_at (생성일) — timestamp
- updated_at (수정일) — timestamp
- use_yn (사용여부) — varcahr
TEAM (팀)
- id (탐 ID) — bigserial — Primary key
- name (팀 이름) — varchar
- status (팀 상태) — varchar
- founded_at (창단일) — date
- description (팀 설명) — varchar
- created_at (생성일) — timestamp
- updated_at (수정일) — timestamp
- use_yn (사용여부) — varchar