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