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)