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