토이 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