NONAME_SCHOOL

Tables (16)

ADMIN (TB_ADMIN)

  • adminId (admin_id) — INTEGER — Primary key — NOT NULL
  • adminName — VARCHAR(150) — NOT NULL — 아이디
  • name — VARCHAR(150) — NOT NULL — 이름
  • nickname — VARCHAR(120) — NOT NULL — 닉네임
  • password — VARCHAR(120) — NOT NULL — 비밀번호
  • role — ENUM — NOT NULL — 권한
  • profile — VARCHAR(255) — NOT NULL — 프로필 이미지
  • createdDate (created_date) — DATETIME — NOT NULL — 생성 시간
  • modifiedDate (modified_date) — DATETIME — NOT NULL — 수정 시간

BOARD (TB_BOARD)

  • boardId (board_id) — INTEGER — Primary key — NOT NULL
  • userId (user_id) — INTEGER — Foreign key → USER.userId — NOT NULL
  • boardCategoryId (board_categpry_id) — INTEGER — Foreign key → BOARD_CATEGORY.boardCategoryId — NOT NULL
  • title — VARCHAR(50) — NOT NULL — 게시글 제목
  • content — VARCHAR(2500) — 내용
  • createdId (created_id) — INTEGER — NOT NULL — 생성자
  • isDeleted (is_deleted) — TINYINT(1) — NOT NULL — 삭제 여부
  • isAnonymity (is_anonymity) — BOOLEAN — NOT NULL — 익명 여부
  • deletedDate (deleted_date) — DATETIME — NOT NULL — 삭제 시간
  • createdDate (created_date) — DATETIME — NOT NULL — 생성 시간
  • modifiedDate (modified_date) — DATETIME — NOT NULL — 수정 시간

BOARD_CATEGORY (TB_BOARD_CATEGORY)

  • boardCategoryId (board_category_id) — INTEGER — Primary key — NOT NULL
  • schoolId (school_id) — INTEGER — Foreign key → SCHOOL.schoolId
  • userId (user_id) — INTEGER — Foreign key → USER.userId — NOT NULL — 생성자
  • name — VARCHAR(50) — NOT NULL — 이름
  • type — ENUM — NOT NULL — 유형
  • description — TEXT — 설명
  • isDeleted (is_deleted) — TINYINT — NOT NULL — 삭제여부
  • deletedDate (deleted_date) — DATETIME — NOT NULL — 삭제 시간
  • createdDate (created_date) — DATETIME — NOT NULL — 생성 시간
  • modifiedDate (modified_date) — DATETIME — NOT NULL — 수정 시간

COMMENT (TB_COMMENT)

  • commentId (comment_id) — INTEGER — Primary key — NOT NULL
  • userId (user_id) — INTEGER — Foreign key → BOARD.userId — NOT NULL
  • boardId (board_id) — INTEGER — Foreign key → BOARD.boardId — NOT NULL
  • parentCommentId — INTEGER — NOT NULL — 부모 댓글 ID
  • content — VARCHAR(255) — NOT NULL — 댓글 내용
  • isAnonymity (is_anonymity) — BOOLEAN — NOT NULL — 익명 여부
  • isDeleted (is_deleted) — TINYINT(1) — NOT NULL — 삭제 여부
  • deletedDate (deleted_date) — DATETIME — NOT NULL — 삭제 시간
  • createdDate (created_date) — DATETIME — NOT NULL — 생성 시간
  • modifiedDate (modified_date) — DATETIME — NOT NULL — 수정 시간

COMMENT_LINK (TB_COMMENT_LINK)

  • commnetLinkId (commnet_link_id) — INTEGER — Primary key — NOT NULL
  • parentCommentId (parent_comment_id) — INTEGER — Foreign key → COMMENT.commentId — NOT NULL
  • childCommentId (child_comment_id) — INTEGER — Foreign key → COMMENT.userId — NOT NULL
  • createdDate (created_date) — DATETIME — NOT NULL — 생성시간

COMPLAINT (TB_COMPLAINT)

  • complaintId (complaint_id) — INTEGER — Primary key — NOT NULL
  • userId (user_id) — INTEGER — Foreign key → USER.userId — NOT NULL — 신고유저
  • boardId (board_id) — INTEGER — Foreign key → BOARD.boardId — NOT NULL
  • decription (description) — TEXT — NOT NULL — 신고 내용
  • type — ENUM — NOT NULL — 종류
  • createdDate (created_date) — DATETIME — NOT NULL — 생성 시간
  • modifiedDate (modified_date) — DATETIME — NOT NULL — 수정 시간

EMTION (TB_EMOTION)

  • emotionId (emotion_id) — INTEGER — Primary key — NOT NULL
  • userId (user_id) — INTEGER — Foreign key → USER.userId — NOT NULL
  • boardId (board_id) — INTEGER — Foreign key → BOARD.boardId — NOT NULL
  • type — ENUM — NOT NULL — 감정표현
  • createdDate — DATETIME — NOT NULL — 생성 시간
  • modifiedDate (modified_date) — DATETIME — NOT NULL — 수정 시간

