col10

Tables (50)

ACCOUNT_STATUS

  • ACCOUNT_STATUS_NO — NUMBER(2,0)
  • STATUS_DETAIL — VARCHAR2(10 BYTE)

ADS_STATUS

  • ADS_STATUS_NO — NUMBER
  • STATUS_DESC — VARCHAR2(30 BYTE)

ARTICLE_STATUS

  • ARTICLE_STATUS_NO — NUMBER(2,0)
  • STATUS_DESC — VARCHAR2(30 BYTE)

AUCTION_ADS

  • ADS_KEY — NUMBER
  • APPLICANT_KEY — NUMBER — Foreign key
  • START_DATE — DATE
  • END_DATE — DATE
  • APPLY_DATE — DATE
  • ADS_MEMO — VARCHAR2(300 BYTE)
  • ADS_STATUS_NO — NUMBER(2,0) — Foreign key → ADS_STATUS.ADS_STATUS_NO
  • ARTICLE_NO — NUMBER — Foreign key → BOARD_AUCTION.ARTICLE_NO

AUCTION_BID

  • BID_KEY — NUMBER
  • ARTICLE_NO — NUMBER — Foreign key → BOARD_AUCTION.ARTICLE_NO
  • WRITER_KEY — NUMBER — Foreign key

AUCTION_COMMENT

  • COMMENT_NO — NUMBER
  • COMMENT_CONTENT — VARCHAR2(600 BYTE)
  • WRITER_KEY — NUMBER — Foreign key
  • WRITTEN_DATE — DATE
  • MODIFIED_DATE — DATE
  • ARTICLE_STATUS_NO — NUMBER(2,0) — Foreign key → ARTICLE_STATUS.ARTICLE_STATUS_NO
  • REF_ARTICLE — NUMBER — Foreign key → BOARD_AUCTION.ARTICLE_NO
  • REF_COMMENT — NUMBER — Foreign key → AUCTION_COMMENT.COMMENT_NO
  • ORIGINAL_FILE_NAME — VARCHAR2(500 BYTE)
  • RENAMED_FILE_NAME — VARCHAR2(500 BYTE)

AUCTION_COMMENT_LIKE

  • COMMENT_NO — NUMBER — Foreign key → AUCTION_COMMENT.COMMENT_NO
  • MEMBER_KEY — NUMBER — Foreign key
  • LIKED_DATE — DATE

AUCTION_ORDER_HISTORY

  • ORDER_NO — NUMBER — Foreign key
  • BID_KEY — NUMBER — Foreign key → AUCTION_BID.BID_KEY

AUCTION_STATUS

  • AUCTION_STATUS_NO — NUMBER(2,0)
  • STATUS_DESC — VARCHAR2(30 BYTE)

BANK_CODE

  • BANK_CODE — NUMBER(4,0)
  • BANK_NAME — VARCHAR2(15 BYTE)

BANNER_ADS

  • ADS_KEY — NUMBER — Foreign key → BANNER_ADS_APPLICATION.ADS_KEY
  • BANNER_ORDER — NUMBER

BANNER_ADS_APPLICATION

  • ADS_KEY — NUMBER
  • APPLICANT_KEY — NUMBER — Foreign key
  • ADS_ORIGINAL_FILE_NAME — VARCHAR2(500 BYTE)
  • ADS_RENAMED_FILE_NAME — VARCHAR2(500 BYTE)
  • START_DATE — DATE
  • END_DATE — DATE
  • APPLY_DATE — DATE
  • URL_LINK — VARCHAR2(500 BYTE)
  • ADS_DESCRIPTION — VARCHAR2(300 BYTE)
  • ADS_MEMO — VARCHAR2(300 BYTE)
  • ADS_STATUS_NO — NUMBER — Foreign key → ADS_STATUS.ADS_STATUS_NO

BA_ATTACHED_FILE

  • FILE_KEY — NUMBER
  • ARTICLE_NO — NUMBER — Foreign key → BOARD_AUCTION.ARTICLE_NO
  • ORIGINAL_FILE_NAME — VARCHAR2(500 BYTE)
  • RENAMED_FILE_NAME — VARCHAR2(500 BYTE)

BA_ATTACHED_IMAGE

  • IMAGE_KEY — NUMBER
  • ARTICLE_NO — NUMBER — Foreign key → BOARD_AUCTION.ARTICLE_NO
  • ORIGINAL_FILE_NAME — VARCHAR2(500 BYTE)
  • RENAMED_FILE_NAME — VARCHAR2(500 BYTE)

