dd

Tables (19)

BANLIST

  • MEMBERID — VARCHAR2(30)
  • MESSAGE — VARCHAR2(4000)
  • REPORTER — VARCHAR2(30)
  • INPUTDATE — DATE

CHATROOM

  • ROOMID — VARCHAR2(500)
  • ROOMNAME — VARCHAR2(100)
  • INPUTDATE — DATE

CLASS_BOARD

  • CLASSNUM — NUMBER
  • MEMBERNUM — NUMBER — NOT NULL
  • DESTINATION — VARCHAR2(1000) — NOT NULL
  • TOTALMEMBER — NUMBER — NOT NULL
  • NICKNAME — VARCHAR2(30) — NOT NULL
  • TITLE — VARCHAR2(100) — NOT NULL
  • CONTENT — VARCHAR2(1000) — NOT NULL
  • INPUTDATE — DATE
  • CLASSTAG — VARCHAR2(2000)
  • ROOMID — VARCHAR2(500) — NOT NULL
  • MEMBERLEVEL — NUMBER
  • VIEWCOUNT — NUMBER
  • ORIGINALFILE — VARCHAR2(200)
  • SAVEDFILE — VARCHAR2(200)

CLASS_ROOM

  • ROOMNUM — NUMBER
  • CLASSNUM — NUMBER — NOT NULL
  • MEMBERNUM — NUMBER — NOT NULL
  • NICKNAME — VARCHAR2(30) — NOT NULL
  • MEMBERLEVEL — NUMBER
  • ADDRESS — VARCHAR2(1000) — NOT NULL
  • ORIGINALFILE — VARCHAR2(200)
  • SAVEDFILE — VARCHAR2(200)

COUPON

  • COUPONNUM — NUMBER
  • COUPONNAME — VARCHAR2(30) — NOT NULL
  • COUPONPOINT — NUMBER — NOT NULL

DELIVERY_MEMBER

  • MEMBERNUM — NUMBER
  • MEMBERID — VARCHAR2(100)
  • MEMBERPW — VARCHAR2(1000) — NOT NULL
  • MEMBERNAME — VARCHAR2(30) — NOT NULL
  • NICKNAME — VARCHAR2(30) — NOT NULL
  • PINNUMBER — VARCHAR2(30)
  • ADDRESS — VARCHAR2(1000)
  • PHONE — VARCHAR2(30)
  • MEMBEREXP — NUMBER
  • MEMBERPOINT — NUMBER
  • ROOMID — VARCHAR2(500)
  • MEMBERLEVEL — NUMBER
  • ENABLED — NUMBER(1)
  • ROLENAME — VARCHAR2(10)
  • ORIGINALFILE — VARCHAR2(200)
  • SAVEDFILE — VARCHAR2(200)

EXP_TABLE

  • USERLEVEL — NUMBER
  • USEREXP — NUMBER — NOT NULL

FREE_BOARD

  • BOARDNUM — NUMBER
  • MEMBERNUM — NUMBER — NOT NULL
  • NICKNAME — VARCHAR2(30) — NOT NULL
  • TITLE — VARCHAR2(100) — NOT NULL
  • CONTENT — VARCHAR2(2000) — NOT NULL
  • INPUTDATE — DATE
  • VIEWCOUNT — NUMBER
  • MEMBERLEVEL — NUMBER
  • ORIGINALFILE — VARCHAR2(200)
  • SAVEDFILE — VARCHAR2(200)

FREE_REPLY

  • REPLYNUM — NUMBER
  • BOARDNUM — NUMBER — NOT NULL
  • MEMBERNUM — NUMBER — NOT NULL
  • NICKNAME — VARCHAR2(30) — NOT NULL
  • CONTENT — VARCHAR2(500) — NOT NULL
  • INPUTDATE — DATE
  • MEMBERLEVEL — NUMBER

