hastings

Tables (43)

agreements (개인정보동의내역)

  • seq (개인정보동의내역id) — Integer — Primary key — NOT NULL
  • customer_id (고객id) — String(10) — Foreign key → customers.id — NOT NULL
  • terms_of_service (서비스 이용약관 = 회원제 서비스 이용/본인확인, default=1) — String(1)
  • info_collect_use (개인정보 수집 및 이용, default=1) — String(1)
  • above_14_years (만 14세 이상, default=1) — String(1)
  • info_consignment (개인정보처리 위탁동의 = 마케팅활용(이벤트,맞춤형 광고)) — String(1)
  • receive_info_sms (무료배송, 할인쿠폰 등 혜택/정보 수신 동의(sms) = 마케팅 및 광고 활용을 위한 정보수신 동의(핸드폰)) — String(1)
  • receive_info_email (무료배송, 할인쿠폰 등 혜택/정보 수신 동의(email) = 마케팅 및 광고 활용을 위한 정보수신 동의(이메일)) — String(1)
  • receive_info_app (앱Push 마케팅 및 광고 활용을 위한 정보 수신 동의 - 정보성) — String(1)
  • receive_ad_app (앱Push 마케팅 및 광고 활용을 위한 정보 수신 동의 - 광고성) — String(1)

attribute_sets (상품정보제공고시)

  • seq (상품정보제공고시id) — Integer — Primary key — NOT NULL
  • model_name (품명 및 모델명) — String(30)
  • legal_license (법에 의한 인증, 허가 ...) — String(30)
  • origin (제조국 또는 원산지) — String(30)
  • manufacturer (제조사) — String(30)
  • after_service_manager (AS 책임자) — String(30)
  • after_service_phone (AS 책임자 연락처) — String(30)
  • seller (판매자) — String(30)

card_receipts (카드영수증)

  • seq (카드영수증id) — Integer — Primary key — NOT NULL
  • card_company (카드사) — String(10)
  • card_number (카드번호) — String(20)
  • card_holder (카드소유자) — String(10)

carts (장바구니)

  • id (장바구니id) — Integer — Primary key — NOT NULL
  • customer_id (고객id) — String(10) — Foreign key → customers.id — NOT NULL
  • mto_product_id (MTO상품id) — Integer — Foreign key → mto_products.seq — NOT NULL
  • mts_product_id (MTS상품id) — Integer — Foreign key → mts_products.seq — NOT NULL
  • quantity (수량) — Integer
  • amount (금액) — Integer

cash_receipts (현금영수증)

  • seq (현금영수증id) — Integer — Primary key — NOT NULL
  • amount (발행금액) — Integer
  • information (발행정보) — String(50)
  • purpose (발급목적) — String(50)
  • phone_number (휴대폰번호) — String(20)
  • cash_receipt_card_number (현금영수증카드번호) — String(20)
  • business_number (사업자번호) — String(20)
  • company_name (업체명) — String(20)

categories (상품분류)

  • seq (상품분류id) — Integer — Primary key — NOT NULL
  • four_levels (분류단계) — String(5)
  • taxonomy (분류명) — String(30)
  • descript (분류설명) — String(30)
  • is_exposed (쇼핑몰노출여부) — String(1)
  • image (이미지) — ???
  • display_order (상품진열순서) — String(5)
  • super_id (상위 상품분류id) — Integer — Foreign key → categories.seq — NOT NULL

category_attachments (상품분류첨부파일)

  • seq (상품분류첨부파일id) — Integer — Primary key — NOT NULL
  • category_seq (상품분류id) — Integer — Foreign key → categories.seq — NOT NULL
  • file_name (파일이름) — String(256)
  • url_address (url주소) — String(256)
  • description (상세설명) — String(256)

companies (기업정보)

  • seq (기업정보id) — Integer — Primary key — NOT NULL
  • customer_id (고객id) — String(10) — Foreign key → customers.id — NOT NULL
  • name (회사명) — String(20)
  • ceo (대표자명) — String(10)
  • buisness_number (사업자등록번호) — String(20)
  • cooperate_number (법인등록번호) — String(20)
  • buisness_type (업태) — String(20)
  • buisness_item (업종) — String(20)
  • postal_code (우편번호) — String(10)
  • address (주소) — String(50)
  • address_detail (상세주소) — String(50)

counsels (상담)

  • seq (상담id) — Integer — Primary key — NOT NULL
  • customer_id (고객id) — String(10) — Foreign key → customers.id — NOT NULL
  • employee_id (직원id) — String(10) — Foreign key → employees.id — NOT NULL
  • created_at (상담일시) — String(20)
  • updated_at (수정일시) — String(20)
  • eight_types (상담분류) — String(2)
  • three_status (처리상태) — String(4)
  • content (상담내용) — String(256)
  • five_evaluation (상담지수) — String(2)

