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