soccer

Tables (15)

DEFEAT_USER (패배유저)

  • id (고유번호) — int — Primary key — NOT NULL
  • record_id (게임정보) — int — Foreign key → RECORD.id — NOT NULL
  • member_id (해당유저) — int — Foreign key → MEMBER.id — NOT NULL

MATCH (매치)

  • id (고유번호) — int — Primary key — NOT NULL
  • matching_team_id_A (매치팀1) — int — Foreign key → MATCHING_TEAM.id — NOT NULL
  • matching_team_id_B (매치팀2) — int — Foreign key → MATCHING_TEAM.id — NOT NULL
  • schedule_id (매칭일정) — int — Foreign key → SCHEDULE.id — NOT NULL
  • state (상태) — number(2)

MATCHING_TEAM (매칭 팀(요청))

  • id (고유번호) — int — Primary key — NOT NULL
  • resolver_id (에약자) — int — Foreign key → MEMBER.id — NOT NULL
  • team_id (예약팀) — int — Foreign key → TEAM.id — NOT NULL
  • schedule_id (스케줄번호) — int — Foreign key → SCHEDULE.id — NOT NULL
  • state (상태) — number(3)
  • request_date (요청날짜) — date
  • shoes_count (신발갯수) — int
  • vest_count (조끼갯수) — int
  • ball_count (공갯수) — int
  • avg_point (평균점수) — int
  • opponent (상대팀매칭번호) — int

MEMBER (맴버)

  • id (고유번호) — int — Primary key — NOT NULL
  • memberid (유저아이디) — varchar2(60)
  • memberpw (비밀번호) — varhcar2(256)
  • email (이메일) — varchar2(60)
  • phone (휴대폰) — varchar2(30)
  • create_at (생성날짜) — date
  • last_login_at (마지막로그인날짜) — date
  • thumbnail (썸네일) — varchar2(256)
  • point (유저점수) — int
  • rolename (권한) — varchar2(30)
  • enabled (활성화) — number(1)

RECORD (게임결과)

  • id (고유번호) — int — Primary key — NOT NULL
  • winner_team_id (이긴팀) — int — Foreign key → TEAM.id — NOT NULL
  • loser_team_id (진팀) — int — Foreign key → TEAM.id — NOT NULL
  • match_id (매치번호) — int — Foreign key → MATCH.id — NOT NULL

RECRUITMENT_POST (구인글)

  • id (고유번호) — int — Primary key — NOT NULL
  • team_id (팀번호) — int — Foreign key → TEAM.id — NOT NULL
  • writer_id (작성자) — int — Foreign key → MEMBER.id — NOT NULL
  • title (제목) — varchar2(100)
  • content (내용) — varchar2(2000)
  • write_date (작성일) — date
  • hits (조회수) — int

RECRUITMENT_REPLY (덧글)

  • id (고유번호) — int — Primary key — NOT NULL
  • post_id (글번호) — int — Foreign key → RECRUITMENT_POST.id — NOT NULL
  • wirter_id (작성자) — int — Foreign key → MEMBER.id — NOT NULL
  • content (내용) — varchar2(2000)
  • write_date (작성일자) — date

REVIEW_REQUEST (리뷰 요청)

  • id (고유번호) — int — Primary key — NOT NULL
  • state (상태) — int
  • target_member_id (타겟유저아이디) — int — Foreign key → MEMBER.id — NOT NULL
  • target_team_id (타겟팀아이디) — int — Foreign key → TEAM.id — NOT NULL
  • target_matching_team_id (타겟매칭팀아이디) — int — Foreign key → MATCHING_TEAM.id — NOT NULL

SCHEDULE (일정)

  • id (고유번호) — int — Primary key — NOT NULL
  • stadium_id (구장) — int — Foreign key → STADIUM.id — NOT NULL
  • owner_id (구장주) — int — Foreign key → MEMBER.id — NOT NULL
  • start_ime (사용시작시간) — int
  • end_time (사용종료시간) — int
  • price (가격) — int
  • game_date (날짜) — date

STADIUM (구장)

  • id (고유번호) — int — Primary key — NOT NULL
  • owner (소유주) — int — Foreign key → MEMBER.id — NOT NULL
  • name (구장이름) — varchar2(60)
  • type (구장종류) — number(2)
  • original_thumbnail (원본제목) — varchar2(256)
  • thumbnail (썸네일) — varchar2(256)
  • description (구장설명) — varchar2(1024)
  • rental_shoes (신발대여여부) — number(1)
  • rental_vest (조끼대여여부) — number(1)
  • rental_ball (공대여여부) — number(1)
  • address (주소) — varchar2(500)

TEAM (팀)

  • id (고유번호) — int — Primary key — NOT NULL
  • leader_id (팀장) — int — Foreign key → MEMBER.id — NOT NULL
  • team_icon (팀아이콘) — varchar2(256)
  • original_icon (원본아이콘이름) — varchar2(256)
  • team_descriptsion (팀설명) — varchar2(200)
  • team_name (팀이름) — varchar2(60)

TEAM_INVITE (팀 초대)

  • id (고유번호) — int — Primary key — NOT NULL
  • team_id (팀번호) — int — Foreign key → TEAM.id — NOT NULL
  • addressee_id (수신자) — int — Foreign key → MEMBER.id — NOT NULL
  • answer (답상태) — int

TEAM_MEMBER (팀 맴버)

  • id (고유번호) — int — Primary key — NOT NULL
  • team_id (소속팀) — int — Foreign key → TEAM.id — NOT NULL
  • member_id (유저번호) — int — Foreign key → MEMBER.id — NOT NULL

TEAM_REVIEW (팀 리뷰)

  • id (고유번호) — int — Primary key — NOT NULL
  • writer_id (작성자) — int — Foreign key → MEMBER.id — NOT NULL
  • team_id (해당팀) — int — Foreign key → TEAM.id — NOT NULL
  • content (내용) — varchar2(1000)
  • offensive (공격력) — int
  • defensive (수비력) — int
  • manner (매너력) — int
  • strength (체력) — int
  • dribble (드리블) — int
  • speed (속력) — int
  • pass (패스) — int
  • shot (슛팅) — int

WIN_USER (승리유저)

  • id (고유번호) — int — Primary key — NOT NULL
  • reocrd_id (게임정보) — int — Foreign key → RECORD.id — NOT NULL
  • member_id (해당유저) — int — Foreign key → MEMBER.id — NOT NULL