custom_order_quote_answer_attachments (주문제작견적문의답변첨부파일)

  • seq (간편견적문의답변첨부파일id) — Integer — Primary key — NOT NULL
  • custom_order_quote_seq (주문제작견적문의id) — Integer — Foreign key → custom_order_quotes.seq — NOT NULL
  • file_name (파일이름) — String(256)
  • url_address (url주소) — String(256)
  • description (상세설명) — String(256)

custom_order_quote_attachments (주문제작견적문의첨부파일)

  • seq (간편견적문의첨부파일id) — Integer — Primary key — NOT NULL
  • custom_order_quote_seq (주문제작견적문의id) — Integer — Foreign key → custom_order_quotes.seq — NOT NULL
  • file_name (파일이름) — String(256)
  • url_address (url주소) — String(256)
  • description (상세설명) — String(256)

custom_order_quotes (주문제작견적문의)

  • seq (주문제작견적문의id) — Integer — Primary key — NOT NULL
  • employee_id (직원id) — String(10) — Foreign key → employees.id — NOT NULL
  • mto_product_seq (MTO상품id) — Integer — Foreign key → mto_products.seq — NOT NULL
  • title (제목) — String(100)
  • is_secret (비밀글여부) — String(1)
  • is_answered (답변여부) — String(1)
  • created_at (등록일시) — String(20)
  • name (업체명/담당자명) — String(20)
  • phone (연락처) — String(20)
  • is_allowed_notification_talk (답변수신문자/알림톡받기) — String(1)
  • email (이메일) — String(30)
  • usage (용도) — String(256)
  • password (비밀번호) — String(100)
  • other_inquiry (기타문의사항) — String(256)
  • consent (이용약관동의) — String(1)
  • answer (답변내용) — String(256)
  • answered_at (답변일시) — String(20)
  • send_reply (답변전송) — String(10)
  • is_received_reply (답변수신여부) — String(1)

customers (고객)

  • id (고객id) — String(10) — Primary key — NOT NULL
  • user_id (이용id) — String(20)
  • password (비밀번호) — String(256)
  • login_attempt_count (로그인 시도 횟수) — Integer
  • access_token (엑세스 토큰) — String(256)
  • has_company_id (기업고객여부) — String(1)
  • status (회원상태) — String(2)
  • created_at (가입일시) — String(20)
  • date_of_last_access (최근접속일시) — String(20)

deliveries (배송)

  • seq (배송id) — Integer — Primary key — NOT NULL
  • purchase_order_seq (주문id) — Integer — Foreign key → purchase_orders.seq — NOT NULL
  • receiver (수령인이름) — String(10)
  • cell_phone (휴대폰) — String(20)
  • phone (연락처) — String(20)
  • email (이메일) — String(30)
  • postal_code (우편번호) — String(10)
  • address (주소) — String(50)
  • address_detail (상세주소) — String(50)
  • memo (배송메모) — String(256)
  • delivery_status (배송상태) — String(30)
  • delivery_method (배송방법) — String(10)

delivery_addresses (배송지)

  • seq (배송지id) — Integer — Primary key — NOT NULL
  • customer_id (고객id) — String(10) — Foreign key → customers.id — NOT NULL
  • is_basic (기본배송지여부) — String(1)
  • is_company (기업배송지여부) — Sring(1)
  • receiver (수령인이름) — String(10)
  • phone (전화번호) — String(20)
  • postal_code (우편번호) — String(10)
  • address (주소) — String(50)
  • address_detail (상세주소) — String(50)
  • nickname (별칭) — String(10)

employees (직원)

  • id (직원id) — String(10) — Primary key — NOT NULL
  • kr_name (한글이름) — String(10)
  • en_name (영어이름) — String(10)
  • password (비밀번호) — String(256)
  • access_token (엑세스토큰) — String(256)
  • login_attempt_count (로그인시도횟수) — Integer
  • team (소속) — String(10)
  • title (직책) — String(10)

faq_attachments (자주묻는질문첨부파일)

  • seq (자주묻는질문첨부파일id) — Integer — Primary key — NOT NULL
  • faq_seq (자주묻는질문id) — Integer — Foreign key → faq_board.seq — NOT NULL
  • file_name (파일이름) — String(256)
  • url_address (url주소) — String(256)
  • description (상세설명) — String(256)

