board

Tables (5)

ATTACH

  • ATTACH_ID — NUMBER — Primary key — NOT NULL
  • BOARD_ID — NUMBER — Foreign key → BOARD.BOARD_ID — NOT NULL
  • ATTACH_PATH — VARCHAR2(200)
  • ATTACH_REAL_NAME — VARCHAR2(200)
  • ATTACH_CHG_NAME — VARCHAR2(200)
  • ATTACH_EXTENSION — VARCHAR2(200)
  • ATTACH_DATE_CREATED — DATE

BOARD

  • BOARD_ID — NUMBER — Primary key — NOT NULL
  • MEMBER_ID — VARCHAR2(100BYTE) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • CATEGORY_ID — NUMBER(10) — Foreign key — NOT NULL
  • BOARD_TITLE — VARCHAR2(200)
  • BOARD_CONTENT — VARCHAR2(200)
  • BOARD_REGISTDATE — DATE
  • BOARD_REPLY_COUNT — NUMBER
  • ATTACH_ID — NUMBER
  • RECOMMEND — NUMBER

MEMBER

  • MEMBER_ID — VARCHAR2(100BYTE) — Primary key — NOT NULL
  • MEMBER_PASSWORD — VARCHAR2(100 BYTE)
  • ROLE_ID — NUMBER
  • MEMBER_EMAIL — VARCHAR2(100 BYTE) — NOT NULL
  • MEMBER_PROPERTY — VARCHAR2(1000 BYTE)
  • MEMBER_REGISTDATE — DATE — NOT NULL

REPLY

  • REPLY_ID — NUMBER — Primary key — NOT NULL
  • BOARD_ID — NUMBER — Foreign key → BOARD.BOARD_ID — NOT NULL
  • MEMBER_ID — VARCHAR2(100BYTE) — Foreign key → BOARD.MEMBER_ID — NOT NULL
  • REPLY_CONTENT — VARCHAR2(50)
  • REPLY_REGISTDATE — DATE

REREPLY

  • REREPLY_ID — NUMBER — Primary key — NOT NULL
  • REPLY_ID (REPLY_ID2) — NUMBER — Foreign key → REPLY.REPLY_ID — NOT NULL
  • MEMBER_ID — VARCHAR2(100BYTE) — Foreign key → REPLY.MEMBER_ID — NOT NULL
  • REREPLY_CONTENT — VARCHAR2(100)
  • REREPLY_REGISTDATE — DATE