Data Table Structure

Back to AA Groups and Administration

Live SQL catalog

Current PGHAA Data Structure

This is the complete current inventory of tables and views in the PGHAA data domain. It is generated from the live MEGA / Allegheny SQL catalog rather than from an earlier hand-maintained schema snapshot.

15tables
2views
600columns
8foreign keys

Catalog snapshot: 2026-08-18T00:01:21Z. Included schemas: gso, pghaa, PGHAADZ, and wpaarea60. The separate WPRDC spatial catalog is outside this PGHAA inventory; [WPRDC PASDA].[001 - AddressPoints] is noted as an external logical dependency where relevant.

GSO source data

General Service Office group evidence used for canonical group linkage.

[gso].[groups]

Table

Source snapshot of General Service Office group identities, names, locations, retrieval evidence, and payload hashes.

13 columns747 current rowsschema modified 2026-08-10T07:07:46

  • PK PK_gso_groups: GSO_group_id
  • UQ UQ_gso_groups_internal_id: GSO_internal_id
Show every current column (13)
  1. 1 GSO_group_id Typechar(9) NullNOT NULL AttributesPK PK_gso_groups
  2. 2 GSO_group_name Typenvarchar(1000) NullNOT NULL Attributes—
  3. 3 GSO_legacy_service_number Typenvarchar(100) NullNULL Attributes—
  4. 4 GSO_internal_id Typenvarchar(100) NullNOT NULL AttributesUQ UQ_gso_groups_internal_id
  5. 5 GSO_city Typenvarchar(300) NullNULL Attributes—
  6. 6 GSO_state Typenvarchar(100) NullNULL Attributes—
  7. 7 GSO_postal_code Typenvarchar(40) NullNULL Attributes—
  8. 8 GSO_country Typenvarchar(100) NullNULL Attributes—
  9. 9 DZ_source_url Typenvarchar(2048) NullNOT NULL Attributes—
  10. 10 DZ_source_retrieved_at_utc Typedatetime2(0) NullNOT NULL Attributes—
  11. 11 GSO_source_payload Typenvarchar(max) NullNOT NULL Attributes—
  12. 12 GSO_source_response Typenvarchar(max) NullNOT NULL Attributes—
  13. 13 DZ_source_hash Typebinary(32) NullNOT NULL Attributes—

PGHAA source and content data

Published PGHAA source records plus website, people, page, and image inventories.

[pghaa].[current site map]

Table

Current PGHAA crawl inventory with HTTP, content, link, hash, and collection measurements.

25 columns71 current rowsschema modified 2026-08-04T13:13:58

  • PK PK_pghaa_current_site_map: DZ_site_map_id
Show every current column (25)
  1. 1 DZ_site_map_id Typebigint NullNOT NULL AttributesIDENTITY; PK PK_pghaa_current_site_map
  2. 2 DZ_crawl_run_id Typeuniqueidentifier NullNOT NULL Attributes—
  3. 3 PGHAA_url Typenvarchar(2048) NullNOT NULL Attributes—
  4. 4 DZ_url_hash Typebinary(32) NullNOT NULL Attributes—
  5. 5 PGHAA_final_url Typenvarchar(2048) NullNULL Attributes—
  6. 6 PGHAA_status_code Typesmallint NullNULL Attributes—
  7. 7 PGHAA_content_type Typenvarchar(255) NullNULL Attributes—
  8. 8 PGHAA_page_title Typenvarchar(1000) NullNULL Attributes—
  9. 9 PGHAA_meta_description Typenvarchar(2000) NullNULL Attributes—
  10. 10 PGHAA_canonical_url Typenvarchar(2048) NullNULL Attributes—
  11. 11 DZ_discovered_from_url Typenvarchar(2048) NullNULL Attributes—
  12. 12 DZ_crawl_depth Typeint NullNOT NULL Attributes—
  13. 13 DZ_is_html Typebit NullNOT NULL Attributes—
  14. 14 DZ_content_bytes Typebigint NullNULL Attributes—
  15. 15 DZ_word_count Typeint NullNULL Attributes—
  16. 16 DZ_h1_count Typeint NullNULL Attributes—
  17. 17 DZ_total_link_count Typeint NullNULL Attributes—
  18. 18 DZ_internal_link_count Typeint NullNULL Attributes—
  19. 19 DZ_external_link_count Typeint NullNULL Attributes—
  20. 20 PGHAA_last_modified_header Typenvarchar(255) NullNULL Attributes—
  21. 21 PGHAA_etag Typenvarchar(255) NullNULL Attributes—
  22. 22 DZ_content_sha256 Typechar(64) NullNULL Attributes—
  23. 23 DZ_crawled_at_utc Typedatetime2(0) NullNOT NULL Attributes—
  24. 24 DZ_error_message Typenvarchar(4000) NullNULL Attributes—
  25. 25 DZ_loaded_at_utc Typedatetime2(0) NullNOT NULL Attributesdefault (sysutcdatetime())

[pghaa].[Images Master]

Table

Master image inventory for PGHAA people pages, including WordPress media, local files, captions, provenance, and evidence.

19 columns90 current rowsschema modified 2026-08-14T17:17:41

  • PK PK_pghaa_Images_Master: ImageMasterId
  • UQ UQ_pghaa_Images_Master_PersonOrdinal: PersonMasterId, ImageOrdinal
  • FK PersonMasterId → [pghaa].[People Master].[PersonMasterId]
Show every current column (19)
  1. 1 ImageMasterId Typeint NullNOT NULL AttributesIDENTITY; PK PK_pghaa_Images_Master
  2. 2 PersonMasterId Typeint NullNOT NULL AttributesUQ UQ_pghaa_Images_Master_PersonOrdinal; FK → [pghaa].[People Master].[PersonMasterId]
  3. 3 ImageOrdinal Typeint NullNOT NULL AttributesUQ UQ_pghaa_Images_Master_PersonOrdinal
  4. 4 SourcePageUrl Typenvarchar(4000) NullNULL Attributes—
  5. 5 SourceImageUrl Typenvarchar(4000) NullNULL Attributes—
  6. 6 WpMediaId Typeint NullNULL Attributes—
  7. 7 ImageUrl Typenvarchar(4000) NullNOT NULL Attributes—
  8. 8 LocalPath Typenvarchar(2000) NullNOT NULL Attributes—
  9. 9 Caption Typenvarchar(2000) NullNOT NULL Attributes—
  10. 10 Description Typenvarchar(max) NullNOT NULL Attributes—
  11. 11 ImageOwnerKind Typenvarchar(100) NullNULL Attributes—
  12. 12 ImageProvenanceStatus Typenvarchar(200) NullNULL Attributes—
  13. 13 NormalizedUploadPath Typenvarchar(2000) NullNULL Attributes—
  14. 14 EvidencePageWpId Typeint NullNULL Attributes—
  15. 15 EvidencePageUrl Typenvarchar(4000) NullNULL Attributes—
  16. 16 EvidencePageTitle Typenvarchar(1020) NullNULL Attributes—
  17. 17 SourceResolvedBy Typenvarchar(200) NullNULL Attributes—
  18. 18 CreatedUtc Typedatetime2(6) NullNOT NULL Attributesdefault (sysutcdatetime())
  19. 19 UpdatedUtc Typedatetime2(6) NullNOT NULL Attributesdefault (sysutcdatetime())

[pghaa].[meetings]

Table

PGHAA-published meeting records with normalized schedule, access, category, geography, source, and GSO-linkage fields.

98 columns613 current rowsschema modified 2026-08-09T20:48:00

  • PK PK_pghaa_meetings: PGHAA_meeting_id
  • FK GSO_group_id → [gso].[groups].[GSO_group_id]
