Table of Contents

Details on Company_Details

Table Purpose

The Company_Details table holds information on each individual company entity. This information is referenced in the users profile and is used for reporting.

Table Structure

Column NameField TypeField LengthNullableAuto IncementDefault ValueForeign KeyIndexedAdditional InfoComment
user_idInteger8Not NullYes0YesYesUnsigned, ZeroFillA synthetic user id

Indicies

Index NameIndex KindIndex TypeFields

Foreign Keys / Constraints

Foreign Key NameAction TriggerReference TableReference Column