col0
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