faq_board (자주묻는질문)

  • seq (자주묻는질문id) — Integer — Primary key — NOT NULL
  • employee_id (직원id) — String(10) — Foreign key → employees.id — NOT NULL
  • is_posted (게시여부) — String(1)
  • created_at (등록일시) — String(20)
  • updated_at (수정일시) — String(20)
  • nine_types (유형) — String(10)
  • title (제목) — String(100)
  • question (질문) — String(256)
  • answer (답변) — String(256)
  • view_count (조회수) — Integer

memberships (회원관리)

  • seq (회원관리id) — Integer — Primary key — NOT NULL
  • customer_id (고객id) — String(10) — Foreign key → customers.id — NOT NULL
  • three_funnels (가입경로) — String(5)
  • search_engine (검색엔진) — String(10)
  • search_keyword (검색어) — String(20)
  • four_funnel_types (가입형태) — String(10)
  • three_mobile_app_status (모바일앱 설치) — String(3)
  • mobileapp_auth (모바일앱 인증) — String(1)
  • mobileapp_push (모바일앱PUSH알림) — String(1)
  • five_customer_types (회원유형) — String(10)
  • memo (메모) — String(256)

mto_products (MTO상품)

  • seq (MTO상품id) — Integer — Primary key — NOT NULL
  • product_id (상품id) — String(10) — Foreign key → products.id — NOT NULL
  • unit (단위) — Sting(10)
  • quantity_per_unit (장 수(단위수량)) — Integer
  • price (가격) — Integer
  • price_replacement_phrase (가격대체문구) — String(30)
  • width (가로) — String(10)
  • height (세로) — String(10)
  • glue (접착) — String(10)
  • header (헤더) — String(10)
  • thickness (두께) — String(10)
  • size_m (M자) — String(10)
  • print_spec (인쇄사양) — String(10)

mts_products (MTS상품)

  • seq (MTS상품id) — Integer — Primary key — NOT NULL
  • product_id (상품id) — String(10) — Foreign key → products.id — NOT NULL
  • unit (단위) — Sting(10)
  • quantity_per_unit (장 수(단위수량)) — Integer
  • price (가격) — Integer
  • price_replacement_phrase (가격대체문구) — String(30)
  • discount_percent (할인율(퍼센트)) — Integer
  • width (가로) — String(10)
  • height (세로) — String(10)
  • glue (접착) — String(10)
  • header (헤더) — String(10)
  • thickness (두께) — String(10)
  • size_m (M자) — String(10)

notice_attachments (공지사항첨부파일)

  • seq (공지사항첨부파일id) — Integer — Primary key — NOT NULL
  • notice_seq (공지사항id) — Integer — Foreign key → notice_board.seq — NOT NULL
  • file_name (파일이름) — String(256)
  • url_address (url주소) — String(256)
  • description (상세설명) — String(256)

notice_board (공지사항)

  • seq (공지사항id) — Integer — Primary key — NOT NULL
  • employee_id (직원id) — String(10) — Foreign key → employees.id — NOT NULL
  • is_pinned (상단고정여부) — String(1)
  • is_posted (게시여부) — String(1)
  • three_types_is_exposed (노출여부) — String(3)
  • created_at (등록일시) — String(20)
  • updated_at (수정일시) — String(20)
  • title (제목) — String(100)
  • content (내용) — String(256)
  • separate_mobile_content (분리된 모바일 내용) — String(256)
  • view_count (조회수) — Integer

odm_items (ODM항목)

  • seq (주문항목id) — Integer — Primary key — NOT NULL
  • purchase_order_seq (주문id) — Integer — Foreign key → purchase_orders.seq — NOT NULL
  • mto_product_seq (MTO상품id) — Integer — Foreign key → mto_products.seq — NOT NULL
  • quantity (수량) — Integer
  • amount (금액) — Integer

oem_items (OEM항목)

  • seq (주문항목id) — Integer — Primary key — NOT NULL
  • purchase_order_seq (주문id) — Integer — Foreign key → purchase_orders.seq — NOT NULL
  • mts_product_seq (MTS상품id) — Integer — Foreign key → mts_products.seq — NOT NULL
  • quantity (수량) — Integer
  • amount (금액) — Integer

payments (결제)

  • seq (결제id) — Integer — Primary key — NOT NULL
  • purchase_order_seq (주문id) — Integer — Foreign key → purchase_orders.seq — NOT NULL
  • pay_method (결제방법) — String(10)
  • delivery_cost (배송비) — Integer
  • purchase_amount (구매금액) — Integer
  • payment_amount (결제금액) — Integer
  • reward_point (적립금) — Integer

