clrate_4

Tables (20)

clarte_addresses

  • id — BIGINT — Primary key — NOT NULL — 주소ID
  • created_at — DATETIME(6) — 생성일시
  • updated_at — DATETIME(6) — 수정일시
  • user_id — BIGINT — Foreign key → clarte_users.id — NOT NULL — 유저ID
  • zipcode — VARCHAR(10) — NOT NULL — 우편번호
  • detail_address — VARCHAR(100) — 상세주소
  • reference — VARCHAR(100) — 참고사항
  • main_address — VARCHAR(200) — NOT NULL — 기본주소

clarte_cart_item_add_ons

  • id — BIGINT — Primary key — NOT NULL — ID
  • quantity — INT — 수량
  • add_on_option_id — BIGINT — 추가옵션ID
  • cart_item_id — BIGINT — Foreign key → clarte_cart_items.id — NOT NULL — 카트항목ID

clarte_cart_items

  • id — BIGINT — Primary key — NOT NULL — 카트항목ID
  • option_quantity — INT — 옵션수량
  • cart_id — BIGINT — Foreign key → clarte_carts.id — 카트ID
  • option_id — BIGINT — Foreign key → clarte_product_option.id — 옵션ID
  • product_id — BIGINT — Foreign key → clarte_product.id — 상품ID

clarte_carts

  • id — BIGINT — Primary key — NOT NULL — 카트ID
  • updated_at — DATETIME(6) — 수정일시
  • user_id — BIGINT — Foreign key → clarte_users.id — NOT NULL — 유저ID

clarte_category

  • id — BIGINT — Primary key — NOT NULL — 카테고리ID
  • parent_id — BIGINT — Foreign key → clarte_category.id — 상위카테고리ID
  • name — VARCHAR(255) — 카테고리명
  • level — ENUM('LARGE', 'MEDIUM', 'SMALL') — 레벨

clarte_notice

  • id — BIGINT — Primary key — NOT NULL — 공지ID
  • pinned — BIT — NOT NULL — 상단고정여부
  • visible — BIT — NOT NULL — 노출여부
  • created_at — DATETIME(6) — 생성일시
  • updated_at — DATETIME(6) — 수정일시
  • title — VARCHAR(255) — 제목
  • content — LONGTEXT — 내용

clarte_order_product_items

  • id — BIGINT — Primary key — NOT NULL — 주문상품항목ID
  • price_snap — INT — 가격스냅
  • quantity — INT — 수량
  • option_id — BIGINT — 옵션ID
  • order_product_id — BIGINT — Foreign key → clarte_order_products.id — NOT NULL — 주문상품ID
  • option_name_snap — VARCHAR(255) — 옵션명스냅
  • option_kind — ENUM('ADD_ON', 'OPTION') — 옵션종류
  • INDEX — `ix_opi_order_product`

clarte_order_product_rma_images

  • id — BIGINT — Primary key — NOT NULL — 이미지ID
  • rma_id — BIGINT — Foreign key → clarte_order_product_rmas.id — NOT NULL — RMAID
  • url — VARCHAR(500) — NOT NULL — 이미지URL
  • INDEX — `ix_rma_images_rma`

clarte_order_product_rmas

  • id — BIGINT — Primary key — NOT NULL — RMAID
  • admin_action_at — DATETIME(6) — 관리자처리일시
  • created_at — DATETIME(6) — 생성일시
  • order_product_id — BIGINT — Foreign key → clarte_order_products.id — NOT NULL — 주문상품ID
  • user_zipcode — VARCHAR(20) — 사용자우편번호
  • user_phone — VARCHAR(50) — 사용자전화번호
  • user_nick_name — VARCHAR(100) — 사용자닉네임
  • user_username — VARCHAR(100) — NOT NULL — 사용자아이디
  • user_email — VARCHAR(200) — 사용자이메일
  • reason_text — VARCHAR(1000) — 사유
  • order_id — VARCHAR(255) — NOT NULL — 주문번호
  • user_address — VARCHAR(255) — 사용자주소
  • user_address_detail — VARCHAR(255) — 사용자상세주소
  • status — ENUM('APPROVED', 'COMPLETE', 'REJECTED', 'REQUESTED') — 상태
  • type — ENUM('CANCELLATION', 'EXCHANGE', 'REFUND') — 유형
  • INDEX — `ix_rmas_order_product`

