· 6 years ago · Aug 11, 2019, 10:26 AM
1CREATE TABLE IF NOT EXISTS "menu" (
2 "id" bigserial PRIMARY KEY,
3 "name" TEXT NOT NULL,
4 "cn" TEXT NOT NULL
5);
6CREATE UNIQUE INDEX "menu.name" ON "menu" (
7 "name"
8);
9CREATE TABLE IF NOT EXISTS "kind" (
10 "id" bigserial PRIMARY KEY,
11 "url" TEXT NOT NULL UNIQUE,
12 "menu_id" INTEGER NOT NULL,
13 "name" TEXT NOT NULL,
14 "cn" TEXT NOT NULL
15);
16CREATE TABLE IF NOT EXISTS "goods_kind" (
17 "id" bigserial PRIMARY KEY,
18 "goods_id" INTEGER NOT NULL,
19 "kind_id" INTEGER NOT NULL
20);
21CREATE UNIQUE INDEX "goods_kind.kind_id.goods_id" ON "goods_kind" (
22 "kind_id",
23 "goods_id"
24);
25CREATE TABLE IF NOT EXISTS "size" (
26 "id" bigserial PRIMARY KEY,
27 "val" INTEGER NOT NULL UNIQUE
28);
29CREATE TABLE IF NOT EXISTS "color" (
30 "id" bigserial PRIMARY KEY,
31 "val" TEXT UNIQUE
32);
33CREATE TABLE IF NOT EXISTS "brand" (
34 "id" bigserial PRIMARY KEY,
35 "val" TEXT UNIQUE
36);
37CREATE TABLE IF NOT EXISTS "goods_size" (
38 "id" bigserial PRIMARY KEY,
39 "goods_id" INTEGER NOT NULL,
40 "size_id" INTEGER NOT NULL
41);
42CREATE UNIQUE INDEX "good_size.size_id.goods_id" ON "goods_size" (
43 "size_id",
44 "goods_id"
45);
46CREATE TABLE style (
47 "id" bigserial PRIMARY KEY,
48 "val" TEXT UNIQUE
49);
50CREATE TABLE IF NOT EXISTS "cat" (
51 "id" bigserial PRIMARY KEY,
52 "up_id" INTEGER NOT NULL,
53 "name" TEXT NOT NULL,
54 "url" TEXT NOT NULL
55);
56CREATE TABLE IF NOT EXISTS "goods" (
57 "id" bigserial PRIMARY KEY,
58 "name" INTEGER NOT NULL,
59 "url" INTEGER NOT NULL,
60 "img" INTEGER NOT NULL,
61 "is_on_sale" INTEGER NOT NULL,
62 "supplier_id" INTEGER NOT NULL,
63 "brand_id" INTEGER NOT NULL,
64 "color_id" INTEGER NOT NULL,
65 "sn" TEXT NOT NULL,
66 "style_id" INTEGER NOT NULL,
67 "color_img" TEXT NOT NULL,
68 "cat_id" INTEGER NOT NULL,
69 "comment" INTEGER NOT NULL DEFAULT 0,
70 "price_show" INTEGER NOT NULL,
71 "price_sale" INTEGER NOT NULL,
72 "stock" INTEGER NOT NULL,
73 "date" INTEGER NOT NULL
74);