토이 2&3 파이널 ERD

테이블 (46)

ADMIN_DETAIL

  • USER_ID — BIGINT — 외래 키 → USERS.USER_ID — NOT NULL
  • NICKNAME — VARCHAR(255)
  • NAME — VARCHAR(255) — NOT NULL
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME
  • DELETED_AT — DATETIME

CART

  • CART_ID — INT — 기본 키 — NOT NULL
  • USER_ID — BIGINT — 외래 키 → USERS.USER_ID — NOT NULL
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME
  • DELETED_AT — DATETIME

CART_ITEM

  • CART_ITEM_ID — INT — 기본 키 — NOT NULL
  • CART_ID — INT — 외래 키 → CART.CART_ID — NOT NULL
  • PRODUCT_ID — BIGINT — 외래 키 → PRODUCT.PRODUCT_ID — NOT NULL
  • PRODUCT_VARIANT_ID — BIGINT — 외래 키 → PRODUCT_VARIANT.PRODUCT_VARIANT_ID
  • QUANTITY — INT — NOT NULL
  • UPDATED_AT — DATETIME

CATEGORY_LV1

  • CATEGORY_LV1_ID — VARCHAR(8) — 기본 키 — NOT NULL
  • NAME — VARCHAR(100)
  • SORT_ORDER — INT
  • IS_ACTIVE — CHAR(1)

CATEGORY_LV2

  • CATEGORY_LV2_ID — VARCHAR(8) — 기본 키 — NOT NULL
  • CATEGORY_LV1_ID — VARCHAR(8) — 외래 키 → CATEGORY_LV1.CATEGORY_LV1_ID — NOT NULL
  • NAME — VARCHAR(100)
  • SORT_ORDER — INT
  • IS_ACTIVE — CHAR(1)

CATEGORY_LV3

  • CATEGORY_LV3_ID — VARCHAR(8) — 기본 키 — NOT NULL
  • CATEGORY_LV2_ID — VARCHAR(8) — 외래 키 → CATEGORY_LV2.CATEGORY_LV2_ID — NOT NULL
  • NAME — VARCHAR(100)
  • SORT_ORDER — INT
  • IS_ACTIVE — CHAR(1)

COUPON

  • COUPON_ID — BIGINT — 기본 키 — NOT NULL
  • COUPON_NAME — VARCHAR(100)
  • COUPON_TYPE — VARCHAR(20)
  • DISCOUNT_VALUE — DECIMAL(10,2)
  • MIN_ORDER_AMOUNT — DECIMAL(10,2)
  • MAX_DISCOUNT_AMOUNT — DECIMAL(10,2)
  • AVAILABLE_PERIOD — INT
  • TOTAL_CNT — INT
  • DUPLICATE_USE — CHAR(1)
  • COUPON_STATUS — VARCHAR(20)
  • DESCRIPTION — TEXT
  • START_DATE — DATETIME
  • END_DATE — DATETIME
  • CREATED_AT — DATETIME
  • CREATED_BY — VARCHAR(255)

DEFAULT_USER_ADDRESS

  • USER_ID — BIGINT — 외래 키 → USERS.USER_ID — NOT NULL
  • ROAD_ADDRESS_1 — VARCHAR(255)
  • ROAD_ADDRESS_2 — VARCHAR(255)
  • JIBUN_ADDRESS — VARCHAR(255)
  • DETAIL_ADDRESS — VARCHAR(255)
  • ENGLISH_ADDRESS — VARCHAR(255)
  • ZIP_CODE — INT
  • ADDRESS_NAME — VARCHAR(100)

