gym
Tables (26)
auth
- member_id — varchar(100) — Foreign key → member.member_id — NOT NULL
- member_auth — varchar(100)
bus
- bus_no — int(11) — Primary key — NOT NULL
- bus_driver — varchar(100) — NOT NULL
- bus_limited — int(11) — NOT NULL
cart
- lecture_no — varchar(50) — Primary key — NOT NULL
- user_id — varchar(100) — Foreign key → user.member_id — NOT NULL
- create_date — datetime — NOT NULL
comment
- comment_no — int(11) — Primary key — NOT NULL
- employee_id — varchar(100) — Foreign key → employee.member_id — NOT NULL
- comment_content — varchar(100) — NOT NULL
- create_date — datetime — NOT NULL
consult
- consult_no — int(11) — Primary key — NOT NULL
- consultReservation_no — int(11) — Foreign key → consultReservation.consultReservation_no — NOT NULL
- employee_id — varchar(100) — Foreign key → employee.member_id — NOT NULL
- consult_content — text — NOT NULL
- create_date — datetime — NOT NULL
consultReservation
- consultReservation_no — int(11) — Primary key — NOT NULL
- user_id — varchar(100) — Foreign key → user.member_id — NOT NULL
- consult_date — datetime — NOT NULL
- create_date — datetime — NOT NULL
employee
- member_id — varchar(100) — Foreign key → member.member_id — NOT NULL
- create_date — datetime — NOT NULL
free_board
- board_no — int(11) — Primary key — NOT NULL
- member_id — varchar(100) — Foreign key → member.member_id — NOT NULL
- board_title — varchar(100) — NOT NULL
- board_contents — varchar(500) — NOT NULL
- board_read — int(11) — NOT NULL
- delete_yn — enum('Y','N')
- update_date — datetime — NOT NULL
- create_date — datetime — NOT NULL
free_board_cm
- cm_no — int(11) — Primary key — NOT NULL
- board_no — int(11) — Foreign key → free_board.board_no — NOT NULL
- member_id — varchar(100) — Foreign key → member.member_id — NOT NULL
- cm_contents — varchar(100)
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL
instructor
- member_id — varchar(100) — Foreign key → member.member_id — NOT NULL
- create_date — datetime — NOT NULL
- introduce — text
- inspectYn — enum('Y','N')
- deleteYn — enum('Y','N')
lecture
- lecture_no — varchar(50) — Primary key — NOT NULL
- instructor_id — varchar(100) — Foreign key → instructor.member_id — NOT NULL
- location_no — int(11) — Foreign key → location.location_no — NOT NULL
- lecture_name — varchar(100) — NOT NULL
- lecture_limited — int(11) — NOT NULL
- lecture_time — varchar(100) — NOT NULL
- lecture_price — int(11) — NOT NULL
- lecture_startDate — date — NOT NULL
- lecture_endDate — date — NOT NULL
lectureday
- lecture_day — varchar(100) — Primary key — NOT NULL
- lecture_no — varchar(50) — Foreign key → lecture.lecture_no — NOT NULL
location
- location_no — int(11) — Primary key — NOT NULL
- lecture_addr — varchar(100) — NOT NULL
- create_date — datetime — NOT NULL
locker
- locker_no — int(11) — Primary key — NOT NULL
- course_no — int(11) — Foreign key → payment.course_no — NOT NULL
- locker_price — int(11) — NOT NULL
member
- member_no — int(11) — Primary key — NOT NULL
- member_id — varchar(100) — NOT NULL
- member_pw — varchar(100) — NOT NULL
- member_name — varchar(100) — NOT NULL
- member_phone — varchar(100)
- member_email — varchar(100) — NOT NULL
- member_addr — varchar(100) — NOT NULL
- member_detailAddr — varchar(100)
- member_birth — varchar(100)
- member_gender — enum('F','M') — NOT NULL
- member_sleepYn — enum('Y','N') — NOT NULL
- last_login — datetime — NOT NULL
- update_date — datetime — NOT NULL
- create_date — datetime — NOT NULL
- delete_yn — enum('Y','N') — NOT NULL
- pw_change_date — datetime — NOT NULL
memberImg
- member_id — varchar(100) — Foreign key → member.member_id — NOT NULL
- file_name — varchar(100) — NOT NULL
- originalFile_name — varchar(100)
- file_type — varchar(100) — NOT NULL
- file_size — int(11)
notice
- notice_no — int(11) — Primary key — NOT NULL
- employee_id — varchar(100) — Foreign key → employee.member_id — NOT NULL
- notice_title — varchar(100) — NOT NULL
- notice_content — varchar(100) — NOT NULL
- notice_read — int(11) — NOT NULL
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL
noticefile
- noticeFile_no — int(11) — Primary key — NOT NULL
- notice_no — int(11) — Foreign key → notice.notice_no — NOT NULL
- file_name — varchar(100) — NOT NULL
- originalFile_name — varchar(100) — NOT NULL
- file_type — varchar(100) — NOT NULL
- file_size — int(11) — NOT NULL
outid
- out_id — varchar(100) — Primary key — NOT NULL
- out_date — datetime — NOT NULL
payment
- course_no — int(11) — Primary key — NOT NULL
- user_id — varchar(100) — Foreign key → user.member_id — NOT NULL
- locker_no — int(11)
- lecture_no — varchar(50) — NOT NULL
- pay_method — varchar(100) — NOT NULL
- pay_date — datetime — NOT NULL
- refund — enum('Y','N') — NOT NULL
- pay_price — int(11)
race
- race_no — int(11) — Primary key — NOT NULL
- bus_no — int(11) — Foreign key → bus.bus_no — NOT NULL
- route_no — int(11) — Foreign key → route.route_no — NOT NULL
rent
- reservation_date — datetime — Primary key — NOT NULL
- rent_place — varchar(100) — Foreign key → rentplace.rent_place — NOT NULL
- user_id — varchar(100) — Foreign key → user.member_id — NOT NULL
- create_date — datetime — NOT NULL
- refund — enum('Y','N') — NOT NULL
rentplace
- rent_place — varchar(100) — Primary key — NOT NULL
- rent_price — int(11) — NOT NULL
- rent_limited — int(11) — NOT NULL
review
- review_no — int(11) — Primary key — NOT NULL
- course_no — int(11) — Foreign key → payment.course_no — NOT NULL
- lecture_no — varchar(50) — Foreign key → lecture.lecture_no — NOT NULL
- review_writer — varchar(50) — Foreign key → member.member_id — NOT NULL
- review_content — varchar(100) — NOT NULL
- create_date — datetime — NOT NULL
route
- route_no — int(11) — Primary key — NOT NULL
- route_start — time — NOT NULL
- route_end — time — NOT NULL
- route_interval — varchar(100) — NOT NULL
- bus_stop — varchar(100) — NOT NULL
user
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
- create_date — datetime — NOT NULL