BCM_ARTICLE

  • ARTICLE_NO — NUMBER
  • THREAD_KEY — NUMBER — Foreign key → BOARD_CLAIM_MAGICIAN.THREAD_KEY
  • ARTICLE_CONTENT — VARCHAR2(4000 BYTE)
  • WRITER_KEY — NUMBER — Foreign key
  • WRITTEN_DATE — DATE
  • MODIFIED_DATE — DATE
  • ARTICLE_STATUS_NO — NUMBER(2,0) — Foreign key → ARTICLE_STATUS.ARTICLE_STATUS_NO
  • REF_ARTICLE — NUMBER — Foreign key → BCM_ARTICLE.ARTICLE_NO

BCM_ARTICLE_LIKE

  • ARTICLE_NO — NUMBER — Foreign key → BCM_ARTICLE.ARTICLE_NO
  • MEMBER_KEY — NUMBER — Foreign key
  • LIKED_DATE — DATE

BCM_ATTACHED_FILE

  • FILE_KEY — NUMBER
  • ARTICLE_NO — NUMBER — Foreign key → BCM_ARTICLE.ARTICLE_NO
  • ORIGINAL_FILE_NAME — VARCHAR2(500 BYTE)
  • RENAMED_FILE_NAME — VARCHAR2(500 BYTE)

BCM_ATTACHED_IMAGE

  • IMAGE_KEY — NUMBER
  • ARTICLE_NO — NUMBER — Foreign key → BCM_ARTICLE.ARTICLE_NO
  • ORIGINAL_FILE_NAME — VARCHAR2(500 BYTE)
  • RENAMED_FILE_NAME — VARCHAR2(500 BYTE)

BCM_LIKE

  • THREAD_KEY — NUMBER — Foreign key → BOARD_CLAIM_MAGICIAN.THREAD_KEY
  • MEMBER_KEY — NUMBER — Foreign key
  • LIKED_DATE — DATE

BDI_ARTICLE

  • ARTICLE_NO — NUMBER
  • THREAD_KEY — NUMBER — Foreign key → BOARD_DIRECT_INQUIRY.THREAD_KEY
  • ARTICLE_CONTENT — VARCHAR2(4000 BYTE)
  • WRITER_KEY — NUMBER — Foreign key
  • WRITTEN_DATE — DATE
  • MODIFIED_DATE — DATE
  • ARTICLE_STATUS_NO — NUMBER(2,0) — Foreign key → ARTICLE_STATUS.ARTICLE_STATUS_NO
  • REF_ARTICLE — NUMBER — Foreign key → BDI_ARTICLE.ARTICLE_NO

BDI_ARTICLE_LIKE

  • ARTICLE_NO — NUMBER — Foreign key → BDI_ARTICLE.ARTICLE_NO
  • MEMBER_KEY — NUMBER — Foreign key
  • LIKED_DATE — DATE

BDI_ATTACHED_FILE

  • FILE_KEY — NUMBER
  • ARTICLE_NO — NUMBER — Foreign key → BDI_ARTICLE.ARTICLE_NO
  • ORIGINAL_FILE_NAME — VARCHAR2(500 BYTE)
  • RENAMED_FILE_NAME — VARCHAR2(500 BYTE)

BDI_ATTACHED_IMAGE

  • IMAGE_KEY — NUMBER
  • ARTICLE_NO — NUMBER — Foreign key → BDI_ARTICLE.ARTICLE_NO
  • ORIGINAL_FILE_NAME — VARCHAR2(500 BYTE)
  • RENAMED_FILE_NAME — VARCHAR2(500 BYTE)

BDI_LIKE

  • THREAD_KEY — NUMBER — Foreign key → BOARD_DIRECT_INQUIRY.THREAD_KEY
  • MEMBER_KEY — NUMBER — Foreign key
  • LIKED_DATE — DATE

BDS_ATTACHED_IMAGE

  • PRODUCT_NO — NUMBER — Foreign key
  • PRODUCT_IMAGE_NO — NUMBER
  • P_ORIGINAL_FILE_NAME — VARCHAR2(500 BYTE)
  • P_RENAMED_FILE_NAME — VARCHAR2(500 BYTE)

BDS_REVIEW

  • REVIEW_NO — NUMBER
  • REVIEW_CONTENT — VARCHAR2(4000 BYTE)
  • WRITER_KEY — NUMBER — Foreign key
  • WRITTEN_DATE — DATE
  • MODIFIED_DATE — DATE
  • REVIEW_STATUS_NO — NUMBER — Foreign key → ARTICLE_STATUS.ARTICLE_STATUS_NO
  • REF_ARTICLE — NUMBER — Foreign key → BOARD_DIRECT_SALE.ARTICLE_NO
  • REF_REVIEW — NUMBER — Foreign key → BDS_REVIEW.REVIEW_NO
  • R_ORIGINAL_FILE_NAME — VARCHAR2(500 BYTE)
  • R_RENAMED_FILE_NAME — VARCHAR2(500 BYTE)

