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 — 삭제일시