difference between Base Table and Core table

arpitt
Tera Expert

What is the difference between Base Table and Core table ?

30 REPLIES 30

Palash Sarkar1
Giga Expert

Hi

I think you already solved your question. It was also confusing to me.

Then I create a document, I share with you. Hope it helps to other.

 

find_real_file.png

 

You may want to be careful of "related tables" - really these are child tables, extended from their parent.

[sys_user] is related to [incident] but that's a PK/FK relationship.

Other than that... quite good. Nice imagery!

Jason K
Tera Contributor

I wonder if the folks from ServiceNow are confused too.  In the SNOW participant guide under the Tables section they state that the [task] table is one of the core tables provided with the base system.  Fast forward to the CMDB section they state "the Task [task] table and the Configuration Item [cmdb_ci] table are the two base tables in ServiceNow".  Very confusing, it seems Core and Base are used interchangeably. 

Sean Hamilton
Giga Expert

Yes, agreed.  What is the current situation?  When I first took and passed my CSA exam in September 2017, the two core tables were task and cmdb_ci, now I'm reading a lot of folks are confused.  Did SN change the core 2 tables to task (stayed the same) and cmdb (from cmdb_ci)?  Seems like this should be an easy one!   I read someone state that SN changed cmdb_ci to cmdb during the Geneva release.  Now I'm confused.  In my NY dev instance it looks as if indeed task and cmdb are the two core tables (if you check the schemas out), but I don't know?  Fun!

cmdb_ci extends cmdb now.

I'm not sure if the 'core' definition has changed with the new table based licensing model.


ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022