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