tennis
Tables (14)
Team_join_tb (Untitled3)
- Team_join_idx (Key) — Primary key — NOT NULL
- Field
- Field2
Team_tb (Untitled2)
- Team_idx (Key) — Primary key — NOT NULL
- TeamName (Field)
- TeamImage (Field2)
- Field3
ath_game_tb
- PK (game_idx) — INT(11) — Primary key — NOT NULL
- club_board_idx — INT(11) — Foreign key → ath_match_tb.클럽보드PK — NOT NULL
- 호스트1 (host_idx1) — INT(11) — NOT NULL
- 호스트2 (host_idx2) — INT(11)
- 게스트1 (guest_idx1) — INT(11) — NOT NULL
- 게스트2 (guest_idx2) — INT(11)
- 호스트점수 (host_score) — INT(11) — NOT NULL
- 게스트점수 (guest_score) — INT(11) — NOT NULL
ath_match_tb
- 클럽보드PK (club_board_idx) — INT(11) — Foreign key → club_board_tb.PK — NOT NULL
- 작성자 (user_idx) — INT(11) — Foreign key → user_tb.PK — NOT NULL
- 참여자수 (user_cnt) — INT(11) — NOT NULL
- 타입(단,복) (match_type) — CHAR(1)
- 게임수 (game_cnt) — INT(11) — NOT NULL
- 코트수 (court_cnt) — INT(11) — NOT NULL
- 생성날짜 (create_dt) — DATETIME — NOT NULL
board_tb
- PK (board_idx) — INT(11) — Primary key — NOT NULL
- 유저PK (user_idx) — INT(11) — Foreign key → user_tb.PK — NOT NULL
- 게시물 제목 (board_title) — VARCHAR(200)
- 게시물 내용 (board_contents) — TEXT — NOT NULL
- 생성날짜 (create_dt) — DATETIME — NOT NULL
- 수정날짜 (update_dt) — DATETIME — NOT NULL
- 삭제여부 (use_yn) — CHAR(1) — NOT NULL
board_upload_tb
- PK (upload_idx) — INT(11) — Primary key — NOT NULL
- 게시물PK (board_idx) — INT(11) — Foreign key → board_tb.PK — NOT NULL
- 이미지경로 (upload_path) — VARCHAR(200) — NOT NULL
- 생성날짜 (create_dt) — DATETIME — NOT NULL
- 수정날짜 (update_dt) — DATETIME
- 삭제여부 (use_yn) — CHAR(1) — NOT NULL
club_board_join_tb (Untitled)
- PK (club_board_join_idx) — INT(11) — Primary key — NOT NULL
- 클럽보드 (club_board_idx) — INT(11) — Foreign key → club_board_tb.PK — NOT NULL
- 생성날짜 (create_dt) — DATETIME
- 유저PK (user_idx) — INT(11) — Foreign key → user_tb.PK — NOT NULL
club_board_reply_tb
- PK (club_reply_idx) — INT(11) — Primary key — NOT NULL
- 클럽보드 (club_board_idx) — INT(11) — Foreign key → club_board_tb.PK — NOT NULL
- 작성자 (writer_idx) — INT(11) — NOT NULL
- 댓글내용 (reply_contents) — TEXT — NOT NULL
- 생성날짜 (create_dt) — DATETIME — NOT NULL
- 수정날짜 (update_dt) — DATETIME — NOT NULL
- 삭제여부 (use_yn) — CHAR(1) — NOT NULL
club_board_tb
- PK (club_board_idx) — INT(11) — Primary key — NOT NULL
- 작성자 (user_idx) — INT(11) — Foreign key → user_tb.PK — NOT NULL
- 클럽 (club_idx) — INT(11) — Foreign key → club_tb.PK — NOT NULL
- 타입 (club_board_type) — CHAR(2) — NOT NULL
- 게시물 제목 (club_board_title) — VARCHAR(200)
- 게시물 내용 (club_board_contents) — TEXT — NOT NULL
- 모집 인원 (wanted_cnt) — INT(11) — NOT NULL
- 생성날짜 (create_dt) — DATETIME — NOT NULL
- 수정날짜 (update_dt) — DATETIME — NOT NULL
- 삭제여부 (use_yn) — CHAR(1) — NOT NULL
club_board_upload_tb
- PK (upload_idx) — INT(11) — Primary key — NOT NULL
- 클럽보드 (club_board_idx) — INT(11) — Foreign key → club_board_tb.PK — NOT NULL
- 경로 (upload_path) — VARCHAR(200) — NOT NULL
- 생성날짜 (create_dt) — DATETIME — NOT NULL
- 삭제여부 (use_yn) — CHAR(1) — NOT NULL
club_join_tb
- PK (club_join_idx) — INT(11) — Primary key — NOT NULL
- 유저PK (user_idx) — INT(11) — Foreign key → user_tb.PK — NOT NULL
- 클럽PK (club_idx) — INT(11) — Foreign key → club_tb.PK — NOT NULL
- 등급 (club_grade) — VARCHAR(20) — NOT NULL
- 생성날짜 (create_dt) — DATETIME — NOT NULL
- 수정날짜 (update_dt) — DATETIME — NOT NULL
- 삭제여부 (use_yn) — CHAR(1) — NOT NULL
club_tb
- PK (club_idx) — INT(11) — Primary key — NOT NULL
- 클럽이름 (club_nm) — VARCHAR(20)
- 클럽정보 (club_info) — TEXT — NOT NULL
- 클럽주소 (club_city) — VARCHAR(20) — NOT NULL
- 세부주소 (club_county) — VARCHAR(20)
- 생성날짜 (create_dt) — DATETIME — NOT NULL
- 수정날짜 (update_dt) — DATETIME — NOT NULL
- 삭제여부 (use_yn) — CHAR(1) — NOT NULL
login_history_tb
- IP주소 (ip_address) — VARCHAR(16) — Primary key — NOT NULL
- 생성날짜 (create_dt) — DATETIME — Primary key — NOT NULL
- 유저PK (user_idx) — INT(11) — Foreign key → user_tb.PK — NOT NULL
user_tb
- PK (user_idx) — INT(11) — Primary key — NOT NULL
- 유저아이디 (user_id) — VARCHAR(20) — NOT NULL
- 유저패스워드 (user_pwd) — VARCHAR(50) — NOT NULL
- NTRP(실력) (user_ntrp) — DECIMAL(2,1)
- 성별 (user_gender) — CHAR(1) — NOT NULL
- 생성날짜 (create_dt) — DATETIME — NOT NULL
- 수정날짜 (update_dt) — DATETIME — NOT NULL
- 삭제여부 (use_yn) — CHAR(1) — NOT NULL