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