BDS_REVIEW_LIKE

  • REVIEW_NO — NUMBER — Foreign key → BDS_REVIEW.REVIEW_NO
  • MEMBER_KEY — NUMBER — Foreign key
  • LIKED_DATE — DATE

BID_CONTENT

  • BID_KEY — NUMBER — Foreign key → AUCTION_BID.BID_KEY
  • PRODUCT_NAME — VARCHAR2(200 BYTE)
  • PRODUCT_QUALITY — VARCHAR2(200 BYTE)
  • PRODUCT_ORIGIN — VARCHAR2(200 BYTE)
  • PRODUCT_QUANTITY — NUMBER
  • MEASURE_UNIT — VARCHAR2(10 BYTE)
  • PRICE — NUMBER
  • PRODUCTION_DATE — DATE
  • EXPIRY_DATE — DATE

BKB_ARTICLE

  • ARTICLE_NO — NUMBER
  • THREAD_KEY — NUMBER — Foreign key → BOARD_KNOW_BATTLE.THREAD_KEY
  • ARTICLE_CONTENT — VARCHAR2(4000 BYTE)
  • WRITER_KEY — NUMBER — Foreign key
  • WRITTEN_DATE — DATE
  • MODIFIED_DATE — DATE
  • ARTICLE_STATUS_NO — NUMBER(2,0) — Foreign key → ARTICLE_STATUS.ARTICLE_STATUS_NO
  • REF_ARTICLE — NUMBER — Foreign key → BKB_ARTICLE.ARTICLE_NO

BKB_ARTICLE_LIKE

  • ARTICLE_NO — NUMBER — Foreign key → BKB_ARTICLE.ARTICLE_NO
  • MEMBER_KEY — NUMBER — Foreign key
  • LIKED_DATE — DATE

BKB_ATTACHED_FILE

  • FILE_KEY — NUMBER
  • ARTICLE_NO — NUMBER — Foreign key → BKB_ARTICLE.ARTICLE_NO
  • ORIGINAL_FILE_NAME — VARCHAR2(500 BYTE)
  • RENAMED_FILE_NAME — VARCHAR2(500 BYTE)

BKB_ATTACHED_IMAGE

  • IMAGE_KEY — NUMBER
  • ARTICLE_NO — NUMBER — Foreign key → BKB_ARTICLE.ARTICLE_NO
  • ORIGINAL_FILE_NAME — VARCHAR2(500 BYTE)
  • RENAMED_FILE_NAME — VARCHAR2(500 BYTE)

BKB_LIKE

  • THREAD_KEY — NUMBER — Foreign key → BOARD_KNOW_BATTLE.THREAD_KEY
  • MEMBER_KEY — NUMBER — Foreign key
  • LIKED_DATE — DATE

BOARD_AUCTION

  • ARTICLE_NO — NUMBER
  • TITLE — VARCHAR2(200 BYTE)
  • WRITER_KEY — NUMBER — Foreign key → BUSINESS.BUSINESS_KEY
  • WRITTEN_DATE — DATE
  • MODIFIED_DATE — DATE
  • START_DATE — DATE
  • END_DATE — DATE
  • READ_COUNT — NUMBER
  • AUCTION_STATUS_NO — NUMBER(2,0) — Foreign key → AUCTION_STATUS.AUCTION_STATUS_NO

BOARD_CLAIM_MAGICIAN

  • THREAD_KEY — NUMBER
  • THREAD_TITLE — VARCHAR2(200 BYTE)
  • WRITER_KEY — NUMBER — Foreign key
  • WRITTEN_DATE — DATE
  • MODIFIED_DATE — DATE
  • READ_COUNT — NUMBER
  • THREAD_STATUS_NO — NUMBER(2,0) — Foreign key

BOARD_DIRECT_INQUIRY

  • THREAD_KEY — NUMBER
  • THREAD_TITLE — VARCHAR2(200 BYTE)
  • WRITER_KEY — NUMBER — Foreign key
  • WRITTEN_DATE — DATE
  • MODIFIED_DATE — DATE
  • READ_COUNT — NUMBER
  • THREAD_STATUS_NO — NUMBER(2,0) — Foreign key

