test

테이블 (16)

ParticipatingPayment

  • p_pay_no — NUMBER — 기본 키 — NOT NULL
  • t_no — NUMBER — NOT NULL
  • b_no — NUMBER — NOT NULL
  • p_pay_date — DATE — NOT NULL
  • p_pay_amount — NUMBER — NOT NULL

Payment

  • pay_no — NUMBER — 기본 키 — NOT NULL
  • t_no — NUMBER — NOT NULL
  • pay_amount — NUMBER
  • pay_card_sort — VARCHAR(50)
  • pay_method — VARCHAR(50)
  • pay_approval — NUMBER
  • pay_date — NUMBER — NOT NULL

Payment1

  • pay_no — NUMBER — 기본 키 — NOT NULL
  • t_no — NUMBER — NOT NULL
  • b_no — NUMBER — NOT NULL
  • pay_date — DATE — NOT NULL
  • pay_amount — NUMBER — NOT NULL

PlayType

  • play_no — NUMBER — 기본 키 — NOT NULL
  • play_name — VARCHAR2(6) — NOT NULL

Review

  • r_no — NUMBER — 기본 키 — NOT NULL
  • pay_no — NUMBER — NOT NULL
  • t_no — NUMBER — NOT NULL
  • r_date — DATE — NOT NULL
  • r_content — VARCHAR(500)
  • r_winorlose — VARCHAR(10) — NOT NULL
  • r_mannerscore — NUMBER — NOT NULL

Team

  • team_no — NUMBER — 기본 키 — NOT NULL
  • user_no — NUMBER — 외래 키 → User.user_no — NOT NULL
  • team_name — VARCHAR(30) — NOT NULL
  • team_gender — VARCHAR2(6) — NOT NULL
  • team_prefer_local — VARCHAR2(10)
  • play_no — NUMBER
  • team_introduce — VARCHAR2(100)
  • team_uniform_color — VARCHAR2(5)
  • team_manner_score — NUMBER
  • team_matches — NUMBER
  • team_win_matches — NUMBER
  • team_lose_matches — NUMBER

TeamImg

  • team_img_no — NUMBER — 기본 키 — NOT NULL
  • team_no — NUMBER — NOT NULL
  • teamimg_origin_name — VARCHAR2(100) — NOT NULL
  • teamimg_stored_name — VARCHAR2(100) — NOT NULL
  • teamimg_type — VARCHAR2(100) — NOT NULL
  • teamimg_path — VARCHAR2(100) — NOT NULL
  • teamimg_size — NUMBER — NOT NULL

Telecom

  • telecom_no — NUMBER — 기본 키 — NOT NULL
  • telecom_name — VARCHAR2(20) — NOT NULL

User

  • user_no — NUMBER — 기본 키 — NOT NULL
  • user_id — VARCHAR2(100) — NOT NULL
  • user_pw — VARCHAR2(30) — NOT NULL
  • user_name — VARCHAR2(30) — NOT NULL
  • telecom_no — NUMBER — NOT NULL
  • user_phone — NUMBER — NOT NULL
  • user_birth — DATE — NOT NULL
  • user_signup — DATE — NOT NULL
  • user_gender — NUMBER — NOT NULL

ground

  • grd_no — NUMBER — 기본 키 — NOT NULL
  • grd_name — VARCHAR2(30) — NOT NULL
  • grd_loc — VARCHAR2(30) — NOT NULL
  • grd_event — VARCHAR2(30) — NOT NULL
  • grd_size — NUMBER — NOT NULL
  • grd_time1 — NUMBER — NOT NULL
  • grd_time2 — NUMBER — NOT NULL
  • grd_shower — NUMBER — NOT NULL
  • grd_park — NUMBER — NOT NULL
  • grd_shoes — NUMBER — NOT NULL
  • grd_wear — NUMBER — NOT NULL
  • grd_report — VARCHAR2(30) — NOT NULL
  • grd_pay — NUMBER — NOT NULL

ground_img

  • grd_imgno — NUMBER — 기본 키 — NOT NULL
  • grd_no — NUMBER — 외래 키 → ground.grd_no — NOT NULL
  • grd_img1 — VARCHAR2(30)
  • grd_img2 — VARCHAR2(30)
  • grd_img3 — VARCHAR2(30)
  • grd_img4 — VARCHAR2(30)
  • grd_img5 — VARCHAR2(30)

notice

  • not_no — NUMBER — 기본 키 — NOT NULL
  • not_title — VARCHAR — NOT NULL
  • not_content — VARCHAR — NOT NULL
  • not_date — DATE — NOT NULL

qna

  • qna_no — NUMBER — 기본 키 — NOT NULL
  • qna_title — VARCHAR — NOT NULL
  • qna_content — VARCHAR — NOT NULL
  • qna_date — DATE — NOT NULL

support

  • sup_no — NUMBER — 기본 키 — NOT NULL
  • qna_no — NUMBER — NOT NULL
  • sup_title — VARCHAR — NOT NULL
  • sup_content — VARCHAR — NOT NULL
  • sup_date — DATE — NOT NULL
  • usr_id — VARCHAR — NOT NULL
  • sup_state — NUMBER — NOT NULL

포인트충전 (PointCharge)

  • 포인트결제번호 (point_payment_no) — NUMBER — 기본 키 — NOT NULL
  • 결제일 (pay_date) — DATE — NOT NULL
  • 금액 (pay_sum) — NUMBER — NOT NULL
  • 팀번호 (team_no) — NUMBER — NOT NULL

환불 (Refund)

  • 환불번호 (refund_no) — NUMBER — 기본 키 — NOT NULL
  • 포인트결제번호 (point_payment_no) — NUMBER — 외래 키 → 포인트충전.포인트결제번호 — NOT NULL
  • 환불날짜 (refund_date) — DATE — NOT NULL
  • 환불수단 (refund_way) — VARCHAR2(10) — NOT NULL
  • 환불금액 (refund_cash) — NUMBER — NOT NULL
  • 결제번호 (payment_no) — NUMBER — NOT NULL
  • 환불요청날짜 (refund_please) — DATE — NOT NULL