DELIVERY_EXCEPTION

  • DELIVERY_EXCEPTION_ID — BIGINT — 기본 키 — NOT NULL
  • SHIPMENT_ID — VARCHAR(50) — NOT NULL
  • EXCEPTION_TYPE_CODE — INT — NOT NULL
  • OCCURRED_AT — DATETIME
  • CUSTOMER_CLAIM_DESC — TEXT
  • EVIDENCE_URL — VARCHAR(500)
  • COURIER_CLAIM_DESC — TEXT
  • COURIER_EVIDENCE_URL — VARCHAR(500)
  • CUSTOMER_COMPENSATION — VARCHAR(200)
  • INTERNAL_MEMO — TEXT
  • UPDATED_AT — DATETIME
  • RESOLVED_AT — DATETIME
  • RESOLVED_BY — VARCHAR(255)

EXCHANGE

  • EXCHANGE_ID — BIGINT — 기본 키 — NOT NULL
  • RETURN_ID — BIGINT — NOT NULL
  • ORIGINAL_ORDER_ID — BIGINT — 외래 키 → ORDERS.ORDER_ID — NOT NULL
  • EXCHANGE_ORDER_ID — BIGINT — 외래 키 → ORDERS.ORDER_ID
  • ADMIN_MEMO — VARCHAR(500)
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP
  • APPROVED_AT — TIMESTAMP
  • COMPLETED_AT — TIMESTAMP
  • FIELD — VARCHAR(255)

GLOBAL_CODE

  • CODE — INT — 기본 키 — NOT NULL
  • CODE_GROUP_ID — VARCHAR(50)
  • CODE_ID — INT
  • CODE_NAME — VARCHAR(100)
  • DESCRIPTION — VARCHAR(255)
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME

INQUIRY

  • INQUIRY_ID — BIGINT — 기본 키 — NOT NULL
  • USER_ID — BIGINT — 외래 키 → USERS.USER_ID — NOT NULL
  • PRODUCT_ID — BIGINT — 외래 키 → PRODUCT.PRODUCT_ID
  • TITLE — VARCHAR(200)
  • CONTENT — TEXT
  • INQUIRY_CATEGORY — VARCHAR(20)
  • STATUS — VARCHAR(20)
  • IS_SECRET — TINYINT(1)
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME
  • DELETED_AT — DATETIME

INQUIRY_ANSWER

  • INQUIRY_ANSWER_ID — BIGINT — 기본 키 — NOT NULL
  • INQUIRY_ID — BIGINT — 외래 키 → INQUIRY.INQUIRY_ID — NOT NULL
  • ADMIN_ID — VARCHAR(50) — NOT NULL
  • CONTENT — TEXT
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME

LOGIN_HISTORY

  • ID — BIGINT — 기본 키 — NOT NULL
  • USER_ID — BIGINT — 외래 키 → USERS.USER_ID — NOT NULL
  • IP — VARCHAR(45)
  • BROWSER — VARCHAR(255)
  • NATION — VARCHAR(100)
  • REGION — VARCHAR(100)
  • ATTEMPT_RESULT — TINYINT(1)
  • CONSECUTIVE_FAILED_LOGIN_ATTEMPT — INT
  • IS_LOCKED — TINYINT(1)
  • CREATED_AT — DATETIME — NOT NULL

MILEAGE

  • MILEAGE_ID — BIGINT — 기본 키 — NOT NULL
  • USER_ID — BIGINT — 외래 키 → USERS.USER_ID — NOT NULL
  • TOTAL_EARNED — DECIMAL(10,2)
  • TOTAL_USED — DECIMAL(10,2)
  • UPDATED_AT — DATETIME

MILEAGE_CODE

  • REASON_CODE — VARCHAR(255) — 기본 키 — NOT NULL
  • REASON_NAME — VARCHAR(100)
  • AMOUNT — DECIMAL(10,2)
  • DESCRIPTION — TEXT
  • MODIFY_TYPE — VARCHAR(20)
  • IS_ACTIVE — TINYINT(1)
  • EXP_DAY — INT

