.blueprint

created:
    - database/factories/CustomerFactory.php
    - database/factories/SupplierFactory.php
    - database/factories/CategoryFactory.php
    - database/factories/SubCategoryFactory.php
    - database/factories/ProductFactory.php
    - database/factories/PaymentTypeFactory.php
    - database/factories/PurchaseOrderFactory.php
    - database/factories/PurchaseOrderItemFactory.php
    - database/factories/SaleFactory.php
    - database/factories/SaleItemFactory.php
    - database/factories/SettingFactory.php
    - database/migrations/2024_06_03_223116_create_customers_table.php
    - database/migrations/2024_06_03_223117_create_suppliers_table.php
    - database/migrations/2024_06_03_223118_create_categories_table.php
    - database/migrations/2024_06_03_223119_create_sub_categories_table.php
    - database/migrations/2024_06_03_223120_create_products_table.php
    - database/migrations/2024_06_03_223121_create_payment_types_table.php
    - database/migrations/2024_06_03_223122_create_purchase_orders_table.php
    - database/migrations/2024_06_03_223123_create_purchase_order_items_table.php
    - database/migrations/2024_06_03_223124_create_sales_table.php
    - database/migrations/2024_06_03_223125_create_sale_items_table.php
    - database/migrations/2024_06_03_223126_create_settings_table.php
    - app/Models/Customer.php
    - app/Models/Supplier.php
    - app/Models/Category.php
    - app/Models/SubCategory.php
    - app/Models/Product.php
    - app/Models/PaymentType.php
    - app/Models/PurchaseOrder.php
    - app/Models/PurchaseOrderItem.php
    - app/Models/Sale.php
    - app/Models/SaleItem.php
    - app/Models/Setting.php
models:
    User: {  }
    Customer: { name: string, email: 'string nullable', phone: 'string nullable', address: text, status: 'enum:active,inactive', gender: 'enum:male,female', relationships: { hasMany: Sale, belongsTo: User } }
    Supplier: { company_name: string, contact_person: string, email: 'string nullable', phone: 'string nullable', status: 'enum:active,inactive', relationships: { belongsTo: User } }
    Category: { name: string, description: 'text nullable', status: 'enum:active,inactive', relationships: { hasMany: SubCategory } }
    SubCategory: { name: string, description: 'text nullable', status: 'enum:active,inactive', relationships: { belongsTo: Category } }
    Product: { sku: 'string unique', name: string, purchase_price: decimal, selling_price: decimal, description: 'text nullable', status: 'enum:active,inactive' }
    PaymentType: { name: string, description: 'text nullable' }
    PurchaseOrder: { purchase_code: 'string unique', order_date: date, expected_delivery_date: 'date nullable', status: 'enum:pending,received,partially_received,cancelled', total_amount: decimal, paid_amount: decimal, relationships: { belongsTo: 'Supplier, PaymentType, User', hasMany: PurchaseOrderItem } }
    PurchaseOrderItem: { sku: string, name: string, quantity: integer, unit_cost: decimal, relationships: { belongsTo: 'PurchaseOrder, Product' } }
    Sale: { invoice_number: string, sale_date: date, vat: double, total_amount: decimal, paid_amount: decimal, relationships: { belongsTo: 'Customer, PaymentType, User', hasMany: SaleItem } }
    SaleItem: { sku: string, name: string, quantity: integer, unit_cost: decimal, relationships: { belongsTo: 'Sale, Product' } }
    Setting: { company_name: string, phone: string, email: string, address: text, currency: string }