dd

Tables (18)

batch_job_queues

  • batch_job_id — bigint
  • job_type — varchar(50) — NOT NULL
  • target_table — varchar(64) — NOT NULL
  • target_id — bigint — NOT NULL
  • status — varchar(15) — NOT NULL
  • job_data — json — NOT NULL
  • retry_count — int — NOT NULL
  • started_at — datetime
  • created_at — datetime — NOT NULL
  • finished_at — datetime

capacity_allocations

  • allocation_id — bigint — Foreign key → capacity_allocations.granter_allocation_id
  • granter_allocation_id — bigint
  • receiver_permission_id — bigint — Foreign key → file_permission_keys.file_permission_id — NOT NULL
  • giver_permission_id — bigint — Foreign key → file_permission_keys.file_permission_id
  • allocated_size — bigint — NOT NULL
  • expiration_date — datetime
  • allocation_type — varchar(20) — NOT NULL
  • description — varchar(100)
  • deleted_at — datetime
  • group_id — bigint — Foreign key → file_permission_keys.group_id
  • user_id (user_id2) — bigint — Foreign key → file_permission_keys.user_id

file_permission_keys

  • file_permission_id — bigint — Foreign key → groups.file_permission_id
  • parent_permission_id — bigint
  • owner_type — varchar(10) — NOT NULL
  • total_capacity — bigint — NOT NULL
  • available_capacity — bigint — NOT NULL
  • deleted_at — datetime
  • group_id — bigint — Foreign key → groups.group_id
  • user_id (user_id2) — bigint — Foreign key

group_invites

  • share_link_id — bigint
  • group_id — bigint — Foreign key → groups.group_id — NOT NULL
  • group_id (group_id2) — bigint — Foreign key → groups.group_id
  • user_id (user_id2) — bigint — Foreign key

group_user_permissions

  • group_user_id — bigint
  • can_manage_user — boolean — NOT NULL
  • can_manage_file — boolean — NOT NULL

group_users

  • group_user_id — bigint — Foreign key → group_user_permissions.group_user_id
  • group_id — bigint — Foreign key → groups.group_id
  • user_id — bigint — Foreign key → users.user_id
  • read_level — int — NOT NULL
  • write_level — int — NOT NULL
  • deleted_at — datetime
  • group_id (group_id2) — bigint — Foreign key → groups.group_id
  • user_id (user_id2) — bigint — Foreign key → users.user_id

groups

  • group_id — bigint — Primary key
  • file_permission_id — bigint — NOT NULL
  • owner_id — bigint — Foreign key → users.user_id — NOT NULL
  • name — varchar(50) — NOT NULL
  • max_member_count — int — NOT NULL
  • current_member_count — int — NOT NULL
  • deleted_at — datetime

real_files

  • real_file_id — bigint
  • storage_uuid — varchar(32) — NOT NULL
  • file_hash — char(64) — NOT NULL
  • file_size — bigint — NOT NULL
  • storage_path — varchar(255) — NOT NULL
  • storage_type — varchar(10) — NOT NULL
  • reference_count — int — NOT NULL
  • deleted_at — datetime

share_directories

  • share_directory_id — bigint — Foreign key → share_directories.parent_directory_id
  • share_link_id — bigint — Foreign key → share_links.share_link_id — NOT NULL
  • parent_directory_id — bigint
  • name — varchar(100) — NOT NULL
  • depth_level — int — NOT NULL
  • deleted_at — datetime
  • group_id (group_id2) — bigint — Foreign key → share_links.group_id
  • user_id (user_id2) — bigint — Foreign key → share_links.user_id

share_files

  • share_file_id — bigint
  • share_directory_id — bigint — Foreign key → share_directories.share_directory_id — NOT NULL
  • virtual_file_id — bigint — Foreign key → virtual_files.virtual_file_id — NOT NULL
  • name — varchar(100) — NOT NULL
  • extension — varchar(50)
  • deleted_at — datetime
  • group_id — bigint — Foreign key → virtual_files.group_id
  • user_id (user_id2) — bigint — Foreign key → share_directories.user_id

share_links

  • share_link_id — bigint — Foreign key → group_invites.share_link_id
  • user_id — bigint — Foreign key → users.user_id
  • share_uuid — varchar(32) — NOT NULL
  • link_type — varchar(15) — NOT NULL
  • expiration_date — datetime — NOT NULL
  • password — varchar(255)
  • max_use_count — int — NOT NULL
  • current_use_count — int — NOT NULL
  • name — varchar(50) — NOT NULL
  • deleted_at — datetime
  • group_id (group_id2) — bigint — Foreign key → group_invites.group_id
  • user_id (user_id2) — bigint — Foreign key → users.user_id

upload_parts

  • part_id — bigint
  • session_id — bigint — Foreign key → upload_sessions.session_id — NOT NULL
  • part_number — int — NOT NULL
  • part_size — int — NOT NULL
  • etag — varchar(100)
  • group_id — bigint — Foreign key → upload_sessions.group_id
  • user_id (user_id2) — bigint — Foreign key → upload_sessions.user_id

upload_sessions

  • session_id — bigint
  • file_permission_id — bigint — Foreign key → file_permission_keys.file_permission_id — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • session_uuid — varchar(32) — NOT NULL
  • total_parts — int — NOT NULL
  • total_size — bigint — NOT NULL
  • upload_task_id — varchar(255)
  • local_path — varchar(255)
  • last_active_at — datetime — NOT NULL
  • group_id — bigint — Foreign key → file_permission_keys.group_id
  • user_id (user_id2) — bigint — Foreign key → users.user_id

user_permissions

  • user_id — bigint — Primary key
  • can_invite_person — boolean — NOT NULL
  • can_share_file — boolean — NOT NULL
  • can_store_personal — boolean — NOT NULL
  • can_create_group — boolean — NOT NULL

users

  • user_id — bigint — Foreign key → user_permissions.user_id
  • file_permission_id — bigint — NOT NULL
  • inviter_id — bigint
  • login_id — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • email — varchar(50) — NOT NULL
  • created_at — datetime
  • deleted_at — datetime
  • user_id (user_id2) — bigint — Foreign key → user_permissions.user_id

virtual_directories

  • directory_id — bigint — Foreign key → virtual_directory_stats.directory_id
  • file_permission_id — bigint — Foreign key → file_permission_keys.file_permission_id — NOT NULL
  • parent_directory_id — bigint
  • read_level — int — NOT NULL
  • write_level — int — NOT NULL
  • name — varchar(100) — NOT NULL
  • depth_level — int — NOT NULL
  • deleted_at — datetime
  • group_id — bigint — Foreign key → file_permission_keys.group_id
  • user_id (user_id2) — bigint — Foreign key → file_permission_keys.user_id

virtual_directory_stats

  • directory_id — bigint
  • total_size — bigint — NOT NULL
  • directory_count — int — NOT NULL
  • file_count — int — NOT NULL

virtual_files

  • virtual_file_id — bigint
  • directory_id — bigint — Foreign key → virtual_directories.directory_id — NOT NULL
  • real_file_id — bigint — Foreign key → real_files.real_file_id — NOT NULL
  • read_level — int — NOT NULL
  • write_level — int — NOT NULL
  • name — varchar(100) — NOT NULL
  • extension — varchar(50)
  • deleted_at — datetime
  • group_id — bigint — Foreign key → virtual_directories.group_id
  • user_id (user_id2) — bigint — Foreign key → virtual_directories.user_id