asdf
Tables (6)
block
- block_id — bigint — Primary key — NOT NULL
- file_version_id — bigint — Foreign key → file_version.id — NOT NULL
- block_order — int
device
- device_id — uuid — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- last_logged_in_at — timestamp
file
- id — bigint — Primary key — NOT NULL
- file_name — varchar(255)
- relative_path — varchar(1024)
- is_directory — boolean
- lastest_version — bigint
- checksum — bigint
- namespace_id — bigint — Foreign key → namespace.id — NOT NULL
- created_at — timestamp
- last_modified — timestamp
file_version
- id — bigint — Primary key — NOT NULL
- file_id — bigint — Foreign key → file.id — NOT NULL
- device_id — uuid — Foreign key → device.device_id
- version_number — bigint
- last_modified — timestamp
namespace (workspace)
- id — bigint — Primary key — NOT NULL
- owner_id — bigint — Foreign key → user.user_id — NOT NULL
- is_shared — boolean
- created_at — timestamp
user
- user_id — bigint — Primary key — NOT NULL
- user_name — varchar(255)
- created_at — timestamp