gymkkong view

Tables (16)

admin (관리자)

  • ID (관리자 ID) — int — Primary key — NOT NULL
  • name (관리자명) — varchar(255) — NOT NULL
  • email (이메일) — varchar(255) — NOT NULL
  • password (비밀번호) — varchar(255) — NOT NULL
  • type (관리자유형) — enum(admin, super-admin) — NOT NULL

attendence (출석)

  • ID (출석) — bigint — Primary key — NOT NULL
  • class_id (수업ID) — BIGINT — Foreign key → class.id — NOT NULL
  • member_id (회원ID) — BIGINT — Foreign key → member.id — NOT NULL
  • status (Field) — Enum('Y',N) — NOT NULL

class (강습)

  • id (수업ID) — BIGINT — Primary key — NOT NULL
  • trainer_id (트레[이너ID) — BIGINT — Foreign key → trainer.id — NOT NULL
  • room_id (room id) — bigint — Foreign key → room.id — NOT NULL
  • class_name (수업 이름) — varchar(255) — NOT NULL
  • start_time (수업 시작시간) — DATETIME — NOT NULL
  • capacity (정원) — int — NOT NULL

class_reservation (예약)

  • id (예약ID) — BIGINT — Primary key — NOT NULL
  • class_id (수업ID) — BIGINT — Foreign key → class.id — NOT NULL
  • member_id (회원ID) — BIGINT — Foreign key → member.id — NOT NULL
  • cancel_YN (취소여부) — ENUM(Y,N)

comment (댓글)

  • id (coment_id) — bigint — Primary key — NOT NULL
  • post_id — bigint — Foreign key → post.id
  • member_id (회원ID) — BIGINT — Foreign key → member.id
  • pt_id (지점별트레이너ID) — BIGINT — Foreign key → place_trainer.id — NOT NULL
  • contents (내용) — varchar(255) — NOT NULL
  • comment_day (댓글 작성 시간) — datetime — NOT NULL

member (회원)

  • id (회원ID) — BIGINT — Primary key — NOT NULL
  • name (이름) — varchar(255) — NOT NULL
  • email (이메일) — varchar(255) — NOT NULL
  • phone_num (휴대폰 번호) — varchar(255) — NOT NULL
  • age (나이) — varchar(255)
  • gender (성별) — enum('m','f')
  • grade (등급) — enum('브론즈'/골드/다이아')) — NOT NULL
  • status (탈퇴 유무) — enum('ACTIVE','INACTIVE;') — NOT NULL
  • password (비밀번호) — varchar(255) — NOT NULL

membership (회원권)

  • id (membership_id) — bigint — Primary key — NOT NULL
  • membership_optionid_ID (옵션) — int — Foreign key → membership_option.ID — NOT NULL
  • member_id (회원ID) — BIGINT — Foreign key → member.id — NOT NULL
  • refund_YN (환불유무) — Enum('y;,n'; — NOT NULL
  • remain_count (잔여개수) — INT — NOT NULL

membership_option (멤버쉽 타입 옵션)

  • ID (id) — int — Primary key — NOT NULL
  • place_id (지점ID) — BIGINT — Foreign key → place.id — NOT NULL
  • count (횟수) — int — NOT NULL
  • price (가격) — int — NOT NULL

payment (결제 내역)

  • id (payment_id) — bigint — Primary key — NOT NULL
  • membership_id — bigint — Foreign key → membership.id — NOT NULL
  • pay_price (결제 금액) — bigint — NOT NULL
  • pay_date (결제날짜) — DATETIME

place (지점)

  • id (지점ID) — BIGINT — Primary key — NOT NULL
  • name (지점명) — varchar(255) — NOT NULL
  • address (지점 주소) — varchar(255) — NOT NULL

place_trainer (지점별 트레이너)

  • id (지점별트레이너ID) — BIGINT — Primary key — NOT NULL
  • place_id (지점ID) — BIGINT — Foreign key → place.id — NOT NULL
  • trainer_id (트레[이너ID) — BIGINT — Foreign key → trainer.id — NOT NULL
  • status (트레이너 지점 탈퇴) — enum('ACTIVE',''INACTIVE') — NOT NULL

post (게시글)

  • id (post_id) — bigint — Primary key — NOT NULL
  • place_trainer_id (지점별트레이너ID) — BIGINT — Foreign key → place_trainer.id — NOT NULL
  • title (제목) — varchar — NOT NULL
  • contents (내용) — varchar(3000) — NOT NULL
  • post_day (게시글 작성 시간) — datetime — NOT NULL

refund (환불)

  • id (refund_id) — bigint — Primary key — NOT NULL
  • payment_id — bigint — Foreign key → payment.id — NOT NULL
  • refund_price (환불 금액) — bigint — NOT NULL
  • refund_date (환불날짜) — DATETIME

room (강습실)

  • id (room id) — bigint — Primary key — NOT NULL
  • place_id (지점ID) — BIGINT — Foreign key → place.id — NOT NULL
  • room_num (방번호) — int — NOT NULL

room_reserve (예약 조회 확인 테이블)

  • ID (예약조회ID) — bigint — Primary key — NOT NULL
  • place_trainer_id (지점별트레이너ID) — BIGINT — Foreign key → place_trainer.id — NOT NULL
  • room_id (room id) — bigint — Foreign key → room.id — NOT NULL
  • start_time (예약_시작_시간) — atetime — NOT NULL

trainer (트레이너)

  • id (트레[이너ID) — BIGINT — Primary key — NOT NULL
  • name (이름) — varchar(255) — NOT NULL
  • email (이메일) — varchar(255) — NOT NULL
  • phone_num (휴대폰번호) — varchar(255) — NOT NULL
  • password (비밀번호) — varchar(255) — NOT NULL
  • status (트레이너 계정 탈퇴) — enum('INACTIVE','INACTIVE') — NOT NULL