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)