gd
Tables (8)
ad_object (Untitled2)
- id (Key) — bigint(20) — Primary key — NOT NULL — 5
- name (Field) — varchar(50) — PC_서든어택_A그룹_소재1
- media_id (Field3) — varchar(50) — 23154135135
- sdate (Field4) — datetime — 2021-01-05 15:22:35
- edate (Field5) — datetime — 2021-01-05 15:22:35
- extra_op (Field6) — json
- features_id (Key2) — int(11) — Foreign key → features.id — NOT NULL — 38
ad_object_rel_user_group (Untitled)
- edate (Key2) — datetime — Primary key — NOT NULL — 2021-01-05 15:22:35
- ad_object_id (Key3) — bigint(20) — Foreign key → ad_object.id — NOT NULL — 5
- user_group_id (Key4) — bigint(20) — Foreign key → user_group.id — NOT NULL — 1468
- sdate (datetime) — datetime — 2021-01-03 05:22:35
creative_resource (Untitled3)
- id (Key) — bigint(20) — Primary key — NOT NULL
- type (enum) — enum('img','gif','video','flash')
- name (Key2) — varchar(50) — NOT NULL
- size (Field) — varchar(20)
- media_resource_id (Field2) — varchar(100)
- platform (Field3) — enum('facebook','google')
features
- id (Key) — int(11) — Primary key — NOT NULL — 38
- p_id (Field) — int(11) — 0
- media_id (Field2) — varchar(50) — 4236245
- platform (Field3) — enum('facebook','google') — google
- type — enum('campaign','campaign_group','ad','ad_group','ad_set','ad_creative') — campaign
- name (Field5) — varchar(200) — PC_서든어택_A그룹_소재1
- sdate (Field6) — datetime — 2021-01-05 15:22:35
- edate (Field7) — datetime — 2021-01-05 15:22:35
- status (Field8) — enum('ACTIVE','PAUSED','ARCHIVED','DELETED','ENABLED','REMOVED') — PAUSED
- daily_budget_v (Field9) — int(10)
- age_min_v (Field10) — int(10)
features_rel_creative_resource (Untitled6)
- features_id (Key3) — bigint(20) — Foreign key → features.id — NOT NULL — 38
- creative_resource_id (Key) — bigint(20) — Foreign key → creative_resource.id — NOT NULL
user (Untitled4)
- id (bigsint(20)) — bigsint(20) — Primary key — NOT NULL — 55555
- nexonsn (Field) — bigint(20) — 1234567
- source_serviceid (Field3) — bigint(20)
- source_npsn (Field4) — bigint(20)
- target_serviceid (Field5) — bigint(20)
- target_npsn (Field6) — bigint(20) — npsn
- extern_id_type (Field7) — enum( )
- madid (Field8) — varchar(100)
- email (Field9) — varchar(100)
- phone (Field10) — varchar(100)
- phonee164 (Field11) — varchar(100)
- gen (Field12) — varchar(100)
- doby (Field13) — varchar(100)
- dobm (Field14) — varchar(100)
- dobd (Field15) — varchar(100)
- ln (Field16) — varchar(100)
- fn (Field17) — varchar(100)
- country (Field18) — varchar(100)
- update (Field19) — varchar(100)
- payload (Field20) — varchar(30)
user_group (Untitled5)
- id (Key) — bigint(20) — Primary key — NOT NULL — 14668
- service_id (Field) — bigsint(20) — 430011393
- media_audience_id (Field2) — jdon — {"google" : "-1"}
- name (Field3) — varchar(50) — adsUserGroup14668
- sdate (Field4) — datetime
- edate (Field5) — datetime — 2021-01-27 15:22:35
- desc (Field6) — varchar(4000 — 복귀확률 15-25%
- extr_op (Field7) — json
- includeCds_v (Field8) — json
- excludeCds_v (Field9) — json
user_rel_user_group (CopyOfUntitled)
- sdate (datetime) — datetime — Primary key — 2021-01-21
- user_group_id (Key4) — bigint(20) — Foreign key → user_group.id — NOT NULL — 430011393
- user_id (bigsint(20)) — bigsint(20) — Foreign key → user.id — NOT NULL — 55555
- edate (Key2) — datetime — NOT NULL — 2021-01-27
- type (Field) — enum ('target','control') — target