By Anonymous - December 18, 2025
churchaddress table
Go back to ahsmaster schema page
This table contains addresses for churches. Note this is a many-to-one relationship.
| column_name | data_type |
|---|---|
| cid | int |
| Type | varchar(30) |
| Description | varchar(20) |
| Confirmation | bit |
| Addressee | varchar(50) |
| Address | varchar(50) |
| City | varchar(50) |
| State | char(2) |
| Zip | varchar(20) |
| UniqueID | int |
| Comments | text(65535) |
| Lat | varchar(20) |
| Lon | varchar(20) |
| GoogleFormattedAddress | varchar(255) |
| GeocodingResultCount | int |