최종

테이블 (26)

CART

  • CART_ID — NUMBER — 기본 키 — NOT NULL
  • PRODUCT_ID — NUMBER — NOT NULL
  • MEMBER_ID — NUMBER — NOT NULL
  • CART_COUNT — NUMBER — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — NUMBER — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_BY — NUMBER — NOT NULL
  • DELETED_AT — TIMESTAMP
  • DELETED_BY — NUMBER

CATEGORY

  • CATEGORY_ID — NUMBER — 기본 키 — NOT NULL
  • CATEGORY_NAME — VARCHAR2(50) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — NUMBER — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_BY — NUMBER — NOT NULL
  • DELETED_AT — TIMESTAMP
  • DELETED_BY — NUMBER

CHAT

  • CHAT_ID — NUMBER — 기본 키 — NOT NULL
  • CATEGORY_ID — NUMBER — NOT NULL
  • PRODUCT_ID — NUMBER
  • MESSAGE_CONTENT — VARCHAR2(2000) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • MEMBER_ID — NUMBER — NOT NULL

COMBINATION

  • COMBINATION_ID — NUMBER — 기본 키 — NOT NULL
  • MEMBER_ID — NUMBER — NOT NULL
  • COMBINATION_NAME — VARCHAR2(100) — NOT NULL
  • COMBINATION_DESCRIPTION — VARCHAR2(2000) — NOT NULL
  • LIKES — NUMBER — NOT NULL
  • BH_TYPE — NUMBER(1) — NOT NULL — 0:뷰티, 1:헬스
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — NUMBER — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_BY — NUMBER — NOT NULL
  • DELETED_AT — TIMESTAMP
  • DELETED_BY — NUMBER

COMBINATION_ITEM

  • COMBINATION_ITEM_ID — NUMBER — 기본 키 — NOT NULL
  • COMBINATION_ID — NUMBER — NOT NULL
  • PRODUCT_ID — NUMBER — NOT NULL

EFFECT

  • EFFECT_ID — NUMBER — 기본 키 — NOT NULL
  • EFFECT_NAME — VARCHAR2(200) — NOT NULL
  • BH_TYPE — NUMBER — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — NUMBER — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_BY — NUMBER — NOT NULL
  • DELETED_AT — TIMESTAMP
  • DELETED_BY — NUMBER