Show every current column (98)
  1. 1 PGHAA_meeting_id Typeint NullNOT NULL AttributesIDENTITY; PK PK_pghaa_meetings
  2. 2 DZ_day_number Typetinyint NullNOT NULL Attributes—
  3. 3 PGHAA_day Typevarchar(9) NullNOT NULL Attributes—
  4. 4 PGHAA_start_time Typetime(0) NullNOT NULL Attributes—
  5. 5 PGHAA_meeting_name Typenvarchar(500) NullNOT NULL Attributes—
  6. 6 DZ_attendance_type Typevarchar(20) NullNOT NULL Attributes—
  7. 7 PGHAA_meeting_details Typenvarchar(2000) NullNULL Attributes—
  8. 8 DZ_access_mode Typevarchar(20) NullNOT NULL Attributes—
  9. 9 PGHAA_venue_name Typenvarchar(500) NullNULL Attributes—
  10. 10 PGHAA_address Typenvarchar(1500) NullNULL Attributes—
  11. 11 PGHAA_locality Typenvarchar(255) NullNULL Attributes—
  12. 12 PGHAA_postal_code Typevarchar(10) NullNULL Attributes—
  13. 13 PGHAA_map_or_join_url Typenvarchar(2048) NullNULL Attributes—
  14. 14 PGHAA_link_text Typenvarchar(255) NullNULL Attributes—
  15. 15 PGHAA_zoom_meeting_id Typenvarchar(100) NullNULL Attributes—
  16. 16 PGHAA_zoom_password Typenvarchar(255) NullNULL Attributes—
  17. 17 PGHAA_phone_number Typenvarchar(100) NullNULL Attributes—
  18. 18 DZ_discussion Typebit NullNOT NULL Attributes—
  19. 19 DZ_speaker Typebit NullNOT NULL Attributes—
  20. 20 DZ_big_book Typebit NullNOT NULL Attributes—
  21. 21 DZ_beginners Typebit NullNOT NULL Attributes—
  22. 22 DZ_twelve_and_twelve Typebit NullNOT NULL Attributes—
  23. 23 DZ_step Typebit NullNOT NULL Attributes—
  24. 24 DZ_tradition Typebit NullNOT NULL Attributes—
  25. 25 DZ_chairs_choice Typebit NullNOT NULL Attributes—
  26. 26 DZ_literature Typebit NullNOT NULL Attributes—
  27. 27 DZ_meditation Typebit NullNOT NULL Attributes—
  28. 28 DZ_as_bill_sees_it Typebit NullNOT NULL Attributes—
  29. 29 DZ_grapevine Typebit NullNOT NULL Attributes—
  30. 30 DZ_daily_reflections Typebit NullNOT NULL Attributes—
  31. 31 DZ_living_sober Typebit NullNOT NULL Attributes—
  32. 32 DZ_plain_language_big_book Typebit NullNOT NULL Attributes—
  33. 33 DZ_text_study Typebit NullNOT NULL Attributes—
  34. 34 DZ_no_smoking Typebit NullNOT NULL Attributes—
  35. 35 DZ_no_vaping Typebit NullNOT NULL Attributes—
  36. 36 DZ_accessible Typebit NullNOT NULL Attributes—
  37. 37 DZ_women_only Typebit NullNOT NULL Attributes—
  38. 38 DZ_men_only Typebit NullNOT NULL Attributes—
  39. 39 DZ_young_people Typebit NullNOT NULL Attributes—
  40. 40 DZ_lgbt_friendly Typebit NullNOT NULL Attributes—
  41. 41 DZ_no_kids Typebit NullNOT NULL Attributes—
  42. 42 DZ_no_slips_signed Typebit NullNOT NULL Attributes—
  43. 43 DZ_spanish_speaking Typebit NullNOT NULL Attributes—
  44. 44 DZ_babysitting_available Typebit NullNOT NULL Attributes—
  45. 45 DZ_service_dogs_only Typebit NullNOT NULL Attributes—
  46. 46 DZ_women_nonbinary_welcome Typebit NullNOT NULL Attributes—
  47. 47 PGHAA_holiday_note Typenvarchar(255) NullNULL Attributes—
  48. 48 PGHAA_seasonal_note Typenvarchar(255) NullNULL Attributes—
  49. 49 PGHAA_source_attributes Typenvarchar(1000) NullNULL Attributes—
  50. 50 DZ_area_eastern_allegheny Typebit NullNOT NULL Attributes—
  51. 51 DZ_area_northern_allegheny Typebit NullNOT NULL Attributes—
  52. 52 DZ_area_south_hills Typebit NullNOT NULL Attributes—
  53. 53 DZ_area_western_allegheny Typebit NullNOT NULL Attributes—
  54. 54 DZ_area_beaver_lawrence_mercer Typebit NullNOT NULL Attributes—
  55. 55 DZ_area_butler_county Typebit NullNOT NULL Attributes—
  56. 56 DZ_area_washington_greene Typebit NullNOT NULL Attributes—
  57. 57 DZ_area_fayette_somerset Typebit NullNOT NULL Attributes—
  58. 58 DZ_area_westmoreland Typebit NullNOT NULL Attributes—
  59. 59 DZ_area_armstrong_jefferson_clarion_indiana Typebit NullNOT NULL Attributes—
  60. 60 DZ_area_city_pittsburgh Typebit NullNOT NULL Attributes—
  61. 61 DZ_area_monongahela_valley Typebit NullNOT NULL Attributes—
  62. 62 DZ_source_instance_count Typeint NullNOT NULL Attributes—
  63. 63 DZ_source_url Typenvarchar(2048) NullNOT NULL Attributes—
  64. 64 DZ_collected_at_utc Typedatetime2(0) NullNOT NULL Attributes—
  65. 67 PGHAA_end_time Typetime(0) NullNULL Attributes—
  66. 68 PGHAA_time_display Typenvarchar(100) NullNULL Attributes—
  67. 69 PGHAA_state Typevarchar(20) NullNULL Attributes—
  68. 70 PGHAA_country Typenvarchar(100) NullNULL Attributes—
  69. 71 PGHAA_latitude Typedecimal(10,7) NullNULL Attributes—
  70. 72 PGHAA_longitude Typedecimal(10,7) NullNULL Attributes—
  71. 73 PGHAA_timezone Typenvarchar(100) NullNULL Attributes—
  72. 74 PGHAA_location_approximate Typebit NullNULL Attributes—
  73. 75 PGHAA_location_url Typenvarchar(2048) NullNULL Attributes—
  74. 76 PGHAA_conference_url Typenvarchar(2048) NullNULL Attributes—
  75. 77 PGHAA_conference_notes Typenvarchar(max) NullNULL Attributes—
  76. 78 PGHAA_location_id Typeint NullNULL Attributes—
  77. 79 PGHAA_region_id Typeint NullNULL Attributes—
  78. 80 PGHAA_region Typenvarchar(500) NullNULL Attributes—
  79. 81 PGHAA_group_id Typeint NullNULL Attributes—
  80. 82 PGHAA_group Typenvarchar(500) NullNULL Attributes—
  81. 83 PGHAA_district_id Typeint NullNULL Attributes—
  82. 84 PGHAA_district Typenvarchar(255) NullNULL Attributes—
  83. 85 DZ_eleventh_step_meditation Typebit NullNOT NULL Attributesdefault ((0))
  84. 86 DZ_candlelight Typebit NullNOT NULL Attributesdefault ((0))
  85. 87 DZ_cross_talk_permitted Typebit NullNOT NULL Attributesdefault ((0))
  86. 88 DZ_digital_basket Typebit NullNOT NULL Attributesdefault ((0))
  87. 89 DZ_smoking_permitted Typebit NullNOT NULL Attributesdefault ((0))
  88. 90 DZ_wheelchair_accessible_bathroom Typebit NullNOT NULL Attributesdefault ((0))
  89. 91 DZ_child_friendly Typebit NullNOT NULL Attributesdefault ((0))
  90. 92 DZ_proof_of_attendance Typebit NullNOT NULL Attributesdefault ((0))
  91. 93 DZ_english_speaking Typebit NullNOT NULL Attributesdefault ((0))
  92. 94 DZ_concurrent_al_anon Typebit NullNOT NULL Attributesdefault ((0))
  93. 95 DZ_birthday Typebit NullNOT NULL Attributesdefault ((0))
  94. 96 DZ_temporarily_closed Typebit NullNOT NULL Attributesdefault ((0))
  95. 97 DZ_source_feed_url Typenvarchar(2048) NullNULL Attributes—
  96. 98 DZ_source_hash Typebinary(32) NullNULL Attributes—
  97. 99 PGHAA_updated_at_utc Typedatetime2(0) NullNULL Attributes—
  98. 100 GSO_group_id Typechar(9) NullNULL AttributesFK → [gso].[groups].[GSO_group_id]

