asd
Tables (42)
APP
- APP_ID — NUMBER
- APP_RESULT — VARCHAR2(100) — NOT NULL
- APP_NOTE — VARCHAR2(1000) — NOT NULL
- APP_ITEM_ID — NUMBER — NOT NULL
APP_RESULT_CODE
- CODE — VARCHAR2(100)
- NAME — VARCHAR2(100) — NOT NULL
AR1
- APP_ID — NUMBER
- AR1_BRAND — VARCHAR2(100) — NOT NULL
- AR1_MODEL — VARCHAR2(100) — NOT NULL
- AR1_PRICE — NUMBER — NOT NULL
- AR1_WATCH_DETAIL — NUMBER
- AR1_BAG_DETAIL — NUMBER
- AR1_CONDITION — VARCHAR2(100) — NOT NULL
AR1_CONDITION_CODE
- CODE — VARCHAR2(100)
- NAME — VARCHAR2(100) — NOT NULL
ATTACHMENT
- ATTACHMENT_ID — NUMBER
- ATTACHMENT_NAME — VARCHAR2(100) — NOT NULL
- ATTACHMENT_RENAME — VARCHAR2(100) — NOT NULL
- ATTACHMENT_PATH — VARCHAR2(200) — NOT NULL
- ATTACHMENT_DATE — DATE — NOT NULL
- ATTACHMENT_LEVEL — NUMBER — NOT NULL
- ATTACHMENT_REF_ITEM — NUMBER
- ATTACHMENT_REF_APP — NUMBER
- ATTACHMENT_REF_BOARD — NUMBER
- ATTACHMENT_TYPE — VARCHAR2(100) — NOT NULL
ATTACHMENT_LEVEL_CODE
- CODE — NUMBER
- NAME — VARCHAR2(100) — NOT NULL
ATTACHMENT_TYPE_CODE
- CODE — VARCHAR2(100)
- NAME — VARCHAR2(100) — NOT NULL
AUCTION
- AUCTION_ID — NUMBER
- AUCTION_COUNT — NUMBER — NOT NULL
- AUCTION_START_PRICE — NUMBER
- AUCTION_MEMBER_NO — NUMBER — NOT NULL
- AUCTION_START_TIME — DATE
- AUCTION_PERIOD — NUMBER
- AUCTION_APP_ID — NUMBER — NOT NULL
AUCTION_COUNT_CODE
- CODE — NUMBER
- NAME — VARCHAR2(100) — NOT NULL
AUCTION_HISTORY
- AUCTION_HISTORY_NO — NUMBER
- AUCTION_HISTORY_TIME — DATE — NOT NULL
- AUCTION_HISTORY_TYPE — VARCHAR2(100) — NOT NULL
- AUCTION_ID — NUMBER — NOT NULL
AUCTION_HISTORY_TYPE_CODE
- CODE — VARCHAR2(100)
- NAME — VARCHAR2(100) — NOT NULL
BAG
- BAG_ID — NUMBER
- BAG_SIZE — VARCHAR2(100) — NOT NULL
- BAG_STRAP — VARCHAR2(100) — NOT NULL
- BAG_GENDER — VARCHAR2(100)
- F)) — NOT — NOT NULL
BIDDING_HISTORY
- BIDDING_ID — NUMBER
- BIDDING_AUCTION_ID — NUMBER — NOT NULL
- BIDDING_MEMBER_NO — NUMBER — NOT NULL
- BIDDING_COUNT — NUMBER — NOT NULL
- BIDDING_PRICE — NUMBER — NOT NULL
- BIDDING_TIME — DATE — NOT NULL
BOARD
- BOARD_ID — NUMBER
- BOARD_MEMBER_NO — NUMBER — NOT NULL
- BOARD_TITLE — VARCHAR2(100) — NOT NULL
- BOARD_CONTENT — VARCHAR2(1000) — NOT NULL
- BOARD_DATE — DATE — NOT NULL
- BOARD_COUNT — NUMBER — NOT NULL
- BOARD_TYPE — VARCHAR2(100) — NOT NULL
- BOARD_STATUS — VARCHAR2(100)
- N)) — NOT — NOT NULL
- BOARD_MODIFY_DATE — DATE — NOT NULL
BOARD_TYPE_CODE
- CODE — VARCHAR2(100)
- NAME — VARCHAR2(100) — NOT NULL
IHS1_HISTORY
- IHS1_HISTORY_ID — NUMBER
- ITEM_HISTORY_ID — NUMBER — NOT NULL
- IHS1_HISTORY_TYPE — VARCHAR2(100) — NOT NULL
- IHS1_HISTORY_DATE — DATE — NOT NULL
IHS1_HISTORY_TYPE_CODE
- CODE — VARCHAR2(100)
- NAME — VARCHAR2(100) — NOT NULL
ITEM
- ITEM_ID — NUMBER
- ITEM_MEMBER_NO — NUMBER — NOT NULL
- ITEM_TYPE — VARCHAR2(100)
- B)) — NOT — NOT NULL
- ITEM_BRAND_MODEL — VARCHAR2(100) — NOT NULL
- ITEM_PUR_DATE — VARCHAR2(100) — NOT NULL
- ITEM_WARRANTY_YN — VARCHAR2(100) — NOT NULL
- ITEM_DETAIL — VARCHAR2(1000)
- ITEM_APP_DATE — DATE — NOT NULL
ITEM_HISTORY
- ITEM_HISTORY_ID — NUMBER
- ITEM_HISTORY_DATE — DATE — NOT NULL
- ITEM_HISTORY_STATUS — VARCHAR2(100) — NOT NULL
- ITEM_ID — NUMBER — NOT NULL
ITEM_HISTORY_STATUS_CODE
- CODE — VARCHAR2(100)
- NAME — VARCHAR2(100) — NOT NULL
MEMBER
- MEMBER_NO — NUMBER
- MEMBER_ID — VARCHAR2(100) — NOT NULL
- MEMBER_PWD — VARCHAR2(200) — NOT NULL
- MEMBER_NAME — VARCHAR2(100) — NOT NULL
- MEMBER_PHONE — VARCHAR2(100) — NOT NULL
- MEMBER_ADDRESS — VARCHAR2(200) — NOT NULL
- MEMBER_EMAIL — VARCHAR2(100) — NOT NULL
- MEMBER_ENROLL_DATE — DATE — NOT NULL
- MEMBER_STATUS — VARCHAR2(100) — NOT NULL
MEMBER_HISTORY
- MEMBER_HISTORY_ID — NUMBER
- MEMBER_NO — NUMBER — NOT NULL
- MEMBER_HISTORY_DATE — DATE — NOT NULL
- MEMBER_HISTORY_TYPE — VARCHAR2(100) — NOT NULL
- MEMBER_HISTORY_DETAIL — VARCHAR2(1000)
MEMBER_HISTORY_TYPE_CODE
- CODE — VARCHAR2(100)
- NAME — VARCHAR2(100) — NOT NULL
MEMBER_SHIPMENT
- MEMBER_SHIPMENT_ID — NUMBER
- MEMBER_NO — NUMBER — NOT NULL
- MEMBER_SHIPMENT_RECEIVER_NAME — VARCHAR2(100) — NOT NULL
- MENBER_SHIPMENT_RECEIVER_PHONE — VARCHAR2(100) — NOT NULL
- MEMBER_SHIPMENT_RECEIVER_EMAIL — VARCHAR2(50) — NOT NULL
- MEMBER_SHIPMENT_ADDRESS — VARCHAR2(200) — NOT NULL
- MEMBER_SHIPMENT_ITEM — NUMBER
- MEMBER_SHIPMENT_APP — NUMBER
- MEMBER_SHIPMENT_AUCTION — NUMBER
- MEMBER_SHIPMENT_TYPE — VARCHAR2(100) — NOT NULL
MEMBER_SHIPMENT_TYPE_CODE
- CODE — VARCHAR2(100)
- NAME — VARCHAR2(100) — NOT NULL
MEMBER_STATUS_CODE
- CODE — VARCHAR2(100)
- NAME — VARCHAR2(100) — NOT NULL
MONEY
- MONEY_ID — VARCHAR2(100)
- MONEY_MEMBER_NO — NUMBER — NOT NULL
- MONEY_APPROVAL_NO — VARCHAR2(100) — NOT NULL
- MONEY_TYPE — VARCHAR2(100) — NOT NULL
- MONEY_SUBJECT_ITEM — NUMBER
- MONEY_SUBJECT_WIN — NUMBER
- MONEY_AMOUNT — NUMBER — NOT NULL
- MONEY_DATE — DATE — NOT NULL
- MONEY_REFUND_REASON — VARCHAR2(1000)
- MONEY_IMP_UID — VARCHAR2(100) — NOT NULL
MONEY_HISTORY
- MONEY_HISTORY_ID — VARCHAR2(100) — NOT NULL
- MONEY_HISTORY_DATE — DATE — NOT NULL
- MONEY_HISTORY_TYPE — VARCHAR2(100) — NOT NULL
- MONEY_ID — VARCHAR2(100) — NOT NULL
MONEY_HISTORY_TYPE_CODE
- CODE — VARCHAR2(100)
- NAME — VARCHAR2(100) — NOT NULL
MONEY_TYPE_CODE
- CODE — VARCHAR2(100)
- NAME — VARCHAR2(100) — NOT NULL
QNA
- QNA_ID — NUMBER
- QNA_MEMBER_NO — NUMBER — NOT NULL
- QNA_TITLE — VARCHAR2(100) — NOT NULL
- QNA_CONTENT — VARCHAR2(1000) — NOT NULL
- QNA_DATE — DATE — NOT NULL
QNA_HISTORY
- QNA_HISTORY_ID — NUMBER
- QNA_ID — NUMBER — NOT NULL
- QNA_HISTORY_DATE — DATE — NOT NULL
- QNA_HISTORY_TYPE — VARCHAR2(100) — NOT NULL
QNA_HISTORY_TYPE_CODE
- CODE — VARCHAR2(100)
- NAME — VARCHAR2(100) — NOT NULL
REPLY
- REPLY_ID — NUMBER
- REPLY_BOARD_ID — NUMBER — NOT NULL
- REPLY_MEMBER_NO — NUMBER — NOT NULL
- REPLY_DATE — DATE — NOT NULL
- REPLY_STATUS — VARCHAR2(100)
- N)) — NOT — NOT NULL
- REPLY_CONTENT — VARCHAR2(200) — NOT NULL
REPORT
- REPORT_ID — NUMBER
- REPORTING_MEMBER_NO — NUMBER — NOT NULL
- REPORTED_MEMBER_NO — NUMBER — NOT NULL
- REPORT_CONTENT — VARCHAR2(1000) — NOT NULL
- REPORT_DATE — DATE — NOT NULL
- REPORT_BOARD — NUMBER
- REPORT_REPLY — NUMBER
- REPORT_TYPE — VARCHAR2(100) — NOT NULL
REPORT_TYPE_CODE
- CODE — VARCHAR2(100)
- NAME — VARCHAR2(100) — NOT NULL
SHIPMENT
- SHIPMENT_WAYBILL — NUMBER
- MEMBER_SHIPMENT_ID — NUMBER — NOT NULL
SHIPMENT_HISTORY
- SHIPMENT_HISTORY_ID — NUMBER
- SHIPMENT_HISTORY_DATE — DATE — NOT NULL
- SHIPMENT_HISTORY_TYPE — VARCHAR2(100) — NOT NULL
- SHIPMENT_WAYBILL — NUMBER — NOT NULL
SHIPMENT_HISTORY_TYPE_CODE
- CODE — VARCHAR2(100)
- NAME — VARCHAR2(100) — NOT NULL
WATCH
- WATCH_ID — NUMBER
- WATCH_GUARANTEE_YN — VARCHAR2(100)
- N)) — NOT — NOT NULL
- WATCH_BOX_YN — VARCHAR2(100)
- N)) — NOT — NOT NULL
- WATCH_MATERIAL — VARCHAR2(100) — NOT NULL
- WATCH_MOVEMENT — VARCHAR2(100) — NOT NULL
- WATCH_CHRONOGRAPH — VARCHAR2(100) — NOT NULL
WIN
- WIN_AUCTION_ID — NUMBER
- WIN_MEMBER_NO — NUMBER — NOT NULL
- WIN_PRICE — NUMBER — NOT NULL
WISHLIST
- WISHLIST_AUCTION_ID — NUMBER — NOT NULL
- WISHLIST_MEMBER_NO — NUMBER — NOT NULL