ER diagram

erDiagram

    FILE_METADATA {
        BIGINT file_metadata_id PK
        BIGINT root_id
        BIGINT creator_id
        BIGINT owner_id
        VARCHAR(50) file_type
        TIMESTAMP created_at
        TIMESTAMP updated_at
        BIGINT parent_folder_id
        BIGINT file_size
        VARCHAR(100) upload_file_name
        VARCHAR(100) uuid_file_name
        VARCHAR(30) upload_status
        TINYINT(1) is_shared
        TIMESTAMP sharing_expired_at
        VARCHAR(10) permission_type
    }

    FOLDER_METADATA {
        BIGINT folder_metadata_id PK
        BIGINT root_id
        BIGINT creator_id
        BIGINT owner_id
        TIMESTAMP created_at
        TIMESTAMP updated_at
        BIGINT parent_folder_id
        VARCHAR(100) upload_folder_name
        BIGINT folder_size
        TINYINT(1) is_shared
        TIMESTAMP sharing_expired_at
        VARCHAR(10) permission_type
    }

    SHARED_LINK {
        BIGINT shared_link_id PK
        TIMESTAMP created_at
        VARCHAR(300) redirect_url
        VARCHAR(100) shared_id
        BIGINT shared_user_id
        TIMESTAMP expired_at
        TINYINT(1) is_file
        BIGINT target_id
        VARCHAR(10) permission_type
    }

Loading