[pghaa].[Page map]

Table

WordPress page hierarchy and description map for the PGHAA section.

9 columns228 current rowsschema modified 2026-08-16T18:15:21

  • PK PK_pghaa_Page_map: WpPageId
Show every current column (9)
  1. 1 WpPageId Typeint NullNOT NULL AttributesPK PK_pghaa_Page_map
  2. 2 ParentWpPageId Typeint NullNOT NULL Attributes—
  3. 3 Title Typenvarchar(1024) NullNOT NULL Attributes—
  4. 4 Url Typenvarchar(4000) NullNOT NULL Attributes—
  5. 5 Page Type Typenvarchar(160) NullNOT NULL Attributes—
  6. 6 Description Typenvarchar(2000) NullNOT NULL Attributes—
  7. 7 CreatedUtc Typedatetime2(6) NullNOT NULL Attributesdefault (sysutcdatetime())
  8. 8 UpdatedUtc Typedatetime2(6) NullNOT NULL Attributesdefault (sysutcdatetime())
  9. 9 Mobile Ready Typenvarchar(32) NullNOT NULL Attributesdefault (N'Not analyzed')

[pghaa].[Page mobile audit]

Table

Latest mobile-readiness audit for each mapped WordPress page, including test status, issues, content hashes, byte counts, and audit time.

9 columns226 current rowsschema modified 2026-08-16T20:36:50

  • PK PK__Page mob__B60D08F7781FB915: WpPageId
Show every current column (9)
  1. 1 WpPageId Typeint NullNOT NULL AttributesPK PK__Page mob__B60D08F7781FB915
  2. 2 Status Typenvarchar(32) NullNOT NULL Attributes—
  3. 3 Issues Typenvarchar(max) NullNULL Attributes—
  4. 4 RawBytes Typebigint NullNOT NULL Attributes—
  5. 5 RenderedBytes Typebigint NullNOT NULL Attributes—
  6. 6 RawSha256 Typechar(64) NullNOT NULL Attributes—
  7. 7 RenderedSha256 Typechar(64) NullNOT NULL Attributes—
  8. 8 TestsRun Typeint NullNOT NULL Attributes—
  9. 9 AuditedUtc Typedatetime2(7) NullNOT NULL Attributes—

[pghaa].[People Master]

Table

Canonical PGHAA people-page records with biography, lineage, geography, media, and synchronization fields.

39 columns10 current rowsschema modified 2026-08-15T07:55:24

  • PK PK_pghaa_People_Master: PersonMasterId
  • UQ UQ_pghaa_People_Master_Slug: Slug
  • UQ UQ_pghaa_People_Master_WpPageId: WpPageId
Show every current column (39)
  1. 1 PersonMasterId Typeint NullNOT NULL AttributesIDENTITY; PK PK_pghaa_People_Master
  2. 2 WpPageId Typeint NullNOT NULL AttributesUQ UQ_pghaa_People_Master_WpPageId
  3. 3 ParentWpPageId Typeint NullNOT NULL Attributes—
  4. 4 DisplayTitle Typenvarchar(510) NullNOT NULL Attributes—
  5. 5 Slug Typenvarchar(510) NullNOT NULL AttributesUQ UQ_pghaa_People_Master_Slug
  6. 6 Url Typenvarchar(4000) NullNOT NULL Attributes—
  7. 7 RelativeUrl Typenvarchar(4000) NullNOT NULL Attributes—
  8. 8 ProfileShortDescription Typenvarchar(max) NullNULL Attributes—
  9. 9 Year Born Typeint NullNULL Attributes—
  10. 10 Year Died Typeint NullNULL Attributes—
  11. 11 Birthplace Typenvarchar(510) NullNULL Attributes—
  12. 12 Full Name Typenvarchar(510) NullNULL Attributes—
  13. 13 Native Name Typenvarchar(510) NullNULL Attributes—
  14. 14 Other Names Typenvarchar(max) NullNULL Attributes—
  15. 15 Sex Typenvarchar(100) NullNULL Attributes—
  16. 16 Nationality Typenvarchar(255) NullNULL Attributes—
  17. 17 Religion Typenvarchar(255) NullNULL Attributes—
  18. 18 Mother Typenvarchar(510) NullNULL Attributes—
  19. 19 Father Typenvarchar(510) NullNULL Attributes—
  20. 20 Contribution Typenvarchar(max) NullNULL Attributes—
  21. 21 ContributionUrl Typenvarchar(4000) NullNULL Attributes—
  22. 22 ContributionDeck Typenvarchar(max) NullNULL Attributes—
  23. 23 PeriodTitle Typenvarchar(510) NullNULL Attributes—
  24. 24 PeriodDateText Typenvarchar(510) NullNULL Attributes—
  25. 25 EraTitle Typenvarchar(510) NullNULL Attributes—
  26. 26 EraDateText Typenvarchar(510) NullNULL Attributes—
  27. 27 RegionTitle Typenvarchar(510) NullNULL Attributes—
  28. 28 TerraAvitaTitle Typenvarchar(510) NullNULL Attributes—
  29. 29 TerraAvitaRegionTitle Typenvarchar(510) NullNULL Attributes—
  30. 30 ModernCountryTitle Typenvarchar(510) NullNULL Attributes—
  31. 31 ModernCountryIso3 Typechar(3) NullNULL Attributes—
  32. 32 MediaFolder Typenvarchar(2000) NullNULL Attributes—
  33. 33 LastPageSyncUtc Typedatetime2(6) NullNOT NULL Attributesdefault (sysutcdatetime())
  34. 34 LastImageSyncUtc Typedatetime2(6) NullNULL Attributes—
  35. 35 LineaPeriodKey Typenvarchar(150) NullNULL Attributes—
  36. 36 LineaEraKey Typenvarchar(200) NullNULL Attributes—
  37. 37 LineaTerraAvitaKey Typenvarchar(200) NullNULL Attributes—
  38. 38 LineaTerraAvitaRegionKey Typenvarchar(200) NullNULL Attributes—
  39. 39 LineaCountryKey Typechar(3) NullNULL Attributes—

[pghaa].[Person Image Review Results]

Table

Auditable per-candidate image review and upload outcomes associated with PGHAA people records.

32 columns90 current rowsschema modified 2026-08-14T17:17:41

  • PK PK_pghaa_Person_Image_Review_Results: PersonImageReviewResultId
  • FK ImagesMasterId → [pghaa].[Images Master].[ImageMasterId]
  • FK PersonMasterId → [pghaa].[People Master].[PersonMasterId]
