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 — 수정시간