부모자식
테이블 (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