MILEAGE_HISTORY

  • HISTORY_ID — BIGINT — 기본 키 — NOT NULL
  • USER_ID — BIGINT — 외래 키 → USERS.USER_ID — NOT NULL
  • MILEAGE_ID — BIGINT — 외래 키 → MILEAGE.MILEAGE_ID — NOT NULL
  • REASON_CODE — VARCHAR(255) — 외래 키 → MILEAGE_CODE.REASON_CODE — NOT NULL
  • RELATED_ORDER_ID — BIGINT — 외래 키 → ORDERS.ORDER_ID
  • REVIEW_ID — BIGINT — 외래 키 → REVIEW.REVIEW_ID
  • BALANCE_AFTER — DECIMAL(10,2)
  • EXPIRE_DATE — DATETIME
  • CREATED_AT — DATETIME — NOT NULL
  • FIELD — VARCHAR(100)

NOTICE

  • NOTICE_ID — INT — 기본 키 — NOT NULL
  • TITLE — VARCHAR(200) — NOT NULL
  • CONTENT — TEXT — NOT NULL
  • CATEGORY — VARCHAR(20)
  • IS_PINNED — TINYINT(1)
  • IS_ACTIVE — TINYINT(1)
  • VIEW_COUNT — INT
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME
  • DELETED_AT — DATETIME
  • CREATED_BY — VARCHAR(50)

ORDERS

  • ORDER_ID — BIGINT — 기본 키 — NOT NULL
  • USER_ID — BIGINT — 외래 키 → USERS.USER_ID — NOT NULL
  • USER_COUPON_ID — BIGINT — 외래 키 → USER_COUPON.USER_COUPON_ID — NOT NULL
  • ORDER_NUM — VARCHAR(50)
  • TOTAL_COUNT — INT
  • TOTAL_PRICE — DECIMAL(12,2)
  • ORDER_STATUS — VARCHAR(20)
  • USE_MILE — DECIMAL(10,2)
  • ORDER_AMOUNT — DECIMAL(12,2)
  • SHIPPING_FEE — DECIMAL(8,2)
  • DISCOUNT_AMOUNT — DECIMAL(10,2)
  • FINAL_AMOUNT — DECIMAL(12,2)
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME
  • ID2 — BIGINT — NOT NULL

ORDER_HISTORY

  • HISTORY_ID — BIGINT — 기본 키 — NOT NULL
  • ORDER_ID — BIGINT — 외래 키 → ORDERS.ORDER_ID — NOT NULL
  • STATUS — VARCHAR(50)
  • COMMENT — TEXT — EXT NUL
  • CREATED_AT — TIMESTAMP
  • CREATED_BY — VARCHAR(255)
  • ID2 — BIGINT — NOT NULL

ORDER_STATE_CODE

  • ID — BIGINT — 기본 키 — NOT NULL
  • NAME — VARCHAR(50)

PAYMENT

  • PAYMENT_ID — BIGINT — 기본 키 — NOT NULL
  • ORDER_ID — BIGINT — 외래 키 → ORDERS.ORDER_ID — NOT NULL
  • USER_ID — BIGINT — 외래 키 → USERS.USER_ID
  • ORDER_NUM — VARCHAR(50)
  • PAID_AMOUNT — DECIMAL(12,2)
  • PAY_TYPE — VARCHAR(20)
  • CASH_RECEIPT — CHAR(1)
  • PG_TRANSACTION_ID — VARCHAR(100)
  • PAYMENT_KEY — VARCHAR(100)
  • RECEIPT_URL — VARCHAR(500)
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP
  • APPROVED_AT — TIMESTAMP
  • CANCELLED_AT — TIMESTAMP
  • PG_ID — BIGINT — 외래 키 → PG_CODE.PG_ID — NOT NULL
  • PAY_STATUS_ID — BIGINT — 외래 키 → PAY_STATUS_CODE.PAY_STATUS_ID — NOT NULL
  • PAY_TYPE_ID — BIGINT — 외래 키 → PAY_TYPE_CODE.PAY_TYPE_ID — NOT NULL

