BallPick
Tables (16)
ADMIN
- ADMIN_ID — NUMBER — Primary key — NOT NULL — 관리자코드
- ADMIN_NAME — VARCHAR2(50) — NOT NULL — 관리자이름
- ADMIN_EMAIL — VARCHAR2(40) — NOT NULL — 관리자이메일
- ADMIN_TEL — VARCHAR2(30) — NOT NULL — 관리자 전화번호
- ID — VARCHAR2(50) — NOT NULL — 관리자아이디
- PASSWORD — VARCHAR2(30) — NOT NULL — 관리자비밀번호
- ACCOUNT_DATE — DATE — NOT NULL — 계정 생성일자
CONNECTION_LOG
- MEMBER_ID — VARCHAR2(50) — Foreign key → MEMBER.MEMBER_ID — NOT NULL — 아이디
- IP_ADDRESS — VARCHAR2(20) — NOT NULL — IP주소
- CONNECTION_DATE — DATE — NOT NULL — 접속일
EVENT
- EVENT_ID — NUMBER — Primary key — NOT NULL — 이벤트코드
- ADMIN_ID — NUMBER — Foreign key → ADMIN.ADMIN_ID — NOT NULL — 관리자코드
- EVENT_TITLE — VARCHAR2(100) — NOT NULL — 이벤트제목
- EVENT_SUMMARY — VARCHAR2(255) — NOT NULL — 이벤트요약
- EVENT_CONTENT — VARCHAR2(255) — NOT NULL — 이벤트내용
- Thumbnail_IMG — VARCHAR2(50) — NOT NULL — 썸네일 이미지
- Representative_IMG — VARCHAR2(50) — NOT NULL — 대표이미지
- EVENT_START_DATE — DATE — NOT NULL — 시작일자
- EVENT_END_DATE — DATE — NOT NULL — 종료일자
- EVENT_WRITE_DATE — DATE — NOT NULL — 작성일자
EVENT_DISCOUNT
- DISCOUNT_RULE_CODE — NUMBER — Primary key — NOT NULL — 할인규칙코드
- EVENT_ID — NUMBER — Foreign key → EVENT.EVENT_ID — NOT NULL — 이벤트코드
- TEAM_ID — NUMBER — Foreign key → TEAM.TEAM_ID — NOT NULL — 팀 코드
- EVENT_DISCOUNT_RATE — NUMBER — NOT NULL — 할인율
GAME_RECORD
- GAME_RECORD_ID — NUMBER — Primary key — NOT NULL — 팀 경기기록코드
- TEAM_ID — NUMBER — Foreign key → TEAM.TEAM_ID — NOT NULL — 팀 코드
- GMAE_CNT — NUMBER — 경기수
- WIN_CNT — NUMBER — 승 횟수
- LOSE_CNT — NUMBER — 패 횟수
- DRAW_CNT — NUMBER — 무 횟수
- WIN_RATE — NUMBER(5,3) — 승률
- SCORE_GAP — NUMBER — 게임차
- RECORD_DATE — DATE — 일자
GAME_SCHEDULE
- GAME_SCHEDULE_ID — NUMBER — Primary key — NOT NULL — 경기일정코드
- STADIUM_ID — NUMBER — Foreign key → STADIUM.STADIUM_ID — NOT NULL — 구장 코드
- TEAM_HOME — NUMBER — Foreign key → TEAM.TEAM_ID — NOT NULL — 홈팀 코드
- TEAM_OTHER — NUMBER — Foreign key → TEAM.TEAM_ID — NOT NULL — 원정팀 코드
- GAME_DATE — DATE — NOT NULL — 경기일자
- SALE_START_DATE — VARCHAR2(5) — NOT NULL — 경기시작시간
- SALE_STATE — VARCHAR2(10) — NOT NULL — 판매상태
- Match_registration_date — DATE — NOT NULL — 경기등록일자
INQUIRY
- INQUIRY_ID — NUMBER — Primary key — NOT NULL — 문의코드
- MEMBER_ID — VARCHAR2(50) — Foreign key → MEMBER.MEMBER_ID — NOT NULL — 아이디
- INQUIRY_TITLE — VARCHAR2(100) — NOT NULL — 제목
- INQUIRY_CONTENT — VARCHAR2(255) — NOT NULL — 내용
- REPLY_CONTENT — VARCHAR2(255) — 답변내용
- INQUIRY_DATE — DATE — NOT NULL — 등록일자
- REPLY_DATE — DATE — 답변일자
INQUIRY_CATEGORY
- INQUIRY_CATEGORY_ID — NUMBER — Primary key — NOT NULL — 문의유형코드
- ADMIN_ID — NUMBER — Foreign key → ADMIN.ADMIN_ID — 관리자코드
- INQUIRY_ID — NUMBER — Foreign key → INQUIRY.INQUIRY_ID — 문의코드
- INQUIRY_TYPE — VARCHAR2(10) — 문의종류
MEMBER
- MEMBER_ID — VARCHAR2(50) — Primary key — NOT NULL — 아이디
- NAME — VARCHAR2(50) — NOT NULL — 이름
- grade_name — VARCHAR2(20) — NOT NULL — 등급이름
- EMAIL — VARCHAR2(40) — NOT NULL — 이메일
- PASS — VARCHAR2(30) — NOT NULL — 비밀번호
- PHONE — VARCHAR2(30) — NOT NULL — 휴대폰번호
- ZIPCODE — NUMBER — NOT NULL — 우편주소
- ADDRESS — VARCHAR2(255) — NOT NULL — 주소
- ADDRESS2 — VARCHAR2(255) — 상세주소
- STATE — VARCHAR2(10) — NOT NULL — 상태
- JOIN_DATE — DATE — NOT NULL — 가입일
- SNS_RECEIVE_YN — CHAR — NOT NULL — SNS수신여부
- EMAIL_RECEIVE_YN — CHAR — NOT NULL — 이메일 수신여부
PAYMENT
- PAYMENT_CODE — NUMBER — Primary key — NOT NULL — 결제코드
- RESERVATION_ID — NUMBER — Foreign key → RESERVATION.RESERVATION_ID — NOT NULL — 예매코드
- PG_INFO — VARCHAR2(3000) — NOT NULL — PG정보
- PG_INFO2 — VARCHAR2(3000) — NOT NULL — PG정보2
RESERVATION
- RESERVATION_ID — NUMBER — Primary key — NOT NULL — 예매코드
- MEMBER_ID — VARCHAR2(50) — Foreign key → MEMBER.MEMBER_ID — NOT NULL — 아이디
- ADMIN_ID — NUMBER — Foreign key → ADMIN.ADMIN_ID — NOT NULL — 관리자코드
- RESERVATION_DATE — DATE — NOT NULL — 예매일
- TOTAL_PRICE — NUMBER — NOT NULL — 총금액
- DISCOUNT_PRICE — NUMBER — NOT NULL — 할인금액
- PAY_PRICE — NUMBER — NOT NULL — 결제금액
- CANCEL_PRICE — NUMBER — NOT NULL — 취소금액
- RESERVATION_STATUS — VARCHAR2(10) — NOT NULL — 예매상태
- PAY_STATE — VARCHAR2(10) — NOT NULL — 결제상태
RESERVATION_CENCEL
- CANCEL_ID — NUMBER — Primary key — NOT NULL — 취소코드
- RESERVATION_ID — NUMBER — Foreign key → RESERVATION.RESERVATION_ID — NOT NULL — 예매코드
- CANCEL_TYPE — VARCHAR2(10) — NOT NULL — 취소구분
- CANCEL_DATE — DATE — NOT NULL — 취소일자
STADIUM
- STADIUM_ID — NUMBER — Primary key — NOT NULL — 구장 코드
- STADIUM_NAME — VARCHAR2(50) — NOT NULL — 구장명
- STADIUM_ADDR — VARCHAR2(255) — NOT NULL — 주소
- STADIUM_REGION — VARCHAR2(255) — NOT NULL — 지역
STADIUM_SEAT
- STADIUM_SEAT_ID — NUMBER — Primary key — NOT NULL — 구장좌석코드
- STADIUM_ID — NUMBER — Foreign key → STADIUM.STADIUM_ID — NOT NULL — 구장 코드
- SEAT_NAME — VARCHAR2(30) — NOT NULL — 좌석명
- ADULT_SEAT_PRICE — NUMBER — NOT NULL — 성인좌석가격
- YOUTH_SEAT_PRICE — NUMBER — NOT NULL — 청소년좌석가격
- CHILD_SEAT_PRICE — NUMBER — NOT NULL — 어린이좌석가격
- STADIUM_SEAT_COUNT — NUMBER — NOT NULL — 좌석수
TEAM
- TEAM_ID — NUMBER — Primary key — NOT NULL — 팀 코드
- TEAM_registration_date — DATE — NOT NULL — 팀 등록일
- TEAM_NAME — VARCHAR2(100) — NOT NULL — 팀명
- TEAM_LOGO_IMG — VARCHAR2(50) — 팀로고 이미지 경로
reservation_detail
- reservation_detail_ID — NUMBER — Primary key — NOT NULL — 예매상세코드
- RESERVATION_ID — NUMBER — Foreign key → RESERVATION.RESERVATION_ID — NOT NULL — 예매코드
- STADIUM_SEAT_ID — NUMBER — Foreign key → STADIUM_SEAT.STADIUM_SEAT_ID — NOT NULL — 구장좌석코드
- RESERVATION_TYPE — VARCHAR2(10) — NOT NULL — 연령구분
- RESERVATION_QUANTITY — NUMBER — NOT NULL — 예매수량