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