Datenbank
=========

.. code-block::mermaid

    erDiagram
        lending_requests {
            bigint(20) id
            varchar(255) username
            varchar(255) name
            varchar(255) email
            varchar(255) phone
            varchar(255) address
            varchar(255) organization
            varchar(255) project_name
            longtext project_description
            date project_begin
            date project_end
            datetime pickup
            datetime return
            longtext notes
            tinyint(1) terms_accepted "boolean"
            longtext items "JSON"
            varchar(255) status
            decimal deposit "(8,2)"
            datetime deposit_paid_date
            varchar(255) deposit_paid_name
            datetime ab_ok_date
            varchar(255) ab_name
            datetime hv_ok_date
            varchar(255) hv_name
            datetime reject_date
            varchar(255) reject_name
            longtext reject_reason
            int(11) group_id
            longtext messages
        }
        
        items {
            bigint(20) item_id
            varchar(255) item_title
            longtext item_description
            longtext item_condition
            int(11) item_category
            int(11) item_place
            int(11) item_group
            int(11) item_number
            date date_of_receipt
            date date_of_retirement
            date date_of_accounting
            decimal acquisition_cost "(8,2)"
            longtext project "JSON"
            longtext receipt "JSON"
            varchar(255) supplier
            date guarantee_until
            date next_technical_inspection
            tinyint(1) borrowable "boolean"
            int(11) parent_item
            longtext image "JSON"
        }
        
        categories {
            bigint(20) category_id
            varchar(255) category_title
            longtext category_description
        }
        
        groups {
            bigint(20) group_id
            varchar(255) group_title
            longtext group_description
            varchar(255) group_email
            longtext group_roles
        }
        
        places {
            bigint(20) place_id
            varchar(255) place_title
            longtext place_description
            decimal latitude "(9,6)"
            decimal longitude "(9,6)"
        }
        
        items }|--|| categories : belongsTo
        items }|--|| places : isAt
        items }|--|| groups : belongsTo
        lending_requests }|--|| groups : belongsTo
        lending_requests }|--|{ items : contains