Gridge-Test

Tables (9)

ANSWER (댓글)

  • ANSWER_ID — BIGINT(20) — Primary key — NOT NULL
  • USER_ID — BIGINT(20) — Foreign key → User.USER_ID — NOT NULL
  • PARENT_ID — BIGINT(20) — Foreign key → ANSWER.ANSWER_ID — NOT NULL
  • BOARD_ID — BIGINT(20) — Foreign key → BOARD.BOARD_ID — NOT NULL
  • COMMENT — VARCHAR(200)
  • UPDATED_TIME — DATETIME(6)
  • CREATED_TIME — DATETIME(6)

ANSWER_LIKE (댓글 좋아요)

  • ANSWER_LIKE_ID — BIGINT(20) — Primary key — NOT NULL
  • USER_ID — BIGINT(20) — Foreign key → User.USER_ID — NOT NULL
  • ANSWER_ID — BIGINT(20) — Foreign key → ANSWER.ANSWER_ID — NOT NULL
  • UPDATED_TIME — DATETIME(6)
  • CREATED_TIME — DATETIME(6)

BOARD (피드)

  • BOARD_ID — BIGINT(20) — Primary key — NOT NULL
  • USER_ID — BIGINT(20) — Foreign key → User.USER_ID — NOT NULL
  • BOARD_IMAGE_ID — BIGINT(20) — Foreign key → BOARD_IMAGE.BOARD_IMAGE_ID — NOT NULL
  • BOARD_LIKE_ID — BIGINT(20) — Foreign key → BOARD_LIKE.BOARD_LIKE_ID — NOT NULL
  • ANSWER_ID — BIGINT(20) — Foreign key → ANSWER.ANSWER_ID — NOT NULL
  • CONTENT — VARCHAR(200)
  • IS_DELETED — BIT(1)
  • BOARD_STATE — VARCHAR(20)
  • UPDATED_TIME — DATETIME(6)
  • CREATED_TIME — DATETIME(6)

BOARD_IMAGE (피드 이미지)

  • BOARD_IMAGE_ID — BIGINT(20) — Primary key — NOT NULL
  • BOARD_ID — BIGINT(20) — Foreign key → BOARD.BOARD_ID — NOT NULL
  • BOARD_IMAGE_NAME — VARCHAR(255)
  • BOARD_IMAGE_URL — VARCHAR(255)
  • UPDATED_TIME — DATETIME(6)
  • CREATED_TIME — DATETIME(6)

BOARD_LIKE (피드 좋아요)

  • BOARD_LIKE_ID — BIGINT(20) — Primary key — NOT NULL
  • USER_ID — BIGINT(20) — Foreign key → User.USER_ID — NOT NULL
  • BOARD_ID — BIGINT(20) — Foreign key → BOARD.BOARD_ID — NOT NULL
  • UPDATED_TIME — DATETIME(6)
  • CREATED_TIME — DATETIME(6)

Follow (팔로우)

  • FOLLOW_ID — BIGINT(20) — Primary key — NOT NULL
  • FROM_USER_ID — BIGINT(20) — Foreign key → User.USER_ID — NOT NULL
  • TO_USER_ID — BIGINT(20) — Foreign key → User.USER_ID — NOT NULL
  • FOLLOW_STATE — VARCHAR(20)
  • UPDATED_TIME — DATETIME(6)
  • CREATED_TIME — DATETIME(6)

Message (메시지)

  • MESSAGE_ID — BIGINT(20) — Primary key — NOT NULL
  • FROM_USER_ID — BIGINT(20) — Foreign key → User.USER_ID — NOT NULL
  • TO_USER_ID — BIGINT(20) — Foreign key → User.USER_ID — NOT NULL
  • CONTENT — VARCHAR(255)
  • UPDATED_TIME — DATETIME(6)
  • CREATED_TIME — DATETIME(6)

Report (신고)

  • REPORT_ID — BIGINT(20) — Primary key — NOT NULL
  • FROM_USER_ID — BIGINT(20) — Foreign key → User.USER_ID — NOT NULL
  • TO_USER_ID — BIGINT(20) — Foreign key → User.USER_ID — NOT NULL
  • SERVICE_TYPE — VARCHAR(20)
  • SERVICE_ID — BIGINT(20)
  • REASON — VARCHAR(200)
  • Field
  • Field2

User (유저)

  • USER_ID — BIGINT(20) — Primary key — NOT NULL
  • USER_TYPE — VARCHAR(10) — enum("GENERAL," "KAKAO")
  • USER_NICKNAME — VARCHAR(20)
  • NICKNAME_UPDATE_DATE — DATETIME(6) — NOT NULL
  • NICKNAME_UPDATE_COUNT — BIGINT(20)
  • USER_NAME — VARCHAR(20)
  • NAME_UPDATE_DATE — DATETIME(6) — NOT NULL
  • NAME_UPDATE_COUNT — BIGINT(20)
  • PROFILE_URL — VARCHAR(255)
  • SOCIAL_ID — VARCHAR(20)
  • PASSWORD — VARCHAR(200)
  • EMAIL — VARCHAR(100)
  • PHONE_NUMBER — VARCHAR(20)
  • ROLE — VARCHAR(30) — enum("ROLE_USER", "ROLE_ADMIN")
  • IS_DELETED — BIT(1)
  • IS_ACCEPT_TERMS — BIT(1)
  • WEBSITE — VARCHAR(255) — NOT NULL
  • DESCRIPTION — VARCHAR(255)
  • IS_PRIVATE_USER — BIT(1)
  • USER_STATE — VARCHAR(20) — enum("ACTIVE", "INACTIVE", "PAUSE")
  • LOG_IN_TIME — DATETIME(6)
  • UPDATED_TIME — DATETIME(6)
  • CREATED_TIME — DATETIME(6)