Show every current column (32)
  1. 1 PersonImageReviewResultId Typeint NullNOT NULL AttributesIDENTITY; PK PK_pghaa_Person_Image_Review_Results
  2. 2 ReviewBatchId Typenvarchar(128) NullNOT NULL Attributes—
  3. 3 PersonMasterId Typeint NullNOT NULL AttributesFK → [pghaa].[People Master].[PersonMasterId]
  4. 4 ReviewOrdinal Typeint NullNOT NULL Attributes—
  5. 5 CandidateSource Typenvarchar(200) NullNOT NULL Attributes—
  6. 6 CandidateName Typenvarchar(1020) NullNULL Attributes—
  7. 7 MatchType Typenvarchar(200) NullNULL Attributes—
  8. 8 SourcePageUrl Typenvarchar(4000) NullNULL Attributes—
  9. 9 SourceImageUrl Typenvarchar(4000) NullNULL Attributes—
  10. 10 CandidateCaption Typenvarchar(4000) NullNULL Attributes—
  11. 11 CandidateDescription Typenvarchar(max) NullNULL Attributes—
  12. 12 CandidateAltText Typenvarchar(2000) NullNULL Attributes—
  13. 13 CandidateVisualRole Typenvarchar(200) NullNULL Attributes—
  14. 14 CandidateQualityScore Typeint NullNULL Attributes—
  15. 15 CandidateIdentityConfidence Typenvarchar(200) NullNULL Attributes—
  16. 16 ImageType Typenvarchar(400) NullNULL Attributes—
  17. 17 VisualCaption Typenvarchar(4000) NullNULL Attributes—
  18. 18 VisualDescription Typenvarchar(max) NullNULL Attributes—
  19. 19 VisualAltText Typenvarchar(2000) NullNULL Attributes—
  20. 20 VisualEvidenceUrl Typenvarchar(4000) NullNULL Attributes—
  21. 21 VisualStatus Typenvarchar(100) NullNOT NULL Attributes—
  22. 22 RejectReason Typenvarchar(1000) NullNULL Attributes—
  23. 23 ReviewedUtc Typedatetime2(6) NullNULL Attributes—
  24. 24 CreatedUtc Typedatetime2(6) NullNOT NULL Attributesdefault (sysutcdatetime())
  25. 25 UpdatedUtc Typedatetime2(6) NullNOT NULL Attributesdefault (sysutcdatetime())
  26. 26 LocalPath Typenvarchar(2000) NullNULL Attributes—
  27. 27 UploadStatus Typenvarchar(100) NullNULL Attributes—
  28. 28 WpMediaId Typeint NullNULL Attributes—
  29. 29 UploadedImageUrl Typenvarchar(4000) NullNULL Attributes—
  30. 30 UploadedUtc Typedatetime2(6) NullNULL Attributes—
  31. 31 UploadError Typenvarchar(max) NullNULL Attributes—
  32. 32 ImagesMasterId Typeint NullNULL AttributesFK → [pghaa].[Images Master].[ImageMasterId]

Canonical and Deasy-managed data

Normalized primary records, controlled dictionaries, research evidence, image registry, and queryable meeting views.

[PGHAADZ].[Group Primary]

Table

Canonical Deasy-managed AA group identity table with GSO linkage and verification status.

7 columns784 current rowsschema modified 2026-08-10T07:07:46

  • PK PK_PGHAADZ_Group_Primary: DZ_group_id
  • FK GSO_group_id → [gso].[groups].[GSO_group_id]
Show every current column (7)
  1. 1 DZ_group_id Typeint NullNOT NULL AttributesIDENTITY; PK PK_PGHAADZ_Group_Primary
  2. 2 GSO_group_id Typechar(9) NullNULL AttributesFK → [gso].[groups].[GSO_group_id]
  3. 3 DZ_Proper_Group_Name Typenvarchar(1000) NullNOT NULL Attributes—
  4. 4 GSO_legacy_service_number Typenvarchar(100) NullNULL Attributes—
  5. 5 DZ_date_first_added Typedate NullNOT NULL Attributesdefault (CONVERT([date],((sysutcdatetime() AT TIME ZONE 'UTC') AT TIME ZONE 'Eastern Standard Time')))
  6. 6 DZ_GSO_Official_Flag Typebit NullNOT NULL Attributesdefault ((0))
  7. 7 DZ_GSO_Status_Reason Typenvarchar(1000) NullNOT NULL Attributes—

[PGHAADZ].[Images]

Table

Deasy-managed registry of PGHAA presentation images and WordPress attachment metadata.

20 columns604 current rowsschema modified 2026-08-10T09:58:36

  • PK PK_PGHAADZ_Images: DZ_image_id
  • UQ UQ_PGHAADZ_Images_WordPress_Attachment_ID: DZ_wordpress_attachment_id
Show every current column (20)
  1. 1 DZ_image_id Typeint NullNOT NULL AttributesIDENTITY; PK PK_PGHAADZ_Images
  2. 2 DZ_page_order Typeint NullNOT NULL Attributes—
  3. 3 DZ_image_section Typenvarchar(200) NullNOT NULL Attributes—
  4. 4 DZ_image_family Typenvarchar(300) NullNOT NULL Attributes—
  5. 5 DZ_image_subject Typenvarchar(300) NullNOT NULL Attributes—
  6. 6 DZ_image_variant_number Typetinyint NullNULL Attributes—
  7. 7 DZ_image_filename Typenvarchar(500) NullNOT NULL Attributes—
  8. 8 DZ_image_url Typenvarchar(2048) NullNOT NULL Attributes—
  9. 9 DZ_wordpress_attachment_id Typebigint NullNOT NULL AttributesUQ UQ_PGHAADZ_Images_WordPress_Attachment_ID
  10. 10 DZ_image_width Typeint NullNULL Attributes—
  11. 11 DZ_image_height Typeint NullNULL Attributes—
  12. 12 DZ_image_alt_text Typenvarchar(1000) NullNULL Attributes—
  13. 13 DZ_image_srcset Typenvarchar(max) NullNULL Attributes—
  14. 14 DZ_image_sizes Typenvarchar(1000) NullNULL Attributes—
  15. 15 DZ_image_loading_behavior Typenvarchar(30) NullNULL Attributes—
  16. 16 DZ_image_fetch_priority Typenvarchar(30) NullNULL Attributes—
  17. 17 DZ_source_page_url Typenvarchar(2048) NullNOT NULL Attributes—
  18. 18 DZ_is_currently_on_page Typebit NullNOT NULL Attributesdefault ((1))
  19. 19 DZ_date_first_seen_utc Typedatetime2(0) NullNOT NULL Attributesdefault (sysutcdatetime())
  20. 20 DZ_date_last_seen_utc Typedatetime2(0) NullNOT NULL Attributesdefault (sysutcdatetime())

[PGHAADZ].[Meeting Internet Search Results]

Table

Internet-search evidence collected for canonical meetings, including ranking, snippets, response data, and timestamps.

11 columns36,096 current rowsschema modified 2026-08-05T13:09:19

  • PK PK_PGHAADZ_Meeting_Internet_Search_Results: DZ_internet_search_result_id
  • FK DZ_meeting_id → [PGHAADZ].[Meeting Primary].[DZ_meeting_id]
Show every current column (11)
  1. 1 DZ_internet_search_result_id Typebigint NullNOT NULL AttributesIDENTITY; PK PK_PGHAADZ_Meeting_Internet_Search_Results
  2. 2 DZ_meeting_id Typeint NullNOT NULL AttributesFK → [PGHAADZ].[Meeting Primary].[DZ_meeting_id]
  3. 3 DZ_source_url Typenvarchar(2048) NullNOT NULL Attributes—
  4. 4 DZ_source_domain Typenvarchar(255) NullNULL Attributes—
  5. 5 DZ_page_title Typenvarchar(1000) NullNULL Attributes—
  6. 6 DZ_evidence_category Typenvarchar(100) NullNULL Attributes—
  7. 7 DZ_accepted_for_meeting Typebit NullNOT NULL Attributes—
  8. 8 DZ_address_status Typenvarchar(100) NullNULL Attributes—
  9. 9 DZ_supporting_evidence Typenvarchar(max) NullNULL Attributes—
  10. 10 DZ_notes Typenvarchar(max) NullNULL Attributes—
  11. 11 DZ_researched_at_utc Typedatetime2(3) NullNOT NULL Attributes—

[PGHAADZ].[Meeting Primary]

Table

Canonical cross-source meeting record with PGHAA and Area 60 identifiers, normalized address/geography, schedule, access, group, and map linkage.

37 columns985 current rowsschema modified 2026-08-16T14:38:49

  • PK PK_PGHAADZ_Meeting_Primary: DZ_meeting_id
  • FK DZ_group_id → [PGHAADZ].[Group Primary].[DZ_group_id]

