2NE1
Tables (10)
ANSWERS (답변정보)
- answer_id (답변식별자) — Primary key
- question_id (질문식별자) — Foreign key → QUESTIONS.question_id
- user_id (회원식별자) — Foreign key → USERS.user_id
- contents (답변내용) — 500
- likes_count (추천수)
- unlikes_count (비추천수)
- choose_YN (채택여부)
- image_url (이미지경로) — 255
- created_at (생성일)
- modified_at (수정일)
ANSWER_COMMENTS (답변댓글정보)
- comment_id (댓글식별자) — Primary key
- answer_id (답변식별자) — Foreign key → ANSWERS.answer_id
- user_id (회원식별자) — Foreign key → USERS.user_id
- comments (댓글) — 255
- created_at (생성일)
- modified_at (수정일)
ANSWER_LIKES (답변좋아요정보)
- answer_id (답변식별자) — Foreign key → ANSWERS.answer_id
- user_id (회원식별자) — Foreign key → USERS.user_id
- like_YN (추천여부)
- unlike_YN (비추천여부)
BOOKMARKS (북마크정보)
- bookmark_id (북마크식별자) — Primary key
- question_id (질문식별자) — Foreign key → QUESTIONS.question_id
- user_id (회원식별자) — Foreign key → USERS.user_id
- answer_id (답변식별자) — Foreign key → ANSWERS.answer_id
QUESTIONS (질문정보)
- question_id (질문식별자) — Primary key
- user_id (회원식별자) — Foreign key → USERS.user_id
- title (제목) — 255
- contents (질문내용) — 500
- answer_YN (답변여부)
- views (조회수)
- likes_count (추천수)
- unlikes_count (비추천수)
- image_url (이미지경로) — 255
- created_at (생성일)
- modified_at (수정일)
QUESTION_COMMENTS (질문댓글정보)
- comment_id (댓글식별자) — Primary key
- question_id (질문식별자) — Foreign key → QUESTIONS.question_id
- user_id (회원식별자) — Foreign key → USERS.user_id
- comments (댓글) — 255
- created_at (생성일)
- modified_at (수정일)
QUESTION_LIKES (질문좋아요정보)
- question_id (질문식별자) — Foreign key → QUESTIONS.question_id
- user_id (회원식별자) — Foreign key → USERS.user_id
- like_YN (추천여부)
- unlike_YN (비추천여부)
REFRESH_TOKEN (토큰정보)
- refresh_token_id (토큰식별자) — Primary key
- refresh_token (리프레시토큰) — 255
- token_email (이메일토큰) — 255
TAGS (태그정보)
- tag_id (태그식별자) — Primary key
- title (제목) — 255
- comments (설명) — 500
- tag_count (사용횟수)
- latest (최근사용일)
- question_id (질문식별자) — Foreign key → QUESTIONS.question_id
USERS (회원정보)
- user_id (회원식별자) — Primary key
- email (이메일) — 255
- password (비밀번호) — 255
- nickname (닉네임) — 255
- created_at (생성일)
- modified_at (수정일)
- refresh_token (토큰정보) — 1000