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