FAQ (TB_FAQ)

  • faqId (faq_id) — INTEGER — Primary key — NOT NULL
  • adminId (admin_id) — INTEGER — Foreign key → ADMIN.adminId — NOT NULL
  • question — VARCHAR(100) — NOT NULL — 질문
  • answer — TEXT — NOT NULL — 답변
  • isEnabled (is_enabled) — TINYINT(1) — NOT NULL — 사용 여부
  • createdDate (created_date) — DATETIME — NOT NULL — 생성 시간
  • modifiedDate (modified_date) — DATETIME — NOT NULL — 수정 시간

FILE (TB_FILE)

  • fileId (file_id) — INTEGER — Primary key — NOT NULL
  • boardId (board_id) — INTEGER — Foreign key → BOARD.boardId — NOT NULL
  • qnaId (qna_id) — INTEGER — Foreign key → QNA.qnaId — NOT NULL
  • url — VARCHAR(255) — NOT NULL
  • type — ENUM — NOT NULL — 유형
  • createdDate (created_date) — DATETIME — NOT NULL — 생성시간

NOTIFICATION (TB_NOTIFICATION)

  • notificationId (notification_id) — INTEGER — Primary key — NOT NULL
  • title — VARCHAR(120) — NOT NULL — 제목
  • description — TEXT — NOT NULL — 내용
  • sendTime (send_time) — DATETIME — NOT NULL — 발송 시간
  • createdDate (created_date) — DATETIME — NOT NULL — 생성 사간
  • modifiedDate (modified_date) — DATETIME — NOT NULL — 수정 시간

QNA (TB_QNA)

  • qnaId (qna_id) — INTEGER — Primary key — NOT NULL
  • userId (user_id) — INTEGER — Foreign key → USER.userId — NOT NULL
  • adminId (admin_id) — INTEGER — Foreign key → ADMIN.adminId — NOT NULL
  • title — VARCHAR(50) — NOT NULL — 질문 제목
  • content — TEXT — NOT NULL — 내용
  • answer — TEXT — NOT NULL — 답변
  • answerDate (answer_date) — DATETIME — 답변시간
  • createdDate (created_date) — DATETIME — NOT NULL — 생성 시간
  • modifiedDate (modified_date) — DATETIME — NOT NULL — 수정 시간

RECENT_BOARD (TB_RECENT_BOARD)

  • recentBoardId (recent_board_id) — INTEGER — Primary key — NOT NULL
  • boardId (board_id) — INTEGER — Foreign key → BOARD.boardId — NOT NULL
  • createdDate (created_date) — DATETIME — NOT NULL — 생성 시간

REQUEST_BOARD_CATEGORY (TB_REQUEST_BOARD_CATEGORY)

  • requestBoardCategoryId (request_board_category_id) — INTEGER — Primary key — NOT NULL
  • userId (user_id) — INTEGER — Foreign key → USER.userId — NOT NULL
  • name — VARCHAR(120) — NOT NULL — 게시판 이름
  • description — TEXT — NOT NULL — 내용
  • status — ENUM — NOT NULL — 승인 상태
  • createdDate (created_date) — DATETIME — NOT NULL — 생성 시간
  • modifiedDate (modified_date) — DATETIME — NOT NULL — 수정 시간

SCHOOL (TB_SCHOOL)

  • schoolId (school_id) — INTEGER — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL — 학교 이름
  • enterence — DATETIME — NOT NULL — 입학년도
  • isDeleted (is_deleted) — TINYINT(1) — NOT NULL — 삭제여부
  • deletedDate (deleted_date) — DATETIME — NOT NULL — 삭제시간
  • createdDate (creataed_date) — DATETIME — NOT NULL — 생성시간
  • modifiedDate (modified_date) — DATETIME — NOT NULL — 수정시간

SCHOOL_USER (TB_SCHOOL_USER)

  • schoolUserId (school_user_id) — INTEGER — Primary key — NOT NULL
  • userId (user_id2) — INTEGER — Foreign key → USER.userId — NOT NULL
  • schoolId (school_id) — INTEGER — Foreign key → SCHOOL.schoolId — NOT NULL
  • status — ENUM — NOT NULL — 입학신청

USER (TB_USER)

  • userId (user_id) — INTEGER — Primary key — NOT NULL
  • username — VARCHAR(150) — NOT NULL — 아이디
  • password — VARCHAR(120) — NOT NULL — 비밀번호
  • name — VARCHAR(120) — NOT NULL — 이름
  • nickname — VARCHAR(120) — NOT NULL — 닉네임
  • profile — VARCHAR(255) — NOT NULL — 프로필 사진
  • isDeleted (is_deleted) — TINYINT(1) — NOT NULL — 삭제여부
  • deletedDate (deleted_date) — DATETIME — NOT NULL — 삭제시간
  • createdDate (created_date) — DATETIME — NOT NULL — 생성시간
  • modifiedDate (modified_date) — DATETIME — NOT NULL — 수정시간