Main_ERD Table

Tables (27)

Club_join_requests

  • request_num — number — Primary key — NOT NULL
  • user_num — number — Foreign key → 회원.User Number — NOT NULL
  • club_num — number — Foreign key → Clubs.club_num — NOT NULL
  • status — number(1) — NOT NULL
  • requested_at — date — NOT NULL
  • processed_at — date
  • request_message — varchar2(4000)

Club_members

  • club_num — number — Foreign key → Clubs.club_num — NOT NULL
  • user_num — number — Foreign key → 회원.User Number — NOT NULL
  • reg_date — date — NOT NULL
  • status — number(1) — NOT NULL
  • role — number(1) — NOT NULL

Clubs

  • club_num — number — Primary key — NOT NULL
  • name — varchar2(50) — NOT NULL
  • region — varchar2(20) — NOT NULL
  • (tier_score) — number(4) — NOT NULL
  • desc — varchar2(4000)
  • max_member — number(2) — NOT NULL
  • reg_date — date — NOT NULL
  • photo — varchar2(4000)
  • status — number(1) — NOT NULL
  • user_num — number — Foreign key → 회원.User Number — NOT NULL
  • updated_at — date

Comment

  • Key (comment_num) — number(5) — Primary key — NOT NULL
  • board_num — number(2) — Foreign key → Post.board_num — NOT NULL
  • user_num — number — Foreign key → 회원.User Number — NOT NULL
  • club_num — number — Foreign key → Clubs.club_num — NOT NULL
  • content — varchar2(4000) — NOT NULL
  • reg_date (create_at) — date — NOT NULL
  • updated_at — date

Inquiry

  • Inq_num (inquiry_num) — number — Primary key — NOT NULL
  • user_num — number — Foreign key → 회원.User Number — NOT NULL
  • Title (title) — varchar2(50) — NOT NULL
  • Content (content) — varchar2(4000) — NOT NULL
  • Answer (answer) — varchar2(50) — NOT NULL
  • Status — number(1) — NOT NULL
  • created_at — date — NOT NULL
  • answered_at — date

MOM_Votes

  • Vote_ID — number — Primary key — NOT NULL
  • Match_num — number — Foreign key → Matches.Match_num — NOT NULL
  • voter_id — number — Foreign key → 회원.User Number — NOT NULL
  • Target_user_id — number — Foreign key → 회원.User Number — NOT NULL
  • created_at — date — NOT NULL

Manner_Votes

  • Manner_ID — number — Primary key — NOT NULL
  • Match_num — number — Foreign key → Matches.Match_num — NOT NULL
  • voter_id — number — Foreign key → 회원.User Number — NOT NULL
  • Target_user_id — number — Foreign key → 회원.User Number — NOT NULL
  • created_at — date — NOT NULL

Match_attendance

  • roster_num — number — Primary key — NOT NULL
  • Match_num — number — Foreign key → Matches.Match_num — NOT NULL
  • club_num — number — Foreign key → Clubs.club_num — NOT NULL
  • user_num — number — Foreign key → 회원.User Number — NOT NULL
  • status — number(1) — NOT NULL

Match_players_records

  • record_num — number — Primary key — NOT NULL
  • Match_num — number — Foreign key → Matches.Match_num — NOT NULL
  • user_num — number — Foreign key → 회원.User Number — NOT NULL
  • goal — number(2) — NOT NULL
  • assist — number(2) — NOT NULL
  • yellow_card (yellow_cards) — number(2) — NOT NULL
  • red_cards — number(2) — NOT NULL
  • reg_date — date — NOT NULL

Match_result

  • result_num — number — Primary key — NOT NULL
  • Match_num — number — Foreign key → Matches.Match_num — NOT NULL
  • home_score — number(2) — NOT NULL
  • away_score — number(2) — NOT NULL
  • win_club — number — Foreign key → Clubs.club_num — NOT NULL
  • ref_num — number — Foreign key → Referee.ref_num — NOT NULL
  • Recorded_at — date — NOT NULL

Match_review

  • Review_num (review_num) — number — Primary key — NOT NULL
  • Match_num (match_num) — number — Foreign key → Matches.Match_num — NOT NULL
  • user_num — number — Foreign key → 회원.User Number — NOT NULL
  • club_num (target_club_num) — number — Foreign key → Clubs.club_num — NOT NULL
  • Rating — number(1) — NOT NULL
  • Content — varchar2(4000) — NOT NULL
  • created_at — date — NOT NULL

Matches

  • Match_num — number — Primary key — NOT NULL
  • user_num — number — Foreign key → 회원.User Number — NOT NULL
  • res_num — number — Foreign key → Stadium_res.res_num — NOT NULL
  • status — number(1) — NOT NULL
  • home_num — number — Foreign key → Clubs.club_num — NOT NULL
  • away_num — number — Foreign key → Clubs.club_num
  • Pnum — number(2)
  • Match_title — varchar2(100) — NOT NULL
  • tier — number(1) — NOT NULL
  • ref_num — number — Foreign key → Referee.ref_num — NOT NULL

Member_item

  • Key (member_item_num) — number(5) — Primary key — NOT NULL
  • Item_ID (item_num) — number(2) — Foreign key → Point_item.Item_ID — NOT NULL
  • user_num — number — Foreign key → 회원.User Number — NOT NULL
  • Field (purchased_at) — date — NOT NULL
  • Field2 (status) — number — NOT NULL

Notice

  • Notice_num (notice_num) — number — Primary key — NOT NULL
  • Title (title) — varchar2(50) — NOT NULL
  • Content (content) — varchar2(4000) — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date

