EverySports

Tables (17)

auth (유저 역할)

  • u_pk (유저pk) — not null — Foreign key → user.u_pk — NOT NULL
  • auth (역할) — not null

chat (채팅)

  • r_pk (채팅방 pk) — not null — Foreign key → chatRoom.r_pk — NOT NULL
  • u_pk (유저pk) — not null — Foreign key → chatRoom.u_pk — NOT NULL
  • r_text (채팅대화) — null
  • r_time (채팅시간) — not null

chatAttach (첨부파일)

  • ca_uuid (고유식별자) — not null — Primary key — NOT NULL
  • r_pk (채팅방 pk) — not null — Foreign key → chat.r_pk — NOT NULL
  • u_pk (유저pk) — not null — Foreign key → chat.u_pk — NOT NULL
  • ca_name (첨부파일 이름) — not null
  • ca_path (첨부파일 경로) — not null
  • ca_type (첨부파일 타입) — not null

chatRoom (채팅방)

  • r_pk (채팅방 pk) — not null — Primary key — NOT NULL
  • u_pk (유저pk) — not null — Foreign key → user.u_pk — NOT NULL

class (클래스 테이블)

  • c_pk (강의 pk) — not null — Primary key — NOT NULL
  • c_name (강의명) — not null
  • c_startTime (강의시작시간) — not null
  • c_endTime (강의종료시간) — not null
  • c_day1 (강의요일) — not null
  • c_day2 (강의요일2) — not null
  • c_day3 (강의요일3) — not null
  • c_price (가격정책) — not null
  • c_curriculum (커리큘럼) — not null
  • c_refund (환불정책) — not null
  • c_num (클래스누적수강생) — not null
  • c_likeNum (클래스 좋아요수) — not null

classAttach (클래스 사진)

  • ca_uuid (프로필사진 식별자) — not null — Primary key — NOT NULL
  • ca_name (클래스사진 이름) — not null
  • ca_path (클래스사진 경로) — not null
  • c_pk (강의 pk) — not null — Foreign key → class.c_pk — NOT NULL

homework (숙제)

  • h_pk (숙제 pk) — not null — Primary key — NOT NULL
  • h_name (숙제명) — not null
  • h_link (숙제링크) — not null
  • h_info (숙제 설명) — not null
  • c_pk (강의 pk) — not null — Foreign key → class.c_pk — NOT NULL

homeworkAttach (숙제 첨부파일)

  • ha_uuid (숙제 식별자) — not null — Primary key — NOT NULL
  • ha_name (제출한 숙제 이름) — not null
  • ha_path (제출한 숙제 경로) — not null
  • uh_pk (유저숙제pk) — not null — Foreign key → userHomework.uh_pk — NOT NULL
  • h_pk (숙제 pk) — not null — Foreign key → userHomework.h_pk — NOT NULL

homeworkResult (숙제결과)

  • uh_pk (유저숙제pk) — not null — Foreign key → userHomework.uh_pk — NOT NULL
  • h_pk (숙제 pk) — not null — Foreign key → userHomework.h_pk — NOT NULL
  • hr_score (숙제 점수) — not null
  • hr_feedback (피드백) — not null

likeClass (클래스 좋아요)

  • u_pk (유저pk) — not null — Foreign key → user.u_pk — NOT NULL
  • c_pk (강의 pk) — not null — Foreign key → class.c_pk — NOT NULL

point (포인트)

  • u_pk (유저pk) — not null — Foreign key → user.u_pk — NOT NULL
  • point (포인트) — not null

review (후기)

  • re_pk (리뷰pk) — not null — Primary key — NOT NULL
  • re_title (리뷰 제목) — not null
  • re_content (리뷰 내용) — not null
  • u_pk (유저pk2) — not null — Foreign key → userClass.u_pk — NOT NULL
  • c_pk (강의 pk2) — not null — Foreign key → userClass.c_pk — NOT NULL

teacherNum (강사누적수강생)

  • u_pk (유저pk) — not null — Foreign key → userClass.u_pk — NOT NULL
  • t_num (강사누적수강생) — not null

user (유저테이블)

  • u_pk (유저pk) — not null — Primary key — NOT NULL
  • u_id (아이디) — not null
  • u_pw (패스워드) — not null
  • u_name (유저 이름) — not null
  • u_gender (성별) — not null
  • u_email (이메일) — not null
  • u_content (유저 정보) — not null

userAttach (프로필사진)

  • ua_uuid (프로필사진 식별자) — not null — Primary key — NOT NULL
  • ua_name (프로필사진 이름) — not null
  • ua_path (프로필사진 경로) — not null
  • u_pk (유저pk) — not null — Foreign key → user.u_pk — NOT NULL

userClass (유저 + 클래스)

  • u_pk (유저pk) — not null — Foreign key → user.u_pk — NOT NULL
  • c_pk (강의 pk) — not null — Foreign key → class.c_pk — NOT NULL

userHomework (유저 + 숙제)

  • uh_pk (유저숙제pk) — not null — Primary key — NOT NULL
  • h_pk (숙제 pk) — not null — Foreign key → homework.h_pk — NOT NULL
  • u_pk (유저pk) — not null — Foreign key → userClass.u_pk — NOT NULL
  • c_pk (강의 pk) — not null — Foreign key → userClass.c_pk — NOT NULL