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