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)