0424

테이블 (11)

ANSWER

  • ANSWER_ID — BIGINT — 기본 키 — NOT NULL
  • CONTENT — TEXT — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • USER_ID2 — BIGINT — NOT NULL
  • QUESTION_ID2 — BIGINT — NOT NULL

COMMENT

  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • USER_ID — VARCHAR(255)
  • MAIN_ID — BIGINT — 외래 키 → 메인페이지.MAIN_ID — NOT NULL

FRIEND

  • USER_ID — BIGINT — 외래 키 → USER.USER_ID — NOT NULL
  • FRIEND_USER_ID — BIGINT — 외래 키 → USER.USER_ID — 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
  • USER_ID2 — BIGINT — NOT NULL

LIKE

  • USER_ID — BIGINT — 외래 키 → USER.USER_ID — NOT NULL
  • ANSWER_ID — BIGINT
  • CREATED_AT — TIMESTAMP — NOT NULL
  • QUESTION_ID2 — BIGINT — 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
  • USER_ID2 — BIGINT — 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 — VARCHAR(255) — 기본 키 — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)
  • Field4 — VARCHAR(255)
  • Field5 — VARCHAR(255)
  • Field6 — VARCHAR(255)
  • Field7 — VARCHAR(255)
  • Field9 — VARCHAR(255)

메인페이지 (main)

  • MAIN_ID — BIGINT — 기본 키 — NOT NULL
  • TITLE — VARCHAR(255) — NOT NULL
  • CONTENT — TEXT — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • USER_ID (USER_ID2) — BIGINT — 외래 키 → USER.USER_ID — NOT NULL

페이지 (CopyOfmain)

  • TITLE — VARCHAR(255) — NOT NULL
  • CONTENT — TEXT — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • USER_ID — BIGINT — 외래 키 → 메인페이지.MAIN_ID — NOT NULL

후기 (FAVORITE)

  • CREATED_AT — TIMESTAMP — NOT NULL
  • QUESTION_ID — BIGINT — 외래 키 → 메인페이지.MAIN_ID — NOT NULL
  • USER_ID — BIGINT — 외래 키 → USER.USER_ID — NOT NULL