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)