col11

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)