Notification

  • Noti_num (notification_num) — number(2) — Primary key — NOT NULL
  • user_num — number — Foreign key → 회원.User Number — NOT NULL
  • Title (title) — varchar2(50) — NOT NULL
  • Content (content) — varchar2(4000) — NOT NULL
  • Noti_type (notification_type) — number(1) — NOT NULL
  • Is_read (is_read) — number(1) — NOT NULL
  • created_at — date — NOT NULL

Point_item

  • Item_ID (item_num) — number(2) — Primary key — NOT NULL
  • Item_name (item_name) — varchar2(50) — NOT NULL
  • Item_DESC (item_description) — varchar2(2000) — NOT NULL
  • Price_point (price_point) — number(7) — NOT NULL
  • status — number(1) — NOT NULL

Point_transaction

  • Transaction_ID (transaction_num) — number(5) — Primary key — NOT NULL
  • user_num — number — Foreign key → 회원.User Number — NOT NULL
  • Field (point_amount) — number(7) — NOT NULL
  • Transaction_type (transaction_type) — number(1) — NOT NULL
  • Description (description) — varchar2(2000) — NOT NULL
  • created_at — date — NOT NULL

Post

  • board_num — number(2) — Primary key — NOT NULL
  • user_num — number — Foreign key → 회원.User Number — NOT NULL
  • club_num — number — Foreign key → Clubs.club_num
  • category — number(1) — NOT NULL
  • title — varchar2(50) — NOT NULL
  • content — varchar2(4000) — NOT NULL
  • view — number(5) — NOT NULL
  • reg_date (create_at) — date — NOT NULL
  • updated_at — date

Referee

  • ref_num — number — Primary key — NOT NULL
  • user_num — number — Foreign key → 회원.User Number — NOT NULL
  • stadium_num — number — Foreign key → Stadium.stadium_num — NOT NULL

Report

  • Report_num (report_num) — number — Primary key — NOT NULL
  • reporter_ID (user_num) — number — Foreign key → 회원.User Number — NOT NULL
  • Target_ID (target_id) — number — Foreign key → 회원.User Number — NOT NULL
  • Target_type (report_type) — number(1) — NOT NULL
  • reason — varchar2(4000) — NOT NULL
  • status — number(1) — NOT NULL
  • created_at — date — NOT NULL
  • processed_date — date
  • Field (response) — varchar2(4000)

Stadium

  • stadium_num — number — Primary key — NOT NULL
  • name — varchar2(100) — NOT NULL
  • address — varchar2(400) — NOT NULL
  • photo — varchar2(4000) — NOT NULL
  • status — number(1) — NOT NULL
  • desc — varchar2(4000)
  • phone — varchar2(15) — NOT NULL
  • type — number(1) — NOT NULL
  • open_time — number(2) — NOT NULL
  • close_time — number(2) — NOT NULL
  • fee — number(7) — NOT NULL
  • ref_num — number — Foreign key → Referee.ref_num — NOT NULL

Stadium_res

  • res_num — number — Primary key — NOT NULL
  • stadium_num — number — Foreign key → Stadium.stadium_num — NOT NULL
  • user_num — number — Foreign key → 회원.User Number — NOT NULL
  • res_date — date — NOT NULL
  • res_time — date — NOT NULL
  • status — number(1)
  • ref_num — number — Foreign key → Referee.ref_num — NOT NULL

User_position

  • Position_Id — number — Primary key — NOT NULL
  • position — number(1) — NOT NULL
  • is_primary — number(1) — NOT NULL
  • created_at — date — NOT NULL
  • user_num — number — Foreign key → 회원.User Number — NOT NULL

ZBoard_chatroom

  • chatroom_num — number — Primary key — NOT NULL
  • board_num — number(2) — Foreign key → Post.board_num — NOT NULL
  • writer_num — number — Foreign key → 회원.User Number — NOT NULL
  • reader_num — number — Foreign key → 회원.User Number — NOT NULL
  • room_date — Date — NOT NULL

match_applications

  • apply_num — number — Primary key — NOT NULL
  • Match_num — number — Foreign key → Matches.Match_num — NOT NULL
  • club_num — number — Foreign key → Clubs.club_num — NOT NULL
  • status — number(1) — NOT NULL
  • Applied_at — date — NOT NULL
  • Processed_at — date

zboard_chat

  • chat_num — number(2) — Primary key — NOT NULL
  • chatroom_num — number — Foreign key → ZBoard_chatroom.chatroom_num — NOT NULL
  • user_num — number — Foreign key → 회원.User Number — NOT NULL
  • message — varchar2(4000) — NOT NULL
  • chat_date — date — NOT NULL
  • read_check — number(1) — NOT NULL

회원 (users)

  • User Number (user_num) — number — Primary key — NOT NULL — sequence
  • 로그인 아이디 (login_id) — varchar2(20) — NOT NULL
  • Password (passwd) — varchar2(255) — NOT NULL
  • name — varchar2(50) — NOT NULL
  • email — varchar2(100) — NOT NULL
  • address1 (address_basic) — varchar2(200) — NOT NULL
  • address2 (address_detail) — varchar2(200) — NOT NULL
  • zipcode — varchar2(5) — NOT NULL
  • profile_image — varchar2(4000)
  • gender — number — NOT NULL
  • phone — varchar2(15) — NOT NULL
  • point_balance — number(15) — NOT NULL
  • status — number(1) — NOT NULL
  • role — number(1) — NOT NULL
  • birth_date — date — NOT NULL
  • tier_score — number(4) — NOT NULL
  • suspended_until — date
  • last_login_at — date
  • created_at — date — NOT NULL
  • updated_at — date
  • nickname — varchar2(30) — NOT NULL
  • stadium_id — number(5)