hahahaha
Tables (10)
AUCTION
- AUCTION_NO — NUMBER
- AUCTION_TITLE — VARCHAR2(50 BYTE)
- AUCTION_WRITER — VARCHAR2(15 BYTE) — Foreign key → USER1.USER_ID
- AUCTION_CONTENT — VARCHAR2(2000 BYTE)
- AUCTION_ORIGINAL_FILENAME — VARCHAR2(100 BYTE)
- AUCTION_RENAMED_FILENAME — VARCHAR2(100 BYTE)
- AUCTION_READCOUNT — NUMBER
- AUCTION_DATE — DATE
- AUCTION_TYPE — CHAR(1 BYTE)
- AUCTION_DELDATE — DATE
- AUCTION_DELTYPE — CHAR(1 BYTE)
COMMENT_TABLE
- COMMENT_NO — VARCHAR2(10 BYTE)
- COMMENT_LEVEL — NUMBER
- USER_ID — VARCHAR2(30 BYTE) — Foreign key → USER1.USER_ID
- COMMENT_CONTENT — VARCHAR2(1000 BYTE)
- COMMENT_REF — NUMBER
- COMMENT_DATE — DATE
- COMMENT_DELDATE — DATE
- COMMENT_DELTYPE — CHAR(1 BYTE)
DECLARATION
- DECLARATION_NO — NUMBER
- DECLARATION_TITLE — VARCHAR2(50 BYTE)
- DECLARATION_WRITER — VARCHAR2(15 BYTE) — Foreign key → USER1.USER_ID
- DECLARATION_RECEIVER — VARCHAR2(15 BYTE) — Foreign key → USER1.USER_ID
- DECLARATION_CONTENT — VARCHAR2(2000 BYTE)
- DECLARATION_ORIGINAL_FILENAME — VARCHAR2(100 BYTE)
- DECLARATION_RENAMED_FILENAME — VARCHAR2(100 BYTE)
- DECLARATION_DATE — DATE
- DECLARATION_STATE — CHAR(1 BYTE)
- DECLARATION_DELDTE — DATE
- DECLARATION_DELTYPE — CHAR(1 BYTE)
FREE_PRODUCT
- FREE_PRODUCT_NO — NUMBER
- FREE_PRODUCT_TITLE — VARCHAR2(50 BYTE)
- FREE_PRODUCT_WRITER — VARCHAR2(15 BYTE) — Foreign key → USER1.USER_ID
- FREE_PRODUCT_CONTENT — VARCHAR2(2000 BYTE)
- FREE_PRODUCT_ORIGINAL_FILENAME — VARCHAR2(100 BYTE)
- FREE_PRODUCT_RENAMED_FILENAME — VARCHAR2(100 BYTE)
- FREE_PRODUCT_DATE — DATE
- FREE_PRODUCT_DELDATE — DATE
- FREE_PRODUCT_DELTYPE — CHAR(1 BYTE)
MESSAGE
- MESSAGE_NO — NUMBER
- MESSAGE_WRITER — VARCHAR2(30 BYTE) — Foreign key → USER1.USER_ID
- MESSAGE_RECIVER — VARCHAR2(30 BYTE)
- MESSAGE_CONTENT — VARCHAR2(1000 BYTE)
- MESSAGE_READ_STATE — CHAR(1 BYTE)
- MESSAGE_DATE — DATE
- MESSAGE_DELDATE — DATE
- MESSAGE_DELTYPE — CHAR(1 BYTE)
NOTICE
- NOTICE_NO — NUMBER
- NOTICE_TITLE — VARCHAR2(50 BYTE)
- NOTICE_WRITER — VARCHAR2(15 BYTE) — Foreign key → USER1.USER_ID
- NOTICE_CONTENT — VARCHAR2(2000 BYTE)
- NOTICE_ORIGINAL_FILENAME — VARCHAR2(100 BYTE)
- NOTICE_RENAMED_FILENAME — VARCHAR2(100 BYTE)
- NOTICE_DATE — DATE
- NOTICE_READCOUNT — NUMBER
- NOTICE_DELDATE — DATE
- NOTICE_DELTYPE — CHAR(1 BYTE)
PRODUCT_BOARD
- PRODUCT_BOARD_NO — NUMBER
- PRODUCT_BOARD_TITLE — VARCHAR2(100 BYTE)
- SELLER — VARCHAR2(30 BYTE) — Foreign key → USER1.USER_ID
- PRODUCT_BOARD_CONTENT — VARCHAR2(1000 BYTE)
- PRODUCT_BOARD_STATE — CHAR(10 BYTE)
- PRODUCT_BOARD_PRICE — NUMBER
- ORIGINAL_FILENAME — VARCHAR2(100 BYTE)
- RENAMED_FILENAME — VARCHAR2(100 BYTE)
- PRODUCT_BOARD_DATE — DATE
- READCOUNT — NUMBER
- PRODUCT_BOARD_DELDATE — DATE
- PRODUCT_BOARD_DELTYPE — CHAR(1 BYTE)
REVIEW_POINT
- REVIEW_POINT_NO — NUMBER
- REVIEW_POINT_WRITER — VARCHAR2(30 BYTE) — Foreign key → USER1.USER_ID
- REVIEW_POINT_RECEIVER — VARCHAR2(30 BYTE) — Foreign key → USER1.USER_ID
- REVIEW_POINT_POINT — VARCHAR2(20 BYTE)
REVIEW_SURVEY
- REVIEW_SURVEY_ONE — VARCHAR2(50 BYTE)
- REVIEW_SURVEY_TWO — VARCHAR2(50 BYTE)
- REVIEW_SURVEY_THREE — VARCHAR2(50 BYTE)
- REVIEW_SURVEY_FOUR — VARCHAR2(50 BYTE)
- REVIEW_SURVEY_FIVE — VARCHAR2(50 BYTE)
USER1
- USER_ID — VARCHAR2(30 BYTE)
- USER_NAME — VARCHAR2(20 BYTE)
- USER_PASSWORD — VARCHAR2(300 BYTE)
- USER_PHONE — CHAR(11 BYTE)
- USER_EMAIL — VARCHAR2(50 BYTE)
- USER_ADDRESS — VARCHAR2(100 BYTE)
- USER_ENROLLDATE — DATE
- USER_DELDATE — DATE
- USER_DELTYPE — CHAR(1 BYTE)