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