product_attachments (상품첨부파일)

  • seq (상품첨부파일id) — Integer — Primary key — NOT NULL
  • product_id (상품id) — String(10) — Foreign key → products.id — NOT NULL
  • file_name (파일이름) — String(256)
  • url_address (url주소) — String(256)
  • description (상세설명) — String(256)

product_inquiries (상품문의)

  • seq (상품문의id) — Integer — Primary key — NOT NULL
  • customer_id (고객id) — String(10) — Foreign key → customers.id — NOT NULL
  • product_id (상품id) — String(10) — Foreign key → products.id — NOT NULL
  • created_at (등록일시) — String(20)
  • updated_at (수정일시) — String(20)
  • title (제목) — String(100)
  • content (내용) — String(256)
  • is_answered (답변여부) — String(1)
  • answered_at (답변일시) — String(20)
  • answer (답변) — String(256)
  • is_secret (비밀글여부) — String(1)

product_inquiry_attachments (상품문의첨부파일)

  • seq (상품문의첨부파일id) — Integer — Primary key — NOT NULL
  • product_inquiry_seq (상품문의id) — Integer — Foreign key → product_inquiries.seq — NOT NULL
  • file_name (파일이름) — String(256)
  • url_address (url주소) — String(256)
  • description (상세설명) — String(256)

products (상품)

  • id (상품id) — String(10) — Primary key — NOT NULL
  • category_seq (상품분류id) — Integer — Foreign key → categories.seq — NOT NULL
  • is_displayed (진열여부) — String(1)
  • is_selling (판매여부) — String(1)
  • created_at (상품등록일) — String(20)
  • updated_at (최종수정일) — String(20)
  • serial_number (상품코드) — String(30)
  • name (상품명) — String(50)
  • detailed_name (상세상품명) — String(50)
  • additional_name (추가상품명) — String(50)
  • explanation (상품설명) — String(256)
  • explanation_for_employee (상품설명_관리자용) — String(256)
  • view_count (조회수) — Integer

profiles (프로필)

  • seq (고객프로필id) — Integer — Primary key — NOT NULL
  • customer_id (고객id) — String(10) — Foreign key → customers.id — NOT NULL
  • name (이름) — String(10)
  • email (이메일) — String(30)
  • cell_phone (휴대전화번호) — String(20)
  • phone (일반전화번호) — String(20)
  • deposit (예치금) — Integer
  • accumulated_point (누적포인트) — int
  • point_balance (포인트잔액) — int
  • postal_code (우편번호) — String(10)
  • address (주소) — String(50)
  • address_detail (상세주소) — String(50)

purchase_orders (구매주문)

  • seq (주문id) — Integer — Primary key — NOT NULL
  • customer_id (고객id) — String(10) — Foreign key → customers.id — NOT NULL
  • transaction_number (주문번호) — String(20)
  • created_at (주문일시) — String(20)
  • eight_status (주문상태) — String(30)

qna_attachments (1:1문의첨부파일)

  • seq (1:1문의첨부파일id) — Integer — Primary key — NOT NULL
  • qna_seq (1:1문의id) — Integer — Foreign key → qnas.seq — NOT NULL
  • file_name (파일이름) — String(256)
  • url_address (url주소) — String(256)
  • description (상세설명) — String(256)

qnas (1:1문의)

  • seq (1:1문의id) — Integer — Primary key — NOT NULL
  • employee_id (직원id) — String(10) — Foreign key → employees.id — NOT NULL
  • purchase_order_seq (주문id) — Integer — Foreign key → purchase_orders.seq — NOT NULL
  • is_posted (게시여부) — String(1)
  • created_at (등록일시) — String(20)
  • updated_at (수정일시) — String(20)
  • nine_types (유형) — String(10)
  • title (제목) — String(100)
  • content (내용) — String(256)
  • is_allowed_notification_talk (문자/알림톡받기) — String(1)
  • is_answered (답변여부) — String(1)
  • answered_at (답변일시) — String(20)
  • answer (답변) — String(256)
  • is_received_reply (답변수신여부) — String(1)
  • view_count (조회수) — Integer

quick_quote_answer_attachments (간편견적문의답변첨부파일)

  • seq (간편견적문의답변첨부파일id) — Integer — Primary key — NOT NULL
  • quick_quote_seq (간편견적문의id) — Integer — Foreign key → quick_quotes.seq — NOT NULL
  • file_name (파일이름) — String(256)
  • url_address (url주소) — String(256)
  • description (상세설명) — String(256)

