최종
테이블 (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