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