BOARD_DIRECT_SALE

  • ARTICLE_NO — NUMBER
  • TITLE — VARCHAR2(200 BYTE)
  • BUSINESS_KEY — NUMBER — Foreign key → BUSINESS.BUSINESS_KEY
  • WRITTEN_DATE — DATE
  • MODIFIED_DATE — DATE
  • SALE_CONTENT — VARCHAR2(4000 BYTE)
  • ORDER_COUNT — NUMBER
  • SALE_STATUS_NO — NUMBER(2,0) — Foreign key

BOARD_KNOW_BATTLE

  • THREAD_KEY — NUMBER
  • THREAD_TITLE — VARCHAR2(200 BYTE)
  • WRITER_KEY — NUMBER — Foreign key
  • WRITTEN_DATE — DATE
  • MODIFIED_DATE — DATE
  • READ_COUNT — NUMBER
  • THREAD_STATUS_NO — NUMBER(2,0) — Foreign key

BOARD_PENALTY

  • BOARD_PENALTY_IDX — NUMBER(2,0)
  • PENALTY_DESC — VARCHAR2(30 BYTE)

BOARD_PENALTY_HISTORY

  • PENALTY_KEY — NUMBER
  • BOARD_TYPE_NO — NUMBER(2,0) — Foreign key → BOARD_TYPE.BOARD_TYPE_NO
  • BP_SCOPE_NO — NUMBER(2,0) — Foreign key → BOARD_PENALTY_SCOPE.BP_SCOPE_NO
  • THREAD_KEY — NUMBER
  • ARTICLE_NO — NUMBER
  • REVIEW_NO — NUMBER
  • COMMENT_NO — NUMBER
  • BOARD_PENALTY_IDX — NUMBER(2,0) — Foreign key → BOARD_PENALTY.BOARD_PENALTY_IDX
  • P_START_DATE — DATE
  • P_END_DATE — DATE

BOARD_PENALTY_SCOPE

  • BP_SCOPE_NO — NUMBER(2,0)
  • SCOPE_DESC — VARCHAR2(30 BYTE)

BOARD_TYPE

  • BOARD_TYPE_NO — NUMBER(2,0)
  • TYPE_DESC — VARCHAR2(30 BYTE)

BUSINESS

  • BUSINESS_KEY — NUMBER
  • MEMBER_KEY — NUMBER — Foreign key
  • BUSINESS_NO — VARCHAR2(12 BYTE)
  • BUSINESS_NAME — VARCHAR2(40 BYTE)
  • BUSINESS_TEL — VARCHAR2(30 BYTE)
  • BANK_CODE — NUMBER(4,0) — Foreign key → BANK_CODE.BANK_CODE
  • BANK_ACCOUNT_NO — VARCHAR2(20 BYTE)
  • BANK_ACCOUNT_NAME — VARCHAR2(40 BYTE)
  • IS_VERIFIED — NUMBER(1,0)
  • REG_DATE — DATE

BUSINESS_CATEGORIES

  • BUSINESS_KEY — NUMBER — Foreign key → BUSINESS.BUSINESS_KEY
  • BUSINESS_CATEGORY_NO — NUMBER — Foreign key → BUSINESS_CATEGORY_DESC.BUSINESS_CATEGORY_NO

BUSINESS_CATEGORY_DESC

  • BUSINESS_CATEGORY_NO — NUMBER
  • BC_DESC — VARCHAR2(30 BYTE)

BUSINESS_LIKE

  • TARGET_BUSINESS — NUMBER — Foreign key → BUSINESS.BUSINESS_KEY
  • ACTOR_KEY — NUMBER — Foreign key
  • LIKED_DATE — DATE

CART

  • MEMBER_KEY — NUMBER — Foreign key
  • PRODUCT_NO — NUMBER — Foreign key
  • AMOUNT — NUMBER

CATEGORIES

  • CATEGORY_NO — NUMBER
  • CATEGORY_DESC — VARCHAR2(20 BYTE)

CHATROOM

  • CHATROOM_KEY — NUMBER
  • USER1 — NUMBER — Foreign key
  • USER2 — NUMBER — Foreign key

CHAT_MSG

  • CHATROOM_KEY — NUMBER — Foreign key → CHATROOM.CHATROOM_KEY
  • WRITER_KEY — NUMBER — Foreign key
  • MSG_CONTENT — VARCHAR2(300 BYTE)
  • MSG_TIME — DATE
  • ADS_ORIGINAL_FILE_NAME — VARCHAR2(500 BYTE)
  • ADS_RENAMED_FILE_NAME — VARCHAR2(500 BYTE)
  • MSG_STATUS_NO — NUMBER — Foreign key
  • MSG_TYPE_NO — NUMBER — Foreign key