test

Tables (50)

TB_USER

  • id — int — Primary key — NOT NULL
  • created_date — datetime(6) — NOT NULL
  • updated_date — datetime(6) — NOT NULL
  • username — varchar(50) — 유저 id
  • password — varchar(120) — 비밀번호
  • role — enum('USER', 'ADMIN') — NOT NULL — 역할

ll_account

  • seq — int — Primary key — NOT NULL
  • bank — enum('국민은행','SC제일은행','KEB하나은행','경남은행','광주은행','아이엠뱅크','부산은행','전북은행','제주은행','수협','신협','기업은행','케이뱅크','카카오뱅크','산업은행','농협','새마을금고','신한은행','씨티은행','우리은행','우체국','토스뱅크') — NOT NULL
  • holder — varchar(100) — NOT NULL
  • account — varchar(30) — NOT NULL
  • use_flag — tinyint — NOT NULL
  • position — int — NOT NULL
  • type — enum('무통장','반품 배송비') — NOT NULL

ll_additional_fee

  • seq — int — Primary key — NOT NULL
  • type — enum('기타','반품') — NOT NULL
  • amount — int — NOT NULL
  • payment_method — enum('직접 송금','사용자 결제') — NOT NULL
  • memo — text
  • status — enum('요청','완료','취소 요청','취소 완료') — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)
  • claim_seq — int — Foreign key → ll_claim.seq
  • payment_seq — int — Foreign key
  • order_seq — int — Foreign key

ll_address

  • seq — int — Primary key — NOT NULL
  • name — varchar(300) — NOT NULL
  • address — json — NOT NULL
  • country — int — NOT NULL
  • phone_number1_country — int — NOT NULL
  • phone_number1 — varchar(30) — NOT NULL
  • phone_number2_country — int — NOT NULL
  • phone_number2 — varchar(30) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

ll_admin

  • seq — int — Primary key — NOT NULL
  • password — varchar(255) — NOT NULL
  • name — varchar(50) — NOT NULL
  • email — varchar(64)
  • cellphone — varchar(20)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • last_login_at — datetime
  • unactivated_at — datetime(6)
  • is_head — tinyint(1) — NOT NULL
  • admin_group_seq — int — Foreign key → ll_admin_group.seq
  • id — varchar(30)
  • file_seq — int — Foreign key

ll_admin_group

  • seq — int — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • privacy_masking_flag — tinyint(1) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

