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)