PAY_STATUS_CODE

  • PAY_STATUS_ID — BIGINT — 기본 키 — NOT NULL
  • PAY_STATUS_NAME — VARCHAR(50)

PAY_TYPE_CODE

  • PAY_TYPE_ID — BIGINT — 기본 키 — NOT NULL
  • PAY_TYPE — VARCHAR(50)
  • CASH_CODE — VARCHAR(50)

PG_CODE

  • PG_ID — BIGINT — 기본 키 — NOT NULL
  • PG_CODE — VARCHAR(36)
  • PG_NAME — VARCHAR(20)

PRODUCT

  • PRODUCT_ID — BIGINT — 기본 키 — NOT NULL
  • CATEGORY_LV3_ID — VARCHAR(8) — 외래 키 → CATEGORY_LV3.CATEGORY_LV3_ID — NOT NULL
  • PRODUCT_TITLE — VARCHAR(200) — NOT NULL
  • PRODUCT_PRICE — DECIMAL(10,2) — NOT NULL
  • PRODUCT_SUMMARY — VARCHAR(500)
  • PRODUCT_THUMBNAIL — VARCHAR(255)
  • PRODUCT_TAG — VARCHAR(255)
  • PRODUCT_SEASON — VARCHAR(10) — NOT NULL
  • PRODUCT_AVERAGE_RATING — DECIMAL(3,1)
  • PRODUCT_SALE_COUNT — INT
  • PRODUCT_VIEW_COUNT — INT
  • PRODUCT_STOCK — INT
  • PRODUCT_AVAILABLE_DATE — DATETIME
  • IS_ENABLED — TINYINT(1) — NOT NULL
  • IS_BEST — TINYINT(1) — NOT NULL
  • IS_NEW — TINYINT(1) — NOT NULL
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME
  • DELETED_AT — DATETIME
  • IS_DELETED — DATETIME

PRODUCT_OPTION_PRICE

  • PRODUCT_OPTION_PRICE_ID — BIGINT — 기본 키 — NOT NULL
  • PRODUCT_VARIANT_ID — BIGINT — 외래 키 → PRODUCT_VARIANT.PRODUCT_VARIANT_ID — NOT NULL
  • ORIGINAL_PRICE — DECIMAL(10,2)
  • SALE_PRICE — DECIMAL(10,2)
  • DISCOUNT_RATE — DECIMAL(5,2)
  • DISCOUNT_START_DATE — DATETIME — NOT NULL
  • DISCOUNT_END_DATE — DATETIME
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME

PRODUCT_STOCK

  • PRODUCT_VARIANT_STOCK_ID — BIGINT — 기본 키 — NOT NULL
  • PRODUCT_STOCK — BIGINT — NOT NULL
  • PRODUCT_STOCK_STATUS — VARCHAR(20) — NOT NULL

PRODUCT_VARIANT

  • PRODUCT_VARIANT_ID — BIGINT — 기본 키 — NOT NULL
  • PRODUCT_VARIANT_SIZE_ID — BIGINT — 외래 키 → PRODUCT_VARIANT_SIZE.PRODUCT_VARIANT_SIZE_ID
  • PRODUCT_ID — BIGINT — 외래 키 → PRODUCT.PRODUCT_ID — NOT NULL
  • PRODUCT_VARIANT_COLOR_ID — INT — 외래 키 → PRODUCT_VARIANT_COLORS.PRODUCT_VARIANT_COLOR_ID — NOT NULL
  • PRODUCT_VARIANT_STOCK_ID — BIGINT — 외래 키 → PRODUCT_STOCK.PRODUCT_VARIANT_STOCK_ID — NOT NULL
  • PRODUCT_VARIANT_WEIGHT — VARCHAR(255)
  • PRODUCT_VARIANT_MEASUREMENT — VARCHAR(255)
  • PRODUCT_VARIANT_EXTRA_CHARGE — DECIMAL(10, 2)
  • CREATED_AT — DATETIME — NOT NULL

