UserPortfolio

53 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"UserPortfolio_id_seq"'::regclass)
uuid uuid 2147483647 null
userId int4 10 null
User.id Implied Constraint R
Bio text 2147483647 √ null
ctaName varchar 255 √ null
ctaNameSecond varchar 255 √ null
ctaLink varchar 255 √ null
ctaLinkSecond varchar 255 √ null
portfolioProject jsonb 2147483647 √ '[]'::jsonb
portfolioBlog jsonb 2147483647 √ '[]'::jsonb
skills jsonb 2147483647 √ '[]'::jsonb
createdBy int4 10 null
updatedBy int4 10 √ null
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
testimonials jsonb 2147483647 √ null
soicalLinks jsonb 2147483647 √ null
designation varchar 255 √ null
faviconUrl jsonb 2147483647 √ null
featuredImage jsonb 2147483647 √ null
seoTitle varchar 255 √ null
customDomain varchar 255 √ null
uniqueSlug varchar 255 √ null
metaDescription text 2147483647 √ null
city varchar 255 √ null
location varchar 255 √ null
accomplishments jsonb 2147483647 √ null
experiance jsonb 2147483647 √ null
deleteAllAccomplishment bool 1 √ false
deleteAllexperiance bool 1 √ false
isPublished bool 1 √ false
contactMe varchar 255 √ null
isPublishedPopup bool 1 √ false
portfolioStatus varchar 255 √ 'Pending'::character varying
remarks varchar 255 √ null
portfolioLiveCount int4 10 √ null
liveLink varchar 255 √ null
customDomainData jsonb 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
UserPortfolio_pkey Primary key Asc id
UserPortfolio_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation