Table: Table_Information
Assigns an integer key to a table in the database.
Tags: read-only

Content of first 30 of 208 rows:
3Billing_Rate_TypeBRT
5dtpropertiesdtproperties
6PrivilegeP
7Privilege_DependencyPD
8Security_GroupSG
13StaffS
14Staff_Billing_RateSBR
16Staff_LevelSL
17Staff_Rate_TableSRT
18Staff_Security_GroupSSG
19Table_InformationTI
21DepartmentD
23FirmFirm
24OfficeO
25Practice_UserPU
32Staff_StatusSS
36User_SessionUS
38ActivityA
39Activity_ClassAC
40Activity_StatusAST
41Activity_CategoryAG
46FilterF
48Filter_LineFL
49Filter_Line_TypeFLT
53Filter_SelectFS
54Filter_TypeFT
56Tax_AreaTA
57Tax_Area_Taxing_AuthorityTATA
58Taxing_AuthorityTAU
59Taxing_Authority_TypeTAT
Columns
NameTypeConstraintsDescription
table_information_KEYintNOT NULL
namenvarchar (128)NOT NULLName of the table.
default_aliasnvarchar (128)NOT NULLThe default alias to use for this table.
Primary key
NameColumnsDescription
PK_Table_Information$table_information_KEYtable_information_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Table_Information$default_aliasdefault_alias
UK_Table_Information$namename
UK_Table_Information$table_information_KEY$nametable_information_KEY, nameExists to support a foreign superkey relationship.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Attachment__Table_Information__table_information_KEYtable_information_KEYAttachment
FK_Changeset_Modified_Table__Table_Information__table_information_KEYtable_information_KEYChangeset_Modified_Table
FK_Custom_Field__Table_Information__table_information_KEYtable_information_KEYCustom_Field
FK_Link_Group__Table_Information__table_information_KEYtable_information_KEYLink_Group
FK_Option_List__Table_Information__table_information_KEYtable_information_KEYOption_List
FK_Tagged_Item__Table_Information__table_information_KEYtable_information_KEYTagged_Item
FK_Custom_Value__Table_Information__table_information_KEYtable_information_KEYCustom_Value

Schema diagram