erd 0401
Tables (10)
ANSWER
- ANSWER_ID — BIGINT — Primary key — NOT NULL
- CONTENT — TEXT — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_AT — TIMESTAMP — NOT NULL
- USER_ID (USER_ID2) — BIGINT — Foreign key → USER.USER_ID — NOT NULL
- QUESTION_ID (QUESTION_ID2) — BIGINT — Foreign key → QUESTION.QUESTION_ID — NOT NULL
Board (Untitled)
- board_ID (Key) — Primary key — NOT NULL
- 게시글 정렬 (Field)
- 게시판 이름1 (Field2)
- 게시글 검색 지워야함 (Field4)
- 게시글 필터링 추가점수없음 (Field5)
- 게시글 작성권한 (Field6)
- 게시글 삭제버튼 (Field7)
- 운영자 전용 페이지 (Field9)
COMMENT
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_AT — TIMESTAMP — NOT NULL
- undefined_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
- ANSWER_ID (ANSWER_ID2) — BIGINT — Foreign key → ANSWER.ANSWER_ID — NOT NULL
- QUESTION_ID (QUESTION_ID2) — BIGINT — Foreign key → QUESTION.QUESTION_ID — NOT NULL
- USER_ID
FAVORITE
- USER_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
- QUESTION_ID — BIGINT — Foreign key → QUESTION.QUESTION_ID — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
FRIEND
- USER_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
- FRIEND_USER_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
GRADE
- GRADE_ID — BIGINT — Primary key — 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_ID (USER_ID2) — BIGINT — Foreign key → USER.USER_ID — NOT NULL
LIKE
- USER_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
- ANSWER_ID — BIGINT
- CREATED_AT — TIMESTAMP — NOT NULL
- QUESTION_ID (QUESTION_ID2) — BIGINT — Foreign key → QUESTION.QUESTION_ID — NOT NULL
POINT
- POINT_ID — BIGINT — Primary key — NOT NULL
- USER_ID — BIGINT — NOT NULL
- POINT — INT — NOT NULL
- REASON — VARCHAR(50) — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
- USER_ID (USER_ID2) — BIGINT — Foreign key → USER.USER_ID — NOT NULL
QUESTION
- QUESTION_ID — BIGINT — Primary key — NOT NULL
- TITLE — VARCHAR(255) — NOT NULL
- CONTENT — TEXT — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_AT — TIMESTAMP — NOT NULL
- USER_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
USER
- USER_ID — BIGINT — Primary key — 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