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