LotteHealthCare

Tables (14)

es_cd_credit (신용평가)

  • es_cd_credit_id (Key) — Primary key — NOT NULL
  • es_er_store_id (Key2) — Foreign key → es_er_store.es_er_store_id — NOT NULL

es_ct_contract (계약)

  • es_ct_contract_id (Key) — Primary key — NOT NULL
  • es_er_store_id (Key2) — Foreign key → es_er_store.es_er_store_id — NOT NULL

es_draft_d (결재D)

  • docu_no (Key) — Primary key — NOT NULL
  • company_cd (Key2) — Foreign key → es_draft_m.company_cd — NOT NULL
  • draft_no (Key3) — Foreign key → es_draft_m.draft_no — NOT NULL
  • es_er_store_id (Key4) — Foreign key → es_er_store.es_er_store_id — NOT NULL

es_draft_m (결재M)

  • company_cd (Key) — Primary key — NOT NULL
  • draft_no (Key2) — Primary key — NOT NULL

es_er_store (입점사마스터)

  • es_er_store_id (Key) — Primary key — NOT NULL
  • company_cd (Key2) — Foreign key → es_partner.company_cd — NOT NULL
  • partner_cd (Key3) — Foreign key → es_partner.partner_cd — NOT NULL

es_lo_manager (입점사담당자)

  • es_lo_manager_id (Key) — Primary key — NOT NULL
  • es_lo_store_id (Key2) — Foreign key → es_lo_store.es_lo_store_id — NOT NULL

es_lo_store (입점사문의)

  • es_lo_store_id (Key) — Primary key — NOT NULL

es_partner (거래처)

  • company_cd (Key) — Primary key — NOT NULL
  • partner_cd (Key2) — Primary key — NOT NULL
  • es_lo_store_id (Key3) — Foreign key → es_lo_store.es_lo_store_id — NOT NULL

es_qa__item_quality_credit (상품품질평가)

  • es_qa_item_quality_credit_id (Key) — Primary key — NOT NULL
  • es_qa_item_id (Key2) — Foreign key → es_qa_item_info.es_qa_item_info_id — NOT NULL

es_qa_item_info (상품정보)

  • es_qa_item_info_id (Key) — Primary key — NOT NULL
  • es_er_store_id (Key2) — Foreign key → es_er_store.es_er_store_id — NOT NULL

es_user (사용자1)

  • company_cd (Key) — Primary key — NOT NULL
  • user_id (Key2) — Primary key — NOT NULL
  • user_nm (Field2)
  • password (Field3)
  • emp_no (Field4)
  • user_gb (Field5)
  • user_tp (Field6)
  • use_yn (Field7)
  • crypto_yn (Field8)
  • insert_id (Field9)
  • insert_dts (Field10)
  • update_id (Field11)
  • update_dts (Field12)
  • authorize_key (Field13)
  • pw_change_dt (Field14)

es_user (사용자)

  • company_cd (Key) — Primary key — NOT NULL
  • user_id (Key2) — Primary key — NOT NULL
  • es_lo_manager_id (field) — Foreign key → es_lo_manager.es_lo_manager_id — NOT NULL
  • es_lo_store_id (Field)

lt_lo_manager (입점사_담당자1)

  • mem_email_addr (Field6) — Primary key
  • biz_no (key1) — Foreign key → lt_lo_store.biz_no — NOT NULL
  • mem_nm (Field)
  • mem_mbrank (Field2)
  • mem_tel_no (Field3)
  • mem_mobile_no (Field4)
  • mem_fax_no (Field5)
  • user_id (Key2) — Foreign key → es_user.user_id — NOT NULL

lt_lo_store (입점사1)

  • biz_no (Key) — Primary key — NOT NULL
  • company_cd (Field)
  • company_nm (Field2)
  • bizarea_cd (Field3)
  • ceo_nm (Field4) — b
  • biz_tp (Field5)
  • bizarea_addr1 (Field6)
  • bizarea_addr2 (Field7)
  • bizarea_zipcode (Field8)
  • biztp_nm (Field9)
  • bizcond_nm (Field10)
  • company_intro (Field11)
  • maj_item_intro (Field12)
  • approve_yn (Field13)
  • insert_id (Field14)
  • insert_dts (Field15)
  • update_id (Field16)
  • update_dts (Field17)