clarte_order_products

  • id — BIGINT — Primary key — NOT NULL — 주문상품ID
  • has_review — BIT — 리뷰여부
  • payment_amount — INT — 결제금액
  • quantity — INT — 수량
  • total_price_snap — INT — 총가격스냅
  • order_id — BIGINT — Foreign key → clarte_orders.id — NOT NULL — 주문ID
  • product_id — BIGINT — Foreign key → clarte_product.id — 상품ID
  • review_id — BIGINT — 리뷰ID
  • product_name_snap — VARCHAR(255) — 상품명스냅
  • thumbnail_snap — VARCHAR(255) — 썸네일스냅
  • status — ENUM( 'CANCELLATION_ACCEPTED', 'CANCELLATION_COMPLETE', 'CANCELLATION_REJECTED', 'CANCELLATION_REQUESTED', 'CANCELLED', 'DELIVERED', 'EXCHANGE_ACCEPTED', 'EXCHANGE_COMPLETE', 'EXCHANGE_REJECTED', 'EXCHANGE_REQUESTED', 'FAILED', 'PAID', 'PENDING', 'PREPARING_DELIVERY', 'REFUND_ACCEPTED', 'REFUND_COMPLETE', 'REFUND_REJECTED', 'REFUND_REQUESTED', 'SHIPPING' ) — 상태
  • INDEX — `ix_op_order`
  • INDEX — `ix_op_product`

clarte_orders

  • id — BIGINT — Primary key — NOT NULL — 주문ID
  • delivery_fee — INT — 배송비
  • total_amount — INT — 총금액
  • total_quantity — INT — 총수량
  • created_at — DATETIME(6) — 생성일시
  • user_id — BIGINT — Foreign key → clarte_users.id — NOT NULL — 유저ID
  • user_zipcode — VARCHAR(20) — 사용자우편번호
  • user_phone — VARCHAR(50) — 사용자전화번호
  • user_nick_name — VARCHAR(100) — 사용자닉네임
  • user_username — VARCHAR(100) — NOT NULL — 사용자아이디
  • user_email — VARCHAR(200) — 사용자이메일
  • delivery_company — VARCHAR(255) — 택배사
  • hero_img — VARCHAR(255) — 대표이미지
  • order_id — VARCHAR(255) — NOT NULL — 주문번호
  • order_name — VARCHAR(255) — 주문명
  • order_payment_key — VARCHAR(255) — 결제키
  • ship_address — VARCHAR(255) — 배송주소
  • ship_address_detail — VARCHAR(255) — 배송상세주소
  • ship_delivery_request — VARCHAR(255) — 배송요청사항
  • ship_recipient_name — VARCHAR(255) — 수령인명
  • ship_recipient_phone — VARCHAR(255) — 수령인전화
  • ship_zipcode — VARCHAR(255) — 배송우편번호
  • tracking_number — VARCHAR(255) — 운송장번호
  • user_address — VARCHAR(255) — 사용자주소
  • user_address_detail — VARCHAR(255) — 사용자상세주소
  • status — ENUM( 'ABORTED', 'CANCELED', 'CANCELLED', 'DELIVERED', 'DONE', 'EXCHANGE_OR_REFUND_ED', 'EXCHANGE_OR_REFUND_ING', 'EXPIRED', 'FAILED', 'IN_PROGRESS', 'PAID', 'PARTIAL_CANCELED', 'PENDING', 'PREPARING_DELIVERY', 'READY', 'SHIPPING', 'WAITING_FOR_DEPOSIT' ) — 상태
  • INDEX — `ix_orders_user`

