erd 0401

Tables (10)

ANSWER

  • ANSWER_ID — BIGINT — Primary key — NOT NULL
  • CONTENT — TEXT — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • USER_ID (USER_ID2) — BIGINT — Foreign key → USER.USER_ID — NOT NULL
  • QUESTION_ID (QUESTION_ID2) — BIGINT — Foreign key → QUESTION.QUESTION_ID — NOT NULL

Board (Untitled)

  • board_ID (Key) — Primary key — NOT NULL
  • 게시글 정렬 (Field)
  • 게시판 이름1 (Field2)
  • 게시글 검색 지워야함 (Field4)
  • 게시글 필터링 추가점수없음 (Field5)
  • 게시글 작성권한 (Field6)
  • 게시글 삭제버튼 (Field7)
  • 운영자 전용 페이지 (Field9)

COMMENT

  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • undefined_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
  • ANSWER_ID (ANSWER_ID2) — BIGINT — Foreign key → ANSWER.ANSWER_ID — NOT NULL
  • QUESTION_ID (QUESTION_ID2) — BIGINT — Foreign key → QUESTION.QUESTION_ID — NOT NULL
  • USER_ID

FAVORITE

  • USER_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
  • QUESTION_ID — BIGINT — Foreign key → QUESTION.QUESTION_ID — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL

FRIEND

  • USER_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
  • FRIEND_USER_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL

GRADE

  • GRADE_ID — BIGINT — Primary key — NOT NULL
  • USER_ID — BIGINT — NOT NULL
  • GRADE_NAME — VARCHAR(50) — NOT NULL
  • MIN_POINT — INT — NOT NULL
  • MAX_POINT — INT — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • USER_ID (USER_ID2) — BIGINT — Foreign key → USER.USER_ID — NOT NULL

LIKE

  • USER_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
  • ANSWER_ID — BIGINT
  • CREATED_AT — TIMESTAMP — NOT NULL
  • QUESTION_ID (QUESTION_ID2) — BIGINT — Foreign key → QUESTION.QUESTION_ID — NOT NULL

POINT

  • POINT_ID — BIGINT — Primary key — NOT NULL
  • USER_ID — BIGINT — NOT NULL
  • POINT — INT — NOT NULL
  • REASON — VARCHAR(50) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • USER_ID (USER_ID2) — BIGINT — Foreign key → USER.USER_ID — NOT NULL

QUESTION

  • QUESTION_ID — BIGINT — Primary key — NOT NULL
  • TITLE — VARCHAR(255) — NOT NULL
  • CONTENT — TEXT — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • USER_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL

USER

  • USER_ID — BIGINT — Primary key — NOT NULL
  • EMAIL — VARCHAR(255) — NOT NULL
  • PASSWORD — VARCHAR(255) — NOT NULL
  • NICKNAME — VARCHAR(50) — NOT NULL
  • ROLE — VARCHAR(20) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL