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