Repository navigation
Expand file tree
/
Copy pathneon-schema.sql
More file actions
73 lines (65 loc) · 2.18 KB
/
Copy pathneon-schema.sql
File metadata and controls
73 lines (65 loc) · 2.18 KB
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
-- =============================================
-- MS Signature Scents - Neon PostgreSQL Schema
-- Prisma is the source of truth. This mirrors prisma/schema.prisma for
-- manual inspection or one-off database setup.
-- =============================================
CREATE TABLE IF NOT EXISTS orders (
id TEXT PRIMARY KEY,
user_email TEXT NOT NULL,
customer_name TEXT NOT NULL,
items JSONB NOT NULL,
total INTEGER NOT NULL,
status TEXT NOT NULL DEFAULT 'confirmed',
shipping_address JSONB NOT NULL,
razorpay_order_id TEXT,
razorpay_payment_id TEXT,
tracking_number TEXT,
carrier TEXT,
notes TEXT,
created_at TIMESTAMPTZ NOT NULL DEFAULT now(),
updated_at TIMESTAMPTZ NOT NULL DEFAULT now()
);
CREATE INDEX IF NOT EXISTS orders_user_email_idx ON orders(user_email);
CREATE INDEX IF NOT EXISTS orders_razorpay_order_id_idx ON orders(razorpay_order_id);
CREATE TABLE IF NOT EXISTS carts (
id TEXT PRIMARY KEY,
user_email TEXT NOT NULL UNIQUE,
items JSONB NOT NULL DEFAULT '[]'::jsonb,
updated_at TIMESTAMPTZ NOT NULL DEFAULT now()
);
CREATE TABLE IF NOT EXISTS shipping_addresses (
id TEXT PRIMARY KEY,
user_email TEXT NOT NULL,
name TEXT NOT NULL,
phone TEXT NOT NULL,
address TEXT NOT NULL,
city TEXT NOT NULL,
state TEXT NOT NULL,
pincode TEXT NOT NULL,
is_default BOOLEAN NOT NULL DEFAULT false,
created_at TIMESTAMPTZ NOT NULL DEFAULT now(),
updated_at TIMESTAMPTZ NOT NULL DEFAULT now()
);
CREATE INDEX IF NOT EXISTS shipping_addresses_user_email_idx
ON shipping_addresses(user_email);
CREATE TABLE IF NOT EXISTS reviews (
id TEXT PRIMARY KEY,
product_id TEXT NOT NULL,
user_email TEXT NOT NULL,
user_name TEXT NOT NULL,
rating INTEGER NOT NULL,
comment TEXT NOT NULL,
images JSONB,
created_at TIMESTAMPTZ NOT NULL DEFAULT now(),
updated_at TIMESTAMPTZ NOT NULL DEFAULT now()
);
CREATE INDEX IF NOT EXISTS reviews_product_id_idx ON reviews(product_id);
CREATE INDEX IF NOT EXISTS reviews_user_email_idx ON reviews(user_email);
CREATE TABLE IF NOT EXISTS contact_submissions (
id TEXT PRIMARY KEY,
name TEXT NOT NULL,
email TEXT NOT NULL,
subject TEXT NOT NULL,
message TEXT NOT NULL,
created_at TIMESTAMPTZ NOT NULL DEFAULT now()
);