hastings-v0522

Tables (42)

agreements (개인정보동의내역)

  • id (개인정보동의내역id) — Primary key — NOT NULL
  • id (고객id) — Foreign key → customers.id — NOT NULL

attribute_sets (상품정보제공고시)

  • id (상품정보제공고시id) — Primary key — NOT NULL
  • id (분류id) — Foreign key → categories.id — 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

category_attachments (분류첨부파일)

  • id (첨부파일id) — Primary key — NOT NULL
  • 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

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

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

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

  • id (첨부파일id) — Primary key — NOT NULL
  • id (간편견적문의id) — Foreign key → quick_quotes.id — NOT NULL

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

  • id (첨부파일id) — Primary key — NOT NULL
  • id (간편견적문의id) — Foreign key → quick_quotes.id — NOT NULL

quick_quotes (간편견적문의)

  • id (간편견적문의id) — Primary key — NOT NULL
  • id (직원id) — Foreign key → employees.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_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