This page is just a living reference for thoese of us using the connections databases directly who want to make sure our code works by checking the db schemas before performing actions, you can see how to get these values in a previous post
If IBM would like to document this themselves (I know they wont as they dont want us near the dbs directly and want us to go via the APIs) I would be happy to bow out and point to their site 🙂
Connections App: Files
BD: FILES
Table: PRODUCT
Connections v4.0 BASE: 79
Connections v4.0 CR1: 79
Connections v4.0 CR2: 79
Connections v4.0 CR3: 79
Connections v4.0 CR4: 79
Connections v4.5 BASE: 82
Connections v4.5 CR1: 82
Connections v4.5 CR2: 82
Connections v4.5 CR3: 89
Connections v4.5 CR4: 89
Connections App: Activities
BD: OPNACT
Table: OA_SCHEMA
Connections v4.0 BASE: 53
Connections v4.0 CR1: 53
Connections v4.0 CR2: 53
Connections v4.0 CR3: 53
Connections v4.0 CR4: 53
Connections v4.5 BASE: 56
Connections v4.5 CR1: 56
Connections v4.5 CR2: 56
Connections v4.5 CR3: 56
Connections v4.5 CR4: 56
Connections App: Blogs
BD: BLOGS
Table: ROLLER_PROPERTIES
Connections v4.0 BASE: 43
Connections v4.0 CR1: 43
Connections v4.0 CR2: 43
Connections v4.0 CR3: 43
Connections v4.0 CR4: 43
Connections v4.5 BASE: 51
Connections v4.5 CR1: 51
Connections v4.5 CR2: 51
Connections v4.5 CR3: 51
Connections v4.5 CR4: 51
Connections App: Communities
BD: SNCOMM
Table: SNCOMM_SCHEMA
Connections v4.0 BASE: 76
Connections v4.0 CR1: 76
Connections v4.0 CR2: 76
Connections v4.0 CR3: 76
Connections v4.0 CR4: 76
Connections v4.5 BASE: 77
Connections v4.5 CR1: 77
Connections v4.5 CR2: 77
Connections v4.5 CR3: 77
Connections v4.5 CR4: 77
Connections App: Community Events
BD: SNCOMM
Table: CA_SCHEMA
Connections v4.0 BASE: 10
Connections v4.0 CR1: 10
Connections v4.0 CR2: 10
Connections v4.0 CR3: 10
Connections v4.0 CR4: 10
Connections v4.5 BASE: 15
Connections v4.5 CR1: 15
Connections v4.5 CR2: 15
Connections v4.5 CR3: 15
Connections v4.5 CR4: 15
Connections App: BookMarks
BD: DOGEAR
Table: DOGEAR_SCHEMA
Connections v4.0 BASE: 14
Connections v4.0 CR1: 14
Connections v4.0 CR2: 14
Connections v4.0 CR3: 14
Connections v4.0 CR4: 14
Connections v4.5 BASE: 15
Connections v4.5 CR1: 15
Connections v4.5 CR2: 15
Connections v4.5 CR3: 15
Connections v4.5 CR4: 15
Connections App: Forums
BD: FORUM
Table: DF_SCHEMA
Connections v4.0 BASE: 21
Connections v4.0 CR1: 21
Connections v4.0 CR2: 21
Connections v4.0 CR3: 21
Connections v4.0 CR4: 21
Connections v4.5 BASE: 27
Connections v4.5 CR1: 27
Connections v4.5 CR2: 27
Connections v4.5 CR3: 27
Connections v4.5 CR4: 27
Connections App: HomePage , News, Search
BD: HOMEPAGE
Table: HOMEPAGE_SCHEMA
Connections v4.0 BASE : 110
Connections v4.0 CR1 : 110
Connections v4.0 CR2 : 132
Connections v4.0 CR3 : 132
Connections v4.0 CR4 : 132
Connections v4.5 BASE: 210
Connections v4.5 CR1 : 210
Connections v4.5 CR2 : 210
Connections v4.5 CR3 : 211
Connections v4.5 CR4 : 213
Connections App: Metrics
BD: METRICS
Table: PRODUCT
Connections v4.0 CR2: 29
Connections v4.0 CR1: 29
Connections v4.0 CR2: 29
Connections v4.0 CR3: 30
Connections v4.0 CR4: 30
Connections v4.5 BASE: 34
Connections v4.5 CR1: 34
Connections v4.5 CR2: 37
Connections v4.5 CR3: 37
Connections v4.5 CR4: 37
Connections App: Mobile
BD: MOBILE
Table: ROLLER_PROPERTIES
Connections v4.0 BASE: 1
Connections v4.0 CR1: 1
Connections v4.0 CR2: 1
Connections v4.0 CR3: 1
Connections v4.0 CR4: 1
Connections v4.5 BASE: 1
Connections v4.5 CR1: 1
Connections v4.5 CR2: 1
Connections v4.5 CR3: 1
Connections v4.5 CR4: 2
Connections App: Profiles
BD: PEOPLEDB
Table: SNPROF_SCHEMA
Connections v4.0 BASE: 33
Connections v4.0 CR1: 33
Connections v4.0 CR2: 33
Connections v4.0 CR3: 33
Connections v4.0 CR4: 33
Connections v4.5 BASE: 36
Connections v4.5 CR1: 36
Connections v4.5 CR2: 36
Connections v4.5 CR3: 36
Connections v4.5 CR4: 36
Connections App: Wiki
BD: WIKIS
Table: PRODUCT
Connections v4.0 BASE: 79
Connections v4.0 CR1: 79
Connections v4.0 CR2: 79
Connections v4.0 CR3: 79
Connections v4.0 CR4: 79
Connections v4.5 BASE: 82
Connections v4.5 CR1: 89
Connections v4.5 CR2: 89
Connections v4.5 CR3: 89
Connections v4.5 CR4: 89
NOTE: All these tips are not officaliy sanctioned by IBM as they do not release DB schema info to the public, so you use them at your own risk, Also if IBM are reading this and I either have somthing wrong or you have documented this for the public, then please tell me and I will correct 🙂
NOTE: I’m not a proper Connections / Web Sphere admin, If you want proper Web Sphere and Connections admin you want the Turtle Partnership