SystemUserBase

154 rows


Description

User

Columns

Column Type Size Nulls Auto Default Children Parents Comments
SystemUserId uuid 2147483647 √ null

Old CRM UserID

FirstName varchar 64 √ null
LastName varchar 64 √ null
PersonalEMailAddress varchar 100 √ null
FullName varchar 2147483647 √ null
InternalEMailAddress varchar 100 √ null
CreatedOn timestamp 26,3 √ null
IsDisabled bool 1 √ null
id serial 10 √ nextval('v1."SystemUserBase_id_seq"'::regclass)
AccountBase.createdby_id AccountBase_createdby_id_fkeyR
AccountBase.owner_id AccountBase_owner_id_fkeyR
Campaign.approver_id Campaign_approver_id_fkeyR
Campaign.createdby_id Campaign_createdby_id_fkeyR
Campaign.owner_id Campaign_owner_id_fkeyR
Campaign.uploader_id Campaign_uploader_id_fkeyR
CampaignStrategy.createdby_id CampaignStrategy_created_by_fkeyR
CampaignStrategy.modified_by CampaignStrategy_modified_by_fkeyR
ContactBase.createdby_id ContactBase_createdby_id_fkeyR
ContactBase.owner_id ContactBase_owner_id_fkeyR
InvoiceBase.CancelledBy InvoiceBase_CancelledBy_fkeyR
InvoiceBase.createdby_id InvoiceBase_createdby_id_fkeyR
InvoiceBase.owner_id InvoiceBase_owner_id_fkeyR
InvoiceDetailBase.createdby_id InvoiceDetailBase_createdby_id_fkeyR
new_brandBase.createdby_id new_brandBase_createdby_id_fkeyR
new_POBase.approvedby_id new_POBase_approvedby_id_fkeyR
new_POBase.CancelledBy new_POBase_CancelledBy_fkeyR
new_POBase.createdby_id new_POBase_createdby_id_fkeyR
new_POBase.owner_id new_POBase_owner_id_fkeyR
new_POBase.paidby_id new_POBase_paidby_id_fkeyR
new_receiptBase.CancelledBy new_receiptBase_CancelledBy_fkeyR
new_receiptBase.createdby_id new_receiptBase_createdby_id_fkeyR
new_receiptBase.owner_id new_receiptBase_owner_id_fkeyR
new_trackerBase.createdby_id new_trackerBase_createdby_id_fkeyR
Posts.approvedby_id Posts_approvedby_id_fkeyR
Posts.approver_id Posts_approver_id_fkeyR
Posts.createdby_id Posts_createdby_id_fkeyR
Posts.onlinechecksubmittedby_id Posts_onlinechecksubmittedby_id_fkeyR
Posts.orderedby_id Posts_orderedby_id_fkeyR
Posts.requestedby_id Posts_requestedby_id_fkeyR
Posts.requestedfrom_id Posts_requestedfrom_id_fkeyR
Posts.uploadedby_id Posts_uploadedby_id_fkeyR
Posts.uploader_id Posts_uploader_id_fkeyR
Preferences.created_by View_created_by_fkeyR
Project.createdby_id Project_createdby_id_fkeyR
Project.owner_id Project_owner_id_fkeyR
SalesOrderBase.createdby_id SalesOrderBase_createdby_id_fkeyR
SalesOrderBase.owner_id SalesOrderBase_owner_id_fkeyR
Users_Roles.user_id Users_Roles_user_id_fkeyR
Website.createdby_id Website_createdby_id_fkeyR
status int4 10 null
UsersStatus.id SystemUserBase_status_fkeyR

Indexes

Constraint Name Type Sort Column(s)
SystemUserBase_pkey Primary key Asc id
SystemUserBase_id_key Must be unique Asc id

Relationships