ll_admin_group_auth

  • seq — int — Foreign key → ll_admin_group.seq — NOT NULL
  • product_page — enum('권한 없음','읽기','편집') — NOT NULL
  • naver_lowest_price_page — enum('권한 없음','읽기','편집') — NOT NULL
  • product_create_update_page — enum('권한 없음','읽기','편집') — NOT NULL
  • product_list_create_page — enum('권한 없음','읽기','편집') — NOT NULL
  • product_list_update_page — enum('권한 없음','읽기','편집') — NOT NULL
  • price_calculation_group_management_page — enum('권한 없음','읽기','편집') — NOT NULL
  • default_price_calculation_group_settings_page — enum('권한 없음','읽기','편집') — NOT NULL
  • brand_matching_page — enum('권한 없음','읽기','편집') — NOT NULL
  • category_page — enum('권한 없음','읽기','편집') — NOT NULL
  • brand_page — enum('권한 없음','읽기','편집') — NOT NULL
  • color_page — enum('권한 없음','읽기','편집') — NOT NULL
  • pattern_shape_page — enum('권한 없음','읽기','편집') — NOT NULL
  • size_page — enum('권한 없음','읽기','편집') — NOT NULL
  • gender_page — enum('권한 없음','읽기','편집') — NOT NULL
  • unique_name_page — enum('권한 없음','읽기','편집') — NOT NULL
  • gift_page — enum('권한 없음','읽기','편집') — NOT NULL
  • gift_create_update_page — enum('권한 없음','읽기','편집') — NOT NULL
  • cj_direct_purchase_page — enum('권한 없음','읽기','편집') — NOT NULL
  • material_page — enum('권한 없음','읽기','편집') — NOT NULL
  • make_country_page — enum('권한 없음','읽기','편집') — NOT NULL
  • every_order_page — enum('권한 없음','읽기','편집') — NOT NULL
  • order_shipment_management_page — enum('권한 없음','읽기','편집') — NOT NULL
  • purchase_confirm_history_page — enum('권한 없음','읽기','편집') — NOT NULL
  • payment_check_page — enum('권한 없음','읽기','편집') — NOT NULL
  • personal_payment_page — enum('권한 없음','읽기','편집') — NOT NULL
  • boutique_request_history_page — enum('권한 없음','읽기','편집') — NOT NULL
  • sale_documentation_page — enum('권한 없음','읽기','편집') — NOT NULL
  • cancel_manage_page — enum('권한 없음','읽기','편집') — NOT NULL
  • return_manage_page — enum('권한 없음','읽기','편집') — NOT NULL
  • exchange_manage_page — enum('권한 없음','읽기','편집') — NOT NULL
  • open_market_product_create_page — enum('권한 없음','읽기','편집') — NOT NULL
  • open_market_product_page — enum('권한 없음','읽기','편집') — NOT NULL
  • open_market_order_page — enum('권한 없음','읽기','편집') — NOT NULL
  • open_market_cancel_page — enum('권한 없음','읽기','편집') — NOT NULL
  • open_market_return_page — enum('권한 없음','읽기','편집') — NOT NULL
  • open_market_exchange_page — enum('권한 없음','읽기','편집') — NOT NULL
  • open_market_integration_page — enum('권한 없음','읽기','편집') — NOT NULL
  • member_info_page — enum('권한 없음','읽기') — NOT NULL
  • deleted_member_info_page — enum('권한 없음','읽기') — NOT NULL
  • member_segment_page — enum('권한 없음','읽기','편집') — NOT NULL
  • manual_alert_page — enum('권한 없음','읽기','편집') — NOT NULL
  • auto_alert_page — enum('권한 없음','읽기','편집') — NOT NULL
  • alert_history_page — enum('권한 없음','읽기','편집') — NOT NULL
  • alert_manage_template_page — enum('권한 없음','읽기','편집') — NOT NULL
  • advantage_policy_page — enum('권한 없음','읽기','편집') — NOT NULL
  • advantage_coupon_page — enum('권한 없음','읽기','편집') — NOT NULL
  • member_tier_page — enum('권한 없음','읽기','편집') — NOT NULL
  • product_inquiry_page — enum('권한 없음','읽기','편집') — NOT NULL
  • customer_inquiry_page — enum('권한 없음','읽기','편집') — NOT NULL
  • channel_talk_page — enum('권한 없음','읽기','편집') — NOT NULL
  • open_market_inquiry_page — enum('권한 없음','읽기','편집') — NOT NULL
  • inquiry_template_page — enum('권한 없음','읽기','편집') — NOT NULL
  • review_page — enum('권한 없음','읽기','편집') — NOT NULL
  • review_event_page — enum('권한 없음','읽기','편집') — NOT NULL
  • notice_page — enum('권한 없음','읽기','편집') — NOT NULL
  • faq_page — enum('권한 없음','읽기','편집') — NOT NULL
  • secret_post_page — enum('권한 없음','읽기','편집') — NOT NULL
  • board_create_manage_page — enum('권한 없음','읽기','편집') — NOT NULL
  • reported_post_manage_page — enum('권한 없음','읽기','편집') — NOT NULL
  • … +28

ll_advantage_policy

  • seq — int — Primary key — NOT NULL — 시퀀스
  • advantage_policy_type — enum('구매 혜택', '누적 구매액 달성 혜택', '리뷰 작성 혜택', '정기 혜택', '신규회원 혜택', '사은품 혜택', '친구 추천 혜택', '생일 혜택', '앱 설치 혜택') — NOT NULL — 혜택 유형
  • name — varchar(100) — NOT NULL — 혜택명
  • start_date — date — NOT NULL — 시작일
  • end_date — date — NOT NULL — 종료일
  • advantage_detail — json — NOT NULL — 혜택 상세 정보
  • member_segment_seq — int — Foreign key — 회원 세그먼트 시퀀스
  • deleted_at — datetime(6) — 삭제일
  • active_flag — tinyint — NOT NULL — 적용중 여부

