|
|
| Table name | Field name | Field type | Primary key | Index #01 | Index #02 | % not Null | Most positive | Oldest date | Newest date | Longest string |
|---|---|---|---|---|---|---|---|---|---|---|
| Animals | ID | INTEGER | ✔ | 100 | 6 | |||||
| Name | VARCHAR_IGNORECASE | ASC | 100 | 8 | ||||||
| P_T | P_ID | INTEGER | ✔ | ASC | 100 | 8 | ||||
| T_ID | INTEGER | ✔ | ASC | 100 | 4 | |||||
| Persons | AnimalID | INTEGER | ASC | 100 | 4 | |||||
| Date | DATE | ASC | 100 | 08/08/1937 | 22/02/2022 | |||||
| ID | INTEGER | ✔ | 100 | 8 | ||||||
| Name | VARCHAR_IGNORECASE | ASC | 100 | 7 | ||||||
| Name2 | VARCHAR | ASC | 100 | 9 | ||||||
| Things | ID | INTEGER | ✔ | 100 | 4 | |||||
| Name | VARCHAR_IGNORECASE | ASC | 100 | 11 |