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