devX_서영철
테이블 (10)
BOARD
- BOARD_ID — INT — 기본 키 — NOT NULL
- USER_ID — INT — 외래 키 → USER.USER_ID — NOT NULL
- TITLE — VARCHAR
- CONTENT — VARCHAR
- CREATION_DATE — TIMESTAMP
COMMENT (Untitled9)
- COMMENT_ID — INT — 기본 키 — NOT NULL
- BOARD_ID — INT — 외래 키 → BOARD.BOARD_ID — NOT NULL
- USER_ID — INT — 외래 키 → BOARD.USER_ID — NOT NULL
- CONTENT — VARCHAR
- CREATION_DATE — TIMESTAMP
- PARENT_COMMENT_ID — INT — 외래 키 → COMMENT.COMMENT_ID — NOT NULL
FILE (Untitled8)
- FILE_ID — INT — 기본 키 — NOT NULL
- BOARD_ID — INT — 외래 키 → BOARD.BOARD_ID — NOT NULL
- REAL_FILE_NAME — VARCHAR
- STORED_FILE_NAME — VARCHAR
- FILE_TYPE — VARCHAR
FOLLOWER (Untitled4)
- FOLLOWER_ID — INT — 기본 키 — NOT NULL
- FOLLWER_USER_ID — INT — 외래 키 → USER.USER_ID — NOT NULL
- Field
LIKE (Untitled5)
- LIKE_ID — int — 기본 키 — NOT NULL
- BOARD_ID — INT — 외래 키 → BOARD.BOARD_ID — NOT NULL
- USER_ID — INT — 외래 키 → USER.USER_ID — NOT NULL
- CREATION_DATE — TIMESTAMP
SCRAP (Untitled2)
- SCRAP_ID — INT — 기본 키 — NOT NULL
- BOARD_ID — INT — 외래 키 → BOARD.BOARD_ID — NOT NULL
- USER_ID — INT — 외래 키 → USER.USER_ID — NOT NULL
- CREATION_DATE — TIMESTAMP
SHARE (Untitled3)
- SHARE_ID — INT — 기본 키 — NOT NULL
- USER_ID — INT — 외래 키 → USER.USER_ID — NOT NULL
- BOARD_ID — INT — 외래 키 → BOARD.BOARD_ID — NOT NULL
- CREATION_DATE — TIMESTAMP
SHARE_TARGET (Untitled6)
- SHARE_TARGET_ID — INT — 기본 키 — NOT NULL
- SHARE_ID — INT — 외래 키 → SHARE.SHARE_ID — NOT NULL
- TARGET_TYPE — VARCHAR
- TARGET_IDENTIFIER — VARCHAR
TEMPORARY_BOARD (Untitled7)
- TEMPBOARD_ID — INT — 기본 키 — NOT NULL
- USER_ID — INT — 외래 키 → USER.USER_ID — NOT NULL
- TITLE — VARCHAR
- CONTENT — VARCHAR
- CREATEION_DATE — TIMESTAMP
USER (Untitled)
- USER_ID — INT — 기본 키 — NOT NULL
- NAME — VARCHAR
- EMAIL — VARCHAR
- FOLLOWERS_COUNT — INT
- SCRAPS_COUNT — INT
- GRADE — VARCHAR