부모자식

테이블 (5)

MEDIA_PAR_INFO (Untitled3)

  • PAR_SEQ (Key) — 기본 키 — NOT NULL
  • ADVRTS_PRDT_CODE (Field)
  • ADC_CTGR_SEQ (Field2)
  • SCRIPT_TP_CODE (Field3)
  • MEDIA_SIZE_CODE (Field4)
  • AD_SEND_YN (Field5)
  • PAR_EVLT_TP_CODE (Field6)
  • ADUT_USE_YN (Field7)
  • RETURN_SEQ (Field8)
  • PAR_DTL_DESC (Field9)
  • PAR_RETURN_DTL_CNTS (Field10)
  • RESPONSIVE_WEB_YN (Field11)
  • SCRIPT_IMG_URL (Field12)
  • Field13
  • Field14

PAR_PRDT_MGMT (부모,자식 지면 저장 테이블)

  • ADVRTS_CODE (Field) — 기본 키
  • IMAGE_CODE (Field2)
  • ADVRTS_PRDT_CODE (Field3)
  • PLTFOM_TP_CODE (Field4)
  • SCRIPT_TP_CODE (Field5)
  • MEDIA_SIZE_CODE (Field6)
  • ADVRTS_RST_CODE (Field7)
  • LINK_TP_CODE (Field8)
  • PAR_AUTH_TP_CODE (Field9)
  • MEDIA_ITL_TP_CODE (Field10)
  • ADVRTS_DESC (Field11)
  • PAR_SCRT_VAL (Field12)
  • REG_USER_ID (Field13)
  • REG_DTTM (Field14)
  • ALT_USER_ID (Field15)
  • Field16
  • PAR_PRDT_SEQ (Key) — NOT NULL
  • Field17
  • Field18

admember (Untitled4)

  • userid (Field2) — 기본 키
  • seq (Field)
  • email (Field3)
  • corpname (Field4)
  • uname (Field5)
  • upasswd (Field6)
  • grade (Field7)
  • hp (Field8)
  • tel (Field9)
  • bankname (Field10)
  • homepi (Field11)
  • Field12
  • Field13
  • Field14

media_script (Untitled)

  • ad_type (Field5) — 기본 키
  • no (Key2) — 외래 키 → media_site.no — NOT NULL
  • userid (key) — 외래 키 → media_site.userid
  • mediasite_no (Field)
  • userid (Field2)
  • sdate (Field3)
  • regdate (Field4)
  • state (Field6)
  • h_type (Field7)
  • h_banner (Field8)
  • accept_sr (Field9)
  • accept_pr (Field10)
  • price_type (Field11)
  • product_type (Field12)
  • w_type (Field13)
  • s_type (Field14)
  • ms_icover_useyn (Field15)
  • MEDIA_ITL_TP_CODE (Field16)
  • ADVRTS_STLE_TP_CODE (Field17)
  • CHRG_FOM_TP_CODE (Field18)
  • CHRG_SECT_TP_CODE (Field19)
  • PAR_KND_TP_CODE (Field20)
  • PAR_SORT_TP_CODE (Field21)
  • CR_INTRCP_YN (Field22)
  • Field23
  • Field24

media_site (Untitled2)

  • no (Key) — 기본 키 — NOT NULL
  • userid (key) — 기본 키
  • sdate (Field2)
  • regdate (Field3)
  • sitecate (Field4)
  • sitename (Field5)
  • siteurl (Field6)
  • sitedesc (Field7)
  • sitetype (Field8)
  • state (Field9)
  • scate (Field10)
  • cpi_sitetype (Field11)
  • Field12
  • Field13