quick_quote_attachments (간편견적문의첨부파일)

  • seq (간편견적문의첨부파일id) — Integer — Primary key — NOT NULL
  • quick_quote_seq (간편견적문의id) — Integer — Foreign key → quick_quotes.seq — NOT NULL
  • file_name (파일이름) — String(256)
  • url_address (url주소) — String(256)
  • description (상세설명) — String(256)

quick_quotes (간편견적문의)

  • seq (간편견적문의id) — Integer — Primary key — NOT NULL
  • employee_id (직원id) — String(10) — Foreign key → employees.id — NOT NULL
  • title (제목) — String(100)
  • is_secret (비밀글여부) — String(1)
  • is_answered (답변여부) — String(1)
  • created_at (등록일시) — String(20)
  • name (업체명/담당자명) — String(20)
  • phone (연락처) — String(20)
  • is_allowed_notification_talk (답변수신문자/알림톡받기) — String(1)
  • email (이메일) — String(30)
  • material (봉투재질) — String(10)
  • width (봉투사이즈(가로)) — Integer
  • height (봉투사이즈(세로)) — Integer
  • print_spec (인쇄사양) — Integer
  • quantity (수량) — Integer
  • usage (용도) — String(256)
  • password (비밀번호) — String(100)
  • other_inquiry (기타문의사항) — String(256)
  • consent (이용약관동의) — String(1)
  • answer (답변내용) — String(256)
  • answered_at (답변일시) — String(20)
  • send_reply (답변전송) — String(10)
  • is_received_reply (답변수신여부) — String(1)

receipt_application_attachments (영수증신청첨부파일)

  • seq (영수증신청첨부파일id) — Integer — Primary key — NOT NULL
  • receipt_application_seq (영수증신청id) — Integer — Foreign key → receipt_applications.seq — NOT NULL
  • file_name (파일이름) — String(256)
  • url_address (url주소) — String(256)
  • description (상세설명) — String(256)

receipt_applications (영수증 신청 게시판)

  • seq (영수증신청id) — Integer — Primary key — NOT NULL
  • employee_id (직원id) — String(10) — Foreign key → employees.id — NOT NULL
  • purchase_order_id (주문id) — Integer — Foreign key → purchase_orders.seq — NOT NULL
  • cash_receipt_seq (현금영수증id) — Integer — Foreign key → cash_receipts.seq — NOT NULL
  • tax_invoice_seq (세금계산서id) — Integer — Foreign key → tax_invoices.seq — NOT NULL
  • card_receipt_seq (카드영수증id) — Integer — Foreign key → card_receipts.seq — NOT NULL
  • simple_receipt_seq (간이영수증id) — Integer — Foreign key → simple_receipts.seq — NOT NULL
  • created_at (등록일시) — String(20)
  • updated_at (수정일시) — String(20)
  • four_types (유형) — String(5)
  • title (제목) — String(100)
  • request_details (요청내용) — String(256)
  • is_allowed_notification_talk (문자/알림톡받기) — String(1)
  • is_answered (답변여부) — String(1)
  • answered_at (답변일시) — String(20)
  • is_received_reply (답변수신여부) — String(1)
  • answer (응답내용) — String(256)
  • is_secret_message (비밀글여부) — String(1)

review_attachments (상품후기첨부파일)

  • seq (상품후기첨부파일id) — Integer — Primary key — NOT NULL
  • review_seq (상품후기id) — Integer — Foreign key → reviews.seq — NOT NULL
  • seq (상품분류id) — Integer — Foreign key → reviews.seq — NOT NULL
  • file_name (파일이름) — String(256)
  • url_address (url주소) — String(256)
  • description (상세설명) — String(256)

reviews (상품후기)

  • seq (상품후기id) — Integer — Primary key — NOT NULL
  • customer_id (고객id) — String(10) — Foreign key → customers.id — NOT NULL
  • product_id (상품id) — String(10) — Foreign key → products.id — NOT NULL
  • seq (상품분류id) — Integer — Foreign key → products.category_seq — NOT NULL
  • created_at (등록일시) — String(20)
  • updated_at (수정일시) — String(20)
  • star_rating (별점) — Integer
  • content (내용) — String(256)

simple_receipts (간이영수증)

  • seq (간이영수증id) — Integer — Primary key — NOT NULL

tax_invoices (세금계산서)

  • seq (세금계산서id) — Integer — Primary key — NOT NULL
  • company_name (회사명) — String(20)
  • ceo (대표자명) — String(10)
  • business_number (사업자등록번호) — String(20)
  • business_type (업태) — String(20)
  • business_item (업종) — String(20)
  • postal_code (우편번호) — String(10)
  • address (주소) — String(50)
  • address_detail (상세주소) — String(50)
  • email (이메일) — String(30)