sk_ads_trackings.md

sk_ads_trackings

Description

Table Definition

CREATE TABLE `sk_ads_trackings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ads_provider` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `campaign_id` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content_id` int(11) DEFAULT NULL,
  `contact_id` int(11) unsigned NOT NULL,
  `accessed_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=[Redacted by tbls] DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Columns

Name	Type	Default	Nullable	Extra Definition	Children	Parents	Comment
id	int(11)		false	auto_increment
ads_provider	varchar(20)		false
campaign_id	varchar(100)		true
content_id	int(11)		true
contact_id	int(11) unsigned		false
accessed_time	timestamp	CURRENT_TIMESTAMP	true

Constraints

Name	Type	Definition
PRIMARY	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
PRIMARY	PRIMARY KEY (id) USING BTREE

Relations

---

Generated by tbls