-
Notifications
You must be signed in to change notification settings - Fork 0
/
databases.txt
69 lines (54 loc) · 2.07 KB
/
databases.txt
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
Models
******************
npx sequelize-cli model:generate --name User --attributes names:string,email:string,address:string,joined:string,telephone:string,role:string,password:string
npx sequelize-cli model:generate --name Admin --attributes names:string,email:string,telephone:string,joined:string,role:string,password:string
npx sequelize-cli model:generate --name Car --attributes name:string,brand:string,imageUrl:string,added:string,price:string,currency:string
npx sequelize-cli model:generate --name Request --attributes userId:string,carId:string,timeRequested:string,isAllowed:boolean
******************
Seeds
******************
npx sequelize-cli seed:generate --name admin
npx sequelize-cli seed:generate --name car
npx sequelize-cli seed:generate --name user
npx sequelize-cli seed:generate --name request
->Execute seed file
npx sequelize-cli db:seed:all
****************
Create User Table
**********************
CREATE TABLE public."Users"
(
id character varying NOT NULL,
"updatedAt" integer,
"createdAt" integer,
names character varying NOT NULL,
email character varying NOT NULL,
address character varying NOT NULL,
joined character varying NOT NULL,
telephone character varying NOT NULL,
role character varying NOT NULL,
password character varying NOT NULL,
PRIMARY KEY (id)
);
ALTER TABLE IF EXISTS public."Users"
OWNER to postgres;
***********************
Create car Table
******************
CREATE TABLE IF NOT EXISTS public."Cars"
(
id character varying COLLATE pg_catalog."default" NOT NULL,
name character varying COLLATE pg_catalog."default" NOT NULL,
brand character varying COLLATE pg_catalog."default" NOT NULL,
"imageUrl" character varying COLLATE pg_catalog."default" NOT NULL,
added integer NOT NULL,
price integer NOT NULL,
"isBooked" boolean NOT NULL,
currency character varying COLLATE pg_catalog."default" NOT NULL,
"createdAt" integer,
"updatedAt" integer,
CONSTRAINT "Cars_pkey" PRIMARY KEY (id)
)
TABLESPACE pg_default;
ALTER TABLE IF EXISTS public."Cars"
OWNER to postgres;