External logical dependency: WPRDC_address_id may identify [WPRDC PASDA].[001 - AddressPoints]; SQL Server does not currently enforce that relationship as a foreign key.

Show every current column (37)
  1. 1 DZ_meeting_id Typeint NullNOT NULL AttributesPK PK_PGHAADZ_Meeting_Primary
  2. 2 PGHAA_meeting_id Typeint NullNULL Attributes—
  3. 3 WPAAREA60_id Typeint NullNULL Attributes—
  4. 4 DZ_Proper_Meeting_Name Typenvarchar(500) NullNOT NULL Attributes—
  5. 5 DZ_date_first_added Typedate NullNOT NULL Attributes—
  6. 6 WPRDC_address_id Typebigint NullNULL Attributes—
  7. 7 DZ_location_status Typevarchar(20) NullNOT NULL Attributes—
  8. 8 DZ_Proper_Street_Number_Prefix Typenvarchar(20) NullNULL Attributes—
  9. 9 DZ_Proper_Street_Number Typenvarchar(30) NullNULL Attributes—
  10. 10 DZ_Proper_Street_Number_Suffix Typenvarchar(20) NullNULL Attributes—
  11. 11 DZ_Proper_Street_Predirection Typenvarchar(20) NullNULL Attributes—
  12. 12 DZ_Proper_Street_Name Typenvarchar(300) NullNULL Attributes—
  13. 13 DZ_Proper_Street_Type Typenvarchar(30) NullNULL Attributes—
  14. 14 DZ_Proper_Street_Postdirection Typenvarchar(20) NullNULL Attributes—
  15. 15 DZ_Proper_SubAddress_Unit_Type Typenvarchar(40) NullNULL Attributes—
  16. 16 DZ_Proper_SubAddress_Unit_Number Typenvarchar(80) NullNULL Attributes—
  17. 17 DZ_Proper_SubAddress_Floor Typenvarchar(80) NullNULL Attributes—
  18. 18 DZ_Proper_SubAddress_Room Typenvarchar(160) NullNULL Attributes—
  19. 19 DZ_Proper_Admin_Municipality Typenvarchar(200) NullNULL Attributes—
  20. 20 DZ_Proper_Admin_City Typenvarchar(200) NullNULL Attributes—
  21. 21 DZ_Proper_Admin_County Typenvarchar(200) NullNULL Attributes—
  22. 22 DZ_Proper_Admin_State Typenvarchar(100) NullNULL Attributes—
  23. 23 DZ_Proper_Admin_Postal_Code Typenvarchar(20) NullNULL Attributes—
  24. 24 DZ_Proper_Admin_Country Typenvarchar(100) NullNULL Attributes—
  25. 25 DZ_Proper_Geography_Latitude Typedecimal(10,7) NullNULL Attributes—
  26. 26 DZ_Proper_Geography_Longitude Typedecimal(10,7) NullNULL Attributes—
  27. 27 DZ_Proper_Geography_Parcel_ID Typenvarchar(100) NullNULL Attributes—
  28. 28 DZ_Proper_Geography_Building_Footprint_ID Typenvarchar(100) NullNULL Attributes—
  29. 29 DZ_Meeting Access Mode Typevarchar(20) NullNOT NULL Attributes—
  30. 30 DZ_Online Meeting URL Typenvarchar(2048) NullNULL Attributes—
  31. 31 DZ_Meeting Day Of Week Typevarchar(9) NullNOT NULL Attributes—
  32. 32 DZ_Meeting Start Time Typetime(0) NullNOT NULL Attributes—
  33. 33 PGHAA_meeting_id_2 Typeint NullNULL Attributes—
  34. 34 WPAAREA60_id_2 Typeint NullNULL Attributes—
  35. 35 DZ_group_id Typeint NullNULL AttributesFK → [PGHAADZ].[Group Primary].[DZ_group_id]
  36. 36 DZ_Google Map Link Typenvarchar(2048) NullNULL Attributes—
  37. 37 DZ_Proper_Admin_Neighborhood Typenvarchar(128) NullNULL Attributes—

[PGHAADZ].[Meeting Types]

Table

Controlled meeting-type dictionary used to normalize codes, names, descriptions, and display order.

11 columns57 current rowsschema modified 2026-08-05T21:26:50

  • PK PK_Meeting_Types: DZ_meeting_type_id
  • UQ UQ_Meeting_Types_Key: DZ_type_key
  • UQ UQ_Meeting_Types_Sort: DZ_sort_order
Show every current column (11)
  1. 1 DZ_meeting_type_id Typeint NullNOT NULL AttributesPK PK_Meeting_Types
  2. 2 DZ_type_group Typevarchar(40) NullNOT NULL Attributes—
  3. 3 DZ_type_key Typevarchar(100) NullNOT NULL AttributesUQ UQ_Meeting_Types_Key
  4. 4 DZ_type_name Typenvarchar(150) NullNOT NULL Attributes—
  5. 5 DZ_type_description Typenvarchar(600) NullNOT NULL Attributes—
  6. 6 PGHAA_field_name Typesysname NullNULL Attributes—
  7. 7 WPAAREA60_field_name Typesysname NullNULL Attributes—
  8. 8 PGHAADZ_field_name Typesysname NullNULL Attributes—
  9. 9 DZ_current_meeting_count Typeint NullNOT NULL Attributes—
  10. 10 DZ_sort_order Typeint NullNOT NULL AttributesUQ UQ_Meeting_Types_Sort
  11. 11 DZ_updated_at_utc Typedatetime2(0) NullNOT NULL Attributes—

[PGHAADZ].[Meetings by Day of the Week]

View

Unified canonical meeting projection used for weekday browsing across PGHAA and WPA Area 60 sources.

82 columns985 current rowsschema modified 2026-08-09T19:10:01

  • Depends on [pghaa].[meetings]
  • Depends on [PGHAADZ].[Meeting Primary]
  • Depends on [wpaarea60].[meetings]
