> ## Documentation Index > Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt > Use this file to discover all available pages before exploring further. # udprojectSmall table > User-defined fields ## udprojectSmall Table (142) User-defined fields ## Fields | Name | Description | Type | Nullable | | ------------------ | ---------------------------- | ---------- | :------: | | udprojectSmall\_id | Primary key | PK | No | | long01 | long value 1, indexed | Id | Yes | | long02 | long value 2, indexed | Id | Yes | | long03 | long value 3, indexed | Id | Yes | | long04 | long value 4, indexed | Id | Yes | | long05 | long value 5, not indexed | Id | Yes | | long06 | long value 6, not indexed | Id | Yes | | long07 | long value 7, not indexed | Id | Yes | | long08 | long value 8, not indexed | Id | Yes | | long09 | long value 9, not indexed | Id | Yes | | long10 | long value 10, not indexed | Id | Yes | | long11 | long value 11, not indexed | Id | Yes | | long12 | long value 12, not indexed | Id | Yes | | long13 | long value 13, not indexed | Id | Yes | | long14 | long value 14, not indexed | Id | Yes | | long15 | long value 15, not indexed | Id | Yes | | long16 | long value 16, not indexed | Id | Yes | | long17 | long value 17, not indexed | Id | Yes | | long18 | long value 18, not indexed | Id | Yes | | long19 | long value 19, not indexed | Id | Yes | | long20 | long value 20, not indexed | Id | Yes | | long21 | long value 21, not indexed | Id | Yes | | long22 | long value 22, not indexed | Id | Yes | | long23 | long value 23, not indexed | Id | Yes | | long24 | long value 24, not indexed | Id | Yes | | long25 | long value 25, not indexed | Id | Yes | | long26 | long value 26, not indexed | Id | Yes | | long27 | long value 27, not indexed | Id | Yes | | long28 | long value 28, not indexed | Id | Yes | | long29 | long value 29, not indexed | Id | Yes | | long30 | long value 30, not indexed | Id | Yes | | long31 | long value 31, not indexed | Id | Yes | | long32 | long value 32, not indexed | Id | Yes | | long33 | long value 33, not indexed | Id | Yes | | long34 | long value 34, not indexed | Id | Yes | | long35 | long value 35, not indexed | Id | Yes | | long36 | long value 36, not indexed | Id | Yes | | long37 | long value 37, not indexed | Id | Yes | | long38 | long value 38, not indexed | Id | Yes | | long39 | long value 39, not indexed | Id | Yes | | long40 | long value 40, not indexed | Id | Yes | | long41 | long value 41, not indexed | Id | Yes | | long42 | long value 42, not indexed | Id | Yes | | long43 | long value 43, not indexed | Id | Yes | | long44 | long value 44, not indexed | Id | Yes | | long45 | long value 45, not indexed | Id | Yes | | long46 | long value 46, not indexed | Id | Yes | | long47 | long value 47, not indexed | Id | Yes | | long48 | long value 48, not indexed | Id | Yes | | long49 | long value 49, not indexed | Id | Yes | | long50 | long value 50, not indexed | Id | Yes | | long51 | long value 51, not indexed | Id | Yes | | long52 | long value 52, not indexed | Id | Yes | | long53 | long value 53, not indexed | Id | Yes | | long54 | long value 54, not indexed | Id | Yes | | long55 | long value 55, not indexed | Id | Yes | | long56 | long value 56, not indexed | Id | Yes | | long57 | long value 57, not indexed | Id | Yes | | long58 | long value 58, not indexed | Id | Yes | | long59 | long value 59, not indexed | Id | Yes | | long60 | long value 60, not indexed | Id | Yes | | string01 | string value 1, indexed | String(39) | Yes | | string02 | string value 2, indexed | String(39) | Yes | | string03 | string value 3, indexed | String(39) | Yes | | string04 | string value 4, indexed | String(39) | Yes | | string05 | string value 5, not indexed | String(39) | Yes | | string06 | string value 6, not indexed | String(39) | Yes | | string07 | string value 7, not indexed | String(39) | Yes | | string08 | string value 8, not indexed | String(39) | Yes | | string09 | string value 9, not indexed | String(39) | Yes | | string10 | string value 10, not indexed | String(39) | Yes | | string11 | string value 11, not indexed | String(39) | Yes | | string12 | string value 12, not indexed | String(39) | Yes | | string13 | string value 13, not indexed | String(39) | Yes | | string14 | string value 14, not indexed | String(39) | Yes | | string15 | string value 15, not indexed | String(39) | Yes | | string16 | string value 16, not indexed | String(39) | Yes | | string17 | string value 17, not indexed | String(39) | Yes | | string18 | string value 18, not indexed | String(39) | Yes | | string19 | string value 19, not indexed | String(39) | Yes | | string20 | string value 20, not indexed | String(39) | Yes | | string21 | string value 21, not indexed | String(39) | Yes | | string22 | string value 22, not indexed | String(39) | Yes | | string23 | string value 23, not indexed | String(39) | Yes | | string24 | string value 24, not indexed | String(39) | Yes | | string25 | string value 25, not indexed | String(39) | Yes | | string26 | string value 26, not indexed | String(39) | Yes | | string27 | string value 27, not indexed | String(39) | Yes | | string28 | string value 28, not indexed | String(39) | Yes | | string29 | string value 29, not indexed | String(39) | Yes | | string30 | string value 30, not indexed | String(39) | Yes | | string31 | string value 31, not indexed | String(39) | Yes | | string32 | string value 32, not indexed | String(39) | Yes | | string33 | string value 33, not indexed | String(39) | Yes | | string34 | string value 34, not indexed | String(39) | Yes | | string35 | string value 35, not indexed | String(39) | Yes | | string36 | string value 36, not indexed | String(39) | Yes | | string37 | string value 37, not indexed | String(39) | Yes | | string38 | string value 38, not indexed | String(39) | Yes | | string39 | string value 39, not indexed | String(39) | Yes | | string40 | string value 40, not indexed | String(39) | Yes | | double01 | double value 1, indexed | Double | Yes | | double02 | double value 2, indexed | Double | Yes | | double03 | double value 3, indexed | Double | Yes | | double04 | double value 4, indexed | Double | Yes | | double05 | double value 5, not indexed | Double | Yes | | double06 | double value 6, not indexed | Double | Yes | | double07 | double value 7, not indexed | Double | Yes | | double08 | double value 8, not indexed | Double | Yes | | double09 | double value 9, not indexed | Double | Yes | | double10 | double value 10, not indexed | Double | Yes | udprojectSmall table relationship diagram ## Indexes | Fields | Types | Description | | -------- | ---------- | ----------- | | long01 | Id | Index | | long02 | Id | Index | | long03 | Id | Index | | long04 | Id | Index | | string01 | String(39) | Index | | string02 | String(39) | Index | | string03 | String(39) | Index | | string04 | String(39) | Index | | double01 | Double | Index | | double02 | Double | Index | | double03 | Double | Index | | double04 | Double | Index | ## Relationships | Table | Description | | -------------------- | ----------- | | [project](./project) | Projects | ## Replication Flags * Area Management controlled table. Contents replicated to satellites and traveller databases. * Replicate changes UP from satellites and travellers back to central. * Copy to satellite and travel prototypes. ## Security Flags * Sentry controls access to items in this table using user's Role and data rights matrix on the table's parent. ## Related topics - [Working with custom objects and fields in API](/en/custom-objects/reference/index.md) - [project table](/en/database/tables/project.md) - [udprojectLarge table](/en/database/tables/udprojectlarge.md) - [SuperOffice.WebApi.Data.UserPreferenceStrings.FieldReplication](/en/api/reference/webapi/SuperOffice.WebApi.Data.UserPreferenceStrings.FieldReplication.md) - [udtempSmall table](/en/database/tables/udtempsmall.md) - [udpersonSmall table](/en/database/tables/udpersonsmall.md)