BOARD

Tables (3)

DETAIL (DEV_DETAIL_KJH)

  • boardId (BOARD_ID) — NUMBER — Foreign key → MASTER.boardId — NOT NULL
  • boardContent (BOARD_CONTENT) — VARCHAR2(1000)
  • fileData (FILE_DATA) — BLOB
  • Field — VARCHAR2(100)

MASTER (DEV_MASTER_KJH)

  • boardId (BOARD_ID) — NUMBER — Primary key — NOT NULL
  • boardTitle (BOARD_TITLE) — VARCHAR2(100)
  • writer (BOARD_WRITER) — VARCHAR2(50)
  • cteateData (BOARD_DATE) — NUMBER
  • status (BOARD_STATUS) — VARCHAR2(10)
  • Field (BOARD_COUNT) — NUMBER

REPLY (DEV_REPLY_KJH)

  • replyId (REPLY_ID) — NUMBER — Primary key
  • boardId (BOARD_ID) — NUMBER — Foreign key → DETAIL.boardId — NOT NULL
  • replyContent (REPLY_CONTENT) — VARCHAR2(1000)
  • replyWriter (REPLY_WRITER) — VARCHAR(100)
  • replyData (REPLT_DATA) — DATA
  • Field (REPLY_STATUS) — VARCHAR2(10)