hastings-v0522
Tables (46)
additional_options (추가항목)
- id (추가항목id) — Primary key — NOT NULL
- id (분류id) — Foreign key → categories.id — NOT NULL
agreements (개인정보동의내역)
- id (개인정보동의내역id) — Primary key — NOT NULL
- id (고객id) — Foreign key → customers.id — NOT NULL
attribute_sets (상품정보제공고시)
- id (상품정보제공고시id) — Primary key — NOT NULL
card_receipts (카드영수증)
- id (카드영수증id) — Primary key — NOT NULL
- id (주문id) — Foreign key → purchase_orders.id — NOT NULL
carts (장바구니)
- id (장바구니id) — Primary key — NOT NULL
- id (고객id) — Foreign key → customers.id — NOT NULL
- id (기성상품id) — Foreign key → mts_products.id — NOT NULL
- id (주문제작상품id) — Foreign key → mto_products.id — NOT NULL
cash_receipts (현금영수증)
- id (현금영수증id) — Primary key — NOT NULL
- id (주문id) — Foreign key → purchase_orders.id — NOT NULL
categories (분류)
- id (분류id) — Primary key — NOT NULL
- super_id (상위분류id) — Foreign key → categories.id — NOT NULL
companies (기업정보)
- id (기업정보id) — Primary key — NOT NULL
- id (고객id) — Foreign key → customers.id — NOT NULL
counsels (상담)
- id (상담id) — Primary key — NOT NULL
- id (직원id) — Foreign key → employees.id — NOT NULL
- id (고객id) — Foreign key → customers.id — NOT NULL
custom_order_quote_answer_attachments (주문제작견적답변첨부파일)
- id (첨부파일id) — Primary key — NOT NULL
- id (주문제작견적문의id) — Foreign key → custom_order_quotes.id — NOT NULL
custom_order_quote_attachments (주문제작견적문의첨부파일)
- id (첨부파일id) — Primary key — NOT NULL
- id (주문제작견적문의id) — Foreign key → custom_order_quotes.id — NOT NULL
custom_order_quotes (주문제작견적문의)
- id (주문제작견적문의id) — Primary key — NOT NULL
- id (직원id) — Foreign key → employees.id — NOT NULL
- id (주문제작상품id) — Foreign key → mto_products.id — NOT NULL
customers (고객)
- id (고객id) — Primary key — NOT NULL
deliveries (배송)
- id (배송id) — Primary key — NOT NULL
- id (주문id) — Foreign key → purchase_orders.id — NOT NULL
delivery_addresses (배송지)
- id (배송지id) — Primary key — NOT NULL
- id (고객id) — Foreign key → customers.id — NOT NULL
detail_descriptions (상세설명)
- id (웹상세설명id) — Primary key — NOT NULL
- id (분류id) — Foreign key → categories.id — NOT NULL
detail_size_charts (상세사이즈차트)
- id (상세사이즈차트id) — Primary key — NOT NULL
- id (분류id) — Foreign key → categories.id — NOT NULL
employees (직원)
- id (직원id) — Primary key — NOT NULL
faq_attachments (자주묻는질문첨부파일)
- id (첨부파일id) — Primary key — NOT NULL
- id (자주묻는질문id) — Foreign key → faq_board.id — NOT NULL
faq_board (자주묻는질문)
- id (자주묻는질문id) — Primary key — NOT NULL
- id (직원id) — Foreign key → employees.id — NOT NULL
- id (문의유형id) — Foreign key → inquery_types.id — NOT NULL
inquery_types (문의유형)
- id (문의유형id) — Primary key — NOT NULL
memberships (회원관리)
- id (회원관리id) — Primary key — NOT NULL
- id (고객id) — Foreign key → customers.id — NOT NULL
mto_products (주문제작상품)
- id (주문제작상품id) — Primary key — NOT NULL
- id (상품id) — Foreign key → products.id — NOT NULL
mts_products (기성상품)
- id (기성상품id) — Primary key — NOT NULL
- id (상품id) — Foreign key → products.id — NOT NULL
notice_attachments (공지사항첨부파일)
- id (첨부파일id) — Primary key — NOT NULL
- id (공지사항id) — Foreign key → notice_board.id — NOT NULL
notice_board (공지사항)
- id (공지사항id) — Primary key — NOT NULL
- id (직원id) — Foreign key → employees.id — NOT NULL
order_items (주문항목)
- id (주문항목id) — Primary key — NOT NULL
- id (주문id) — Foreign key → purchase_orders.id — NOT NULL
- id (기성상품id) — Foreign key → mts_products.id — NOT NULL
- id (주문제작상품id) — Foreign key → mto_products.id — NOT NULL
payments (결제)
- id (결제id) — Primary key — NOT NULL
- id (주문id) — Foreign key → purchase_orders.id — NOT NULL
product_attachments (상품첨부파일)
- id (첨부파일id) — Primary key — NOT NULL
- id (상품id) — Foreign key → products.id — NOT NULL
product_inquiries (상품문의)
- id (상품문의id) — Primary key — NOT NULL
- id (상품id) — Foreign key → products.id — NOT NULL
- id (고객id) — Foreign key → customers.id — NOT NULL
- id (직원id) — Foreign key → employees.id — NOT NULL
product_inquiry_attachments (상품문의첨부파일)
- id (첨부파일id) — Primary key — NOT NULL
- id (상품문의id) — Foreign key → product_inquiries.id — NOT NULL
products (상품)
- id (상품id) — Primary key — NOT NULL
- id (대분류id) — Foreign key → categories.id — NOT NULL
- id (중분류id)
- id (소분류id)
- id (상세분류id)
profiles (프로필)
- id (프로필id) — Primary key — NOT NULL
- id (고객id) — Foreign key → customers.id — NOT NULL
purchase_orders (주문)
- id (주문id) — Primary key — NOT NULL
- id (고객id) — Foreign key → customers.id — NOT NULL
qna_attachments (1:1문의첨부파일)
- id (첨부파일id) — Primary key — NOT NULL
- id (1:1문의id) — Foreign key → qnas.id — NOT NULL
qnas (1:1문의)
- id (1:1문의id) — Primary key — NOT NULL
- id (직원id) — Foreign key → employees.id — NOT NULL
- id (주문id) — Foreign key → purchase_orders.id — NOT NULL
receipt_application_attachments (영수증신청첨부파일)
- id (첨부파일id) — Primary key — NOT NULL
- id (영수증신청id) — Foreign key → receipt_applications.id — NOT NULL
receipt_applications (영수증 신청 게시판)
- id (영수증신청id) — Primary key — NOT NULL
- id (주문id) — Foreign key → purchase_orders.id — NOT NULL
- id (직원id) — Foreign key → employees.id — NOT NULL
review_attachments (상품후기첨부파일)
- id (첨부파일id) — Primary key — NOT NULL
- id (상품후기id) — Foreign key → reviews.id — NOT NULL
reviews (상품후기)
- id (상품후기id) — Primary key — NOT NULL
- id (상품id) — Foreign key → products.id — NOT NULL
- id (고객id) — Foreign key → customers.id — NOT NULL
simple_quote_answer_attachments (간편견적답변첨부파일)
- id (첨부파일id) — Primary key — NOT NULL
- id (간편견적문의id) — Foreign key → simple_quotes.id — NOT NULL
simple_quote_attachments (간편견적문의첨부파일)
- id (첨부파일id) — Primary key — NOT NULL
- id (간편견적문의id) — Foreign key → simple_quotes.id — NOT NULL
simple_quotes (간편견적문의)
- id (간편견적문의id) — Primary key — NOT NULL
- id (직원id) — Foreign key → employees.id — NOT NULL
simple_receipts (간이영수증)
- id (간이영수증id) — Primary key — NOT NULL
- id (주문id) — Foreign key → purchase_orders.id — NOT NULL
tax_invoices (세금계산서)
- id (세금계산서id) — Primary key — NOT NULL
- id (주문id) — Foreign key → purchase_orders.id — NOT NULL
top_images (상단이미지)
- id (상단이미지id) — Primary key — NOT NULL
- id (분류id) — Foreign key → categories.id — NOT NULL