erd 게시판

테이블 (10)

ANSWER

  • ANSWER_ID — BIGINT — NOT NULL
  • CONTENT — TEXT — NOT NULL
  • USER_ID — BIGINT — NOT NULL
  • QUESTION_ID — BIGINT — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

COMMENT

  • undefined_ID — BIGINT — NOT NULL
  • USER_ID — BIGINT — NOT NULL
  • QUESTION_ID — BIGINT
  • ANSWER_ID — BIGINT
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

FAVORITE

  • USER_ID — BIGINT — NOT NULL
  • QUESTION_ID — BIGINT — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL

FRIEND

  • USER_ID — BIGINT — NOT NULL
  • FRIEND_USER_ID — BIGINT — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL

GRADE

  • GRADE_ID — BIGINT — 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

LIKE

  • USER_ID — BIGINT — NOT NULL
  • QUESTION_ID — BIGINT
  • ANSWER_ID — BIGINT
  • CREATED_AT — TIMESTAMP — NOT NULL

POINT

  • POINT_ID — BIGINT — NOT NULL
  • USER_ID — BIGINT — NOT NULL
  • POINT — INT — NOT NULL
  • REASON — VARCHAR(50) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL

QUESTION

  • QUESTION_ID — BIGINT — NOT NULL
  • TITLE — VARCHAR(255) — NOT NULL
  • CONTENT — TEXT — NOT NULL
  • USER_ID — BIGINT — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

USER

  • USER_ID — BIGINT — 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

Untitled

  • Key — 기본 키 — NOT NULL
  • Field