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