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