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