clarte_payments

  • id — BIGINT — Primary key — NOT NULL — 결제ID
  • approved_at — DATETIME(6) — 승인일시
  • requested_at — DATETIME(6) — 요청일시
  • virtual_account_due_date — DATETIME(6) — 가상계좌만료일
  • balance_amount — INT — 잔액
  • card_amount — INT — 카드금액
  • card_installment_plan_months — INT — 할부개월
  • card_is_interest_free — BIT — 무이자여부
  • card_use_point — BIT — 포인트사용여부
  • easy_pay_amount — INT — 간편결제금액
  • easy_pay_discount_amount — INT — 간편결제할인금액
  • is_partial_cancelable — BIT — 부분취소가능여부
  • supplied_amount — INT — 공급가액
  • tax_exemption_amount — INT — 면세금액
  • tax_free_amount — INT — 비과세금액
  • total_amount — INT — 총금액
  • use_escrow — BIT — 에스크로사용여부
  • vat — INT — 부가세
  • virtual_account_bank_code — TINYINT — 가상계좌은행코드
  • virtual_account_expired — BIT — 가상계좌만료여부
  • virtual_account_refund_receive_bank_code — TINYINT — 환불수취은행코드
  • payment_key — VARCHAR(200) — NOT NULL — 결제키
  • card_acquire_status — VARCHAR(255) — 카드취득상태
  • card_approve_no — VARCHAR(255) — 카드승인번호
  • card_interest_payer — VARCHAR(255) — 이자납부자
  • card_number — VARCHAR(255) — 카드번호
  • card_owner_type — VARCHAR(255) — 소유자구분
  • card_type — VARCHAR(255) — 카드종류
  • currency — VARCHAR(255) — 통화
  • easy_pay_provider — VARCHAR(255) — 간편결제사
  • last_transaction_key — VARCHAR(255) — 최종트랜잭션키
  • m_id — VARCHAR(255) — 머천트ID
  • order_id — BIGINT — Foreign key → clarte_orders.id — 주문ID
  • order_name — VARCHAR(255) — 주문명
  • receipt_url — VARCHAR(255) — 영수증URL
  • transfer_settlement_status — VARCHAR(255) — 정산상태
  • virtual_account_account_number — VARCHAR(255) — 가상계좌번호
  • virtual_account_account_type — VARCHAR(255) — 가상계좌종류
  • virtual_account_customer_name — VARCHAR(255) — 가상계좌예금주
  • virtual_account_refund_receive_account_number — VARCHAR(255) — 환불계좌번호
  • virtual_account_refund_receive_holder_name — VARCHAR(255) — 환불계좌예금주
  • virtual_account_refund_status — VARCHAR(255) — 환불상태
  • virtual_account_settlement_status — VARCHAR(255) — 정산완료여부
  • card_acquirer_code — ENUM( 'BC', 'CITI', 'GWANGJUBANK', 'HANA', 'HYUNDAI', 'IBK_BC', 'JEJUBANK', 'JEONBUKBANK', 'KAKAOBANK', 'KBANK', 'KDBBANK', 'KOOKMIN', 'LOTTE', 'NONGHYEOP', 'POST', 'SAEMAUL', 'SAMSUNG', 'SAVINGBANK', 'SHINHAN', 'SHINHYEOP', 'SUHYEOP', 'TOSSBANK', 'UNIDENTIFIED', 'WOORI', 'WOORI_1' ) — 매입사코드
  • card_issuer_code — ENUM( 'BC', 'CITI', 'GWANGJUBANK', 'HANA', 'HYUNDAI', 'IBK_BC', 'JEJUBANK', 'JEONBUKBANK', 'KAKAOBANK', 'KBANK', 'KDBBANK', 'KOOKMIN', 'LOTTE', 'NONGHYEOP', 'POST', 'SAEMAUL', 'SAMSUNG', 'SAVINGBANK', 'SHINHAN', 'SHINHYEOP', 'SUHYEOP', 'TOSSBANK', 'UNIDENTIFIED', 'WOORI', 'WOORI_1' ) — 발급사코드
  • method — ENUM('BOOK_GIFT', 'CARD', 'CULTURE_GIFT', 'EASY_PAY', 'GAME_GIFT', 'PHONE', 'TRANSFER', 'VBANK') — 결제수단
  • status — ENUM('ABORTED', 'CANCELED', 'DONE', 'EXPIRED', 'IN_PROGRESS', 'PARTIAL_CANCELED', 'READY', 'WAITING_FOR_DEPOSIT') — 상태
  • transfer_bank_code — ENUM( 'BUSANBANK', 'CITI', 'DAEGUBANK', 'GWANGJUBANK', 'HANA', 'HSBC', 'IBK', 'JEJUBANK', 'JEONBUKBANK', 'KAKAOBANK', 'KBANK', 'KDBBANK', 'KOOKMIN', 'KYONGNAMBANK', 'LOCALNONGHYEOP', 'NONGHYEOP', 'POST', 'SAEMAUL', 'SANLIM', 'SAVINGBANK', 'SC', 'SHINHAN', 'SHINHYEOP', 'SUHYEOP', 'TOSSBANK', 'WOORI' ) — 이체은행코드
  • type — ENUM('BILLING', 'BRANDPAY', 'NORMAL') — 유형
  • INDEX — `ix_payments_order`