Show every current column (82)
  1. 1 DZ_meeting_id Typeint NullNOT NULL Attributes—
  2. 2 PGHAA_meeting_id Typeint NullNULL Attributes—
  3. 3 WPAAREA60_id Typeint NullNULL Attributes—
  4. 4 DZ_Proper_Meeting_Name Typenvarchar(500) NullNOT NULL Attributes—
  5. 5 DZ_day_number Typeint NullNULL Attributes—
  6. 6 DZ_meeting_day_of_week Typevarchar(9) NullNOT NULL Attributes—
  7. 7 DZ_meeting_start_time Typetime(0) NullNOT NULL Attributes—
  8. 8 DZ_meeting_access_mode Typevarchar(20) NullNOT NULL Attributes—
  9. 9 DZ_online_meeting_url Typenvarchar(2048) NullNULL Attributes—
  10. 10 DZ_location_status Typevarchar(20) NullNOT NULL Attributes—
  11. 11 DZ_attendance_type Typevarchar(20) NullNULL Attributes—
  12. 12 DZ_is_open Typebit NullNULL Attributes—
  13. 13 DZ_is_closed Typebit NullNULL Attributes—
  14. 14 DZ_venue_name Typenvarchar(1000) NullNULL Attributes—
  15. 15 DZ_source_street_address Typenvarchar(1500) NullNULL Attributes—
  16. 16 DZ_locality Typenvarchar(255) NullNULL Attributes—
  17. 17 DZ_state Typenvarchar(100) NullNULL Attributes—
  18. 18 DZ_postal_code Typenvarchar(20) NullNULL Attributes—
  19. 19 DZ_timezone Typenvarchar(100) NullNULL Attributes—
  20. 20 DZ_location_url Typenvarchar(2048) NullNULL Attributes—
  21. 21 DZ_meeting_details Typenvarchar(max) NullNULL Attributes—
  22. 22 DZ_online_conference_notes Typenvarchar(max) NullNULL Attributes—
  23. 23 DZ_zoom_meeting_id Typenvarchar(100) NullNULL Attributes—
  24. 24 DZ_zoom_password Typenvarchar(255) NullNULL Attributes—
  25. 25 DZ_phone_number Typenvarchar(100) NullNULL Attributes—
  26. 26 DZ_region Typenvarchar(500) NullNULL Attributes—
  27. 27 DZ_group Typenvarchar(500) NullNULL Attributes—
  28. 28 DZ_district Typenvarchar(255) NullNULL Attributes—
  29. 29 DZ_discussion Typebit NullNULL Attributes—
  30. 30 DZ_speaker Typebit NullNULL Attributes—
  31. 31 DZ_big_book Typebit NullNULL Attributes—
  32. 32 DZ_beginners Typebit NullNULL Attributes—
  33. 33 DZ_twelve_and_twelve Typebit NullNULL Attributes—
  34. 34 DZ_step Typebit NullNULL Attributes—
  35. 35 DZ_tradition Typebit NullNULL Attributes—
  36. 36 DZ_chairs_choice Typebit NullNULL Attributes—
  37. 37 DZ_literature Typebit NullNULL Attributes—
  38. 38 DZ_meditation Typebit NullNULL Attributes—
  39. 39 DZ_eleventh_step_meditation Typebit NullNULL Attributes—
  40. 40 DZ_as_bill_sees_it Typebit NullNULL Attributes—
  41. 41 DZ_grapevine Typebit NullNULL Attributes—
  42. 42 DZ_daily_reflections Typebit NullNULL Attributes—
  43. 43 DZ_living_sober Typebit NullNULL Attributes—
  44. 44 DZ_plain_language_big_book Typebit NullNULL Attributes—
  45. 45 DZ_text_study Typebit NullNULL Attributes—
  46. 46 DZ_candlelight Typebit NullNULL Attributes—
  47. 47 DZ_cross_talk_permitted Typebit NullNULL Attributes—
  48. 48 DZ_digital_basket Typebit NullNULL Attributes—
  49. 49 DZ_no_smoking Typebit NullNULL Attributes—
  50. 50 DZ_no_vaping Typebit NullNULL Attributes—
  51. 51 DZ_smoking_permitted Typebit NullNULL Attributes—
  52. 52 DZ_accessible Typebit NullNULL Attributes—
  53. 53 DZ_wheelchair_accessible_bathroom Typebit NullNULL Attributes—
  54. 54 DZ_women_only Typebit NullNULL Attributes—
  55. 55 DZ_men_only Typebit NullNULL Attributes—
  56. 56 DZ_young_people Typebit NullNULL Attributes—
  57. 57 DZ_lgbt_friendly Typebit NullNULL Attributes—
  58. 58 DZ_child_friendly Typebit NullNULL Attributes—
  59. 59 DZ_no_kids Typebit NullNULL Attributes—
  60. 60 DZ_no_slips_signed Typebit NullNULL Attributes—
  61. 61 DZ_proof_of_attendance Typebit NullNULL Attributes—
  62. 62 DZ_spanish_speaking Typebit NullNULL Attributes—
  63. 63 DZ_english_speaking Typebit NullNULL Attributes—
  64. 64 DZ_babysitting_available Typebit NullNULL Attributes—
  65. 65 DZ_service_dogs_only Typebit NullNULL Attributes—
  66. 66 DZ_women_nonbinary_welcome Typebit NullNULL Attributes—
  67. 67 DZ_concurrent_al_anon Typebit NullNULL Attributes—
  68. 68 DZ_birthday Typebit NullNULL Attributes—
  69. 69 DZ_temporarily_closed Typebit NullNULL Attributes—
  70. 70 DZ_area_eastern_allegheny Typebit NullNULL Attributes—
  71. 71 DZ_area_northern_allegheny Typebit NullNULL Attributes—
  72. 72 DZ_area_south_hills Typebit NullNULL Attributes—
  73. 73 DZ_area_western_allegheny Typebit NullNULL Attributes—
  74. 74 DZ_area_beaver_lawrence_mercer Typebit NullNULL Attributes—
  75. 75 DZ_area_butler_county Typebit NullNULL Attributes—
  76. 76 DZ_area_washington_greene Typebit NullNULL Attributes—
  77. 77 DZ_area_fayette_somerset Typebit NullNULL Attributes—
  78. 78 DZ_area_westmoreland Typebit NullNULL Attributes—
  79. 79 DZ_area_armstrong_jefferson_clarion_indiana Typebit NullNULL Attributes—
  80. 80 DZ_area_city_pittsburgh Typebit NullNULL Attributes—
  81. 81 DZ_area_monongahela_valley Typebit NullNULL Attributes—
  82. 82 DZ_data_collected_at_utc Typedatetime2(0) NullNULL Attributes—

[PGHAADZ].[Online Meetings]

View

Online and hybrid subset of the unified weekday meeting view.

82 columns80 current rowsschema modified 2026-08-09T19:10:01

  • Depends on [PGHAADZ].[Meetings by Day of the Week]
