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)