KoreaIT_project02

Tables (8)

User (유저테이블)

  • userid (id) — Primary key — NOT NULL
  • userpw (비번)
  • username (이름)
  • usernick (닉네임)
  • zipcode (우편번호)
  • addr (주소)
  • addrdetail (주소상세)
  • addretc (참조사항)
  • email (이메일)
  • phone (전화번호)
  • duedate (회원권날짜)

admin_reservation (예약(관리자) 테이블)

  • rv_num (번호) — Primary key — NOT NULL
  • rv_date (일자)
  • rv_time (시간)
  • rv_title (과목)

ex_board (운동지식공유)

  • ex_num (번호) — Primary key — NOT NULL
  • userid (id) — Foreign key → User.userid — NOT NULL
  • ex_title (제목)
  • ex_date (일자)
  • ex_contents (내용)
  • ex_like (추천)
  • view_cnt (조회수)

exc_comment (운동지식댓글)

  • exc_num (번호) — Primary key — NOT NULL
  • ex_num (번호2) — Foreign key → ex_board.ex_num — NOT NULL
  • exc_writer (작성자)
  • exc_contents (내용)
  • exc_date (일자)
  • exc_like (추천)

f_board (자유게시판)

  • b_num (번호) — Primary key — NOT NULL
  • userid (id) — Foreign key → User.userid — NOT NULL
  • b_title (제목)
  • b_date (일자)
  • b_contents (내용)
  • b_like (추천)
  • view_cnt (조회수)

f_comment (자판댓글)

  • c_num (번호) — Primary key — NOT NULL
  • b_num (번호2) — Foreign key → f_board.b_num — NOT NULL
  • c_writer (작성자)
  • c_contents (내용)
  • c_date (일자)
  • c_like (추천)

notice (공지사항)

  • notice_num (번호) — Primary key — NOT NULL
  • notice_title (제목)
  • notice_contents (내용)
  • notice_date (일자)
  • view_cnt (조회수)

reservation (예약테이블)

  • userid (id) — Foreign key → User.userid — NOT NULL
  • rv_num (번호) — Foreign key → admin_reservation.rv_num — NOT NULL