Show every current column (82)
  1. 1 DZ_meeting_id Typeint NullNOT NULL Attributes—
  2. 2 PGHAA_meeting_id Typeint NullNULL Attributes—
  3. 3 WPAAREA60_id Typeint NullNULL Attributes—
  4. 4 DZ_Proper_Meeting_Name Typenvarchar(500) NullNOT NULL Attributes—
  5. 5 DZ_day_number Typeint NullNULL Attributes—
  6. 6 DZ_meeting_day_of_week Typevarchar(9) NullNOT NULL Attributes—
  7. 7 DZ_meeting_start_time Typetime(0) NullNOT NULL Attributes—
  8. 8 DZ_meeting_access_mode Typevarchar(20) NullNOT NULL Attributes—
  9. 9 DZ_online_meeting_url Typenvarchar(2048) NullNULL Attributes—
  10. 10 DZ_location_status Typevarchar(20) NullNOT NULL Attributes—
  11. 11 DZ_attendance_type Typevarchar(20) NullNULL Attributes—
  12. 12 DZ_is_open Typebit NullNULL Attributes—
  13. 13 DZ_is_closed Typebit NullNULL Attributes—
  14. 14 DZ_venue_name Typenvarchar(1000) NullNULL Attributes—
  15. 15 DZ_source_street_address Typenvarchar(1500) NullNULL Attributes—
  16. 16 DZ_locality Typenvarchar(255) NullNULL Attributes—
  17. 17 DZ_state Typenvarchar(100) NullNULL Attributes—
  18. 18 DZ_postal_code Typenvarchar(20) NullNULL Attributes—
  19. 19 DZ_timezone Typenvarchar(100) NullNULL Attributes—
  20. 20 DZ_location_url Typenvarchar(2048) NullNULL Attributes—
  21. 21 DZ_meeting_details Typenvarchar(max) NullNULL Attributes—
  22. 22 DZ_online_conference_notes Typenvarchar(max) NullNULL Attributes—
  23. 23 DZ_zoom_meeting_id Typenvarchar(100) NullNULL Attributes—
  24. 24 DZ_zoom_password Typenvarchar(255) NullNULL Attributes—
  25. 25 DZ_phone_number Typenvarchar(100) NullNULL Attributes—
  26. 26 DZ_region Typenvarchar(500) NullNULL Attributes—
  27. 27 DZ_group Typenvarchar(500) NullNULL Attributes—
  28. 28 DZ_district Typenvarchar(255) NullNULL Attributes—
  29. 29 DZ_discussion Typebit NullNULL Attributes—
  30. 30 DZ_speaker Typebit NullNULL Attributes—
  31. 31 DZ_big_book Typebit NullNULL Attributes—
  32. 32 DZ_beginners Typebit NullNULL Attributes—
  33. 33 DZ_twelve_and_twelve Typebit NullNULL Attributes—
  34. 34 DZ_step Typebit NullNULL Attributes—
  35. 35 DZ_tradition Typebit NullNULL Attributes—
  36. 36 DZ_chairs_choice Typebit NullNULL Attributes—
  37. 37 DZ_literature Typebit NullNULL Attributes—
  38. 38 DZ_meditation Typebit NullNULL Attributes—
  39. 39 DZ_eleventh_step_meditation Typebit NullNULL Attributes—
  40. 40 DZ_as_bill_sees_it Typebit NullNULL Attributes—
  41. 41 DZ_grapevine Typebit NullNULL Attributes—
  42. 42 DZ_daily_reflections Typebit NullNULL Attributes—
  43. 43 DZ_living_sober Typebit NullNULL Attributes—
  44. 44 DZ_plain_language_big_book Typebit NullNULL Attributes—
  45. 45 DZ_text_study Typebit NullNULL Attributes—
  46. 46 DZ_candlelight Typebit NullNULL Attributes—
  47. 47 DZ_cross_talk_permitted Typebit NullNULL Attributes—
  48. 48 DZ_digital_basket Typebit NullNULL Attributes—
  49. 49 DZ_no_smoking Typebit NullNULL Attributes—
  50. 50 DZ_no_vaping Typebit NullNULL Attributes—
  51. 51 DZ_smoking_permitted Typebit NullNULL Attributes—
  52. 52 DZ_accessible Typebit NullNULL Attributes—
  53. 53 DZ_wheelchair_accessible_bathroom Typebit NullNULL Attributes—
  54. 54 DZ_women_only Typebit NullNULL Attributes—
  55. 55 DZ_men_only Typebit NullNULL Attributes—
  56. 56 DZ_young_people Typebit NullNULL Attributes—
  57. 57 DZ_lgbt_friendly Typebit NullNULL Attributes—
  58. 58 DZ_child_friendly Typebit NullNULL Attributes—
  59. 59 DZ_no_kids Typebit NullNULL Attributes—
  60. 60 DZ_no_slips_signed Typebit NullNULL Attributes—
  61. 61 DZ_proof_of_attendance Typebit NullNULL Attributes—
  62. 62 DZ_spanish_speaking Typebit NullNULL Attributes—
  63. 63 DZ_english_speaking Typebit NullNULL Attributes—
  64. 64 DZ_babysitting_available Typebit NullNULL Attributes—
  65. 65 DZ_service_dogs_only Typebit NullNULL Attributes—
  66. 66 DZ_women_nonbinary_welcome Typebit NullNULL Attributes—
  67. 67 DZ_concurrent_al_anon Typebit NullNULL Attributes—
  68. 68 DZ_birthday Typebit NullNULL Attributes—
  69. 69 DZ_temporarily_closed Typebit NullNULL Attributes—
  70. 70 DZ_area_eastern_allegheny Typebit NullNULL Attributes—
  71. 71 DZ_area_northern_allegheny Typebit NullNULL Attributes—
  72. 72 DZ_area_south_hills Typebit NullNULL Attributes—
  73. 73 DZ_area_western_allegheny Typebit NullNULL Attributes—
  74. 74 DZ_area_beaver_lawrence_mercer Typebit NullNULL Attributes—
  75. 75 DZ_area_butler_county Typebit NullNULL Attributes—
  76. 76 DZ_area_washington_greene Typebit NullNULL Attributes—
  77. 77 DZ_area_fayette_somerset Typebit NullNULL Attributes—
  78. 78 DZ_area_westmoreland Typebit NullNULL Attributes—
  79. 79 DZ_area_armstrong_jefferson_clarion_indiana Typebit NullNULL Attributes—
  80. 80 DZ_area_city_pittsburgh Typebit NullNULL Attributes—
  81. 81 DZ_area_monongahela_valley Typebit NullNULL Attributes—
  82. 82 DZ_data_collected_at_utc Typedatetime2(0) NullNULL Attributes—

WPA Area 60 source data

Published WPA Area 60 sitemap and meeting source records.

[wpaarea60].[current site map]

Table

Current WPA Area 60 sitemap inventory with source URLs, titles, priorities, hashes, and collection timestamps.

8 columns2,250 current rowsschema modified 2026-08-04T16:27:58

  • PK PK_wpaarea60_current_site_map: DZ_site_map_id
  • UQ UX_wpaarea60_current_site_map_url_hash: DZ_url_hash
Show every current column (8)
  1. 1 DZ_site_map_id Typebigint NullNOT NULL AttributesIDENTITY; PK PK_wpaarea60_current_site_map
  2. 2 DZ_crawl_run_id Typeuniqueidentifier NullNOT NULL Attributes—
  3. 3 WPAAREA60_url Typenvarchar(2048) NullNOT NULL Attributes—
  4. 4 DZ_url_hash Typebinary(32) NullNOT NULL AttributesUQ UX_wpaarea60_current_site_map_url_hash
  5. 5 WPAAREA60_last_modified Typedatetimeoffset(0) NullNULL Attributes—
  6. 6 WPAAREA60_sitemap_url Typenvarchar(2048) NullNOT NULL Attributes—
  7. 7 DZ_url_type Typevarchar(40) NullNOT NULL Attributes—
  8. 8 DZ_collected_at_utc Typedatetime2(0) NullNOT NULL Attributes—

[wpaarea60].[meetings]

Table

WPA Area 60-published meeting records with normalized schedule, attendance, geography, category, source, and GSO-linkage fields.

98 columns947 current rowsschema modified 2026-08-09T20:48:00

  • PK PK_wpaarea60_meetings: WPAAREA60_id
  • FK GSO_group_id → [gso].[groups].[GSO_group_id]
