数据信息。

[cheenwe]

• 数据库数据记录

用户 users: 48067
相册 albums: 181171
照片 photos: 5776093 

• 数据用途

人脸识别、服饰分类、物体识别等.....

• 照片示例

• 更多数据需求

mail: cxhyun@126.com

[cheenwe]

CREATE TABLE albums (
id bigint(20) DEFAULT NULL,
user_id bigint(20) DEFAULT NULL,
name varchar(255) DEFAULT NULL,
created_at date DEFAULT NULL,
remark text,
kind int(11) DEFAULT NULL,
total float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE photos (
id bigint(20) DEFAULT NULL,
album_id bigint(20) DEFAULT NULL,
name varchar(255) DEFAULT NULL,
url varchar(255) DEFAULT NULL,
kind int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE users (
id bigint(20) DEFAULT NULL,
name varchar(255) DEFAULT NULL,
remark text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO users (id, name, remark)
VALUES
(687471686, '田媛媛', ''),
(405095521, 'v悦悦', ''),
(631300490, '崔辰辰', ''),
(414457129, '大猫儿', ''),
(141234233, '金甜甜', ''),
(96614110, '紫轩', ''),
(37448401, '谢婷婷', ''),
(74386764, '夏晨洁', ''),
(523216808, 'Cherry', ''),
(46599595, '雪倩nika', ''),
(45834230, '李喵喵', ''),
(91442126, '悦小舞', ''),
(272536951, '夏欢欢', ''),
(63153008, '赵颖', ''),
(319426092, '姬嘉琳', ''),
(646858747, '邝萃莉', ''),
(276439081, '吴若梵', ''),
(717492986, '熊仔欣', ''),
(76438272, '阿朵拉', ''),
(516376911, '安戴妃', ''),
(539549300, '滕雨佳', ''),
(440678454, '张娟娟', ''),
(73283141, '沁源', ''),
(555178574, '晓莉莉', ''),
(290551947, '关晰文', ''),
(689744369, '美高小咪', ''),
(745790526, '杨羽凡', ''),
(102188467, '未未', ''),
(10378945, '李柒柒', ''),
(93166849, '倪佩婕', '');

INSERT INTO `photos` (`id`, `album_id`, `name`, `url`, `kind`)

VALUES
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i2/687471686/TB1cK23LVXXXXXjXVXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i1/687471686/TB1chXCMXXXXXaHXpXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i1/687471686/TB1NmL0LVXXXXbQXVXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i2/687471686/TB1ueQeLVXXXXcOXXXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i2/687471686/TB1wmEjLVXXXXXAXXXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i1/687471686/TB15hkaLVXXXXa_XpXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i2/687471686/TB15e8hMXXXXXc5aXXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i4/687471686/TB1gI8BMXXXXXbtXpXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i1/687471686/TB1nkkbLVXXXXXwXpXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i4/687471686/TB1NgvULVXXXXbOaXXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i1/687471686/TB1aIeELFXXXXcrapXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i2/687471686/TB1rrJdMXXXXXaSapXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i1/687471686/TB1butuMXXXXXXeXVXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i1/687471686/TB1fdb7LVXXXXbqXFXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i1/687471686/TB1LCNtMXXXXXXYXVXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i4/687471686/TB1uqYWLVXXXXataXXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i4/687471686/TB1GEU5LFXXXXX4XVXXXXXXXXXX_!!2-tstar.png_620x10000.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i2/687471686/TB13vdhLVXXXXXLXpXXXXXXXXXX_!!2-tstar.png_620x10000.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i4/687471686/TB10zFXLVXXXXcDXpXXXXXXXXXX_!!2-tstar.png_620x10000.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i2/687471686/TB1wmEjLVXXXXXAXXXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i4/687471686/TB1fPU0LFXXXXXiaXXXXXXXXXXX_!!2-tstar.png_620x10000.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i4/687471686/TB1kIxmLVXXXXa8XXXXXXXXXXXX_!!2-tstar.png_620x10000.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i1/687471686/TB1CZs5LFXXXXX_XVXXXXXXXXXX_!!2-tstar.png_620x10000.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i2/687471686/TB1oK7VLFXXXXbOaXXXXXXXXXXX_!!2-tstar.png_620x10000.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i1/687471686/TB1azcbLVXXXXadXpXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i2/687471686/TB1J8v6LVXXXXbJXFXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i2/687471686/TB12z32LFXXXXcrXVXXXXXXXXXX_!!2-tstar.png_620x10000.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i2/687471686/TB1u.pgLVXXXXXNXpXXXXXXXXXX_!!2-tstar.png_620x10000.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i4/687471686/TB1QrthLVXXXXXPXpXXXXXXXXXX_!!2-tstar.png_620x10000.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i3/687471686/TB1MY35LFXXXXaLXVXXXXXXXXXX_!!2-tstar.png_620x10000.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i1/687471686/TB1W8IVLFXXXXaSaXXXXXXXXXXX_!!2-tstar.png_620x10000.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i3/687471686/TB1IKo8LFXXXXcfXFXXXXXXXXXX_!!2-tstar.png_620x10000.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i3/687471686/TB1iDZ8LFXXXXbUXFXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i3/687471686/TB1WkEFLFXXXXc5aXXXXXXXXXXX_!!2-tstar.png_620x10000.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i4/687471686/TB1K5A_LFXXXXbJXXXXXXXXXXXX_!!0-tstar.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i1/687471686/TB1pws1LFXXXXXwXFXXXXXXXXXX_!!2-tstar.png_620x10000.jpg', 1),
(NULL, 10000702574, '', 'http://img.alicdn.com/imgextra/i2/687471686/TB1u.pgLVXXXXXNXpXXXXXXXXXX_!!2-tstar.png_620x10000.jpg', 1);

INSERT INTO albums (id, user_id, name, created_at, remark, kind, total)
VALUES
(10000702574, 687471686, '2016年春夏韩国', '2016-02-28', '', 1, 45),
(301381083, 687471686, '女裤', '2013-08-08', '', 1, 91),
(10000196901, 687471686, '春夏新装', '2014-10-05', '', 1, 118),
(301563127, 687471686, '春夏装', '2013-10-23', '', 1, 15),
(10000587450, 687471686, '秋冬款针织衫毛衣', '2015-10-05', '', 1, 110),
(10000692814, 687471686, '淘女郎田媛媛每日穿', '2015-12-27', '', 1, 6),
(183809402, 687471686, '要秀你就秀', '2012-02-09', '', 1, 679),
(10000683469, 687471686, '春季针织衫', '2015-12-13', '', 1, 57),
(301794069, 687471686, '韩版裙子1', '2014-02-23', '', 1, 113),
(183796927, 687471686, '头像相册', '2012-02-09', '', 1, 93),
(10000688515, 687471686, '春装卫衣', '2015-12-18', '', 1, 17),
(10000064305, 687471686, '春夏女装', '2014-05-24', '', 1, 17),
(10000690069, 687471686, '休闲裤', '2015-11-20', '', 1, 7),
(10000681013, 687471686, '秋冬新品', '2015-11-17', '', 1, 12),
(10000677278, 687471686, '毛呢大衣', '2015-11-14', '', 1, 17),
(10000688473, 687471686, '搭配专辑', '2015-12-15', '', 1, 1),
(10000488035, 687471686, '秋冬连衣裙', '2015-09-02', '', 1, 21),
(10000063498, 687471686, '成熟女装', '2014-05-25', '', 1, 72),
(301610018, 687471686, '爱秀相册', '2013-11-14', '', 1, 33),
(10000085495, 687471686, '瑜珈服', '2014-06-23', '', 1, 10),
(301212422, 687471686, '真人秀相册', '2013-05-04', '', 1, 3),
(10000054026, 687471686, '可爱韩版风格', '2014-05-18', '', 1, 51),
(10000444735, 687471686, '秋冬T恤', '2015-08-29', '', 1, 27),
(202798419, 687471686, '秋冬女装', '2012-02-09', '', 1, 41),
(225815161, 687471686, '包包控', '2012-02-09', '', 1, 46),
(301377135, 687471686, '休闲运动套装卫衣', '2013-08-07', '', 1, 76),
(301387002, 687471686, '秋冬装', '2013-08-12', '', 1, 76),
(300972482, 687471686, '秋冬装系列', '2012-12-16', '', 1, 47),
(10000049623, 687471686, '夏季T恤', '2014-05-14', '', 1, 20),
(10000486045, 687471686, '羽绒服', '2015-09-03', '', 1, 20),
(10000187008, 687471686, '羽绒裤', '2014-09-09', '', 1, 10),
(301139903, 687471686, '2014爆款女鞋', '2013-03-24', '', 1, 133),
(183796928, 687471686, '贴图相册', '2012-02-09', '', 1, 25),
(197765265, 687471686, '靓车丽影', '2012-02-09', '', 1, 12),
(301147529, 687471686, '韩版2', '2013-03-28', '', 1, 52),
(301616104, 687471686, '爆款专辑', '2013-11-23', '', 1, 12),
(301347639, 687471686, '咖啡厅职业装', '2013-07-14', '', 1, 19),
(197772274, 687471686, '我和明星的合影', '2012-02-09', '', 1, 20);