ll_alert_log

  • seq — int — Primary key — NOT NULL
  • alert_type — enum('회원', '주문', '리마인드', '게시판') — NOT NULL — 알림 구분
  • alert_detail_type — enum('회원 가입', '아이디 찾기', '비밀번호 찾기', '회원 탈퇴', '광고성 정보 수신 동의 여부', '광고성 정보 수신 동의 변경', '휴면 일반 회원 전환 사후 안내', '주문 접수', '입금 요청', '결제 확인', '출고 완료', '해외 배송 출발', '배송 완료', '환불 완료(취소)'
  • 환불 — 완료(반품)'
  • 비회원 — 주문
  • 미입금 — 취소
  • 래플 — 이벤트
  • 마일리지 — 지급'
  • 쿠폰 — 만료
  • 포인트 — 지급'
  • 다음 — 달
  • 장바구니/위시 — 상품'
  • 장바구니/위시 — 상품
  • 장바구니/위시 — 상품
  • 쿠폰 — 발급'
  • 가격 — 인하'
  • 포인트 — 소멸
  • 고객 — 등급
  • 상품 — 리뷰
  • 게시판 — 댓글
  • 상품 — 문의
  • 1:1 — 문의 — NOT NULL — 알림 상세 구분
  • platform — enum('이메일', 'SMS', '카카오', '슬랙', '푸시') — NOT NULL — 알림 플랫폼
  • auto_flag — tinyint — NOT NULL — 자동 알림 여부
  • ad_flag — tinyint — NOT NULL — 광고성 여부
  • title — varchar(50) — 알림 제목
  • content — varchar(1000) — NOT NULL — 알림 내용
  • status — enum('성공', '실패', '대기중', '예약대기중') — NOT NULL — 발송 상태
  • sent_at — datetime — NOT NULL — 발송 일시
  • sender — varchar(20) — NOT NULL — 발송자
  • created_at — datetime(6) — NOT NULL

ll_alert_setting

  • seq — int — Primary key — NOT NULL
  • email_consent_message_default — varchar(1000)
  • email_sender_info_default — varchar(1000)
  • sms_product_max_letters — int
  • sms_limit_flag — tinyint
  • sms_limit_start_hour — tinyint
  • sms_limit_end_hour — tinyint
  • sms_resend_hour — tinyint
  • sms_resend_minute — tinyint

ll_auto_alert_template

  • seq — int — Primary key — NOT NULL
  • platform — enum('이메일','SMS','카카오','슬랙','푸시') — NOT NULL
  • use_flag — tinyint(1) — NOT NULL
  • content — varchar(1000)
  • buttons — json
  • default_content — varchar(1000)
  • auto_alert_type_seq — int — Foreign key → ll_auto_alert_type.seq — NOT NULL
  • title — varchar(500)

ll_auto_alert_type

  • seq — int — Primary key — NOT NULL
  • alert_type — enum('회원','주문','리마인드','게시판') — NOT NULL
  • alert_detail_type — enum('회원 가입','아이디 찾기','비밀번호 찾기','회원 탈퇴','광고성 정보 수신 동의 여부','광고성 정보 수신 동의 변경','휴면 일반 회원 전환 사후 안내','주문 접수','입금 요청','결제 확인','출고 완료','해외 배송 출발','배송 완료','환불 완료(취소)'
  • 환불 — 완료(반품)'
  • 비회원 — 주문
  • 미입금 — 취소
  • 래플 — 이벤트
  • 마일리지 — 지급'
  • 쿠폰 — 만료
  • 포인트 — 지급'
  • 다음 — 달
  • 장바구니/위시 — 상품'
  • 장바구니/위시 — 상품
  • 장바구니/위시 — 상품
  • 쿠폰 — 발급'
  • 가격 — 인하'
  • 포인트 — 소멸
  • 고객 — 등급
  • 상품 — 리뷰
  • 게시판 — 댓글
  • 상품 — 문의
  • 1:1 — 문의 — NOT NULL
  • info_flag — tinyint — NOT NULL
  • fix_opened_flag — tinyint — NOT NULL
  • additional_setting — json

ll_banner

  • seq — int — Primary key — NOT NULL
  • type — enum('이미지','이미지 캐로셀','이미지 슬라이드','상품','이미지+상품','분류기준+상품','텍스트','텍스트 캐로셀','텍스트 슬라이드') — NOT NULL
  • name — varchar(100) — NOT NULL

ll_banner_classification

  • banner_seq — int — Foreign key → ll_banner.seq — NOT NULL
  • product_display_type — enum('조회순','할인금액순','가격낮은순','가격높은순','등록순','순서 자유 조정') — NOT NULL
  • classification_type — enum('브랜드','색상','소재','사이즈','패턴/형태','제조국','성별','고유명칭','카테고리') — NOT NULL
  • name — varchar(80) — NOT NULL

ll_banner_classification_exclude_product

  • banner_classification_seq — int — Foreign key → ll_banner_classification.banner_seq — NOT NULL
  • product_seq — int — Foreign key — NOT NULL

ll_banner_image

  • seq — int — Primary key — NOT NULL
  • name — varchar(100)
  • banner_seq — int — Foreign key → ll_banner.seq — NOT NULL
  • url — varchar(500) — NOT NULL
  • use_flag — tinyint — NOT NULL
  • position — int — NOT NULL
  • pc_image_seq — int — Foreign key — NOT NULL
  • mobile_image_seq — int — Foreign key

ll_banner_product

  • banner_seq — int — Foreign key → ll_banner.seq — NOT NULL
  • product_range_seq — int — Foreign key — NOT NULL
  • image_url — varchar(500)
  • pc_image_seq — int — Foreign key
  • mobile_image_seq — int — Foreign key
  • display_type — enum('조회순','할인금액순','가격낮은순','가격높은순','등록순','순서 자유 조정') — NOT NULL
  • rest_display_type — enum('조회순','할인금액순','가격낮은순','가격높은순','등록순','순서 자유 조정')

ll_banner_product_display_order

  • product_seq — int — Foreign key — NOT NULL
  • banner_product_seq — int — Foreign key → ll_banner_product.banner_seq — NOT NULL
  • position — int — NOT NULL

ll_banner_text

  • banner_seq — int — Foreign key → ll_banner.seq — NOT NULL
  • text_color — varchar(10) — NOT NULL
  • background_color — varchar(10) — NOT NULL
  • text_size — int — NOT NULL

ll_board

  • seq — int — Primary key — NOT NULL
  • name — varchar(30) — NOT NULL
  • default_type — enum('공지사항','자주 묻는 질문')
  • position — int
  • expose_flag — tinyint — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • use_reply_flag — tinyint — NOT NULL
  • use_comment_flag — tinyint — NOT NULL
  • use_post_vote_flag — tinyint — NOT NULL
  • use_post_downvote_flag — tinyint — NOT NULL
  • use_comment_vote_flag — tinyint — NOT NULL
  • use_comment_downvote_flag — tinyint — NOT NULL
  • post_default_text — varchar(1000)
  • secret_post_setting — enum('필수','선택','사용안함') — NOT NULL
  • attach_file_flag — tinyint — NOT NULL
  • use_video_flag — tinyint — NOT NULL
  • use_report_flag — tinyint — NOT NULL
  • post_read_auth — enum('전체','회원') — NOT NULL
  • post_write_auth — enum('전체','회원','관리자') — NOT NULL
  • reply_write_auth — enum('전체','회원','관리자') — NOT NULL
  • comment_write_auth — enum('전체','회원','관리자') — NOT NULL
  • show_number_flag — tinyint — NOT NULL
  • show_writer_flag — tinyint — NOT NULL
  • show_created_date_flag — tinyint — NOT NULL
  • show_view_cnt_flag — tinyint — NOT NULL
  • show_vote_flag — tinyint — NOT NULL
  • new_icon_duration — int — NOT NULL
  • hot_icon_min_view_cnt — int — NOT NULL
  • new_icon_file_seq — int
  • hot_icon_file_seq — int
  • comment_upvote_icon_file_seq — int — Foreign key
  • comment_downvote_icon_file_seq — int — Foreign key
  • show_type — enum('리스트','갤러리','썸네일') — NOT NULL
  • post_upvote_icon_file_seq — int — Foreign key
  • post_downvote_icon_file_seq — int — Foreign key
  • post_count — int — NOT NULL

ll_boutique

  • seq — int — Primary key — NOT NULL
  • name_en — varchar(50)
  • name_ko — varchar(50) — NOT NULL
  • abbreviation — varchar(10)
  • price_calculation_group_seq — int — Foreign key
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

ll_boutique_deposit_log

  • seq — int — Primary key — NOT NULL
  • boutique_seq — int — Foreign key → ll_boutique.seq — NOT NULL
  • actioned_at — datetime(6) — NOT NULL
  • type — enum('deposit','manual','auto','credit') — NOT NULL
  • product_order_seq — int
  • plus — decimal(10,2) — NOT NULL
  • minus — decimal(10,2) — NOT NULL
  • total — decimal(10,2) — NOT NULL
  • memo — text
  • file_seq — int — Foreign key

ll_boutique_goods

  • b_goods_seq — int — Primary key — NOT NULL
  • boutique_seq — int — Foreign key → ll_boutique.seq — NOT NULL
  • goods_id — varchar(50)
  • goods_name — varchar(255)
  • category_code1 — varchar(255)
  • category_code2 — varchar(255)
  • category_code3 — varchar(255)
  • category_code4 — varchar(255)
  • category_title_eng1 — varchar(255)
  • category_title_eng2 — varchar(255)
  • category_title_eng3 — varchar(255)
  • category_title_eng4 — varchar(255)
  • brand_code — varchar(255)
  • brand_title_eng — varchar(255)
  • goods_code — varchar(255)
  • gender — varchar(255)
  • color — varchar(255)
  • season — varchar(255)
  • collection — varchar(255)
  • detail_info — text
  • made_in — varchar(255)
  • composition — text
  • size_fit_info — varchar(255)
  • tot_stock — int
  • extraction_status — tinyint
  • extraction_status_msg — varchar(255)
  • llink_connect — tinyint
  • llink_connect_last_status — tinyint
  • llink_connect_last_msg — varchar(255)
  • img_reload — tinyint
  • regist_date — datetime(6) — NOT NULL
  • update_date — datetime(6) — NOT NULL
  • id — int — NOT NULL

ll_boutique_goods_option

  • option_seq — bigint — Primary key — NOT NULL
  • b_goods_seq — bigint — NOT NULL
  • goods_id — varchar(100) — NOT NULL
  • option_id — varchar(30) — NOT NULL
  • image_id — varchar(20) — NOT NULL
  • barcode — varchar(30) — NOT NULL
  • cod_articolo — varchar(50) — NOT NULL
  • option1 — varchar(100) — NOT NULL
  • retail_price — decimal(10,2) — NOT NULL
  • retail_price_tax_ex — decimal(10,2) — NOT NULL
  • net_price — decimal(10,2) — NOT NULL
  • discount_rate — decimal(10,2) — NOT NULL
  • tax_rate — decimal(10,2) — NOT NULL
  • stock — int — NOT NULL
  • currency — varchar(10) — NOT NULL
  • retailer — varchar(20) — NOT NULL
  • regist_date — datetime — NOT NULL
  • update_date — datetime — NOT NULL
  • beestore_first_update — tinyint — NOT NULL

ll_brand

  • seq — int — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • eng_name — varchar(50) — NOT NULL
  • korean_name — varchar(100) — NOT NULL
  • url — text
  • keyword — text
  • market_keyword — text
  • best_brand_flag — tinyint — NOT NULL
  • show_flag — tinyint — NOT NULL
  • kids_flag — tinyint — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

ll_brand_market_brand

  • brand_seq — int — Foreign key → ll_brand.seq — NOT NULL
  • market_brand_code — varchar(25) — Foreign key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

ll_business_information

  • seq — tinyint — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • representative_name — varchar(100) — NOT NULL
  • industry — varchar(100) — NOT NULL
  • category — varchar(100) — NOT NULL
  • postal_address — varchar(10) — NOT NULL
  • parcel_number — varchar(300) — NOT NULL
  • road_name — varchar(300) — NOT NULL
  • detail_address — varchar(300) — NOT NULL
  • representative_phone — varchar(20) — NOT NULL
  • representative_fax — varchar(20) — NOT NULL
  • representative_email — varchar(20) — NOT NULL
  • privacy_officer — varchar(100) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • business_number — varchar(20) — NOT NULL
  • mail_order_sales_approval_number — varchar(300) — NOT NULL

ll_category

  • seq — int — Primary key — NOT NULL
  • code — varchar(25) — NOT NULL
  • name — varchar(50) — NOT NULL
  • name_en — varchar(50)
  • url — text
  • keyword — text
  • market_keyword — text
  • show_flag — tinyint — NOT NULL
  • level — int — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • product_attr_set_default_type — enum('의류','구두/신발','가방','패션잡화','침구류/커튼','가구') — NOT NULL
  • price_calculation_group_seq — int — Foreign key

ll_category_closure

  • seq — int — Primary key — NOT NULL
  • parent_seq — int — Foreign key → ll_category.seq — NOT NULL
  • child_seq — int — Foreign key → ll_category.seq — NOT NULL

ll_category_market_category

  • category_seq — int — Foreign key → ll_category.seq — NOT NULL
  • market_category_code — varchar(25) — Foreign key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

ll_claim

  • seq — int — Primary key — NOT NULL
  • claim_number — varchar(50) — NOT NULL — 클레임 번호
  • can_use_coupon_flag — tinyint — NOT NULL — 배송비 쿠폰 사용 가능 여부
  • delivery_coupon_issuance_seq — int — Foreign key → ll_coupon_issuance.seq — 배송비 쿠폰 발급 시퀀스
  • created_at — datetime(6) — NOT NULL — 생성일
  • cancel_status — enum('취소요청', '취소완료 처리중', '취소완료', '취소 거부 처리중', '취소 거부', '취소 원복') — 취소 상태
  • return_status — enum('반품 요청', '반품 수거중', '반품 수거 완료', '반품 완료 처리중', '반품 완료', '반품 거부 처리중', '반품 거부') — 반품 상태
  • exchange_status — enum('교환 요청', '교환 수거 중', '교환 수거 완료', '교환 재배송 처리중', '교환 재배송중', '교환 완료', '교환 거부 처리중', '교환 거부') — 교환 상태
  • hold_status — enum('보류', '보류 해제') — 보류 상태
  • claim_delivery_payment_method — enum('환불 금액에서 차감', '직접 송금', '택배상자 동봉', '사용자 결제') — 배송 결제 방법
  • claim_delivery_payment_seq — int — Foreign key — 배송 결제 시퀀스
  • claim_reason_seq — int — Foreign key → ll_claim_reason.seq — NOT NULL — 클레임 사유 시퀀스
  • claim_end_date — datetime — 클레임 완료일
  • refund_method — enum('PG사 환불', '계좌 환불') — 환불 방법
  • refund_account — json — 환불 계좌
  • refund_status — enum('환불 대기', '환불 진행중', '환불 완료') — 환불 상태
  • refund_end_date — datetime — 환불 완료일
  • refund_all_flag — tinyint — 전체 취소 여부
  • refund_processor_seq — int — Foreign key → ll_admin.seq — 환불 처리자 시퀀스
  • order_seq — int — Foreign key — NOT NULL — 주문 번호
  • claim_delivery_discount_amount — int
  • claim_delivery_payment_responsibility — enum('판매자', '구매자') — 배송 결제 책임
  • hold_reason_seq — int — Foreign key → ll_claim_hold_reason.seq — 보류 사유 시퀀스
  • claim_reason_detail — varchar(1500) — 상세 사유
  • collected_date — datetime — 수거 완료일
  • deleted_at — datetime(6) — 삭제일
  • claim_type — enum('취소', '반품', '교환') — NOT NULL — 클레임 종류
  • adjusted_amount — int — 중요 클레임 여부

ll_claim_delivery

  • seq — int — Primary key — NOT NULL
  • claim_seq — int — Foreign key → ll_claim.seq — NOT NULL
  • collection_delivery_company_seq — int — Foreign key
  • collection_invoice_number — varchar(50)
  • redelivery_invoice_number — varchar(50)
  • redelivery_delivery_company_seq — int — Foreign key
  • collection_end_date — datetime
  • redelivery_end_date — datetime
  • claim_delivery_cost — int — NOT NULL
  • collection_method — enum('자가반품','택배수거')
  • collection_delivery_policy — enum('해외','국내')
  • collection_domestic_address_seq — int — Foreign key
  • collection_international_address_seq — int — Foreign key
  • redelivery_delivery_policy — enum('해외','국내')
  • redelivery_domestic_address_seq — int — Foreign key
  • redelivery_international_address_seq — int — Foreign key
  • redelivery_recipient — varchar(100)
  • redelivery_phone — varchar(50)

ll_claim_hold_reason

  • seq — int — Primary key — NOT NULL
  • reason_category — enum('제품 훼손','정책 위반','기한 초과') — NOT NULL
  • claim_type — enum('반품','교환') — NOT NULL
  • reason — varchar(300) — NOT NULL

ll_claim_reason

  • seq — int — Primary key — NOT NULL
  • caused_by — enum('사용자','판매자') — NOT NULL
  • user_responsibility — enum('변심','주문 실수')
  • seller_responsibility — enum('하자','오배송')
  • type — enum('취소','반품','교환') — NOT NULL
  • reason — varchar(300) — NOT NULL
  • deleted_at — datetime(6)

ll_claim_refund

  • seq — int — Primary key — NOT NULL — 클레임 환불 시퀀스
  • claim_seq — int — Foreign key → ll_claim.seq — NOT NULL — 클레임 시퀀스
  • refund_amount_sum — int — NOT NULL — 환불금 합
  • retrieval_info — json — NOT NULL — 회수금 정보
  • point_info — json — 포인트 정보
  • mileage_info — json — 마일리지 정보
  • claim_delivery_cost_deduct_flag — tinyint — 배송비 차감 여부
  • total_refund_amount — int — NOT NULL — 최종 환불 금액
  • adjusted_amount — int — 조정 금액

ll_color

  • seq — int — Primary key — NOT NULL
  • name_ko — varchar(20) — NOT NULL
  • name_en — varchar(15) — NOT NULL
  • color_code — varchar(10) — NOT NULL
  • keyword — text
  • show — tinyint — NOT NULL
  • position — int — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

ll_color_market_color

  • market_color_code — varchar(25) — Foreign key — NOT NULL
  • color_seq — int — Foreign key → ll_color.seq — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

ll_column_format

  • seq — int — Primary key — NOT NULL
  • format_name — varchar(255) — NOT NULL — 양식 이름
  • is_pinned — tinyint(1) — NOT NULL — 고정 여부
  • updated_at — datetime(6) — NOT NULL — 수정일
  • created_at — datetime(6) — NOT NULL — 생성일
  • admin_seq — int — Foreign key → ll_admin.seq — NOT NULL — 관리자 번호
  • column_format — json — NOT NULL — 컬럼 양식
  • column_format_type — enum('PRODUCT FIND', 'PRODUCT UPDATE', 'ORDER ALL', 'ORDER EXCEL ALL', 'ORDER SHIPPING', 'ORDER EXCEL SHIPPING', 'ORDER PURCHASE CONFIRM', 'ORDER EXCEL PURCHASE CONFIRM', 'ORDER CANCEL', 'ORDER RETURN', 'ORDER EXCHANGE', 'ORDER DOWNLOAD') — NOT NULL
  • is_default — tinyint(1) — NOT NULL — 기본 양식 여부

ll_comment

  • seq — int — Primary key — NOT NULL
  • content — varchar(1000) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • secret_flag — tinyint
  • deleted_at — datetime(6)
  • post_seq — int — Foreign key — NOT NULL
  • writer_member_seq — int — Foreign key
  • writer_admin_seq — int — Foreign key → ll_admin.seq
  • parent_comment_seq — int — Foreign key → ll_comment.seq

ll_country

  • country_code — varchar(2) — Primary key — NOT NULL
  • continent — enum('아프리카','아시아','유럽','오세아니아','남아메리카','북아메리카') — NOT NULL
  • name — varchar(50) — NOT NULL
  • name_en — varchar(50) — NOT NULL
  • number — varchar(10) — NOT NULL

ll_coupon

  • seq — int — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • latest_coupon_history_seq — int — Foreign key → ll_coupon_history.seq
  • created_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)
  • specification — enum('혜택','프로모션') — NOT NULL

ll_coupon_history

  • seq — int — Primary key — NOT NULL
  • description — varchar(300) — NOT NULL
  • type — enum('개별 상품','주문서','배송비','교환반품배송비') — NOT NULL
  • valid_period_type — enum('무제한','발급일 기준','고정 날짜') — NOT NULL
  • valid_period_length — int
  • valid_period_start_date — date
  • valid_period_end_date — date
  • detail — json — NOT NULL
  • product_coupon_overlap — tinyint(1) — NOT NULL
  • order_coupon_overlap — tinyint(1) — NOT NULL
  • delivery_coupon_overlap — tinyint(1)
  • discount_code_overlap — tinyint(1)
  • discount_path_overlap — tinyint(1)
  • reuse_time — int
  • modified_at — datetime(6) — NOT NULL
  • product_range_seq — int — Foreign key
  • coupon_seq — int — Foreign key → ll_coupon.seq — NOT NULL
  • use_reuse — tinyint(1) — NOT NULL
  • use_reuse_time — tinyint(1)
  • reuse_time_unit — enum('시간','일','개월','년')
  • reuse_count — int
  • use_min_order_price — tinyint(1) — NOT NULL
  • min_order_price — int
  • use_max_discount_amount — tinyint(1) — NOT NULL
  • max_discount_amount — int

ll_coupon_issuance

  • seq — int — Primary key — NOT NULL
  • member_seq — int — Foreign key — NOT NULL
  • coupon_history_seq — int — Foreign key → ll_coupon_history.seq — NOT NULL
  • use_flag — tinyint(1) — NOT NULL
  • issue_date — datetime(6) — NOT NULL
  • due_date — datetime

ll_coupon_log

  • seq — int — Primary key — NOT NULL
  • actioned_at — datetime(6) — NOT NULL
  • changed_item — enum('쿠폰 설명','쿠폰 유효 기한','쿠폰 종류','쿠폰 내용','쿠폰 제한','적용 가능 상품','발급 기간','발급 링크','발급 코드','마이페이지 발급') — NOT NULL
  • category — enum('추가','수정','삭제') — NOT NULL
  • content — text — NOT NULL
  • memo — text
  • admin_seq — int — NOT NULL
  • coupon_seq — int — Foreign key → ll_coupon.seq — NOT NULL

ll_customer_inquiry

  • seq — int — Primary key — NOT NULL
  • category — enum('상품','결제','배송','취소','교환','반품','환불','회원정보','기타') — NOT NULL
  • title — varchar(100) — NOT NULL
  • writer_member_seq — int — Foreign key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • thread_seq — int — Foreign key → ll_customer_inquiry_thread.seq — NOT NULL
  • view_cnt — int — NOT NULL

ll_customer_inquiry_answer

  • seq — int — Primary key — NOT NULL
  • customer_inquiry_seq — int — Foreign key → ll_customer_inquiry.seq — NOT NULL
  • title — varchar(100) — NOT NULL
  • content — varchar(1000) — NOT NULL
  • writer_admin_seq — int — Foreign key → ll_admin.seq — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

ll_customer_inquiry_thread

  • seq — int — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

ll_default_address

  • seq — int — Primary key — NOT NULL
  • send_address_seq — int — Foreign key → ll_address.seq — NOT NULL
  • return_exchange_address_seq — int — Foreign key → ll_address.seq — NOT NULL

ll_delivery

  • seq — int — Primary key — NOT NULL
  • product_order_seq — int — Foreign key — NOT NULL
  • delivery_policy — enum('해외','국내') — NOT NULL
  • delivery_method — enum('택배','퀵서비스','방문수령') — NOT NULL
  • delivery_address_type — enum('해외','국내') — NOT NULL
  • remote_area_additional_fee — int — NOT NULL
  • boutique_delivery_company_seq — int — Foreign key
  • boutique_invoice_number — varchar(50)
  • boutique_delivery_start_date — datetime
  • customer_delivery_company_seq — int — Foreign key
  • customer_invoice_number — varchar(50)
  • customer_delivery_start_date — datetime

ll_delivery_bundle_group

  • seq — int — Primary key — NOT NULL
  • name — varchar(150) — NOT NULL
  • remote_area_fee_policy — enum('없음','2권역','3권역') — NOT NULL
  • remote_area_fee1 — int
  • remote_area_fee2 — int
  • use_flag — tinyint(1) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • calculation_method — enum('min','max') — NOT NULL