0% found this document useful (0 votes)
3 views2 pages

Database Schema for User Assets

Uploaded by

developerabhi17
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
3 views2 pages

Database Schema for User Assets

Uploaded by

developerabhi17
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

users documents

0..1
id uuid id uuid
*
name varchar asset_id uuid

email varchar version int

profile_image varchar size bigint

created_at timestamp checksum varchar


*
updated_at timestamp created_by uuid

created_at timestamp

updated_at timestamp

assets
0..1
id uuid
links
name varchar
id uuid
type enum(file,folder)
*
asset_id uuid
subtype varchar
*
created_by uuid
no_of_files int
link_token varchar
color varchar
access_type enum(public,restricted)
is_important boolean
allowed_emails json
last_accessed_at timestamp
* expires_at timestamp
folder_id uuid
* created_at timestamp
owner_id uuid
updated_at timestamp
s3_key varchar

created_at timestamp

updated_at timestamp
users documents
0..1
id uuid id uuid
*
name varchar asset_id uuid

email varchar version int

profile_image varchar size bigint

created_at timestamp checksum varchar


*
updated_at timestamp created_by uuid

created_at timestamp

updated_at timestamp

assets
0..1
id uuid
links
name varchar
id uuid
type enum(file,folder)
*
asset_id uuid
subtype varchar
*
created_by uuid
no_of_files int
link_token varchar
color varchar
access_type enum(public,restricted)
is_important boolean
allowed_emails json
last_accessed_at timestamp
* expires_at timestamp
folder_id uuid
* created_at timestamp
owner_id uuid
updated_at timestamp
s3_key varchar

created_at timestamp

updated_at timestamp

You might also like