Last_last_last_pjt
Tables (18)
ChatLog (채팅로그)
- chatlog_id (id) — Primary key — NOT NULL
- Charroom_id (id2) — Foreign key → ChatRoom.Charroom_id — NOT NULL
- 사용자명 (username)
- 메세지 (message)
- 작성시간 (time)
ChatRoom (채팅방)
- Charroom_id (id) — Primary key — NOT NULL
- trainer_id (id2) — Foreign key → Trainer.trainer_id — NOT NULL
- Client_id (id4) — Foreign key → Client.Client_id — NOT NULL
- 채팅번호 (roomId)
Client (클라이언트)
- Client_id (id) — Primary key — NOT NULL
- user_id (id2) — Foreign key → User.user_id — NOT NULL
- tag_id (id3) — Foreign key → Tag.tag_id — NOT NULL
- 이름 (name)
- 나이 (age)
- 성별 (gender)
Notification (알림)
- notification_id (id) — Primary key — NOT NULL
- program_id (id2) — Foreign key → Program.program_id — NOT NULL
- Client_id (id3) — Foreign key → Client.Client_id — NOT NULL
- 룸아이디 (webrtcroomId)
- 봤는지확인 (is_view)
Program (프로그램)
- program_id (id) — Primary key — NOT NULL
- trainer_id (id2) — Foreign key → Trainer.trainer_id — NOT NULL
- tag_id (id3) — Foreign key → Tag.tag_id — NOT NULL
- 유형 (_type)
- 제목 (title)
- 소개 (content)
- 조회수 (visit_count)
- 썸네일 (thumb_img)
ProgramPayment (프로그램 결제)
- programPayment_ID (id1) — Primary key — NOT NULL
- Client_id (id) — Foreign key → Client.Client_id — NOT NULL
- program_id (id2) — Foreign key → Program.program_id — NOT NULL
- 결제금액 (price)
- 결제시간 (created_at)
ProgramPrice (프로그램 세부정보)
- programprice_id (id) — Primary key — NOT NULL
- program_id (id2) — Foreign key → Program.program_id — NOT NULL
- 제목 (title)
- 온라인횟수 (online_count)
- 오프라인횟수 (offline_count)
ProgramRecord (프로그램회원관리)
- programRecord_id (id) — Primary key — NOT NULL
- program_id (id2) — Foreign key → Program.program_id — NOT NULL
- programprice_id (id3) — Foreign key → ProgramPrice.programprice_id — NOT NULL
- Client_id (id4) — Foreign key → Client.Client_id — NOT NULL
- 만료됬는지 (is_active)
- 최대 온라인수업횟수 (max_online_count)
- 최대 오프라인 수업회수 (max_offline_count)
- 현재까지 들은 온라인횟수 (now_online_count)
- 현재까지 들은 오프라인 횟수 (now_offline_count)
- 생성시간 (created_at)
ProgramRecordDetail (프로그램회원출석날짜 관리)
- programrecorddetail_id (id) — Primary key — NOT NULL
- programRecord_id (id2) — Foreign key → ProgramRecord.programRecord_id — NOT NULL
- 수업타입 (_type)
- 내용 (content)
- 생성시간 (created_at)
ProgramReservationDay (프로그램 예약날짜)
- programreservationday_id (id) — Primary key — NOT NULL
- program_id (id2) — Foreign key → Program.program_id — NOT NULL
- 날짜 (day)
ProgramReservationTime (프로그램예약시간)
- programReservationTime (id) — Primary key — NOT NULL
- programreservationday_id (id2) — Foreign key → ProgramReservationDay.programreservationday_id — NOT NULL
- Client_id (id3) — Foreign key → Client.Client_id — NOT NULL
- 시작시간 (start_hour)
- 종료시간 (end_hour)
- 예약생성시간 (created_at)
ProgramSchedule (온라인프로그램 스케쥴)
- programschedule_id (id) — Primary key — NOT NULL
- program_id (id2) — Foreign key → Program.program_id — NOT NULL
- 요일 (day)
- 시작시간 (start_hour)
- 종료시간 (end_hour)
ProgramWebRtc (온라인프로그램 WebRtc)
- programwebrtc_id (id) — Primary key — NOT NULL
- program_id (id2) — Foreign key → Program.program_id — NOT NULL
- 룸아이디 (webrtcroomId)
- 생성시기 (create_at)
Tag (태그)
- tag_id (id) — Primary key — NOT NULL
- 이름 (name)
Trainer (트레이너)
- trainer_id (id) — Primary key — NOT NULL
- user_id (id2) — Foreign key → User.user_id — NOT NULL
- tag_id (id3) — Foreign key → Tag.tag_id — NOT NULL
- 이름 (name)
- 나이 (age)
- 성별 (gender)
- 소개 (content)
- 주소 (address)
TrainerSchedule (트레이너 스케쥴)
- trainerSchedule (id) — Primary key — NOT NULL
- trainer_id (id2) — Foreign key → Trainer.trainer_id — NOT NULL
- 요일 (day)
- 시작시간 (start_hour)
- Field2 (end_hour)
User (유저)
- user_id (id) — Primary key — NOT NULL
- 유저네임 (username)
- 유저구별 (is_first)
UserProfile (유저프로필)
- userprofile_id (id) — Primary key — NOT NULL
- user_id (id2) — Foreign key → User.user_id — NOT NULL
- 이미지경로 (profile_img)