MBTInside

Tables (20)

BLACKLIST (블랙리스트)

  • id (블랙리스트아이디) — INTEGER — Primary key — NOT NULL
  • user_id (사용자아이디) — INTEGER — Foreign key → USER.id — NOT NULL
  • status (상태) — VARCHAR(1)
  • period (영창?기간) — INTEGER
  • due_date (영창기한) — DATETIME

COMMENT (댓글)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • board_id (게시판아이디) — INTEGER
  • text (텍스트) — VARCHAR(500)
  • create_time (생성시각) — DATETIME
  • delete_time (삭제시각) — DATETIME
  • update_time (업데이트(수정)시각) — DATETIME
  • status (상태) — VARCHAR(1)

COMMUNITY (커뮤니티)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • title (제목) — VARCHAR(50)
  • author (글쓴이) — INTEGER
  • text (텍스트) — TEXT
  • create_time (생성시각) — DATETIME
  • update_time (업데이트(수정)시각) — DATETIME
  • delete_time (삭제시각) — DATETIME
  • view_count (읽은 수) — INTEGER
  • like_count (좋아요 수) — INTEGER
  • status (상태) — VARCHAR(1)

COMMUNITYMBTIMAPPING (Untitled)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • mbti_id (mbti 아이디) — INTEGER — Foreign key → MBTI.id — NOT NULL
  • community_id (커뮤니티아이디) — INTEGER — Foreign key → COMMUNITY.id — NOT NULL

IMAGEMAPPING (이미지매핑)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • board_id (커뮤니티/매거진 아이디) — INTEGER
  • path (이미지경로) — VARCHAR(50)
  • name (이미지명) — VARCHAR(30)
  • extension (확장자) — VARCHAR(4)
  • size (사이즈) — INTEGER

INTERESTING (관심분야)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • name (이름) — VARCHAR(20)

INTERESTINGCOMMAPPING (관심사-커뮤니티매핑)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • interesting_id (관심분야아이디) — INTEGER — Foreign key → INTERESTING.id — NOT NULL
  • community_id (커뮤니티아이디) — INTEGER — Foreign key → COMMUNITY.id — NOT NULL

INTERESTINGUSERMAPPING (관심사-사용자매핑)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • interesting_id (관심분야아이디) — INTEGER — Foreign key → INTERESTING.id — NOT NULL
  • user_id (사용자아이디) — INTEGER — Foreign key → USER.id — NOT NULL

MAGAZINE (매거진)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • title (제목) — VARCHAR(50)
  • text (텍스트) — TEXT
  • author (글쓴이) — INTEGER
  • create_time (생성시각) — DATETIME
  • delete_time (삭제시각) — DATETIME
  • update_time (수정(업데이트)시각) — DATETIME
  • view_count (읽은 수) — INTEGER
  • like_count (좋아요 수) — INTEGER
  • status (상태) — VARCHAR(1)

MAGAZINECATEGORYMAPPING (매거진-카테고리 매핑)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • magazine_id (매거진아이디) — INTEGER — Foreign key → MAGAZINE.id — NOT NULL
  • category_id (카테고리아이디) — INTEGER — Foreign key → MAGAZINE_CATEGORY.id — NOT NULL

MAGAZINE_CATEGORY (매거진 카테고리)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • name (카테고리명) — VARCHAR(20)
  • status (상태) — VARCHAR(1)

MBTI (mbti)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • name (mbti명) — VARCHAR(4)

NOTIFICATION (공지)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • title (제목) — VARCHAR(50)
  • text (텍스트) — TEXT
  • create_time (생성시각) — DATETIME
  • update_time (업데이트(수정)시각) — DATETIME
  • delete_time (삭제시각) — DATETIME
  • status (상태) — VARCHAR(1)

QNA (Q&A)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • title (제목) — VARCHAR(50)
  • text (텍스트) — TEXT
  • create_time (생성시각) — DATETIME
  • update_time (업데이트(수정)시각) — DATETIME
  • delete_time (삭제시각) — DATETIME
  • status (상태) — VARCHAR(1)
  • order (순서) — INTEGER

REPORT (신고내역)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • user_id (사용자아이디) — INTEGER — Foreign key → USER.id — NOT NULL
  • ano_user_id (타사용자아이디) — INTEGER
  • do_yn (신고주체) — VARCHAR(1)
  • reason (신고사유) — VARCHAR(20)
  • create_time (신고시각) — DATETIME

RE_COMMENT (대댓글)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • comment_id (댓글아이디) — INTEGER — Foreign key → COMMENT.id — NOT NULL
  • text (텍스트) — VARCHAR(500)
  • create_time (생성시각) — DATETIME
  • update_time (업데이트(수정)시각) — DATETIME
  • delete_time (삭제시각) — DATETIME
  • status (상태) — VARCHAR(1)

TERMS (약관)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • title (타이틀) — VARCHAR(20)
  • terms_info (타이틀내용) — TEXT
  • start_time (적용시각) — DATETIME
  • mandatory_yn (필수여부) — VARCHAR(1)
  • status (상태) — VARCHAR(1)

TERMS_AGREEMENT (약관동의)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • user_id (사용자아이디) — INTEGER — Foreign key → USER.id — NOT NULL
  • term_id (약관아이디) — INTEGER — Foreign key → TERMS.id — NOT NULL
  • agreement_yn (동의여부) — VARCHAR(1)
  • agreement_time (동의시간) — DATETIME

USER (사용자)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • name (이름) — VARCHAR(20)
  • nickname (닉네임) — VARCHAR(20)
  • password (패스워드) — VARCHAR(20)
  • sex (성별) — VARCHAR(1)
  • phone (전화번호) — VARCHAR(12)
  • mbti — VARCHAR(4)
  • status (상태) — VARCHAR(1)
  • create_time (생성시각) — DATETIME
  • delete_time (탈퇴시각) — DATETIME
  • role (역할) — VARCHAR(1)

USERMBTIMAPPING (사용자-mbti 매핑)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • mbti_id (mbti 아이디) — INTEGER — Foreign key → MBTI.id — NOT NULL
  • user_id (사용자아이디) — INTEGER — Foreign key → USER.id — NOT NULL