· 7 years ago · Jan 30, 2019, 04:44 AM
1-- Table: public.vsalibrary
2
3-- DROP TABLE public.vsalibrary;
4
5CREATE TABLE if not exists public.vsalibrary
6(
7 Id uuid PRIMARY KEY,
8 EngagementId uuid,
9 BussinessProcessId uuid not NULL,
10 FileObjectId TEXT,
11 FileName varchar(255) ,
12 ImageObjectId TEXT,
13 IsActive boolean DEFAULT false,
14 TemplateId uuid not NULL,
15 CreatedUser UUID not NULL,
16 CreatedTime timestamp without time zone NOT NULL,
17 LastSavedTime timestamp without time zone NOT NULL,
18 LastSavedUser UUID not NULL
19 -- CONSTRAINT vsalibrary_pk PRIMARY KEY (Id)
20)
21WITH (
22 OIDS = FALSE
23)
24TABLESPACE pg_default;
25
26ALTER TABLE public.vsalibrary
27 OWNER to postgres;