SnapLine

Tables (6)

COMMENT (댓글)

  • COMMEMT_SQNO (COMMENT_SQNO) — BIGINT — Primary key — NOT NULL
  • POST_SQNO — BIGINT — Foreign key → POST.POST_SQNO — NOT NULL
  • USER_ID — UUID — Foreign key → POST.USER_ID — NOT NULL
  • CONTENT — TEXT
  • CREATE_DT — TIMESTAMP

FOLLOW (팔로우)

  • FOLLOW_SQNO — BIGINT — Primary key — NOT NULL
  • USER_ID — UUID — Foreign key → USER.USER_ID — NOT NULL
  • TARGET_ID — UUID
  • CREATE_DT — TIMESTAMP

LIKE (좋아요)

  • LIKE_SQNO — BIGINT — Primary key — NOT NULL
  • POST_SQNO — BIGINT — Foreign key → POST.POST_SQNO — NOT NULL
  • USER_ID — UUID — Foreign key → POST.USER_ID — NOT NULL
  • CREATE_DT — TIMESTAMP

NOTIFICATION (알림)

  • NOTI_SQNO — BIGINT — Primary key — NOT NULL
  • RECEVER_ID — UUID
  • SEND_ID — UUID
  • TPYET (TYPE) — VARCHAR(20)
  • POST_SQNO — BIGINT
  • IS_READ — CHAR(1)
  • CREATE_DT — TIMESTAMP

POST (게시글)

  • POST_SQNO — BIGINT — Primary key — NOT NULL
  • USER_ID — UUID — Foreign key → USER.USER_ID — NOT NULL
  • CONTENT — TEXT
  • IMG — BLOB
  • CREATE_DT — TIMESTAMP
  • UPDATE_DT — TIMESTAMP

USER (사용자)

  • USER_ID — UUID — Primary key — NOT NULL
  • USER_NM — VARCHAR(100)
  • NICKNAME — VARCHAR(100)
  • EMAIL — VARCHAR(255)
  • PASSWORD — VARCHAR(255)
  • INTRO — TEXT
  • PROFILE_IMG — BLOB
  • PASSWORD_DT — VARCHAR(255)
  • CREATE_DT — TIMESTAMP
  • UPDATE_DT — TIMESTAMP
  • REFRESH_TOKEN — VARCHAR(255)
  • ACCESS_TOKEN — VARCHAR(255)
  • TOKEN_EXPIRED_DT — TIMESTAMP