clarte_policy

  • id — BIGINT — Primary key — NOT NULL — 정책ID
  • as_phone — VARCHAR(255) — NOT NULL — AS전화번호
  • company_name — VARCHAR(255) — NOT NULL — 회사명
  • delivery_company — VARCHAR(255) — NOT NULL — 택배사
  • delivery_method — VARCHAR(255) — NOT NULL — 배송방법
  • delivery_period — VARCHAR(255) — NOT NULL — 배송기간
  • exchange_fee — VARCHAR(255) — NOT NULL — 교환비용
  • name — VARCHAR(255) — NOT NULL — 정책명
  • representative — VARCHAR(255) — NOT NULL — 대표자명
  • return_fee — VARCHAR(255) — NOT NULL — 반품비용
  • simple_return_cost — VARCHAR(255) — NOT NULL — 간이반품비용
  • defect_return_info — TINYTEXT — NOT NULL — 불량반품안내
  • dispute_resolution — TINYTEXT — NOT NULL — 분쟁해결방법
  • refund_info — TINYTEXT — NOT NULL — 환불안내
  • return_address — TINYTEXT — NOT NULL — 반품주소
  • return_guide — TINYTEXT — NOT NULL — 반품안내
  • return_impossible_reasons — TINYTEXT — NOT NULL — 반품불가사유
  • return_period — TINYTEXT — NOT NULL — 반품기간
  • return_restriction_info — TINYTEXT — NOT NULL — 반품제한정보
  • warranty_info — TINYTEXT — NOT NULL — 보증안내

clarte_product

  • id — BIGINT — Primary key — NOT NULL — 상품ID
  • avg_rating — FLOAT(53) — NOT NULL — 평균평점
  • delivery_price — INT — NOT NULL — 배송가격
  • discount_price — INT — NOT NULL — 할인가격
  • is_best — BIT — NOT NULL — 베스트여부
  • markup — INT — NOT NULL — 마진율
  • review_count — INT — NOT NULL — 리뷰수
  • supply_price — INT — NOT NULL — 공급가액
  • category_id — BIGINT — Foreign key → clarte_category.id — NOT NULL — 카테고리ID
  • created_at — DATETIME(6) — NOT NULL — 생성일시
  • name — VARCHAR(120) — NOT NULL — 상품명
  • description — TEXT — NOT NULL — 설명
  • display_status — ENUM('DISPLAYED', 'HIDDEN') — 노출상태
  • INDEX — `ix_product_category`

