col5
Tables (78)
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
CHAT_MSG_TYPE
- MSG_TYPE_NO — NUMBER
- TYPE_DESC — VARCHAR2(20 BYTE)
DIRECT_SALES_ADS
- ADS_KEY — NUMBER
- APPLICANT_KEY — NUMBER — Foreign key → MEMBER.MEMBER_KEY
- START_DATE — DATE
- END_DATE — DATE
- APPLY_DATE — DATE
- ADS_MEMO — VARCHAR2(300 BYTE)
- ADS_STATUS_NO — NUMBER(2,0) — Foreign key
- ARTICLE_NO — NUMBER — Foreign key
DIRECT_SALE_ORDER_HISTORY
- ORDER_NO — NUMBER — Foreign key → ORDERS.ORDER_NO
- PRODUCT_NO — NUMBER — Foreign key → DIRECT_SALE_PRODUCT.PRODUCT_NO
- AMOUNT — NUMBER
- ORDER_STATUS_NO — NUMBER(2,0) — Foreign key → ORDER_STATUS.ORDER_STATUS_NO
- EVENT_DATE — DATE
DIRECT_SALE_PRODUCT
- PRODUCT_NO — NUMBER
- 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
- REMAINING_QUANTITY — NUMBER
- PRODUCTION_DATE — DATE
- EXPIRY_DATE — DATE
- ARTICLE_NO — NUMBER — Foreign key
- PRODUCT_STATUS_NO — NUMBER — Foreign key → PRODUCT_STATUS.PRODUCT_STATUS_NO
EMAIL_CHECK
- MEMBER_KEY — NUMBER — Foreign key → MEMBER.MEMBER_KEY
- SENT_DATE — DATE
- CONFIRMATION_KEY — VARCHAR2(100 BYTE)
- TRY_COUNT — NUMBER
LOGIN_SOURCE
- LOGIN_SOURCE_NO — NUMBER(2,0)
- DESCRIPTION — VARCHAR2(20 BYTE)
LOGIN_STATUS
- LOGIN_STATUS_NO — NUMBER(2,0)
- DESCRIPTION — VARCHAR2(20 BYTE)
MEMBER
- MEMBER_KEY — NUMBER
- ID — VARCHAR2(30 BYTE)
- PASSWORD — VARCHAR2(50 BYTE)
- USERNAME — VARCHAR2(30 BYTE)
- NICKNAME — VARCHAR2(20 BYTE)
- PHONE — VARCHAR2(18 BYTE)
- EMAIL — VARCHAR2(70 BYTE)
- POSTCODE — NUMBER(6,0)
- ADDRESS1 — VARCHAR2(70 BYTE)
- ADDRESS2 — VARCHAR2(70 BYTE)
- LEVEL_NO — NUMBER — Foreign key → MEMBER_LEVEL.LEVEL_NO
- ENROLL_DATE — DATE
- MODIFIED_DATE — DATE
- PROFILE_URL — VARCHAR2(400 BYTE)
- IS_CONFIRMED — NUMBER(1,0)
- ACCOUNT_STATUS_NO — NUMBER(2,0) — Foreign key
MEMBER_LEVEL
- LEVEL_NO — NUMBER
- LEVEL_DESC — VARCHAR2(10 BYTE)
MEMBER_LIKE
- TARGET_MEMBER — NUMBER — Foreign key → MEMBER.MEMBER_KEY
- ACTOR_KEY — NUMBER — Foreign key → MEMBER.MEMBER_KEY
- LIKED_DATE — DATE
MEMBER_LOG
- MEMBER_KEY — NUMBER — Foreign key → MEMBER.MEMBER_KEY
- LOGIN_DATE — DATE
- LOGIN_STATUS_NO — NUMBER(2,0) — Foreign key → LOGIN_STATUS.LOGIN_STATUS_NO
- LOGIN_SOURCE_NO — NUMBER(2,0) — Foreign key → LOGIN_SOURCE.LOGIN_SOURCE_NO
MEMBER_PENALTY
- MEMBER_PENALTY_IDX — NUMBER(2,0)
- PENALTY_DESC — VARCHAR2(30 BYTE)
MEMBER_PENALTY_HISTORY
- PENALTY_KEY — NUMBER
- TARGET_MEMBER — NUMBER — Foreign key → MEMBER.MEMBER_KEY
- MEMBER_PENALTY_IDX — NUMBER(2,0) — Foreign key → MEMBER_PENALTY.MEMBER_PENALTY_IDX
- P_START_DATE — DATE
- P_END_DATE — DATE
MSG_STATUS
- MSG_STATUS_NO — NUMBER
- STATUS_DESC — VARCHAR2(10 BYTE)
ORDERS
- ORDER_NO — NUMBER
- BUYER_KEY — NUMBER — Foreign key → MEMBER.MEMBER_KEY
- ORDERED_DATE — DATE
- LAST_MODIFIED_DATE — DATE
- PAYMENT_METHOD — VARCHAR2(20 BYTE)
- ORDER_STATUS_NO — NUMBER(2,0) — Foreign key → ORDER_STATUS.ORDER_STATUS_NO
- APPLY_NUM — VARCHAR2(30 BYTE)
- MERCHANT_UID — VARCHAR2(30 BYTE)
- BUYER_TEL — VARCHAR2(20 BYTE)
- RECEIVER_NAME — VARCHAR2(30 BYTE)
- RECEIVER_TEL — VARCHAR2(20 BYTE)
- RECEIVER_POSTCODE — NUMBER(6,0)
- RECEIVER_ADDR1 — VARCHAR2(50 BYTE)
- RECEIVER_ADDR2 — VARCHAR2(50 BYTE)
- RECEIVER_COMMENT — VARCHAR2(40 BYTE)
- DISCOUNT — NUMBER
- TOTAL_PRICE — NUMBER
ORDER_STATUS
- ORDER_STATUS_NO — NUMBER(2,0)
- STATUS_DESC — VARCHAR2(30 BYTE)
POINT
- MEMBER_KEY — NUMBER — Foreign key → MEMBER.MEMBER_KEY
- POINT_DIFFERENCE — NUMBER
- OCCUR_DATE — DATE
PRODUCT_STATUS
- PRODUCT_STATUS_NO — NUMBER(2,0)
- STATUS_DESC — VARCHAR2(30 BYTE)
REPORTS
- REPORT_KEY — NUMBER
- REPORTING_MEMBER — NUMBER — Foreign key → MEMBER.MEMBER_KEY
- REPORT_TARGET_NO — NUMBER(2,0) — Foreign key → REPORT_TARGET.REPORT_TARGET_NO
- TARGET_NO — NUMBER
- REPORT_CRITERIA — NUMBER(3,0) — Foreign key → REPORT_CRITERIA.CRITERIA_NO
- REPORT_DETAIL — VARCHAR2(2000 BYTE)
- REPORT_DATE — DATE
- REPORT_STATUS_NO — NUMBER(2,0) — Foreign key → REPORT_STATUS.REPORT_STATUS_NO
- MEMO — VARCHAR2(2000 BYTE)
REPORT_CRITERIA
- CRITERIA_NO — NUMBER(3,0)
- CRITERIA_DESC — VARCHAR2(30 BYTE)
REPORT_RESULT
- REPORT_KEY — NUMBER — Foreign key → REPORTS.REPORT_KEY
- PENALTY_TARGET — NUMBER — Foreign key → REPORT_TARGET.REPORT_TARGET_NO
- PENALTY_KEY — NUMBER
REPORT_STATUS
- REPORT_STATUS_NO — NUMBER(2,0)
- STATUS_DESC — VARCHAR2(30 BYTE)
REPORT_TARGET
- REPORT_TARGET_NO — NUMBER(2,0)
- TARGET_DESC — VARCHAR2(30 BYTE)
SALE_STATUS
- SALE_STATUS_NO — NUMBER(2,0)
- STATUS_DESC — VARCHAR2(30 BYTE)
SNS_LOGIN
- MEMBER_KEY — NUMBER — Foreign key → MEMBER.MEMBER_KEY
- LOGIN_SOURCE_NO — NUMBER(2,0) — Foreign key → LOGIN_SOURCE.LOGIN_SOURCE_NO
- SNS_ID — VARCHAR2(100 BYTE)
- SNS_NAME — VARCHAR2(50 BYTE)
- SNS_PROFILE_PIC — VARCHAR2(1000 BYTE)
- SNS_CONNECT_DATE — DATE
- ACCESS_TOKEN — VARCHAR2(500 BYTE)
- REFRESH_TOKEN — VARCHAR2(500 BYTE)
- REFRESH_TOKEN_VALID_DATE — DATE
THREAD_STATUS
- THREAD_STATUS_NO — NUMBER(2,0)
- STATUS_DESC — VARCHAR2(30 BYTE)
TRANSFER_HISTORY
- TRANSFER_NO — NUMBER
- MEMBER_KEY — NUMBER — Foreign key → MEMBER.MEMBER_KEY
- TRANSFER_AMOUNT — NUMBER
- TRANSFER_DATE — DATE
- TRANSFER_STATUS_NO — NUMBER(2,0) — Foreign key → TRANSFER_STATUS.TRANSFER_STATUS_NO
- ORDER_NO — NUMBER — Foreign key → ORDERS.ORDER_NO
TRANSFER_STATUS
- TRANSFER_STATUS_NO — NUMBER(2,0)
- STATUS_DESC — VARCHAR2(30 BYTE)