1.原型圖

這是利用Axure畫的，簡(jiǎn)單畫一下原型圖，根據(jù)他們的業(yè)務(wù)邏輯我們完成書城商店API開發(fā)

首頁(yè)

分類

商品詳情?

購(gòu)物車

個(gè)人中心?

2.數(shù)據(jù)庫(kù)設(shè)計(jì)

首頁(yè)

首頁(yè)導(dǎo)航

導(dǎo)航欄產(chǎn)品

通過點(diǎn)擊導(dǎo)航欄對(duì)應(yīng)id和產(chǎn)品id關(guān)聯(lián)獲取產(chǎn)品內(nèi)容

設(shè)置外建

?sql語(yǔ)句

CREATE TABLE `book`.`Untitled`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `product_id` int NOT NULL COMMENT '產(chǎn)品id',
  `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '產(chǎn)品名稱',
  `product_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '產(chǎn)品標(biāo)題',
  `product_imgUrl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '產(chǎn)品封面',
  `product_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '產(chǎn)品內(nèi)容',
  `product_old_price` decimal(10, 2) NOT NULL COMMENT '產(chǎn)品舊價(jià)格',
  `product_new_price` decimal(10, 2) NOT NULL COMMENT '產(chǎn)品新價(jià)格',
  `product_remaining_quantity` int NOT NULL COMMENT '產(chǎn)品庫(kù)存量',
  `product_clicks` int NOT NULL COMMENT '產(chǎn)品點(diǎn)擊量',
  `product_sales` int NOT NULL COMMENT '產(chǎn)品銷售量',
  `product_total` int NOT NULL COMMENT '產(chǎn)品總數(shù)',
  `module_id` int NULL DEFAULT NULL COMMENT '屬于哪個(gè)模塊',
  `status` int NOT NULL DEFAULT 0 COMMENT '狀態(tài)',
  `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '產(chǎn)品創(chuàng)建時(shí)間',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '產(chǎn)品更新時(shí)間',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `nav`(`product_id` ASC) USING BTREE,
  INDEX `module`(`module_id` ASC) USING BTREE,
  CONSTRAINT `module` FOREIGN KEY (`module_id`) REFERENCES `book`.`book_module` (`module_id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `nav` FOREIGN KEY (`product_id`) REFERENCES `book`.`book_nav` (`navId`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

產(chǎn)品輪播圖

通過外建獲取產(chǎn)品輪播圖數(shù)據(jù)

設(shè)置外建

sql語(yǔ)句

CREATE TABLE `book`.`Untitled`  (
  `image_id` int NOT NULL AUTO_INCREMENT COMMENT '產(chǎn)品輪播圖id',
  `product_id` int NOT NULL COMMENT '產(chǎn)品id',
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '圖片路徑',
  `order` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '圖片展示順序',
  `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新時(shí)間',
  PRIMARY KEY (`image_id`) USING BTREE,
  INDEX `images`(`product_id` ASC) USING BTREE,
  CONSTRAINT `images` FOREIGN KEY (`product_id`) REFERENCES `book`.`book_navproduct` (`product_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

首頁(yè)輪播圖

sql語(yǔ)句

CREATE TABLE `book`.`Untitled`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '輪播圖id',
  `imgUrl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '圖片路徑',
  `order` int NOT NULL COMMENT '圖片輪播順序',
  `introduce` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '圖片介紹',
  `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新時(shí)間',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

前臺(tái)模塊

外鍵

sql文章來源地址http://www.zghlxwxcb.cn/news/detail-738128.html

CREATE TABLE `book`.`Untitled`  (
  `module_id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `module_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '模塊名字',
  `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新時(shí)間',
  PRIMARY KEY (`module_id`) USING BTREE,
  CONSTRAINT `module` FOREIGN KEY (`module_id`) REFERENCES `book`.`book_navproduct` (`module_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

到了這里，關(guān)于Express框架開發(fā)接口之書城商店原型圖的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！