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