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