jFuk5PLa

1CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
2
3-- Table: public."LockRule"
4
5-- DROP TABLE public."LockRule";
6
7CREATE TABLE public."LockRule"
8(
9    id SERIAL,
10    idx uuid NOT NULL DEFAULT uuid_generate_v1(),
11    name text COLLATE pg_catalog."default" NOT NULL,
12    max_tries integer NOT NULL,
13    lock_interval time without time zone NOT NULL,
14    created_on timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
15    is_obsolete boolean NOT NULL DEFAULT false,
16    modified_on timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
17    CONSTRAINT "LockRule_pkey" PRIMARY KEY (id)
18)
19WITH (
20    OIDS = FALSE
21)
22TABLESPACE pg_default;
23
24ALTER TABLE public."LockRule"
25    OWNER to postgres;
26
27
28
29-- Table: public."Users"
30
31-- DROP TABLE public."Users";
32
33CREATE TABLE public."Auth"
34(
35    id SERIAL,
36    idx uuid DEFAULT uuid_generate_v1(),
37    phone_number text COLLATE pg_catalog."default" NOT NULL,
38    phone_ext text COLLATE pg_catalog."default" NOT NULL,
39	email text COLLATE pg_catalog."default" NOT NULL,
40    created_on timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
41    is_obsolete boolean DEFAULT false,
42    modified_on timestamp without time zone DEFAULT CURRENT_TIMESTAMP
43    CONSTRAINT auth_pkey PRIMARY KEY (id)
44)
45WITH (
46    OIDS = FALSE
47)
48TABLESPACE pg_default;
49
50ALTER TABLE public."Auth"
51    OWNER to postgres;
52
53
54
55-- Table: public."Users"
56
57-- DROP TABLE public."Users";
58
59CREATE TABLE public."Users"
60(
61    id SERIAL,
62    idx uuid DEFAULT uuid_generate_v1(),
63	auth_id bigint,
64    first_name text COLLATE pg_catalog."default" NOT NULL,
65    middle_name text COLLATE pg_catalog."default" NOT NULL,
66    last_name text COLLATE pg_catalog."default" NOT NULL,
67	email text COLLATE pg_catalog."default" NOT NULL,
68    created_on timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
69    is_obsolete boolean DEFAULT false,
70    modified_on timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
71    CONSTRAINT users_pkey PRIMARY KEY (id),
72    CONSTRAINT "fk_auth_id" FOREIGN KEY (auth_id)
73        REFERENCES public."Auth" (id) MATCH SIMPLE
74        ON UPDATE NO ACTION
75        ON DELETE NO ACTION
76)
77WITH (
78    OIDS = FALSE
79)
80TABLESPACE pg_default;
81
82ALTER TABLE public."Users"
83    OWNER to postgres;
84
85
86
87
88
89
90-- DROP TABLE public."Role";
91
92CREATE TABLE public."Role"
93(
94    id SERIAL,
95    idx uuid NOT NULL DEFAULT uuid_generate_v1(),
96    name text COLLATE pg_catalog."default" NOT NULL,
97    created_on timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
98    is_obsolete boolean NOT NULL DEFAULT false,
99    modified_on timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
100    CONSTRAINT "Role_pkey" PRIMARY KEY (id)
101)
102WITH (
103    OIDS = FALSE
104)
105TABLESPACE pg_default;
106
107ALTER TABLE public."Role"
108    OWNER to postgres;
109
110
111
112-- Table: public."Permission"
113
114-- DROP TABLE public."Permission";
115
116CREATE TABLE public."Permission"
117(
118    id SERIAL,
119    idx uuid NOT NULL DEFAULT uuid_generate_v1(),
120    base_name text NOT NULL,
121    url text COLLATE pg_catalog."default" NOT NULL,
122    method text COLLATE pg_catalog."default" NOT NULL,
123    created_on timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
124    modified_on timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
125    is_obsolete boolean NOT NULL,
126    CONSTRAINT "Permission_pkey" PRIMARY KEY (id)
127)
128WITH (
129    OIDS = FALSE
130)
131TABLESPACE pg_default;
132
133ALTER TABLE public."Permission"
134    OWNER to postgres;
135
136
137
138-- Table: public."CompanyUser"
139
140-- DROP TABLE public."CompanyUser";
141
142CREATE TABLE public."CompanyUser"
143(
144    id SERIAL,
145    idx uuid NOT NULL DEFAULT uuid_generate_v1(),
146    company_idx uuid NOT NULL,
147    auth_id bigint,
148    username text COLLATE pg_catalog."default" NOT NULL,
149    password text COLLATE pg_catalog."default" NOT NULL,
150    is_active boolean NOT NULL,
151    created_on timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
152    is_obsolete boolean NOT NULL,
153    modified_on timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
154    CONSTRAINT "CompanyUser_pkey" PRIMARY KEY (id),
155    CONSTRAINT "fk_auth_id" FOREIGN KEY (auth_id)
156        REFERENCES public."Auth" (id) MATCH SIMPLE
157        ON UPDATE NO ACTION
158        ON DELETE NO ACTION
159)
160WITH (
161    OIDS = FALSE
162)
163TABLESPACE pg_default;
164
165ALTER TABLE public."CompanyUser"
166    OWNER to postgres;
167
168
169
170
171-- Table: public."UserLog"
172
173-- DROP TABLE public."UserLog";
174
175CREATE TABLE public."UserLog"
176(
177    id SERIAL,,
178    idx uuid DEFAULT uuid_generate_v1(),
179    company_user_id bigint,
180    ip_address text COLLATE pg_catalog."default" NOT NULL,
181    user_agent text COLLATE pg_catalog."default" NOT NULL,
182    created_on timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
183    is_obsolete boolean NOT NULL DEFAULT false,
184    modified_on timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
185    CONSTRAINT userlog_pkey PRIMARY KEY (id),
186    CONSTRAINT fk_company_user_id FOREIGN KEY (company_user_id)
187        REFERENCES public."CompanyUser" (id) MATCH SIMPLE
188        ON UPDATE NO ACTION
189        ON DELETE NO ACTION
190)
191WITH (
192    OIDS = FALSE
193)
194TABLESPACE pg_default;
195
196ALTER TABLE public."UserLog"
197    OWNER to postgres;
198
199
200
201
202-- Table: public."UserRole"
203
204-- DROP TABLE public."UserRole";
205
206CREATE TABLE public."UserRole"
207(
208    id SERIAL,
209    idx uuid NOT NULL DEFAULT uuid_generate_v1(),
210    role_id bigint NOT NULL,
211    company_user_id bigint NOT NULL,
212    created_on timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
213    is_obsolete boolean NOT NULL DEFAULT false,
214    modified_on timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
215    CONSTRAINT "UserRole_pkey" PRIMARY KEY (id),
216    CONSTRAINT fk_company_user_id FOREIGN KEY (company_user_id)
217        REFERENCES public."CompanyUser" (id) MATCH SIMPLE
218        ON UPDATE NO ACTION
219        ON DELETE NO ACTION,
220    CONSTRAINT fk_role_id FOREIGN KEY (role_id)
221        REFERENCES public."Role" (id) MATCH SIMPLE
222        ON UPDATE NO ACTION
223        ON DELETE NO ACTION
224)
225WITH (
226    OIDS = FALSE
227)
228TABLESPACE pg_default;
229
230ALTER TABLE public."UserRole"
231    OWNER to postgres;
232
233
234
235
236-- Table: public."UserActionLock"
237
238-- DROP TABLE public."UserActionLock";
239
240CREATE TABLE public."UserActionLock"
241(
242    id SERIAL,
243    idx uuid NOT NULL DEFAULT uuid_generate_v1(),
244    company_user_id bigint NOT NULL,
245    lock_rule_id bigint NOT NULL,
246    lock_count integer NOT NULL,
247    tries integer NOT NULL,
248	locked_at  timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
249    created_on timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
250    is_obsolete bigint,
251    modified_on timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
252    CONSTRAINT "UserActionLock_pkey" PRIMARY KEY (id),
253    CONSTRAINT fk_company_user_id FOREIGN KEY (company_user_id)
254        REFERENCES public."CompanyUser" (id) MATCH SIMPLE
255        ON UPDATE NO ACTION
256        ON DELETE NO ACTION,
257    CONSTRAINT fk_lock_rule_id FOREIGN KEY (lock_rule_id)
258        REFERENCES public."LockRule" (id) MATCH SIMPLE
259        ON UPDATE NO ACTION
260        ON DELETE NO ACTION
261)
262WITH (
263    OIDS = FALSE
264)
265TABLESPACE pg_default;
266
267ALTER TABLE public."UserActionLock"
268    OWNER to postgres;
269
270
271
272
273-- Table: public."PermissionRole"
274
275-- DROP TABLE public."PermissionRole";
276
277CREATE TABLE public."PermissionRole"
278(
279    id SERIAL,
280    idx uuid NOT NULL DEFAULT uuid_generate_v1(),
281    role_id bigint NOT NULL,
282    permission_id bigint NOT NULL,
283    created_on timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
284    is_obsolete boolean NOT NULL DEFAULT false,
285    modified_on timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
286    CONSTRAINT "PermissionRole_pkey" PRIMARY KEY (id),
287    CONSTRAINT fk_permission_id FOREIGN KEY (permission_id)
288        REFERENCES public."Permission" (id) MATCH SIMPLE
289        ON UPDATE NO ACTION
290        ON DELETE NO ACTION,
291    CONSTRAINT fk_role_id FOREIGN KEY (role_id)
292        REFERENCES public."Role" (id) MATCH SIMPLE
293        ON UPDATE NO ACTION
294        ON DELETE NO ACTION
295)
296WITH (
297    OIDS = FALSE
298)
299TABLESPACE pg_default;
300
301ALTER TABLE public."PermissionRole"
302    OWNER to postgres;