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