HAIR_CONCERN

  • MEMBER_ID — NUMBER — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
  • HAIR_LOSS — NUMBER(1) — NOT NULL
  • DAMAGED_HAIR — NUMBER(1) — NOT NULL
  • SCALP_TROUBLE — NUMBER(1) — NOT NULL
  • DANDRUFF — NUMBER(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — NUMBER — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_BY — NUMBER — NOT NULL

HEALTH_CONCERN

  • MEMBER_ID — NUMBER — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
  • EYE_HEALTH — NUMBER(1) — NOT NULL
  • FATIGUE — NUMBER(1) — NOT NULL
  • SLEEP_STRESS — NUMBER(1) — NOT NULL
  • IMMUNE_CARE — NUMBER(1) — NOT NULL
  • MUSCLE_HEALTH — NUMBER(1) — NOT NULL
  • GUT_HEALTH — NUMBER(1) — NOT NULL
  • BLOOD_CIRCULATION — NUMBER(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — NUMBER — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_BY — NUMBER — NOT NULL

HEALTH_INFO

  • STEPS — NUMBER
  • BLOOD_GLUCOSE — NUMBER
  • BLOOD_PRESSURE — NUMBER
  • TOTAL_CALORIES_BURNED — NUMBER
  • NUTRITION — NUMBER
  • SLEEPSESSION — NUMBER
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — NUMBER — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_BY — NUMBER — NOT NULL

INGREDIENT_RULE

  • INGREDIENT_RULE_ID — NUMBER — 기본 키 — NOT NULL
  • INGREDIENT_NAME — VARCHAR2(200) — NOT NULL
  • INGREDIENT_CATEGORY — NUMBER(1) — NOT NULL
  • DESCRIPTION — VARCHAR2(1000)
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — NUMBER — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_BY — NUMBER — NOT NULL

MEMBER

  • MEMBER_ID — NUMBER — 기본 키 — NOT NULL
  • EMAIL — VARCHAR2(100) — NOT NULL — UNIQUE
  • NICKNAME — VARCHAR2(100) — NOT NULL — UNIQUE
  • MEMBER_NAME — VARCHAR2(100) — NOT NULL
  • PASSWORD — VARCHAR2(100) — NOT NULL
  • ZIPCODE — NUMBER — NOT NULL
  • ROAD_ADDRESS — VARCHAR2(500) — NOT NULL
  • DETAIL_ADDRESS — VARCHAR2(500) — NOT NULL
  • OAUTH_ID — VARCHAR2(100)
  • GENDER — VARCHAR2(2) — NOT NULL
  • BIRTHDAY — DATE — NOT NULL
  • PHONE_NUMBER — VARCHAR2(20) — NOT NULL
  • PROFILE_URL — VARCHAR2(500) — NOT NULL
  • DELIVERY_NOTE — VARCHAR2(100)
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — NUMBER — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_BY — NUMBER — NOT NULL
  • DELETED_AT — TIMESTAMP
  • DELETED_BY — NUMBER

MEMBER_DEVICE

  • MEMBER_DEVICE_ID — NUMBER — 기본 키 — NOT NULL
  • PLATFORM — VARCHAR2(10) — NOT NULL
  • FCM_TOKEN — VARCHAR2(500) — NOT NULL
  • DEVICE_ID — VARCHAR2(100)
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — NUMBER — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_BY — NUMBER — NOT NULL
  • IS_ACTIVE — NUMBER(1) — NOT NULL
  • LAST_SUCCESS_AT — TIMESTAMP
  • MEMBER_ID — NUMBER — NOT NULL

MEMBER_PRODUCT

  • MEMBER_PRODUCT_ID — NUMBER — 기본 키 — NOT NULL
  • PRODUCT_ID — NUMBER
  • ORDER_ITEM_ID — NUMBER
  • MEMBER_ID — NUMBER — NOT NULL
  • BH_TYPE — NUMBER(1) — NOT NULL
  • START_DATE — DATE — NOT NULL
  • RECOMMENDED_EXPIRATION_DATE — NUMBER — NOT NULL
  • USAGE_STATUS — NUMBER — NOT NULL
  • PRODUCT_NAME — VARCHAR2(200) — NOT NULL
  • BRAND_NAME — VARCHAR2(100) — NOT NULL
  • CATEGORY_ID — NUMBER
  • COMPLETED_DATE — DATE
  • EXPIRY7_ALERT_SENT — NUMBER(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — NUMBER — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_BY — NUMBER — NOT NULL
  • DELETED_AT — TIMESTAMP
  • DELETED_BY — NUMBER

MEMBER_PRODUCT_EFFECT

  • MEMBER_PRODUCT_EFFECT_ID — NUMBER — 기본 키 — NOT NULL
  • MEMBER_PRODUCT_ID — NUMBER — NOT NULL
  • EFFECT_ID — NUMBER — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — NUMBER — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_BY — NUMBER — NOT NULL

NOTIFICATION

  • NOTIFICATION_ID — NUMBER — 기본 키 — NOT NULL
  • MEMBER_ID — NUMBER — NOT NULL
  • TITLE — VARCHAR2(100) — NOT NULL
  • BODY — VARCHAR2(500) — NOT NULL
  • IMAGE_URL — VARCHAR2(500)
  • DEEPLINK — VARCHAR2(200)
  • TYPE — VARCHAR2(50) — NOT NULL
  • IS_READ — NUMBER(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • READ_AT — TIMESTAMP

ORDERS

  • ORDER_ID — NUMBER — 기본 키 — NOT NULL
  • MEMBER_ID — NUMBER — NOT NULL
  • ORDER_CODE — VARCHAR2(100) — NOT NULL
  • TOTAL_PRICE — NUMBER — NOT NULL
  • GOODS_AMOUNT — NUMBER — NOT NULL
  • DELIVERY_ADDRESS — VARCHAR2(255) — NOT NULL
  • ZIPCODE — NUMBER — NOT NULL
  • DETAIL_ADDRESS — VARCHAR2(500) — NOT NULL
  • ROAD_ADDRESS — VARCHAR2(500) — NOT NULL
  • ORDER_STATUS — NUMBER — NOT NULL
  • EXPIRES_AT — TIMESTAMP — NOT NULL
  • DELIVERY_FEE — NUMBER — NOT NULL
  • DISCOUNT — NUMBER — NOT NULL
  • ORDER_SUMMARY — VARCHAR2(300)
  • DELIVERED_AT — TIMESTAMP
  • DEPOSITED_AT — TIMESTAMP
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — NUMBER — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_BY — NUMBER — NOT NULL
  • DELETED_AT — TIMESTAMP
  • DELETED_BY — NUMBER

ORDER_ITEM

  • ORDER_ITEM_ID — NUMBER — 기본 키 — NOT NULL
  • PRODUCT_ID — NUMBER — NOT NULL
  • ORDER_ID — NUMBER — NOT NULL
  • ORDER_STATUS — NUMBER — NOT NULL
  • ITEM_COUNT — NUMBER — NOT NULL
  • ITEM_PRICE — NUMBER — NOT NULL
  • CANCELED_COUNT — NUMBER — NOT NULL
  • LINE_AMOUNT — NUMBER — NOT NULL
  • PRODUCT_NAME — VARCHAR2(200)
  • BRAND_NAME — VARCHAR2(100)
  • THUMBNAIL_URL — VARCHAR2(500)
  • ORG_UNIT_PRICE — NUMBER — NOT NULL
  • DISCOUNT_RATE — NUMBER — NOT NULL
  • STATUS_CHANGE_REASON — VARCHAR2(1000)
  • USED_COUNT — NUMBER — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — NUMBER — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_BY — NUMBER — NOT NULL
  • DELETED_AT — TIMESTAMP
  • DELETED_BY — NUMBER

PAYMENT

  • PAYMENT_ID — NUMBER — 기본 키 — NOT NULL
  • ORDER_ID — NUMBER — NOT NULL
  • ORDER_CODE — VARCHAR2(100) — NOT NULL
  • PAYMENT_KEY — VARCHAR2(200) — NOT NULL
  • METHOD — VARCHAR2(40) — NOT NULL
  • CURRENCY — VARCHAR2(3) — NOT NULL
  • TOTAL_AMOUNT — NUMBER — NOT NULL
  • BALANCE_AMOUNT — NUMBER — NOT NULL
  • STATUS — NUMBER — NOT NULL
  • APPROVED_AT — TIMESTAMP
  • RECEIPT_URL — VARCHAR2(500)
  • RAW_JSON — CLOB
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — NUMBER — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_BY — NUMBER — NOT NULL
  • VA_ACCOUNT_NO — VARCHAR2(50)
  • VA_BANK_CODE — VARCHAR2(10)
  • VA_ACCOUNT_TYPE — VARCHAR2(20)
  • VA_CUSTOMER_NAME — VARCHAR2(100)
  • VA_DEPOSITOR_NAME — VARCHAR2(100)
  • VA_DUE_DATE — TIMESTAMP
  • VA_EXPIRED — NUMBER(1)
  • VA_SETTLEMENT_STATUS — VARCHAR2(30)
  • VA_SECRET — VARCHAR2(200)
  • VA_REFUND_STATUS — VARCHAR2(30)

PAYMENT_CANCEL

  • PAYMENT_CANCEL_ID — NUMBER — 기본 키 — NOT NULL
  • PAYMENT_ID — NUMBER — NOT NULL
  • CANCEL_REQUEST_ID — VARCHAR2(100) — NOT NULL
  • CANCEL_AMOUNT — NUMBER — NOT NULL
  • TAX_FREE_AMOUNT — NUMBER — NOT NULL
  • CANCEL_REASON — VARCHAR2(200) — NOT NULL
  • CANCELED_AT — TIMESTAMP — NOT NULL
  • RAW_JSON — CLOB
  • SHIPPING_ADJ_APPLIED — NUMBER(1) — NOT NULL
  • REFUND_BANK_CODE — VARCHAR2(10)
  • REFUND_ACCOUNT_NO — VARCHAR2(50)
  • REFUND_HOLDER_NAME — VARCHAR2(100)

PRODUCT

  • PRODUCT_ID — NUMBER — 기본 키 — NOT NULL
  • CATEGORY_ID — NUMBER — NOT NULL
  • PRODUCT_NAME — VARCHAR2(200) — NOT NULL
  • BRAND_NAME — VARCHAR2(100) — NOT NULL
  • PRICE — NUMBER — NOT NULL
  • STOCK — NUMBER — NOT NULL
  • DISCOUNT_RATE — NUMBER — NOT NULL
  • THUMBNAIL_URL — VARCHAR2(500) — NOT NULL
  • RECOMMENDED_PERIOD — NUMBER — NOT NULL
  • BH_TYPE — NUMBER(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — NUMBER — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_BY — NUMBER — NOT NULL
  • DELETED_AT — TIMESTAMP
  • DELETED_BY — NUMBER

PRODUCT_EFFECT

  • PRODUCT_EFFECT_ID — NUMBER — 기본 키 — NOT NULL
  • EFFECT_ID — NUMBER — NOT NULL
  • PRODUCT_ID — NUMBER — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — NUMBER — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_BY — NUMBER — NOT NULL
  • DELETED_AT — TIMESTAMP
  • DELETED_BY — NUMBER

PRODUCT_IMAGE

  • PRODUCT_IMAGE_ID — NUMBER — 기본 키 — NOT NULL
  • PRODUCT_ID — NUMBER — NOT NULL
  • IMAGE_URL — VARCHAR2(500) — NOT NULL
  • IMAGE_ORDER — NUMBER — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — NUMBER — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_BY — NUMBER — NOT NULL
  • DELETED_AT — TIMESTAMP
  • DELETED_BY — NUMBER

PRODUCT_SKIN_COMPAT

  • SKIN_TYPE — NUMBER(1) — 기본 키 — NOT NULL
  • COMPAT — NUMBER(1) — NOT NULL

RECOMMEND_RESULT

  • BASE_PRODUCT_ID — NUMBER — NOT NULL
  • NEIGHBOR_PRODUCT_ID — NUMBER — NOT NULL
  • CATEGORY_ID — NUMBER — NOT NULL
  • SIM_OVERALL — NUMBER(9,6) — NOT NULL
  • RANK_ORDER — NUMBER — NOT NULL
  • SNAPSHOT_AT — TIMESTAMP — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — NUMBER — NOT NULL

SHEDLOCK

  • NAME — VARCHAR2(64) — 기본 키 — NOT NULL
  • LOCK_UNTIL — TIMESTAMP — NOT NULL
  • LOCKED_AT — TIMESTAMP — NOT NULL
  • LOCKED_BY — VARCHAR2(255) — NOT NULL

SKIN_CONCERN

  • MEMBER_ID — NUMBER — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
  • SKIN_TYPE — NUMBER(1) — NOT NULL
  • ATOPIC — NUMBER(1) — NOT NULL
  • ACNE — NUMBER(1) — NOT NULL
  • WHITENING — NUMBER(1) — NOT NULL
  • SEBUM — NUMBER(1) — NOT NULL
  • INNER_DRYNESS — NUMBER(1) — NOT NULL
  • WRINKLES — NUMBER(1) — NOT NULL
  • ENLARGED_PORES — NUMBER(1) — NOT NULL
  • REDNESS — NUMBER(1) — NOT NULL
  • KERATIN — NUMBER(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — NUMBER — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_BY — NUMBER — NOT NULL