06-09-2022, 01:01 PM
|
|
|
Confirmed User
Industry Role:
Join Date: Oct 2018
Location: New Orleans, Louisiana. / Newcastle, England.
Posts: 1,123
|
Quote:
CREATE TABLE `Stats` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`start` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`end` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`publisher` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`titleid` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
`isbn` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
`title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`author` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`distributor` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`vendor` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`country` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`unitssold` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`unitsreturned` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`unitsnet` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`model` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`retailer` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`listprice` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`currency` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
`offerprice` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`percentage` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`channelfee` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`channelrevenue` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`channelextended` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`channelshare` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`distributorshare` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`publisherestimate` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`publisherpayout` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`verified` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`status` enum('Active','Inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Active',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
The two bolded lines above.
In essence, sales vs. chargebacks.
__________________
NOTHING TO SEE HERE
|
|
|