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