GUESTBOOK

  • GUESTBOOKNUM — NUMBER
  • MEMBERNUM — NUMBER — NOT NULL
  • WRITERNUM — NUMBER
  • NICKNAME — VARCHAR2(30) — NOT NULL
  • CONTENT — VARCHAR2(500) — NOT NULL
  • INPUTDATE — DATE

ITEM_TABLE

  • ITEMNUM — NUMBER
  • STORENUM — NUMBER — NOT NULL
  • ITEMNAME — VARCHAR2(30) — NOT NULL
  • ITEMCONTENT — VARCHAR2(1000) — NOT NULL
  • ITEMPRICE — NUMBER — NOT NULL
  • ORIGINALFILE — VARCHAR2(200)
  • SAVEDFILE — VARCHAR2(200)

MESSAGEREPORT

  • REPORTNUM — NUMBER
  • SENDER — VARCHAR2(30)
  • MESSAGE — VARCHAR2(4000)
  • REPORTER — VARCHAR2(4000)
  • ROOMID — VARCHAR2(500)
  • INPUTDATE — DATE

MULTI_FILE_TABLE_OF_FREE_BOARD

  • FILENUM — NUMBER
  • BOARDNUM — NUMBER
  • ORIGINALFILE — VARCHAR2(200)
  • SAVEDFILE — VARCHAR2(200)
  • FILESIZE — NUMBER — NOT NULL
  • DELETE_YN — VARCHAR2(5) — NOT NULL
  • INSERT_TIME — DATE
  • DELETE_TIME — DATE

MYCOUPON

  • MYCOUPONNUM — NUMBER
  • MEMBERNUM — NUMBER — NOT NULL
  • COUPONNUM — NUMBER — NOT NULL
  • COUPONNAME — VARCHAR2(30) — NOT NULL
  • COUPONPOINT — NUMBER — NOT NULL

ORDER_TABLE

  • ORDERNUM — NUMBER
  • MEMBERNUM — NUMBER — NOT NULL
  • ITEMNUM — NUMBER — NOT NULL
  • STORENUM — NUMBER — NOT NULL
  • ITEMNAME — VARCHAR2(30) — NOT NULL
  • ITEMPRICE — NUMBER — NOT NULL
  • QUANTITY — NUMBER
  • COMPLETE — CHAR

RECEIPT

  • RECEIPTNUM — NUMBER
  • MEMBERNUM — NUMBER — NOT NULL
  • STORENUM — NUMBER — NOT NULL
  • ORDERHISTORY — VARCHAR2(1000) — NOT NULL
  • TOTALAMOUNT — NUMBER — NOT NULL
  • ORDERADDRESS — VARCHAR2(1000)
  • WAITING — CHAR
  • COMPLETE — CHAR

REVIEW

  • REVIEWNUM — NUMBER
  • MEMBERNUM — NUMBER — NOT NULL
  • STORENUM — NUMBER — NOT NULL
  • RECEIPTNUM — NUMBER — NOT NULL
  • NICKNAME — VARCHAR2(30) — NOT NULL
  • ORDERHISTORY — VARCHAR2(1000) — NOT NULL
  • RATING — NUMBER — NOT NULL
  • COMPLETE — CHAR
  • REVIEWCONTENT — VARCHAR2(500) — NOT NULL

STORE

  • STORENUM — NUMBER
  • MEMBERNUM — NUMBER — NOT NULL
  • STORENAME — VARCHAR2(30) — NOT NULL
  • STORECONTENT — VARCHAR2(1000)
  • CATEGORY — VARCHAR2(30) — NOT NULL
  • ADDRESS — VARCHAR2(1000) — NOT NULL
  • PHONE — VARCHAR2(30) — NOT NULL
  • RATING — NUMBER
  • WISHLIST — NUMBER
  • ORIGINALFILE — VARCHAR2(200)
  • SAVEDFILE — VARCHAR2(200)

WISHLIST

  • MEMBERNUM — NUMBER — NOT NULL
  • MEMBERID — VARCHAR2(30)
  • STORENUM — NUMBER — NOT NULL