PRODUCT_VARIANT_COLORS

  • PRODUCT_VARIANT_COLOR_ID — INT — 기본 키 — NOT NULL
  • PRODUCT_VARIANT_COLOR_NAME — VARCHAR(50) — NOT NULL
  • HEX_CODE — VARCHAR(7) — NOT NULL
  • IS_ACTIVE — TINYINT(1) — NOT NULL

PRODUCT_VARIANT_DESCRIPTION_IMAGE

  • PRODUCT_VARIANT_DESCRIPTION_IMAGE_ID — BIGINT — 기본 키 — NOT NULL
  • PRODUCT_VARIANT_ID — BIGINT — 외래 키 → PRODUCT_VARIANT.PRODUCT_VARIANT_ID — NOT NULL
  • PRODUCT_VARIANT_DESCRIPTION_IMAGE_URL — VARCHAR(255) — NOT NULL
  • SHOW_DEVICE — VARCHAR(100) — NOT NULL
  • FORMAT — VARCHAR(10) — NOT NULL
  • RENDER_PRIORITY — INT
  • CREATED_AT — DATETIME — NOT NULL

PRODUCT_VARIANT_IMAGE

  • PRODUCT_VARIANT_IMAGE_ID — BIGINT — 기본 키 — NOT NULL
  • PRODUCT_VARIANT_ID — BIGINT — 외래 키 → PRODUCT_VARIANT.PRODUCT_VARIANT_ID — NOT NULL
  • SHOW_DEVICE — VARCHAR(100)
  • PRODUCT_VARIANT_IMAGE_URL — VARCHAR(255) — NOT NULL
  • FORMAT — VARCHAR(10) — NOT NULL
  • RENDER_PRIORITY — INT
  • CREATED_AT — DATETIME — NOT NULL

PRODUCT_VARIANT_SIZE

  • PRODUCT_VARIANT_SIZE_ID — BIGINT — 기본 키 — NOT NULL
  • PRODUCT_VARIANT_SIZE_NAME — VARCHAR(20)
  • IS_ACTIVE — TINYINT(1) — NOT NULL

REFUND_ACCOUNT

  • USER_ID — BIGINT — 기본 키 — 외래 키 → USERS.USER_ID — NOT NULL
  • ACCOUNT_NAME — VARCHAR(255)
  • BANK_NAME — VARCHAR(255)
  • ACCOUNT_NUM — VARCHAR(255)

REPORT

  • REPORT_ID — BIGINT — 기본 키 — NOT NULL
  • USER_ID — BIGINT — 외래 키 → USERS.USER_ID — NOT NULL
  • TARGET_TYPE — VARCHAR(20) — NOT NULL
  • TARGET_ID — BIGINT — NOT NULL
  • REASON — TEXT — NOT NULL
  • STATE — VARCHAR(20) — NOT NULL
  • APPROVED_AT — DATETIME
  • APPROVED_BY — BIGINT
  • IS_DELETED — TINYINT(1)
  • CREATED_AT — DATETIME — NOT NULL

REVIEW

  • REVIEW_ID — BIGINT — 기본 키 — NOT NULL
  • USER_ID — BIGINT — 외래 키 → USERS.USER_ID — NOT NULL
  • PRODUCT_ID — BIGINT — 외래 키 → PRODUCT.PRODUCT_ID — NOT NULL
  • PURCHASE_ID — VARCHAR(255) — NOT NULL
  • RATING — TINYINT — NOT NULL
  • TITLE — VARCHAR(200)
  • CONTENT — TEXT
  • IMG_URL — TEXT
  • LIKE_COUNT — INT — NOT NULL
  • STATE — VARCHAR(20) — NOT NULL
  • APPROVED_AT — DATETIME
  • IS_DELETED — TINYINT(1)
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME
  • DELETED_AT — DATETIME