Show every current column (98)
  1. 1 WPAAREA60_id Typeint NullNOT NULL AttributesPK PK_wpaarea60_meetings
  2. 2 DZ_day_number Typetinyint NullNOT NULL Attributes—
  3. 3 WPAAREA60_day Typevarchar(9) NullNOT NULL Attributes—
  4. 4 WPAAREA60_start_time Typetime(0) NullNOT NULL Attributes—
  5. 5 WPAAREA60_end_time Typetime(0) NullNULL Attributes—
  6. 6 WPAAREA60_time_display Typenvarchar(100) NullNULL Attributes—
  7. 7 WPAAREA60_meeting_name Typenvarchar(500) NullNOT NULL Attributes—
  8. 8 DZ_attendance_type Typevarchar(20) NullNOT NULL Attributes—
  9. 9 WPAAREA60_meeting_details Typenvarchar(max) NullNULL Attributes—
  10. 10 DZ_access_mode Typevarchar(20) NullNOT NULL Attributes—
  11. 11 WPAAREA60_venue_name Typenvarchar(1000) NullNULL Attributes—
  12. 12 WPAAREA60_address Typenvarchar(1000) NullNULL Attributes—
  13. 13 WPAAREA60_locality Typenvarchar(255) NullNULL Attributes—
  14. 14 WPAAREA60_state Typevarchar(20) NullNULL Attributes—
  15. 15 WPAAREA60_postal_code Typevarchar(20) NullNULL Attributes—
  16. 16 WPAAREA60_country Typenvarchar(100) NullNULL Attributes—
  17. 17 WPAAREA60_latitude Typedecimal(10,7) NullNULL Attributes—
  18. 18 WPAAREA60_longitude Typedecimal(10,7) NullNULL Attributes—
  19. 19 WPAAREA60_timezone Typenvarchar(100) NullNULL Attributes—
  20. 20 WPAAREA60_location_approximate Typebit NullNOT NULL Attributes—
  21. 21 WPAAREA60_location_url Typenvarchar(2048) NullNULL Attributes—
  22. 22 WPAAREA60_map_or_join_url Typenvarchar(2048) NullNULL Attributes—
  23. 23 WPAAREA60_link_text Typenvarchar(255) NullNULL Attributes—
  24. 24 WPAAREA60_conference_url Typenvarchar(2048) NullNULL Attributes—
  25. 25 WPAAREA60_conference_notes Typenvarchar(max) NullNULL Attributes—
  26. 26 WPAAREA60_zoom_meeting_id Typenvarchar(100) NullNULL Attributes—
  27. 27 WPAAREA60_zoom_password Typenvarchar(255) NullNULL Attributes—
  28. 28 WPAAREA60_phone_number Typenvarchar(100) NullNULL Attributes—
  29. 29 WPAAREA60_location_id Typeint NullNOT NULL Attributes—
  30. 30 WPAAREA60_region_id Typeint NullNOT NULL Attributes—
  31. 31 WPAAREA60_region Typenvarchar(500) NullNULL Attributes—
  32. 32 WPAAREA60_group_id Typeint NullNULL Attributes—
  33. 33 WPAAREA60_group Typenvarchar(500) NullNULL Attributes—
  34. 34 WPAAREA60_district_id Typeint NullNULL Attributes—
  35. 35 WPAAREA60_district Typenvarchar(255) NullNULL Attributes—
  36. 36 DZ_discussion Typebit NullNOT NULL Attributes—
  37. 37 DZ_speaker Typebit NullNOT NULL Attributes—
  38. 38 DZ_big_book Typebit NullNOT NULL Attributes—
  39. 39 DZ_beginners Typebit NullNOT NULL Attributes—
  40. 40 DZ_twelve_and_twelve Typebit NullNOT NULL Attributes—
  41. 41 DZ_step Typebit NullNOT NULL Attributes—
  42. 42 DZ_tradition Typebit NullNOT NULL Attributes—
  43. 43 DZ_chairs_choice Typebit NullNOT NULL Attributes—
  44. 44 DZ_literature Typebit NullNOT NULL Attributes—
  45. 45 DZ_meditation Typebit NullNOT NULL Attributes—
  46. 46 DZ_eleventh_step_meditation Typebit NullNOT NULL Attributes—
  47. 47 DZ_as_bill_sees_it Typebit NullNOT NULL Attributes—
  48. 48 DZ_grapevine Typebit NullNOT NULL Attributes—
  49. 49 DZ_daily_reflections Typebit NullNOT NULL Attributes—
  50. 50 DZ_living_sober Typebit NullNOT NULL Attributes—
  51. 51 DZ_plain_language_big_book Typebit NullNOT NULL Attributes—
  52. 52 DZ_text_study Typebit NullNOT NULL Attributes—
  53. 53 DZ_candlelight Typebit NullNOT NULL Attributes—
  54. 54 DZ_cross_talk_permitted Typebit NullNOT NULL Attributes—
  55. 55 DZ_digital_basket Typebit NullNOT NULL Attributes—
  56. 56 DZ_no_smoking Typebit NullNOT NULL Attributes—
  57. 57 DZ_no_vaping Typebit NullNOT NULL Attributes—
  58. 58 DZ_smoking_permitted Typebit NullNOT NULL Attributes—
  59. 59 DZ_accessible Typebit NullNOT NULL Attributes—
  60. 60 DZ_wheelchair_accessible_bathroom Typebit NullNOT NULL Attributes—
  61. 61 DZ_women_only Typebit NullNOT NULL Attributes—
  62. 62 DZ_men_only Typebit NullNOT NULL Attributes—
  63. 63 DZ_young_people Typebit NullNOT NULL Attributes—
  64. 64 DZ_lgbt_friendly Typebit NullNOT NULL Attributes—
  65. 65 DZ_child_friendly Typebit NullNOT NULL Attributes—
  66. 66 DZ_no_kids Typebit NullNOT NULL Attributes—
  67. 67 DZ_no_slips_signed Typebit NullNOT NULL Attributes—
  68. 68 DZ_proof_of_attendance Typebit NullNOT NULL Attributes—
  69. 69 DZ_spanish_speaking Typebit NullNOT NULL Attributes—
  70. 70 DZ_english_speaking Typebit NullNOT NULL Attributes—
  71. 71 DZ_babysitting_available Typebit NullNOT NULL Attributes—
  72. 72 DZ_service_dogs_only Typebit NullNOT NULL Attributes—
  73. 73 DZ_women_nonbinary_welcome Typebit NullNOT NULL Attributes—
  74. 74 DZ_concurrent_al_anon Typebit NullNOT NULL Attributes—
  75. 75 DZ_birthday Typebit NullNOT NULL Attributes—
  76. 76 DZ_temporarily_closed Typebit NullNOT NULL Attributes—
  77. 77 WPAAREA60_holiday_note Typenvarchar(1000) NullNULL Attributes—
  78. 78 WPAAREA60_seasonal_note Typenvarchar(1000) NullNULL Attributes—
  79. 79 WPAAREA60_source_attributes Typenvarchar(max) NullNOT NULL Attributes—
  80. 80 DZ_area_eastern_allegheny Typebit NullNOT NULL Attributes—
  81. 81 DZ_area_northern_allegheny Typebit NullNOT NULL Attributes—
  82. 82 DZ_area_south_hills Typebit NullNOT NULL Attributes—
  83. 83 DZ_area_western_allegheny Typebit NullNOT NULL Attributes—
  84. 84 DZ_area_beaver_lawrence_mercer Typebit NullNOT NULL Attributes—
  85. 85 DZ_area_butler_county Typebit NullNOT NULL Attributes—
  86. 86 DZ_area_washington_greene Typebit NullNOT NULL Attributes—
  87. 87 DZ_area_fayette_somerset Typebit NullNOT NULL Attributes—
  88. 88 DZ_area_westmoreland Typebit NullNOT NULL Attributes—
  89. 89 DZ_area_armstrong_jefferson_clarion_indiana Typebit NullNOT NULL Attributes—
  90. 90 DZ_area_city_pittsburgh Typebit NullNOT NULL Attributes—
  91. 91 DZ_area_monongahela_valley Typebit NullNOT NULL Attributes—
  92. 92 DZ_source_instance_count Typeint NullNOT NULL Attributes—
  93. 93 DZ_source_url Typenvarchar(2048) NullNOT NULL Attributes—
  94. 94 DZ_source_feed_url Typenvarchar(2048) NullNOT NULL Attributes—
  95. 95 DZ_source_hash Typebinary(32) NullNOT NULL Attributes—
  96. 96 WPAAREA60_updated_at_utc Typedatetime2(0) NullNOT NULL Attributes—
  97. 97 DZ_collected_at_utc Typedatetime2(0) NullNOT NULL Attributes—
  98. 98 GSO_group_id Typechar(9) NullNULL AttributesFK → [gso].[groups].[GSO_group_id]

Enforced relationships

  • [pghaa].[Images Master].[PersonMasterId] → [pghaa].[People Master].[PersonMasterId] (FK_pghaa_Images_Master_People_Master)
  • [pghaa].[meetings].[GSO_group_id] → [gso].[groups].[GSO_group_id] (FK_pghaa_meetings_gso_groups)
  • [pghaa].[Person Image Review Results].[ImagesMasterId] → [pghaa].[Images Master].[ImageMasterId] (FK_pghaa_Person_Image_Review_Results_Images_Master)
  • [pghaa].[Person Image Review Results].[PersonMasterId] → [pghaa].[People Master].[PersonMasterId] (FK_pghaa_Person_Image_Review_Results_People_Master)
  • [PGHAADZ].[Group Primary].[GSO_group_id] → [gso].[groups].[GSO_group_id] (FK_PGHAADZ_Group_Primary_gso_groups)
  • [PGHAADZ].[Meeting Internet Search Results].[DZ_meeting_id] → [PGHAADZ].[Meeting Primary].[DZ_meeting_id] (FK_PGHAADZ_Meeting_Internet_Search_Results_Meeting_Primary)
  • [PGHAADZ].[Meeting Primary].[DZ_group_id] → [PGHAADZ].[Group Primary].[DZ_group_id] (FK_PGHAADZ_Meeting_Primary_Group_Primary)
  • [wpaarea60].[meetings].[GSO_group_id] → [gso].[groups].[GSO_group_id] (FK_wpaarea60_meetings_gso_groups)