亚马逊电商数据自动化管理接口平台开发SQL设计

已于 2022-03-04 21:20:17 修改
阅读量587 收藏 1
点赞数
分类专栏： 亚马逊 完整项目 数据库 文章标签： sql mysql
于 2022-03-04 19:03:29 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_44155966/article/details/123283057
版权

亚马逊电商数据自动化管理接口平台开发SQL设计

重要说明

  • 本文章为亚马逊系列其中的一篇，具体详见 主页 中亚马逊分类
  • 该系列项目均为【CSDN轻夏】原创，未经允许禁止转载
  • 如有疑问请添加qq群聊302493982学习咨询

文章目录

1、店铺权限

authorized_shops.sql

# SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS `authorized_shops`;
CREATE TABLE `authorized_shops`
(
    `inner_id`        int NOT NULL PRIMARY KEY AUTO_INCREMENT,
    `organization_id` int NULL     DEFAULT NULL,
    `shop_id`         int NULL     DEFAULT NULL,
    `shop_rename`     varchar(255) DEFAULT NULL,
    `amazon_name`     varchar(255) DEFAULT NULL,
    `authorized_time` date         DEFAULT NULL,
    `account_area`    varchar(255) DEFAULT NULL,
    `account_second_area`    varchar(255) DEFAULT NULL,
    `merchant_id`     varchar(255) DEFAULT NULL,
    `authorized_id`   varchar(255) DEFAULT NULL,
    INDEX (`organization_id`) USING BTREE,
    CONSTRAINT `authorized_shops_fk`
        FOREIGN KEY (`organization_id`) REFERENCES `organization` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

# SET FOREIGN_KEY_CHECKS = 1;

2、订单信息

buy.sql

DROP TABLE IF EXISTS `buy`;
CREATE TABLE `buy`
(
    `inner_id`                              int NOT NULL PRIMARY KEY AUTO_INCREMENT,
    `order_id`                              int            DEFAULT -1,
    `upload_id`                             int            DEFAULT -1,
    `product_id`                            int            DEFAULT -1,
    `buy_number`                            DECIMAL(10, 2) DEFAULT NULL,
    `buy_time`                              date           DEFAULT NULL,
    `firm_name`                             varchar(255)   DEFAULT NULL,
    `photo`                                 varchar(255)   DEFAULT NULL,
    `amazon_id`                             varchar(255)   DEFAULT NULL,
    `buy_money`                             DECIMAL(10, 2) DEFAULT NULL,
    `amazon_profit`                         DECIMAL(10, 2) DEFAULT NULL,
    `get_money`                             DECIMAL(10, 2) DEFAULT NULL,
    `now_day_exchange_rate`                 DECIMAL(10, 2) DEFAULT NULL,
    `purchase_price`                        DECIMAL(10, 2) DEFAULT NULL,
    `national_transport_money`              DECIMAL(10, 2) DEFAULT NULL,
    `international_transport_money`         DECIMAL(10, 2) DEFAULT NULL,
    `international_transport_money_correct` DECIMAL(10, 2) DEFAULT NULL,
    `international_transport_money_freeze`  DECIMAL(10, 2) DEFAULT NULL,
    `platform_money`                        DECIMAL(10, 2) DEFAULT NULL,
    `packing_charge`                        DECIMAL(10, 2) DEFAULT NULL,
    `return_money`                          DECIMAL(10, 2) DEFAULT NULL,
    `profit`                                DECIMAL(10, 2) DEFAULT NULL,
    `buy_status`                            varchar(255)   DEFAULT NULL,
    `remark`                                varchar(255)   DEFAULT NULL,
    `status`                                tinyint(1)     DEFAULT 0
);

# SET FOREIGN_KEY_CHECKS = 1;

3、运输费用

cost_freight.sql

# SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS `cost_freight`;
CREATE TABLE `cost_freight`
(
    `inner_id`        int NOT NULL PRIMARY KEY AUTO_INCREMENT,
    `product_id`      int NULL       DEFAULT NULL,
    `buy_price`       DECIMAL(10, 2) DEFAULT NULL,
    `inland_price`    DECIMAL(10, 2) DEFAULT NULL,
    `outland_price`   DECIMAL(10, 2) DEFAULT NULL,
    `repertory_count` int            DEFAULT NULL,
    `package_size_l`  DECIMAL(10, 2) DEFAULT NULL,
    `package_size_w`  DECIMAL(10, 2) DEFAULT NULL,
    `package_size_h`  DECIMAL(10, 2) DEFAULT NULL,
    `package_weight`  DECIMAL(10, 2) DEFAULT NULL,
    `profit_rate`     DECIMAL(10, 2) DEFAULT NULL,
    `up_people`       int            DEFAULT NULL,
    `enable`          tinyint(1)     default 0,
    `time`            date,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `cost_freight_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

# SET FOREIGN_KEY_CHECKS = 1;

4、费用细则

drop table if exists china_cost_rate;

create table china_cost_rate
(
    `inner_id`        int            not null primary key AUTO_INCREMENT,
    `cost_freight_id` int,
    `freight_cost`    DECIMAL(10, 2) null,
    `selling_cost`    DECIMAL(10, 2) null,
    `foreign_cost`    DECIMAL(10, 2) null,
    `optimize`        DECIMAL(10, 2) null,
    `final_price`     DECIMAL(10, 2) null,
    `profit`          DECIMAL(10, 2) null,
    INDEX (`cost_freight_id`) USING BTREE,
    CONSTRAINT `china_cost_rate_fk`
        FOREIGN KEY (`cost_freight_id`) REFERENCES `cost_freight` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists america_cost_rate;
create table america_cost_rate
(
    `inner_id`        int            not null primary key AUTO_INCREMENT,
    `cost_freight_id` int,
    `freight_cost`    DECIMAL(10, 2) null,
    `selling_cost`    DECIMAL(10, 2) null,
    `foreign_cost`    DECIMAL(10, 2) null,
    `optimize`        DECIMAL(10, 2) null,
    `final_price`     DECIMAL(10, 2) null,
    `profit`          DECIMAL(10, 2) null,
    INDEX (`cost_freight_id`) USING BTREE,
    CONSTRAINT `america_cost_rate_fk`
        FOREIGN KEY (`cost_freight_id`) REFERENCES `cost_freight` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists canada_cost_rate;
create table canada_cost_rate
(
    `inner_id`        int            not null primary key AUTO_INCREMENT,
    `cost_freight_id` int,
    `freight_cost`    DECIMAL(10, 2) null,
    `selling_cost`    DECIMAL(10, 2) null,
    `foreign_cost`    DECIMAL(10, 2) null,
    `optimize`        DECIMAL(10, 2) null,
    `final_price`     DECIMAL(10, 2) null,
    `profit`          DECIMAL(10, 2) null,
    INDEX (`cost_freight_id`) USING BTREE,
    CONSTRAINT `canada_cost_rate_fk`
        FOREIGN KEY (`cost_freight_id`) REFERENCES `cost_freight` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists brazil_cost_rate;
create table brazil_cost_rate
(
    `inner_id`        int            not null primary key AUTO_INCREMENT,
    `cost_freight_id` int,
    `freight_cost`    DECIMAL(10, 2) null,
    `selling_cost`    DECIMAL(10, 2) null,
    `foreign_cost`    DECIMAL(10, 2) null,
    `optimize`        DECIMAL(10, 2) null,
    `final_price`     DECIMAL(10, 2) null,
    `profit`          DECIMAL(10, 2) null,
    INDEX (`cost_freight_id`) USING BTREE,
    CONSTRAINT `brazil_cost_rate_fk`
        FOREIGN KEY (`cost_freight_id`) REFERENCES `cost_freight` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists mexico_cost_rate;
create table mexico_cost_rate
(
    `inner_id`        int            not null primary key AUTO_INCREMENT,
    `cost_freight_id` int,
    `freight_cost`    DECIMAL(10, 2) null,
    `selling_cost`    DECIMAL(10, 2) null,
    `foreign_cost`    DECIMAL(10, 2) null,
    `optimize`        DECIMAL(10, 2) null,
    `final_price`     DECIMAL(10, 2) null,
    `profit`          DECIMAL(10, 2) null,
    INDEX (`cost_freight_id`) USING BTREE,
    CONSTRAINT `mexico_cost_rate_fk`
        FOREIGN KEY (`cost_freight_id`) REFERENCES `cost_freight` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists england_cost_rate;
create table england_cost_rate
(
    `inner_id`        int            not null primary key AUTO_INCREMENT,
    `cost_freight_id` int,
    `freight_cost`    DECIMAL(10, 2) null,
    `selling_cost`    DECIMAL(10, 2) null,
    `foreign_cost`    DECIMAL(10, 2) null,
    `optimize`        DECIMAL(10, 2) null,
    `final_price`     DECIMAL(10, 2) null,
    `profit`          DECIMAL(10, 2) null,
    INDEX (`cost_freight_id`) USING BTREE,
    CONSTRAINT `england_cost_rate_fk`
        FOREIGN KEY (`cost_freight_id`) REFERENCES `cost_freight` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists germany_cost_rate;
create table germany_cost_rate
(
    `inner_id`        int            not null primary key AUTO_INCREMENT,
    `cost_freight_id` int,
    `freight_cost`    DECIMAL(10, 2) null,
    `selling_cost`    DECIMAL(10, 2) null,
    `foreign_cost`    DECIMAL(10, 2) null,
    `optimize`        DECIMAL(10, 2) null,
    `final_price`     DECIMAL(10, 2) null,
    `profit`          DECIMAL(10, 2) null,
    INDEX (`cost_freight_id`) USING BTREE,
    CONSTRAINT `germany_cost_rate_fk`
        FOREIGN KEY (`cost_freight_id`) REFERENCES `cost_freight` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists france_cost_rate;
create table france_cost_rate
(
    `inner_id`        int            not null primary key AUTO_INCREMENT,
    `cost_freight_id` int,
    `freight_cost`    DECIMAL(10, 2) null,
    `selling_cost`    DECIMAL(10, 2) null,
    `foreign_cost`    DECIMAL(10, 2) null,
    `optimize`        DECIMAL(10, 2) null,
    `final_price`     DECIMAL(10, 2) null,
    `profit`          DECIMAL(10, 2) null,
    INDEX (`cost_freight_id`) USING BTREE,
    CONSTRAINT `france_cost_rate_fk`
        FOREIGN KEY (`cost_freight_id`) REFERENCES `cost_freight` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists spain_cost_rate;
create table spain_cost_rate
(
    `inner_id`        int            not null primary key AUTO_INCREMENT,
    `cost_freight_id` int,
    `freight_cost`    DECIMAL(10, 2) null,
    `selling_cost`    DECIMAL(10, 2) null,
    `foreign_cost`    DECIMAL(10, 2) null,
    `optimize`        DECIMAL(10, 2) null,
    `final_price`     DECIMAL(10, 2) null,
    `profit`          DECIMAL(10, 2) null,
    INDEX (`cost_freight_id`) USING BTREE,
    CONSTRAINT `spain_cost_rate_fk`
        FOREIGN KEY (`cost_freight_id`) REFERENCES `cost_freight` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists italy_cost_rate;
create table italy_cost_rate
(
    `inner_id`        int            not null primary key AUTO_INCREMENT,
    `cost_freight_id` int,
    `freight_cost`    DECIMAL(10, 2) null,
    `selling_cost`    DECIMAL(10, 2) null,
    `foreign_cost`    DECIMAL(10, 2) null,
    `optimize`        DECIMAL(10, 2) null,
    `final_price`     DECIMAL(10, 2) null,
    `profit`          DECIMAL(10, 2) null,
    INDEX (`cost_freight_id`) USING BTREE,
    CONSTRAINT `italy_cost_rate_fk`
        FOREIGN KEY (`cost_freight_id`) REFERENCES `cost_freight` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists netherlands_cost_rate;
create table netherlands_cost_rate
(
    `inner_id`        int            not null primary key AUTO_INCREMENT,
    `cost_freight_id` int,
    `freight_cost`    DECIMAL(10, 2) null,
    `selling_cost`    DECIMAL(10, 2) null,
    `foreign_cost`    DECIMAL(10, 2) null,
    `optimize`        DECIMAL(10, 2) null,
    `final_price`     DECIMAL(10, 2) null,
    `profit`          DECIMAL(10, 2) null,
    INDEX (`cost_freight_id`) USING BTREE,
    CONSTRAINT `netherlands_cost_rate_fk`
        FOREIGN KEY (`cost_freight_id`) REFERENCES `cost_freight` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists japanese_cost_rate;
create table japanese_cost_rate
(
    `inner_id`        int            not null primary key AUTO_INCREMENT,
    `cost_freight_id` int,
    `freight_cost`    DECIMAL(10, 2) null,
    `selling_cost`    DECIMAL(10, 2) null,
    `foreign_cost`    DECIMAL(10, 2) null,
    `optimize`        DECIMAL(10, 2) null,
    `final_price`     DECIMAL(10, 2) null,
    `profit`          DECIMAL(10, 2) null,
    INDEX (`cost_freight_id`) USING BTREE,
    CONSTRAINT `japanese_cost_rate_fk`
        FOREIGN KEY (`cost_freight_id`) REFERENCES `cost_freight` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists india_cost_rate;
create table india_cost_rate
(
    `inner_id`        int            not null primary key AUTO_INCREMENT,
    `cost_freight_id` int,
    `freight_cost`    DECIMAL(10, 2) null,
    `selling_cost`    DECIMAL(10, 2) null,
    `foreign_cost`    DECIMAL(10, 2) null,
    `optimize`        DECIMAL(10, 2) null,
    `final_price`     DECIMAL(10, 2) null,
    `profit`          DECIMAL(10, 2) null,
    INDEX (`cost_freight_id`) USING BTREE,
    CONSTRAINT `india_cost_rate_fk`
        FOREIGN KEY (`cost_freight_id`) REFERENCES `cost_freight` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists australian_cost_rate;
create table australian_cost_rate
(
    `inner_id`        int            not null primary key AUTO_INCREMENT,
    `cost_freight_id` int,
    `freight_cost`    DECIMAL(10, 2) null,
    `selling_cost`    DECIMAL(10, 2) null,
    `foreign_cost`    DECIMAL(10, 2) null,
    `optimize`        DECIMAL(10, 2) null,
    `final_price`     DECIMAL(10, 2) null,
    `profit`          DECIMAL(10, 2) null,
    INDEX (`cost_freight_id`) USING BTREE,
    CONSTRAINT `australian_cost_rate_fk`
        FOREIGN KEY (`cost_freight_id`) REFERENCES `cost_freight` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists sweden_cost_rate;
create table sweden_cost_rate
(
    `inner_id`        int            not null primary key AUTO_INCREMENT,
    `cost_freight_id` int,
    `freight_cost`    DECIMAL(10, 2) null,
    `selling_cost`    DECIMAL(10, 2) null,
    `foreign_cost`    DECIMAL(10, 2) null,
    `optimize`        DECIMAL(10, 2) null,
    `final_price`     DECIMAL(10, 2) null,
    `profit`          DECIMAL(10, 2) null,
    INDEX (`cost_freight_id`) USING BTREE,
    CONSTRAINT `sweden_cost_rate_fk`
        FOREIGN KEY (`cost_freight_id`) REFERENCES `cost_freight` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists poland_cost_rate;
create table poland_cost_rate
(
    `inner_id`        int            not null primary key AUTO_INCREMENT,
    `cost_freight_id` int,
    `freight_cost`    DECIMAL(10, 2) null,
    `selling_cost`    DECIMAL(10, 2) null,
    `foreign_cost`    DECIMAL(10, 2) null,
    `optimize`        DECIMAL(10, 2) null,
    `final_price`     DECIMAL(10, 2) null,
    `profit`          DECIMAL(10, 2) null,
    INDEX (`cost_freight_id`) USING BTREE,
    CONSTRAINT `poland_cost_rate_fk`
        FOREIGN KEY (`cost_freight_id`) REFERENCES `cost_freight` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists arab_cost_rate;
create table arab_cost_rate
(
    `inner_id`        int            not null primary key AUTO_INCREMENT,
    `cost_freight_id` int,
    `freight_cost`    DECIMAL(10, 2) null,
    `selling_cost`    DECIMAL(10, 2) null,
    `foreign_cost`    DECIMAL(10, 2) null,
    `optimize`        DECIMAL(10, 2) null,
    `final_price`     DECIMAL(10, 2) null,
    `profit`          DECIMAL(10, 2) null,
    INDEX (`cost_freight_id`) USING BTREE,
    CONSTRAINT `arab_cost_rate_fk`
        FOREIGN KEY (`cost_freight_id`) REFERENCES `cost_freight` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists saudi_cost_rate;
create table saudi_cost_rate
(
    `inner_id`        int            not null primary key AUTO_INCREMENT,
    `cost_freight_id` int,
    `freight_cost`    DECIMAL(10, 2) null,
    `selling_cost`    DECIMAL(10, 2) null,
    `foreign_cost`    DECIMAL(10, 2) null,
    `optimize`        DECIMAL(10, 2) null,
    `final_price`     DECIMAL(10, 2) null,
    `profit`          DECIMAL(10, 2) null,
    INDEX (`cost_freight_id`) USING BTREE,
    CONSTRAINT `saudi_cost_rate_fk`
        FOREIGN KEY (`cost_freight_id`) REFERENCES `cost_freight` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists singapore_cost_rate;
create table singapore_cost_rate
(
    `inner_id`        int            not null primary key AUTO_INCREMENT,
    `cost_freight_id` int,
    `freight_cost`    DECIMAL(10, 2) null,
    `selling_cost`    DECIMAL(10, 2) null,
    `foreign_cost`    DECIMAL(10, 2) null,
    `optimize`        DECIMAL(10, 2) null,
    `final_price`     DECIMAL(10, 2) null,
    `profit`          DECIMAL(10, 2) null,
    INDEX (`cost_freight_id`) USING BTREE,
    CONSTRAINT `singapore_cost_rate_fk`
        FOREIGN KEY (`cost_freight_id`) REFERENCES `cost_freight` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

5、介绍细则

introduce_detial.sql

drop table if exists china_introduce;

create table china_introduce
(
    `inner_id`        int          not null primary key AUTO_INCREMENT,
    `product_id`      int,
    `title`           varchar(500) null,
    `five_describe`   varchar(500) null,
    `detail_describe` varchar(500) null,
    `key`             varchar(500) null,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `china_introduce_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists america_introduce;
create table america_introduce
(
    inner_id          int          not null primary key AUTO_INCREMENT,
    product_id        int,
    `title`           varchar(500) null,
    `five_describe`   varchar(500) null,
    `detail_describe` varchar(500) null,
    `key`             varchar(500) null,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `america_introduce_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists canada_introduce;
create table canada_introduce
(
    inner_id          int          not null primary key AUTO_INCREMENT,
    product_id        int,
    `title`           varchar(500) null,
    `five_describe`   varchar(500) null,
    `detail_describe` varchar(500) null,
    `key`             varchar(500) null,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `canada_introduce_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists brazil_introduce;
create table brazil_introduce
(
    inner_id          int          not null primary key AUTO_INCREMENT,
    product_id        int,
    `title`           varchar(500) null,
    `five_describe`   varchar(500) null,
    `detail_describe` varchar(500) null,
    `key`             varchar(500) null,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `brazil_introduce_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists mexico_introduce;
create table mexico_introduce
(
    inner_id          int          not null primary key AUTO_INCREMENT,
    product_id        int,
    `title`           varchar(500) null,
    `five_describe`   varchar(500) null,
    `detail_describe` varchar(500) null,
    `key`             varchar(500) null,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `mexico_introduce_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists england_introduce;
create table england_introduce
(
    inner_id          int          not null primary key AUTO_INCREMENT,
    product_id        int,
    `title`           varchar(500) null,
    `five_describe`   varchar(500) null,
    `detail_describe` varchar(500) null,
    `key`             varchar(500) null,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `england_introduce_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists germany_introduce;
create table germany_introduce
(
    inner_id          int          not null primary key AUTO_INCREMENT,
    product_id        int,
    `title`           varchar(500) null,
    `five_describe`   varchar(500) null,
    `detail_describe` varchar(500) null,
    `key`             varchar(500) null,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `germany_introduce_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists france_introduce;
create table france_introduce
(
    inner_id          int          not null primary key AUTO_INCREMENT,
    product_id        int,
    `title`           varchar(500) null,
    `five_describe`   varchar(500) null,
    `detail_describe` varchar(500) null,
    `key`             varchar(500) null,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `france_introduce_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists spain_introduce;
create table spain_introduce
(
    inner_id          int          not null primary key AUTO_INCREMENT,
    product_id        int,
    `title`           varchar(500) null,
    `five_describe`   varchar(500) null,
    `detail_describe` varchar(500) null,
    `key`             varchar(500) null,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `spain_introduce_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists italy_introduce;
create table italy_introduce
(
    inner_id          int          not null primary key AUTO_INCREMENT,
    product_id        int,
    `title`           varchar(500) null,
    `five_describe`   varchar(500) null,
    `detail_describe` varchar(500) null,
    `key`             varchar(500) null,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `italy_introduce_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists netherlands_introduce;
create table netherlands_introduce
(
    inner_id          int          not null primary key AUTO_INCREMENT,
    product_id        int,
    `title`           varchar(500) null,
    `five_describe`   varchar(500) null,
    `detail_describe` varchar(500) null,
    `key`             varchar(500) null,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `netherlands_introduce_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists japanese_introduce;
create table japanese_introduce
(
    inner_id          int          not null primary key AUTO_INCREMENT,
    product_id        int,
    `title`           varchar(500) null,
    `five_describe`   varchar(500) null,
    `detail_describe` varchar(500) null,
    `key`             varchar(500) null,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `japanese_introduce_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists india_introduce;
create table india_introduce
(
    inner_id          int          not null primary key AUTO_INCREMENT,
    product_id        int,
    `title`           varchar(500) null,
    `five_describe`   varchar(500) null,
    `detail_describe` varchar(500) null,
    `key`             varchar(500) null,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `india_introduce_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists australian_introduce;
create table australian_introduce
(
    inner_id          int          not null primary key AUTO_INCREMENT,
    product_id        int,
    `title`           varchar(500) null,
    `five_describe`   varchar(500) null,
    `detail_describe` varchar(500) null,
    `key`             varchar(500) null,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `australian_introduce_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists sweden_introduce;
create table sweden_introduce
(
    inner_id          int          not null primary key AUTO_INCREMENT,
    product_id        int,
    `title`           varchar(500) null,
    `five_describe`   varchar(500) null,
    `detail_describe` varchar(500) null,
    `key`             varchar(500) null,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `sweden_introduce_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists poland_introduce;
create table poland_introduce
(
    inner_id          int          not null primary key AUTO_INCREMENT,
    product_id        int,
    `title`           varchar(500) null,
    `five_describe`   varchar(500) null,
    `detail_describe` varchar(500) null,
    `key`             varchar(500) null,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `poland_introduce_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists arab_introduce;
create table arab_introduce
(
    inner_id          int          not null primary key AUTO_INCREMENT,
    product_id        int,
    `title`           varchar(500) null,
    `five_describe`   varchar(500) null,
    `detail_describe` varchar(500) null,
    `key`             varchar(500) null,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `arab_introduce_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists saudi_introduce;
create table saudi_introduce
(
    inner_id          int          not null primary key AUTO_INCREMENT,
    product_id        int,
    `title`           varchar(500) null,
    `five_describe`   varchar(500) null,
    `detail_describe` varchar(500) null,
    `key`             varchar(500) null,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `saudi_introduce_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

drop table if exists singapore_introduce;
create table singapore_introduce
(
    inner_id          int          not null primary key AUTO_INCREMENT,
    product_id        int,
    `title`           varchar(500) null,
    `five_describe`   varchar(500) null,
    `detail_describe` varchar(500) null,
    `key`             varchar(500) null,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `singapore_introduce_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

6、物流信息

logistics_information.sql

DROP TABLE IF EXISTS `logistics_information`;
CREATE TABLE `logistics_information`
(
    `inner_id`                       int NOT NULL PRIMARY KEY AUTO_INCREMENT,
    `buy_id`                         int            DEFAULT -1,
    `recipients`                     varchar(255)   DEFAULT NULL,
    `tel`                            varchar(255)   DEFAULT NULL,
    `country`                        varchar(255)   DEFAULT NULL,
    `country_china`                  varchar(255)   DEFAULT NULL,
    `zip_code`                       varchar(255)   DEFAULT NULL,
    `state`                          varchar(255)   DEFAULT NULL,
    `city`                           varchar(255)   DEFAULT NULL,
    `street`                         varchar(255)   DEFAULT NULL,
    `detial`                         varchar(255)   DEFAULT NULL,
    `number`                         int            DEFAULT NULL,
    `name`                           varchar(255)   DEFAULT NULL,
    `englishName`                    varchar(255)   DEFAULT NULL,
    `weight`                         DECIMAL(10, 2) DEFAULT NULL,
    `long`                           DECIMAL(10, 2) DEFAULT NULL,
    `wide`                           DECIMAL(10, 2) DEFAULT NULL,
    `high`                           DECIMAL(10, 2) DEFAULT NULL,
    `logistics_kind`                 varchar(255)   DEFAULT NULL,
    `logistics_second_kind`          varchar(255)   DEFAULT NULL,
    `ioss`                           varchar(255)   DEFAULT NULL,
    `transport_number`               varchar(255)   DEFAULT NULL,
    `tracking_number`                varchar(255)   DEFAULT NULL,
    `international_transport_number` varchar(255)   DEFAULT NULL,
    `international_tracking_number`  varchar(255)   DEFAULT NULL,
    `international_money`            DECIMAL(10, 2) DEFAULT NULL,
    `route`                          varchar(255)   DEFAULT NULL,
    `deliver_time`                   date           DEFAULT NULL,
    `logistics_time`                 date           DEFAULT NULL,
    `deliver_status`                 varchar(255)   DEFAULT NULL,
    `synchronization_status`         varchar(255)   DEFAULT NULL,
    `enable`                         tinyint(1)     default 0,

    INDEX (`buy_id`) USING BTREE,
    CONSTRAINT `logistics_information_fk`
        FOREIGN KEY (`buy_id`) REFERENCES `buy` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

# SET FOREIGN_KEY_CHECKS = 1;

7、组织架构

organization.sql

# SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS `organization`;
CREATE TABLE `organization`
(
    `inner_id`          int NOT NULL PRIMARY KEY AUTO_INCREMENT,
    `name`              int          DEFAULT NULL,
    `user_name`         varchar(255) DEFAULT NULL,
    `password`          varchar(255) DEFAULT NULL,
    `organization_kind` varchar(255) DEFAULT NULL,
    `organization_name` varchar(255) DEFAULT NULL,
    `up_organization`   int          DEFAULT NULL,
    `sku_prefix`        varchar(255) DEFAULT NULL,
    `contact`           varchar(255) DEFAULT NULL,
    `phone_number`      varchar(255) DEFAULT NULL,
    `last_money`        varchar(255) DEFAULT NULL,
    `is_look`           tinyint(1)   DEFAULT 0,
    `is_delete`         tinyint(1)   DEFAULT 0,
    `enable`            int          DEFAULT NULL,
    `time`              date
);

# SET FOREIGN_KEY_CHECKS = 1;

8、图片组

photo_group.sql

drop table if exists photo_group;
create table photo_group
(
    `inner_id`   int NOT NULL PRIMARY KEY AUTO_INCREMENT,
    `product_id` int          DEFAULT NULL,
    `photo_name` varchar(255) DEFAULT NULL,
    `photo_path` varchar(255) DEFAULT NULL,
    `enable`     tinyint(1)   default 0,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `photo_group_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

9、图片变体

photo_variant.sql

drop table if exists photo_variant;
create table photo_variant
(
    inner_id         int          not null primary key AUTO_INCREMENT,
    variant_group_id int          null,
    photo_name       varchar(255) null,
    photo_path       varchar(255) null,
    INDEX (`variant_group_id`) USING BTREE,
    CONSTRAINT `photo_variant_fk`
        FOREIGN KEY (`variant_group_id`) REFERENCES `variant_group` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

10、产品

product.sql

SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS `product`;
CREATE TABLE `product`
(
    `inner_id`           int NOT NULL PRIMARY KEY AUTO_INCREMENT,
    `cost_freight_id`    int          DEFAULT NULL,
    `product_number`     varchar(255) DEFAULT NULL,
    `product_name`       varchar(255) DEFAULT NULL,
    `product_kind`       varchar(255) DEFAULT NULL,
    `product_inner_kind` varchar(255) DEFAULT NULL,
    `load_status`        varchar(255) DEFAULT NULL,
    `product_code`       varchar(255) DEFAULT NULL,
    `up_people`          int          DEFAULT NULL,
    `enable`             tinyint(1)   default 0,
    `time`               date,
    INDEX (`cost_freight_id`) USING BTREE,
    CONSTRAINT `product_fk`
        FOREIGN KEY (`cost_freight_id`) REFERENCES `organization` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

SET FOREIGN_KEY_CHECKS = 1;

11、产品信息

product_info.sql

drop table if exists product_info;
create table product_info
(
    `inner_id`       int not null primary key AUTO_INCREMENT,
    `product_id`     int null,
    `firm_name`      varchar(255) DEFAULT NULL,
    `brand_name`     varchar(255) DEFAULT NULL,
    `firm_id`        varchar(255) DEFAULT NULL,
    `product_from`   varchar(255) DEFAULT NULL,
    `inner_sku`      varchar(255) DEFAULT NULL,
    `correction_sku` varchar(255) DEFAULT NULL,
    `web_path`       varchar(255) DEFAULT NULL,
    `remark`         varchar(255) DEFAULT NULL,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `product_info_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

12、数据上传

upload.sql

DROP TABLE IF EXISTS `upload`;
CREATE TABLE `upload`
(
    `inner_id`             int NOT NULL PRIMARY KEY AUTO_INCREMENT,
    `authorized_shops_id`  int          DEFAULT -1,
    `operate_people_id`    int          DEFAULT NULL,
    `product_id`           int          DEFAULT -1,
    `amazon_classify_type` varchar(255) DEFAULT NULL,
    `classify_id`          varchar(255) DEFAULT NULL,
    `classify_type`        varchar(255) DEFAULT NULL,
    `update_time`          date         DEFAULT NULL,
    `load_status`          varchar(255) DEFAULT NULL,
    `fail_reason`          varchar(500) DEFAULT NULL,

    INDEX (`operate_people_id`) USING BTREE,
    CONSTRAINT `upload_operate_people_id_fk`
        FOREIGN KEY (`operate_people_id`) REFERENCES `organization` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE,
    INDEX (`authorized_shops_id`) USING BTREE,
    CONSTRAINT `upload_authorized_shops_id_fk`
        FOREIGN KEY (`authorized_shops_id`) REFERENCES `authorized_shops` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);

# SET FOREIGN_KEY_CHECKS = 1;

13、变体组

variant_group.sql

drop table if exists variant_group;
create table variant_group
(
    inner_id            int            not null primary key AUTO_INCREMENT,
    product_id          int            null,
    variant_name        varchar(255)   null,
    variant_sku         varchar(255)   null,
    variant_add_money   DECIMAL(10, 2) null,
    inventory           int            null,
    variant_total_money DECIMAL(10, 2) null,
    variant_upc_ean     varchar(255)   null,
    asin                varchar(255)   null,
    INDEX (`product_id`) USING BTREE,
    CONSTRAINT `variant_group_fk`
        FOREIGN KEY (`product_id`) REFERENCES `product` (`inner_id`)
            ON DELETE CASCADE ON UPDATE CASCADE
);
轻夏
关注
专栏目录
详细的在线电商数据库详细设计
06-20
详细的大型电商数据库设计，来自某平台的收费课程，具体的数据可设计十分详细，注释清晰
电商项目的数据库表设计（MySQL版）
Fzicoo的博客
09-06 2871
简介： 目的: 电商常用功能模块的数据库设计 常见问题的数据库解决方案 环境: MySQL5.7 图形客户端，SQLyog Linux 模块: 用户：注册、登陆 商品：浏览、管理 订单：生成、管理 仓配：库存、管理 电商实例数据库结构设计 用户模块: 用户表涉及的实体: 改进1: 第三范式：将依赖传递的列分离出来。比如：登录名<-用户级别<-级别积分上限，级别积分下限 改进2:...
【SQL Server】网上购物商城数据库设计报告(专业课设作品附上sql文件文档)
热门推荐
go
07-30 5万+
目录一、需求分析1.1 背景1.2 数据需求1.3 事物需求1.4 数据流程图二、概念结构设计2.1 E-R图三、关系模式3.2 数据逻辑结构四、物理结构设计4.1 建立一个数据库4.2 建立八张表4.3 建立表的连接五、系统功能的实现5.1 数据库建立5.2 创建立数据表5.3 建立表连接5.4 数据初始5.4.1 管理員初姶化5.4.2添加商品組信息5.4.3 在各商品組加入商品5.4.4添加注册会員信息5.4.6 添加枚限信息5.4.7 添加管理员权限信息5.5 查询5.5.1 查询本站有哪些种类的商
常见电商项目的数据库表设计(MySQL版)
u012015632的博客
03-07 8534
常见电商项目的数据库表设计(MySQL版) 简介： 目的： 电商常用功能模块的数据库设计 常见问题的数据库解决方案 环境： MySQL5.7 图形客户端，SQLyog Linux 模块： 用户：注册、登陆 商品：浏览、管理 订单：生成、管理 仓配：库存、管理 电商实例数据库结构设计： 电商项目用户模块 用户表涉及的实体 在这里插入图片描述 改进1：第三范式：将依赖传递的列分离出来。比如...
使用 Amazon EMR 构建您的数据分析平台
kikokingの比特宇宙
05-23 8392
Amazon EMR是云上的数据分析平台，通过 Amazon EMR 的图形化或命令行接口，用户可以快速搭建和部署基于 Amazon EC2 实例的数据分析系统，并能动态扩展集群。Amazon EMR 也可以读写其他 AWS 数据存储服务，例如 Amazon S3 和 Amazon DynamoDB。用户也可以在该平台上使用开源分析框架（如 Apache Spark、 Presto 等）运行大规模分布式数据处理作业，交互式 SQL 查询，以及机器学习 (ML) 应用程序。
【AI落地应用实战】Amazon Bedrock + Amazon DynamoDB 数据设计与建模
最新发布
白洞，白色的明天在等着我们
07-29 9670
在当今数字化转型的浪潮中，企业对数据处理能力的需求日益增长，为了应对大规模数据和高并发访问的挑战，选择一款合适的数据库解决方案变得尤为重要。Amazon DynamoDB，作为亚马逊云科技提供的一种完全托管式、无服务器的，凭借其高性能、高可用性和可扩展性，成为了构建现代化应用程序的理想选择。在中，DynamoDB不仅支持快速数据访问和实时数据处理，还能够处理大规模数据集的存储和检索。在。
【无标题】数仓实战之亚马逊全球跨境电商分析平台
huangchunqq的博客
11-26 422
一、Sqoop框架 --1. 验证sqoop cd /export/server/sqoop-1.4.7 bin/sqoop list-databases \ --connect jdbc:mysql://node1:3306/ \ --username root --password 123456 二、拉链表-Demo -- 1、MySQL创建商品表 -- 创建数据库 CREATE DATABASE demo; -- 创建商品表 create table if not exists demo....
【电商API接口】电商卖家必看！电商数据源对接全攻略！收藏！
电商数据Girl的博客
01-19 1289
目前支持连接淘系（天猫、淘宝）、京东、得物、抖音、快手、拼多多、微信视频号、唯品会、小红书、小米优品等电商平台数据，旗下跨境行业产品【数跨境BI】则支持连接十余种跨境电商平台，如亚马逊、虾皮、Lazada、Ebay、沃尔玛、速卖通、Shopify、店匠、Shopline等，基本。帮助卖家获取品牌数据、商品分析数据、广告数据、交易数据、人群画像、直播间数据、达人分析数据、售后服务单等数百项数据，只要是在电商后台界面中有展示的数据，都支持全域抓取，永久留存。只要是在电商后台界面展示的数据，均可使用RPA抓取。
电商订单仓储ERP管理系统 v4.3.6.zip
07-11
它充分利用电商务平台提供的API 接口，通过软件自动同步技术，实现网店数据的自动化、简易化管理，协助店主更高效的管理店铺。 电商订单仓储ERP管理系统功能 1、一套软件多个仓库、多个电子商务平台、多个店铺进行...
基于云原生架构构建亿级多语言电商平台设计到落地实现（3个阶段全）
01-09
"基于云原生架构构建亿级多语言电商平台设计到落地实现"的视频教程涵盖了从设计、开发到实施的全过程，旨在帮助开发者和企业理解如何利用云原生技术来搭建能够处理亿级用户流量、支持多语言的高效平台。 云原生是一...
数据中台的设计模式与实现——探讨数据中台的由来、作用、构成、设计模式以及实践方法
程序员光剑
07-31 2644
数据中台是一种重要的业务平台模式，它能够将传统的数据仓库、数据湖等多个数据源进行集成和整合，形成统一的数据服务体系，并通过数据驱动的方式，优化公司各个业务部门之间的信息流动、数据共享和价值传递，最终实现数据的价值的最大化转化。数据中台在数据处理流程、数据治理、数据应用、数据服务等方面发挥着越来越重要的作用。在企业数字化过程中，如何构建一个具备高效可靠、数据一致性强、运维自动化程度高的数据中台，是一个值得关注的课题。
C语言飞机大战小游戏（2万字！完整精讲解版+源代码）
轻夏的博客
03-16 2万+
C语言飞机大战小游戏（2万字！完整精讲解版+源代码）运行效果项目技术点1、启动欢迎界面2、游戏运行界面3、结束界面4、其他功能细节注意命名规范主要思想代码详解函数定义1、界面函数2、绘制与清除飞机函数3、运行刷新函数4、碰撞检测函数5、结束函数6、随机位置生成函数界面控制常量结构体1、创建己方飞机位置结构体2、创建敌方飞机位置结构体3、创建己方飞机炮弹结构体4、创建敌方飞机炮弹结构体5、创建敌方飞...
亚马逊电商数据自动化管理接口平台JAVA SP-API接口开发（下）
轻夏的博客
03-04 3826
亚马逊电商数据自动化管理接口平台JAVA SP-API接口开发（下） 1、上传数据 2、获取ProductTpye目录 3、获取ProductTpye详细目录 4、上传json数据 参考文献
高颜值数据库项目实战MySQL+JavaFX+Fxml+CSS（完整精讲解版+源代码）(一）
轻夏的博客
03-17 2753
高颜值数据库项目实战MySQL+JavaFX+Fxml+CSS（完整精讲解版+源代码）项目效果图功能点实现内部优化主要结构创建1、创建主Management 类，并继承Application2、创建start以提供启动 项目效果图 功能点实...
亚马逊电商数据自动化管理接口平台体系设计
轻夏的博客
03-04 2268
亚马逊电商数据自动化管理接口平台体系设计，用于设计该平台的整体架构，从而方便去实现数据库的设计，该设计配套与其他设计一同组成亚马逊电商数据自动化管理接口平台
亚马逊电商数据自动化管理接口平台JAVA SP-API接口开发（中）
轻夏的博客
03-04 1781
亚马逊电商数据自动化管理接口平台JAVA SP-API接口开发（中） 准备工作 1、小技巧 List类型的数据 时间数据 报错信息 2、一个获取报告的例子 3、另一个获取报告的例子 例子1 例子2 例子3 例子4 例子5 参考文献
高颜值数据库项目实战MySQL+JavaFX+Fxml+CSS（完整精讲解版+源代码）(八）
轻夏的博客
03-26 1445
8：高颜值JavaFX数据库-九讲之八项目效果图功能点实现内部优化类结构示例书写其他类的操作逻辑1、书写Search类的操作添加搜索事件按钮创建数据库执行语句Search类效果图Search类完整代码2、书写Delete 类的操作添加搜索事件按钮添加删除事件按钮询问一下用户是否真的需要删除判断一下，如果用户选择了什么执行SQL语句最后添加清空操作方法Delete 类效果图Delete 类完整代码3...
AMAZON电商接口开发指南：XML与订单处理详解
AMAZON电商接口指南是开发者的重要工具，它专门针对亚马逊电商平台提供详细的XML（eXtensible Markup Language）使用方法。XML在电子商务中的作用在于标准化数据交换，使得不同系统之间能有效地共享和理解信息。本...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值