Diagrams


Table

Application Area Setup

Fields

# Name Type
1 Company Name (Company Name) Text30
2 Profile ID (Profile ID) Code30
3 User ID (User ID) Code50
100 Basic (Basic) Boolean
200 Suite (Suite) Boolean
300 Relationship Mgmt (Relationship Mgmt) Boolean
400 Jobs (Jobs) Boolean
500 Fixed Assets (Fixed Assets) Boolean

Keys

# Fields
0 Company Name,Profile ID,User ID (Company Name,Profile ID,User ID) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Company Name (Company Name) Company Name (Name) 1..n
Profile ID (Profile ID) Profile Profile ID (Profile ID) 1..n
User ID (User ID) User User Name (User Name) 1..n

Table Relations From Other Tables

From Table From Field