skmagic cs

Tables (26)

cnts_map_mgt (컨텐츠 연동 테이블)

  • cnts_map_id (Key) — Primary key — NOT NULL
  • cnts_mgt_id (컨텐츠관리 id) — Foreign key → svc_cnts_mgt.cnts_mgt_id — NOT NULL
  • faq_id (faq id) — Foreign key → svc_faq.faq_id — NOT NULL
  • prd_id (상품 id) — Foreign key → svc_prd.prd_id — NOT NULL

menu_grp_mapping (메뉴 형성을 위한 맵핑)

  • menu_grp_mapping_id (Key) — Primary key — NOT NULL
  • menu_id (Key2) — Foreign key → svc_menu.menu_id — NOT NULL
  • group_id (Key3) — Foreign key → svc_grp.grp_id — NOT NULL

svc_as_mgt (AS 예약 관리)

  • as_id (주문예약 ID) — Primary key — NOT NULL

svc_as_prd (AS 예약 상품)

  • as_prd_id (Key) — Primary key — NOT NULL
  • as_id (주문예약 ID) — Foreign key → svc_as_mgt.as_id — NOT NULL

svc_atch (첨부파일)

  • atch_no (첨부파일 id) — Primary key — NOT NULL

svc_cd_dtl (코드관리 상세)

  • cd_dtl_id (코드상세 id) — Primary key — NOT NULL
  • cd_mst_id (코드ID) — Foreign key → svc_cd_mst.cd_mst_id — NOT NULL

svc_cd_mst (코드 관리)

  • cd_mst_id (코드ID) — Primary key — NOT NULL

svc_cnts_mgt (컨텐츠관리)

  • cnts_mgt_id (컨텐츠관리 id) — Primary key — NOT NULL
  • atch_no (첨부파일 id) — Foreign key → svc_atch.atch_no — NOT NULL
  • cnts_typ (컨텐츠유형)

svc_cusl_mgt (온라인상담)

  • cusl_id (상담예약 id) — Primary key — NOT NULL
  • atch_id (첨부파일 id) — Foreign key → svc_atch.atch_no — NOT NULL

svc_faq (FAQ)

  • faq_id (faq id) — Primary key — NOT NULL
  • faq_title (faq 제목)
  • faq_cnts (faq 내용)
  • faq_typ (faq 유형(질문,동영상))
  • prd_div_cd (제품군 코드)
  • video_yn (동영상 유무)
  • use_yn (사용유무)
  • cs_ctg_cd (Field)

svc_faq_map (맵핑테이블)

  • svc_faq_map (faq 맵핑 id) — Primary key
  • faq_id (faq id) — Foreign key → svc_faq.faq_id — NOT NULL
  • prd_id (상품 id) — Foreign key → svc_prd.prd_id — NOT NULL
  • prd_div_cd (제품군 코드) — Foreign key → svc_prd.prd_div_cd — NOT NULL
  • self_chk_id (자가진단 id) — Foreign key → svc_self_chk.self_chk_id — NOT NULL

svc_grp (권한그룹 , 단일이면 코드관리?)

  • grp_id (그룹 id) — Primary key — NOT NULL

svc_menu (메뉴 관리)

  • menu_id (메뉴 id) — Primary key — NOT NULL

svc_ord (주문 정보)

  • ord_id (주문 id) — Primary key — NOT NULL

svc_ord_cart (장바구니)

  • ord_crt_id (Key) — Primary key — NOT NULL

svc_ord_pay (주문 결제 정보)

  • ord_pay_id (주문 결제 id) — Primary key — NOT NULL
  • ord_id (주문 id) — Foreign key → svc_ord.ord_id — NOT NULL

svc_ord_prd (주문 상품 정보)

  • ord_prd_id (주문 상품 id) — Primary key — NOT NULL
  • ord_id (주문 id) — Foreign key → svc_ord.ord_id — NOT NULL
  • parts_id (부품id) — Foreign key → svc_prd_parts.parts_id — NOT NULL
  • prd_id (상품 id) — Foreign key → svc_prd.prd_id — NOT NULL
  • prd_div_cd (제품군 코드) — Foreign key → svc_prd.prd_div_cd — NOT NULL

svc_parts_set (Untitled)

  • set_id (Key) — Primary key — NOT NULL
  • parts_id (부품id) — Foreign key → svc_prd_parts.parts_id — NOT NULL
  • ret_parts_id (Field)

svc_prd (제품)

  • prd_id (상품 id) — Primary key — NOT NULL
  • prd_div_cd (제품군 코드) — Foreign key → svc_prd_div.prd_div_cd — NOT NULL
  • atch_no (첨부파일 id) — Foreign key → svc_atch.atch_no — NOT NULL
  • prd_nm (상품명)

svc_prd_ask (상품 문의)

  • prd_asc_id (Key) — Primary key — NOT NULL
  • prd_id (상품 id) — Foreign key → svc_prd.prd_id — NOT NULL
  • prd_div_cd (제품군 코드) — Foreign key → svc_prd.prd_div_cd — NOT NULL
  • atch_no (첨부파일 id) — Foreign key → svc_prd.atch_no — NOT NULL

svc_prd_div (제품군)

  • prd_div_cd (제품군 코드) — Primary key — NOT NULL
  • prd_div_nm (제품군명)

svc_prd_map (제품 부품 맵핑)

  • Key (제품맵핑id) — Primary key — NOT NULL
  • prd_id (상품 id) — Foreign key → svc_prd.prd_id — NOT NULL
  • parts_id (부품id) — Foreign key → svc_prd_parts.parts_id — NOT NULL

svc_prd_parts (부품)

  • parts_id (부품id) — Primary key — NOT NULL

svc_self_chk (자가진단)

  • self_chk_id (자가진단 id) — Primary key — NOT NULL
  • prd_id (상품 id) — Foreign key → svc_prd_div.prd_div_cd — NOT NULL
  • prd_div_cd (제품군 코드) — Foreign key → svc_prd.prd_div_cd — NOT NULL
  • atch_id (첨부파일 id) — Foreign key → svc_prd.atch_no — NOT NULL
  • main_ctg (대분류)
  • sub_ctg (중분류)
  • sts_ctg (증상)
  • use_yn (사용유무)

svc_user (회원관리)

  • user_id (회원 id) — Primary key — NOT NULL
  • grp_id (그룹id) — Foreign key → svc_grp.grp_id — NOT NULL

svc_voc_mgt (고객의소리)

  • svc_voc_id (고객의소리 id) — Primary key — NOT NULL
  • atch_no (첨부파일 id) — Foreign key → svc_atch.atch_no — NOT NULL