This is an old revision of the document!
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 Name | Field Type | Field Length | Nullable | Auto Incement | Default Value | Foreign Key | Indexed | Additional Info | Comment |
|---|---|---|---|---|---|---|---|---|---|
| user_id | Integer | 8 | Not Null | Yes | 0 | Yes | Yes | Unsigned, ZeroFill | A synthetic user id |
Indicies
| Index Name | Index Kind | Index Type | Fields |
|---|---|---|---|
Foreign Keys / Constraints
| Foreign Key Name | Action Trigger | Reference Table | Reference Column |
|---|---|---|---|