# AnniesApp table inventory

Generated: 2026-06-28 23:07
Database: `C:\Users\josh\Documents\projects\sync_coordinator\AnniesApp.mdb`

## Summary

| Category | Count |
|----------|------:|
| Linked to Access backend (.mdb) | 0 |
| Linked to SQL Express (ODBC) | 37 |
| Local tables | 4 |
| System | 11 |

## Keep local (do not link to SQL Express)

- `UsysSqlConfig`
- `Switchboard Items`
- `tblDeliveryNoteItemORIG`

## Linked to Access backend - relink to SQL Express

_None._

## Linked to SQL Express (ODBC)

| Table | Remote source |
|-------|---------------|
| adn | dbo.adn |
| adni | dbo.adni |
| tblCategory | dbo.tblCategory |
| tblColour | dbo.tblColour |
| tblConCategory | dbo.tblConCategory |
| tblConSubCategory | dbo.tblConSubCategory |
| tblConsumable | dbo.tblConsumable |
| tblCustomer | dbo.tblCustomer |
| tblCustomerBlockReason | dbo.tblCustomerBlockReason |
| tblCustomerType | dbo.tblCustomerType |
| tblDeliveryNote | dbo.tblDeliveryNote |
| tblDeliveryNoteItem | dbo.tblDeliveryNoteItem |
| tblDeliveryNoteItemCon | dbo.tblDeliveryNoteItemCon |
| tblDepartment | dbo.tblDepartment |
| tblDN_NotInvoiced | dbo.tblDN_NotInvoiced |
| tblFabric | dbo.tblFabric |
| tblGoodsType | dbo.tblGoodsType |
| tblInvoice | dbo.tblInvoice |
| tblInvoiceItem | dbo.tblInvoiceItem |
| tblItem | dbo.tblItem |
| tblJobType | dbo.tblJobType |
| tblLocation | dbo.tblLocation |
| tblOperator | dbo.tblOperator |
| tblOwner | dbo.tblOwner |
| tblPayment | dbo.tblPayment |
| tblPaymentType | dbo.tblPaymentType |
| tblProduct | dbo.tblProduct |
| tblQuote | dbo.tblQuote |
| tblQuoteItem | dbo.tblQuoteItem |
| tblSalesPerson | dbo.tblSalesPerson |
| tblSex | dbo.tblSex |
| tblStatement_Detail | dbo.tblStatement_Detail |
| tblSubCategory | dbo.tblSubCategory |
| tblSupplier | dbo.tblSupplier |
| tblSystem | dbo.tblSystem |
| tblWardrobePerson | dbo.tblWardrobePerson |
| tblWardrobePersonType | dbo.tblWardrobePersonType |

## Local tables

| Table | Keep local |
|-------|------------|
| Switchboard Items | yes |
| UsysDN | review |
| UsysIN | review |
| UsysSqlConfig | yes |