REVIEW_COMMENT

  • COMMENT — ADD — NOT NULL — DD CONSTRAINT FK_REVIEW_TO_REVIEW_COMMENT_1 FOREIGN KEY (_ID INT NOT NULL AUTO_INCREMENT REVIEW_ID BIGINT NOT NULL, USE…
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME
  • DELETED_AT — DATETIME

REVIEW_LIKE

  • LIKE_ID — BIGINT — 기본 키 — NOT NULL
  • REVIEW_ID — BIGINT — 외래 키 → REVIEW.REVIEW_ID — NOT NULL
  • USER_ID — BIGINT — 외래 키 → USERS.USER_ID — NOT NULL
  • CREATED_AT — DATETIME — NOT NULL

SHIPMENT_RELATED_CODE

  • CODE_GROUP_NUM — TINYINT
  • CODE_ID — TINYINT
  • CODE_NAME — VARCHAR(100)
  • DESCRIPTION — VARCHAR(500)
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME
  • SHIPMENT_ID — VARCHAR(50) — NOT NULL

SPECIAL_SECTION

  • SPECIAL_ID — VARCHAR(2) — 기본 키 — NOT NULL
  • NAME — VARCHAR(100)
  • SORT_ORDER — INT
  • IS_ACTIVE — TINYINT(1)

TERMS

  • TERMS_ID — BIGINT — 기본 키 — NOT NULL
  • TITLE — VARCHAR(200)
  • CODE — VARCHAR(50)
  • CONTENT — TEXT
  • VERSION — VARCHAR(20)
  • IS_REQUIRED — TINYINT(1)
  • IS_ACTIVE — TINYINT(1)
  • CREATED_AT — DATETIME
  • EFFECTIVE_FROM — DATETIME
  • EFFECTIVE_TO — DATETIME

USERS

  • USER_ID — BIGINT — NOT NULL
  • LOGIN_ID — VARCHAR(30) — NOT NULL
  • PASSWORD — VARCHAR(255) — NOT NULL
  • IS_ACTIVATE — TINYINT(1)
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME
  • DELETED_AT — DATETIME
  • ROLE — VARCHAR(20)
  • IS_DELETED — TINYINT(1)

USER_COUPON

  • USER_COUPON_ID — BIGINT — 기본 키 — NOT NULL
  • USER_ID — BIGINT — 외래 키 → USERS.USER_ID — NOT NULL
  • COUPON_ID — BIGINT — 외래 키 → COUPON.COUPON_ID — NOT NULL
  • COUPON_CODE — VARCHAR(50)
  • ISSUED_AT — DATETIME
  • IS_USED — TINYINT(1)
  • USED_AT — DATETIME
  • COUPON_NUM — BIGINT
  • CREATED_AT — DATETIME
  • EXPIRE_AT — DATETIME
  • DELETED_AT — DATETIME

USER_DETAIL

  • USER_ID — BIGINT — 외래 키 → USERS.USER_ID — NOT NULL
  • EMAIL — VARCHAR(255) — NOT NULL
  • NAME — VARCHAR(255) — NOT NULL
  • PHONE_NUMBER — VARCHAR(20) — NOT NULL
  • BIRTH_DATE — DATE
  • GENDER — CHAR(1)
  • JOB_CODE — INT — NOT NULL

USER_TERMS_AGREEMENT

  • AGREEMENT_ID — BIGINT — 기본 키 — NOT NULL
  • USER_ID — BIGINT — 외래 키 → USERS.USER_ID — NOT NULL
  • TERMS_ID — BIGINT — 외래 키 → TERMS.TERMS_ID — NOT NULL
  • AGREED_AT — DATETIME
  • IP_ADDRESS — VARCHAR(45)

WISH_LIST

  • WISH_ID — BIGINT — 기본 키 — NOT NULL
  • USER_ID — BIGINT — 외래 키 → USERS.USER_ID — NOT NULL
  • PRODUCT_ID — BIGINT — 외래 키 → PRODUCT.PRODUCT_ID — NOT NULL
  • ADDED_AT — DATETIME