ㅁㄴㅇㄹ
Tables (44)
ADMIN_DETAIL
- user_id — VARCHAR(255) — NOT NULL
- name — VARCHAR(255)
- nickname — VARCHAR(255)
AGREE_TERMS
- agreed_at — VARCHAR(255) — TIMESTAMP
- user_id — VARCHAR(255) — NOT NULL
- terms_id — VARCHAR(255) — NOT NULL
CART
- cart_id — INT — NOT NULL — 장바구니 고유 ID
- created_at — DATE — 장바구니 생성 시각
- deleted_at — DATE — 장바구니 삭제 시각
- user_id — VARCHAR(255) — NOT NULL
COLORS
- parent_id — INT — 계층적 색상 구조(밝은 빨강의 부모는 빨강 등)
- name — VARCHAR(50) — NOT NULL
- hex_code — VARCHAR(7) — NOT NULL — 색상의 16 진수 코드
COPYOFPRODUCT
- product_snapshot_id — VARCHAR(255) — NOT NULL
- category_id — VARCHAR(255) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
- date_created — DATETIME — NOT NULL
- remaining_stock — INT
- comment — VARCHAR(255) — ARCHAR(255
- enabled — BIT — NOT NULL
- thumbnail — VARCHAR(255)
- special — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
- delete_ad — DATETIME
- product_id — VARCHAR(50) — NOT NULL
COUPON
- coupon_id — VARCHAR(255) — NOT NULL
- coupin_name — VARCHAR(255)
- Field13 — VARCHAR(255) — null 가능/사용하는
- method — VARCHAR(255) — abs, mod
- Field4 — VARCHAR(255) — 10, 3000
- Field — VARCHAR(255) — 0~n
- Field3 — VARCHAR(255)
- available — VARCHAR(255) — 3일/ 1주일
- Field9 — VARCHAR(255) — 0~n
- coupon_status — VARCHAR(255) — on /off
- Field11 — VARCHAR(255)
- created_at — TIMESTAMP
- Field2 — VARCHAR(255)
- description — VARCHAR(255)
DELIVERY_COMPANY_API
- company_id — VARCHAR(50) — NOT NULL
- compnay_name — VARCHAR(255)
- Field — VARCHAR(255)
- Field7 — VARCHAR(255)
- Field16 — VARCHAR(255)
- Field17 — VARCHAR(255)
- Field18 — VARCHAR(255)
- Field19 — VARCHAR(255)
- Field20 — VARCHAR(255)
- shipment_id — VARCHAR(50) — NOT NULL
DELIVERY_EXCEPTION
- EXCEPTION_TYPE — VARCHAR(20) — NOT NULL — 파손, 분실, 도난
- STATUS — VARCHAR(20) — REPORTING, INVEST, RESOLVED, REJECT
- OCCURRED_AT — DATE
- CUSTOMER_CLAIM_DESC — VARCHAR(500)
- EVIDENCE_URL — VARCHAR(300) — 사진, 영상
- COURIER_CLAIM_DESC — VARCHAR(100)
- Field — VARCHAR(300) — 사진, 영상
- CUSTOMER_COMPENSATION — VARCHAR(100) — 환불, 교환 등
- INTERNAL_MEMO — VARCHAR(500)
- CREATED_AT — DATE
- UPDATED_AT — DATE
- shipment_id — VARCHAR(50) — NOT NULL
EXCHANGE
- exchange_id — VARCHAR(50) — NOT NULL
- Field6 — DATE
- Field — VARCHAR(100)
- Field2 — DATE
- Field3 — VARCHAR(100)
- Field5 — CHAR(1)
- original_order_id — VARCHAR(50) — NOT NULL
- exchange_order_id — VARCHAR(50) — NOT NULL
- return_id — VARCHAR(50) — NOT NULL
HANDOVER
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field5 — VARCHAR(255)
INQUIRY
- inquiry_id — VARCHAR(255) — NOT NULL
- title — VARCHAR(255)
- content — VARCHAR(255)
- created_at — VARCHAR(255)
- deleted_at — VARCHAR(255)
- inquiry_category — VARCHAR(255)
- status — VARCHAR(255)
- user_id — VARCHAR(255) — NOT NULL
- product_id — VARCHAR(50) — NOT NULL
- is_secret — VARCHAR(255)
INQUIRY_ANSWER
- inquiry_answer_id — VARCHAR(255) — NOT NULL
- content — VARCHAR(255)
- created_at — DATE
- id — VARCHAR(255) — NOT NULL
LOGIN_HISTORY
- id — VARCHAR(36) — NOT NULL
- ip — VARCHAR(255)
- browser — VARCHAR(255)
- nation — VARCHAR(255)
- region — VARCHAR(255)
- attempt_result — TINYINT(1)
- user_id — VARCHAR(255) — NOT NULL
MILEAGE
- user_id — VARCHAR(255) — NOT NULL
- amount — VARCHAR(255)
- updated_at — VARCHAR(255)
MILEAGE_CODE
- reason_code — VARCHAR(255) — NOT NULL
- amount — VARCHAR(255)
- description — VARCHAR(255)
- modify_type — VARCHAR(255)
MILEAGE_HISTORY
- id — VARCHAR(255) — NOT NULL
- amount — VARCHAR(255)
- created_at — VARCHAR(255) — NOT NULL
- mileage_id — VARCHAR(255) — NOT NULL
- user_id — VARCHAR(255) — NOT NULL
- reason_code — VARCHAR(255) — NOT NULL
- product_id — VARCHAR(255) — NOT NULL
- review_id — VARCHAR(255) — NOT NULL
MODEL
- model_id — VARCHAR(50) — NOT NULL
- height — INT
- weight — INT
- gender — ENUM('M', 'F', 'O')
- age — INT
NOTICE
- notice_id — INT — NOT NULL — 공지사항 고유 ID
- title — VARCHAR(255) — NOT NULL — 공지사항 제목
- content — TEXT — NOT NULL — 공지사항 내용
- created_at — DATE — 공지사항 최초 작성일자
- deleted_at — DATE — 공지사항 삭제일자
- view_count — INT — 공지사항 조회수
- is_pinned — BOOLEAN — 최상단 고정 여부
- available — BOOLEAN — 공지사항 노출 여부
ORDER
- order_id — BIGINT — NOT NULL
- order_num — BIGINT
- total_count — BIGINT
- total_price — DECIMAL(10,2)
- order_status — ENUM
- Field — BIGINT
- use_mile — DECIMAL(10,2)
- order_amount — DECIMAL(10,2)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- user_id — BIGINT — NOT NULL
ORDER_HISTORY
- Field — VARCHAR(50)
- created_at — TIMESTAMP
- Key2 — BIGINT — NOT NULL
PAYMENT
- payment_id — BIGINT — NOT NULL
- user_id — VARCHAR(50)
- order_num — VARCHAR(50)
- paid_amount — DECIMAL(10, 2)
- pay_type — ENUM
- pg_id — VARCHAR(50)
- pg_transaction_id — VARCHAR(50)
- Field — VARCHAR(50) — 최종 것만
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- Field2 — VARCHAR(255)
PRODUCT
- product_id — VARCHAR(50) — NOT NULL
- category_id — VARCHAR(50) — NOT NULL
- brand_id — VARCHAR(50)
- parent_id — VARCHAR(50) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
- discount_price — DECIMAL(10,2)
- sku — VARCHAR(50)
- summary — VARCHAR(255)
- thumbnail — VARCHAR(255)
- weight — DECIMAL(5,2)
- dimensions — VARCHAR(50)
- special — VARCHAR(100)
- tags — VARCHAR(255)
- seasons — BIT
- is_featured — BIT
- average_rating — DECIMAL(3,1)
- sales_count — INT
- view_count — INT
- availability_date — DATETIME
- enabled — BIT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- deleted_at — DATETIME
PRODUCT_CATEGORY
- parent_id — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- category_id — VARCHAR(50) — NOT NULL
PRODUCT_DESCRIPTION_IMAGE
- image_id — VARCHAR(50) — NOT NULL
- product_id — VARCHAR(50) — NOT NULL
- min_width — INT
- max_width — INT
- url — VARCHAR(255) — NOT NULL
- format — ENUM('jpg', 'png', 'webp') — NOT NULL
- render_priority — INT
- INDEX — idx_product_id
PRODUCT_DETAIL
- id — BIGINT — NOT NULL — 상세 정보의 고유 식별자
- product_id — VARCHAR(50) — NOT NULL
- size — INT
- related_item_id — VARCHAR(50)
- qna — LONGTEXT — Q&A 내용
- delivery_option — INT
- model_specific — VARCHAR(100)
- model_id — VARCHAR(50) — NOT NULL
PRODUCT_VARIANT
- variant_id — VARCHAR(50) — NOT NULL
- product_id — VARCHAR(50) — NOT NULL
- sku — VARCHAR(50) — NOT NULL
- color_id — INT — NOT NULL
- size — VARCHAR(50) — NOT NULL
- remaining_stock — INT — NOT NULL
- stock_status — ENUM('in_stock', 'out_of_stock', 'low_stock') — NOT NULL
- price_modifier — DECIMAL(10,2)
- image_url — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
PRODUCT_VARIANT_IMAGE
- image_id — VARCHAR(50) — NOT NULL
- variant_id — VARCHAR(50) — NOT NULL
- url — VARCHAR(255) — NOT NULL — 이미지 URL(예: \'/images/P001/빨강/front.jpg\')
- format — ENUM('jpg', 'png', 'webp') — NOT NULL
- image_type — ENUM('main', 'front', 'back', 'side', 'zoom')
- min_width — INT
- max_width — INT
- render_priority — INT — 표시 우선순위(낮을수록 우선, 예: 1=메인)
- created_at — DATETIME — NOT NULL
REFUND
- exchange_id — DECIMAL(10, 2) — NOT NULL
- Field4 — VARCHAR(20) — 전체, 부분
- Field6 — VARCHAR(20)
- Field7 — DATE
- Field — VARCHAR(100)
- Field2 — DATE
- Field3 — VARCHAR(100)
- Field5 — CHAR(1)
- payment_id — VARCHAR(50) — NOT NULL
- return_id — VARCHAR(50) — NOT NULL
REPORT
- id — VARCHAR(255) — NOT NULL
- user_id — VARCHAR(255) — NOT NULL
- target_type — VARCHAR(20) — NOT NULL — \'review\', \'comment\'
- target_id — VARCHAR(255) — NOT NULL — 리뷰일 경우 review_id, 댓글일 경우 comment
- reason — VARCHAR(255) — NOT NULL
- created_at — VARCHAR(255) — NOT NULL
- state — VARCHAR(2) — NOT NULL — 처리한 경우 Y
- approved_at — VARCHAR(255)
- isDeleted — BOOLEAN — 삭제한 경우 Y
RETURN
- return_id — VARCHAR(50) — NOT NULL
- refund_option — VARCHAR(50) — 교환, 환불, 반품 X
- Field4 — VARCHAR(50) — 단순 변심 / 배송문제/ 상품문제
- reciver_name — VARCHAR(100)
- reciver_phnum — VARCHAR(100) — 확인중, 결과, 진행중
- recive_method — VARCHAR(100) — 수락, 거절
- Field8 — VARCHAR(300) — 디테일
- Field6 — DATE
- Field — VARCHAR(100)
- Field2 — DATE
- Field3 — VARCHAR(100)
- Field5 — CHAR(1)
REVIEW
- id — VARCHAR(255) — NOT NULL
- order_item_id — INT — NOT NULL
- purchase_id — VARCHAR(255) — NOT NULL — 구매상태가 확정이어야 함
- rating — INT — NOT NULL — 옵션 1~5 숫자
- content — VARCHAR(3000) — content 길이 40~3000
- img_url — VARCHAR(20) — 이미지 여러 개 가능
- created_at — DATETIME — NOT NULL
- state — VARCHAR(10) — NOT NULL — \'auto\', \'pending\
- \rejected\, — approved_at — \'auto\'일 경우 created_at과 동일
- like_num — INT — NOT NULL
- isDeleted — BOOLEAN
- user_id — VARCHAR(255) — NOT NULL
- product_id — VARCHAR(50) — NOT NULL
REVIEW_COMMENT
- id — INT — NOT NULL
- review_id — VARCHAR(255) — NOT NULL
- parent_id — VARCHAR(255) — 상위 댓글이 없을 시 null
- content — VARCHAR(255) — NOT NULL
- created_at — VARCHAR(255) — NOT NULL
- isDeleted — BOOLEAN — NOT NULL — 삭제할 경우 대댓글까지 삭제
- user_id — VARCHAR(255)
SHIPMENT
- shipment_id — VARCHAR(50) — NOT NULL
- order_id — VARCHAR(50) — FK
- shipment_option — VARCHAR(50) — 배송, 회수, 재배송
- shipment_type — VARCHAR(50) — 퀵, 일반배송, 직접
- shipment_fee — DECIMAL(10, 2)
- status_code — VARCHAR(50)
- Key2 — VARCHAR(50) — NOT NULL
- reciver_name — VARCHAR(100)
- reciver_phnum — VARCHAR(100)
- recive_method — VARCHAR(100) — 택배함
- Field8 — DATE
- Field — VARCHAR(100)
- Field2 — DATE
- Field3 — VARCHAR(100)
- Field5 — CHAR(1)
- Field4 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field7 — VARCHAR(255)
- Field9 — VARCHAR(255)
- Field10 — VARCHAR(255)
- Field11 — VARCHAR(255)
SOCIAL_ACCOUNT
- id — VARCHAR(255) — NOT NULL
- user_id — VARCHAR(255) — NOT NULL
- provider — ENUM('KAKAO', 'NAVER', 'GOOGLE')
- provider_user_id — VARCHAR(255)
TERMS
- terms_id — VARCHAR(255) — NOT NULL
- code — VARCHAR(255)
- is_required — TINYINT(1)
- version — VARCHAR(255)
- content — VARCHAR(255)
- title — VARCHAR(255)
- created_at — DATE
UNTITLED10
- terms_id — VARCHAR(255) — NOT NULL
- code — VARCHAR(255)
- is_required — TINYINT(1)
- version — VARCHAR(255)
- content — VARCHAR(255)
- title — VARCHAR(255)
- created_at — DATE
UNTITLED11
- id — BIGINT — NOT NULL — 보안관련
- code — VARCHAR(50)
- payment_id — BIGINT — NOT NULL
UNTITLED5
- id — VARCHAR(50) — NOT NULL
- Field — VARCHAR(50)
- created_at — TIMESTAMP
- payment_id — VARCHAR(50) — NOT NULL
UNTITLED7
- Key2 — VARCHAR(255) — NOT NULL
- product_id — VARCHAR(255) — NOT NULL
UNTITLED8
- agreed_at — VARCHAR(255)
- user_id — VARCHAR(255) — NOT NULL
- terms_id — VARCHAR(255) — NOT NULL
USER
- user_id — VARCHAR(255) — NOT NULL
- is_activate — TINYINT(1)
- created_at — DATE
- updated_at — DATE
- deleted_at — DATE
- role — VARCHAR(255) — "ADMIN" | "USER"
- password — VARCHAR(255)
USER_COUPON
- user_id — VARCHAR(255) — NOT NULL
- coupon_id — VARCHAR(255) — NOT NULL
- coupon_code — VARCHAR(255) — 시퀀스 사용
- Field3 — TIMESTAMP
- Field4 — BOOLEAN
- Field5 — TIMESTAMP
- Field2 — INT
- created_at — TIMESTAMP
- expire_at — TIMESTAMP
- deleted_at — TIMESTAMP
USER_DETAIL
- id — VARCHAR(255) — NOT NULL
- email — VARCHAR(255)
- string — ??`
- phone_number — VARCHAR(255)
WISH_LIST
- id — VARCHAR(255) — NOT NULL
- user_id — VARCHAR(255) — NOT NULL
- product_id — VARCHAR(50) — NOT NULL