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 — 예매수량