supabase/create-table.sql at main · delivery-moa/supabase · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
CREATE TABLE "user"(
    "id" UUID NOT NULL,
    "nickname" TEXT NOT NULL,
    "user_rating" FLOAT(53) DEFAULT 50.0,
    "cash" BIGINT DEFAULT 0,
				"profile_url" TEXT,
				"address" TEXT,
				"room_address_detail" TEXT,
    "created_at" TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT now()
);
ALTER TABLE
    "user" ADD PRIMARY KEY("id");
CREATE TABLE "room"(
    "id" BIGINT GENERATED BY DEFAULT AS IDENTITY,
    "store_id" BIGINT NOT NULL,
    "room_name" TEXT NOT NULL,
    "room_address" TEXT NOT NULL,
    "max_people" INTEGER NOT NULL,
    "users" jsonb default '[]'::jsonb,
    "leader_id" UUID NOT NULL,
    "status" TEXT DEFAULT '모집중', -- '모집중','진행중','마감'
    "created_at" TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT now()
);
ALTER TABLE
    "room" ADD PRIMARY KEY("id");
CREATE TABLE "room_join"(
    "id" BIGINT GENERATED BY DEFAULT AS IDENTITY,
				"room_id" BIGINT NOT NULL,
				"user_id" UUID,
				"joined_at" TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT now(),
				"status" TEXT DEFAULT '준비중' -- '준비중','준비완료'
);
ALTER TABLE
    "room_join" ADD PRIMARY KEY("id");
CREATE TABLE "store"(
    "id" BIGINT GENERATED BY DEFAULT AS IDENTITY,
    "category_id" TEXT NOT NULL,
    "store_name" TEXT NOT NULL,
    "store_address" TEXT NOT NULL,
    "min_price" BIGINT DEFAULT 10000,
    "tel" TEXT NOT NULL
);
ALTER TABLE
    "store" ADD PRIMARY KEY("id");
CREATE TABLE "menu_category"(
    "id" TEXT NOT NULL,
    "category" TEXT NOT NULL
);
ALTER TABLE
    "menu_category" ADD PRIMARY KEY("id");
CREATE TABLE "order"(
    "order_id" BIGINT GENERATED BY DEFAULT AS IDENTITY,
    "room_id" BIGINT NOT NULL,
    "user_id" UUID NOT NULL,
    "store_id" BIGINT NOT NULL,
    "room_order" jsonb NOT NULL,
    "total_price" BIGINT NOT NULL,
    "created_at" TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT now()
);
ALTER TABLE
    "order" ADD PRIMARY KEY("order_id");
CREATE TABLE "menu"(
    "id" BIGINT GENERATED BY DEFAULT AS IDENTITY,
    "store_id" BIGINT NOT NULL,
    "img_id" BIGINT NOT NULL,
    "menu_name" TEXT NOT NULL,
    "menu_price" BIGINT NOT NULL
);
ALTER TABLE
    "menu" ADD PRIMARY KEY("id");
CREATE TABLE "chat"(
    "id" BIGINT GENERATED BY DEFAULT AS IDENTITY,
    "room_id" BIGINT NOT NULL,
    "chat" TEXT NOT NULL,
    "user_id" UUID NOT NULL,
    "created_at" TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT now()
);
ALTER TABLE
    "chat" ADD PRIMARY KEY("id");
CREATE TABLE "image"(
    "id" BIGINT GENERATED BY DEFAULT AS IDENTITY,
    "bucket" TEXT NOT NULL,
    "folder" TEXT NOT NULL,
    "filename" TEXT NOT NULL
);
ALTER TABLE
    "image" ADD PRIMARY KEY("id");
CREATE TABLE "qna"(
    "id" BIGINT GENERATED BY DEFAULT AS IDENTITY,
    "user_id" UUID NOT NULL,
    "title" TEXT NOT NULL,
    "q_contents" TEXT NOT NULL,
    "q_answer" TEXT NULL,
    "created_at" TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL
);
ALTER TABLE
    "qna" ADD PRIMARY KEY("id");
CREATE TABLE "payment"(
    "id" BIGINT GENERATED BY DEFAULT AS IDENTITY,
    "user_id" UUID NOT NULL,
    "order_id" BIGINT NOT NULL,
    "status" TEXT NOT NULL,
    "amount" BIGINT NOT NULL
);
ALTER TABLE
    "payment" ADD PRIMARY KEY("id");