AITutor

Tables (7)

affiliation (AFFILIATION)

  • affiliationId (AFFILIATION_ID) — BIGINT — Primary key — NOT NULL — 소속 식별자
  • code (CODE) — VARCHAR(10) — 소속 코드
  • name (NAME) — VARCHAR(30) — 소속 이름
  • createdAt (CREATED_AT) — TIMESTAMP — NOT NULL — 생성일시
  • updatedAt (UPDATED_AT) — TIMESTAMP — 수정일시
  • deletedAt (DELETED_AT) — TIMESTAMP — 삭제일시

answer (ANSWER)

  • answerId (ANSWER_ID) — BIGINT — Primary key — NOT NULL — 답변 식별자
  • questionId (QUESTION_ID) — BIGINT — Foreign key → question.questionId — NOT NULL — 질문 식별자
  • content (CONTENT) — TEXT — 답변 내용
  • score (SCORE) — INT — 만족도
  • createdAt (CREATED_AT) — TIMESTAMP — NOT NULL — 생성일시
  • updatedAt (UPDATED_AT) — TIMESTAMP — 수정일시
  • deletedAt (DELETED_AT) — TIMESTAMP — 삭제일시

course (COURSE)

  • courseId (COURSE_ID) — BIGINT — Primary key — NOT NULL — 교과목 식별자
  • tutorId (TUTOR_ID) — BIGINT — Foreign key → user.userId — NOT NULL — 교수자 식별자
  • affiliationId (AFFILIATION_ID) — BIGINT — Foreign key → affiliation.affiliationId — NOT NULL — 소속 식별자
  • name (NAME) — VARCHAR(50) — 교과목 이름
  • description (DESCRIPTION) — TEXT — 교과목 설명
  • createdAt (CREATED_AT) — TIMESTAMP — NOT NULL — 생성일시
  • updatedAt (UPDATED_AT) — TIMESTAMP — 수정일시
  • deletedAt (DELETED_AT) — TIMESTAMP — 삭제일시

courseRegistration (COURSE_REGISTRATION)

  • courseRegistrationId (COURSE_REGISTRATION_ID) — BIGINT — Primary key — NOT NULL — 교과목 등록 식별자
  • tuteeId (TUTEE_ID) — BIGINT — Foreign key → user.userId — NOT NULL — 학습자 식별자
  • courseId (COURSE_ID) — BIGINT — Foreign key → course.courseId — NOT NULL — 교과목 식별자
  • createdAt (CREATED_AT) — TIMESTAMP — NOT NULL — 생성일시
  • updatedAt (UPDATED_AT) — TIMESTAMP — 수정일시
  • deletedAt (DELETED_AT) — TIMESTAMP — 삭제일시

feedback (FEEDBACK)

  • feedbackId (Key) — BIGINT — Primary key — NOT NULL — 피드백 식별자
  • answerId (ANSWER_ID) — BIGINT — Foreign key → answer.answerId — NOT NULL — 답변 식별자
  • content (CONTENT) — TEXT — 피드백 내용
  • createdAt (CREATED_AT) — TIMESTAMP — NOT NULL — 생성일시
  • updatedAt (UPDATED_AT) — TIMESTAMP — 수정일시
  • deletedAt (DELETED_AT) — TIMESTAMP — 삭제일시

question (QUESTION)

  • questionId (QUESTION_ID) — BIGINT — Primary key — NOT NULL — 질문 식별자
  • questionerId (QUESTIONER_ID) — BIGINT — Foreign key → user.userId — NOT NULL — 질문자 식별자
  • courseId (COURSE_ID) — BIGINT — Foreign key → course.courseId — NOT NULL — 교과목 식별자
  • content (CONTENT) — TEXT — 질문 내용
  • createdAt (CREATED_AT) — TIMESTAMP — NOT NULL — 생성일시
  • updatedAt (UPDATED_AT) — TIMESTAMP — 수정일시
  • deletedAt (DELETED_AT) — TIMESTAMP — 삭제일시

user (USER)

  • userId (USER_ID) — BIGINT — Primary key — NOT NULL — 유저 식별자
  • affiliationId (AFFILIATION_ID) — BIGINT — Foreign key → affiliation.affiliationId — 소속 식별자
  • username (USERNAME) — VARCHAR(50) — NOT NULL — 유저 아이디(이메일)
  • password (PASSWORD) — VARCHAR(60) — NOT NULL — 패스워드
  • role (ROLE) — VARCHAR(20) — NOT NULL — 권한
  • name (NAME) — VARCHAR(20) — NOT NULL — 유저 이름
  • createdAt (CREATED_AT) — TIMESTAMP — NOT NULL — 생성일시
  • updatedAt (UPDATED_AT) — TIMESTAMP — 수정일시
  • deletedAt (DELETED_AT) — TIMESTAMP — 삭제일시