clarte_product_image

  • sort_order — INT — Primary key — NOT NULL — 정렬순서
  • product_id — BIGINT — Foreign key → clarte_product.id — NOT NULL — 상품ID
  • image_url — VARCHAR(255) — NOT NULL — 이미지URL
  • INDEX — `ix_img_product`

clarte_product_option

  • id — BIGINT — Primary key — NOT NULL — 옵션ID
  • additional_price — INT — NOT NULL — 추가금액
  • product_id — BIGINT — Foreign key → clarte_product.id — 상품ID
  • name — VARCHAR(100) — NOT NULL — 옵션명
  • kind — ENUM('ADD_ON', 'OPTION') — 옵션종류
  • INDEX — `ix_opt_product`

clarte_qna

  • id — BIGINT — Primary key — NOT NULL — Q&AID
  • answer_updated_at — DATETIME(6) — 답변수정일시
  • answered_at — DATETIME(6) — 답변일시
  • answered_by — BIGINT — Foreign key → clarte_users.id — 답변자ID
  • questioner_id — BIGINT — Foreign key → clarte_users.id — NOT NULL — 질문자ID
  • created_at — DATETIME(6) — NOT NULL — 생성일시
  • title — VARCHAR(150) — NOT NULL — 제목
  • answer — TEXT — 답변내용
  • question — TEXT — NOT NULL — 질문내용
  • status — ENUM('ANSWERED', 'PENDING') — NOT NULL — 상태
  • INDEX — `ix_qna_ans`
  • INDEX — `ix_qna_qer`

clarte_review_image

  • url — VARCHAR(500) — Primary key — NOT NULL — 이미지URL
  • review_id — BIGINT — Foreign key → clarte_reviews.id — NOT NULL — 리뷰ID
  • INDEX — `ix_revimg_review`

clarte_reviews

  • id — BIGINT — Primary key — NOT NULL — 리뷰ID
  • admin_hidden — BIT — NOT NULL — 관리자숨김
  • hidden — BIT — NOT NULL — 사용자숨김
  • rating — INT — NOT NULL — 평점
  • created_at — DATETIME(6) — 생성일시
  • order_product_id — BIGINT — Foreign key → clarte_order_products.id — 주문상품ID
  • product_id — BIGINT — Foreign key → clarte_product.id — 상품ID
  • user_zipcode — VARCHAR(20) — 사용자우편번호
  • user_phone — VARCHAR(50) — 사용자전화번호
  • user_nick_name — VARCHAR(100) — 사용자닉네임
  • user_username — VARCHAR(100) — NOT NULL — 사용자아이디
  • user_email — VARCHAR(200) — 사용자이메일
  • content — VARCHAR(1000) — 내용
  • user_address — VARCHAR(255) — 사용자주소
  • user_address_detail — VARCHAR(255) — 사용자상세주소
  • INDEX — `ix_reviews_order_prod`
  • INDEX — `ix_reviews_product`

clarte_users

  • id — BIGINT — Primary key — NOT NULL — 유저ID
  • additional_information — BIT — NOT NULL — 추가정보여부
  • created_at — DATETIME(6) — 생성일시
  • updated_at — DATETIME(6) — 수정일시
  • phone — VARCHAR(15) — 전화번호
  • nick_name — VARCHAR(45) — 닉네임
  • password — VARCHAR(100) — NOT NULL — 비밀번호
  • email — VARCHAR(120) — 이메일
  • provider_id — VARCHAR(120) — NOT NULL — 제공자ID
  • name — VARCHAR(130) — NOT NULL — 이름
  • provider — ENUM('GOOGLE', 'KAKAO', 'LOCAL', 'NAVER') — NOT NULL — 제공자
  • role — ENUM('ADMIN', 'USER') — NOT NULL — 역할
  • status — ENUM('ACTIVE', 'DELETED', 'SUSPENDED') — 상태