광고관리
테이블 (5)
ad(광고 메인) (광고_메인)
- ad_id (Key) — int — 기본 키 — NOT NULL
- ap_type (Field) — varchar(10)
- show_type (Field2) — varchar(10)
- control_code (Field3) — varchar(10)
- ad_on (Field4) — varchar(1)
- status (Field5) — varchar(10)
- show_seq (Field6) — int
- start_at (Field7) — timestamp
- end_at (Field8) — timestamp
- memo (Field9) — text
- link_url (Field10) — varchar(500)
- open_link (Field11) — varchar(1)
- created_at (Field12) — timestamp
- created_by (Field13) — varchar(30)
- updated_at (Field14) — timestamp
- updated_by (Field15) — varchar(30)
- deleted_at (Field16) — timestamp
ad_detail(광고 콘텐츠) (Untitled)
- ad_detail_id (Key) — int — 기본 키 — NOT NULL
- ad_id (Key2) — int — 외래 키 → ad(광고 메인).ad_id — NOT NULL
- ad_type (Field2) — varchar(10)
- file_key (Field3) — varchar(100)
- file_name (Field4) — varchar(150)
- mime_type (Field5) — varchar(10)
- file_size (Field6) — long
- width (Field7) — int
- height (Field8) — int
- text_body (Field9) — text
ad_history(광고 이력 관리) (Untitled2)
- log_id (Key) — int — 기본 키 — NOT NULL
- ad_id (Key2) — int — 외래 키 → ad(광고 메인).ad_id — NOT NULL
- chg_type (Field2) — varchar(10)
- reason (Field3) — text
- diff_json (Field4) — text
- create_at (Field5) — timestamp
- create_by (Field6) — varchar(30)
ad_target(단지 타겟) (Untitled3)
- target_id (Key) — int — 기본 키 — NOT NULL
- ad_id (Key22) — int — 외래 키 → ad_target_binding(광고 타겟 연결).ad_id — NOT NULL
- binding_id (Key2) — int — 외래 키 → ad_target_binding(광고 타겟 연결).binding_id — NOT NULL
- app_type (Field) — varchar(10)
- blzn__id (Field2) — varchar(50)
- blan_type (Field3) — varchar(50)
- status (Field4) — varchar(10)
- is_over_3y (Field5) — varchar(1)
- memo (Field6) — text
- created_at (Field7) — timestamp
- created_by (Field8) — varchar(30)
- updated_at (Field9) — timestamp
- updated_by (Field10) — varchar(30)_
- deleted_at (Field11) — timestamp
ad_target_binding(광고 타겟 연결) (Untitled4)
- binding_id (Key) — int — 기본 키 — NOT NULL
- ad_id (Key2) — int — 외래 키 → ad(광고 메인).ad_id — NOT NULL
- target_type (Field2) — varchar(10)
- target_id (Field3) — int
- created_at (Field4) — timestamp
- crated_by (Field5) — varchar(30)