Please enable JavaScript.
Coggle requires JavaScript to display documents.
Planner User Dashboard (Clients Index - RPC237 (View Single Client -…
Planner User Dashboard
My Profile
-
Notification Preferences
Activity Notifications - RPC824
-
-
Invites/Request Connect/Search #
-
-
-
Invite Connect/Create Client - RPC717
-
View Single Client - RPC598
-
Clients Vendors List - RPC241
View Client Related Vendor Docs - RPC665
-
-
-
-
-
-
-
-
Role Model: read only
RoleID: PRIMARY, string, machine defined, must validate as unique-in-table
Name: string, machine defined
CanInvitePlannerUser: boolean, machine defined
CanInviteVendor: boolean, machinedefined
CanInviteClientUser: boolean, machinedefined
CanCreateInvoice: boolean, machine defined
CanCreateContract: boolean, machine defined
CanReviewInvoice: boolean, machine defined
CanReviewContract: boolean, machine defined
CanSignContract: boolean, machine defined
CanPayInvoice: boolean, machine defined
CanDeactivePlanneUser: boolean, machine defined
CanDeactiveClientUser: boolean, machine defined
CanDeactiveVendorUser: boolean, machine defined
CanDeactivatePlannerOrganiser: boolean, machine defined
CanGrantFreeTime: boolean, machine defined
CanAcceptConnection: boolean, machine-defined
CanGrantPermissionsToPU: boolean, machine-defined
CanGrantPermissionsToPO: boolean, machine-defined
CanVoidContract: boolean, machine defined
CanUpdateEmail: boolean, machine defined
CanArchiveContract: boolean, machine-defined
CanArchiveInvoice: boolean, machine-defined
CanPauseAccount: boolean, machine-defined
CanVoidINvoice: boolean, machine-defined
CanUpdateInvoice: boolean, machine-defined
CanUpdateContract: boolean, machine-defined
CanArchiveClientConnection: boolean, machine-defined
CanUpdatePlannerUser: boolean, machine-defined
CanDeactivatePlannerUser: boolean, machine defined
CanSetPrimaryPaymentMethod: boolean, machine-defined
CanUpdatePrimaryPaymentMethod: boolean, machine-defined
CanRemovePaymentMethod: boolean, machine-defined
CanAddPaymentMethod: boolean, user defined
CanInitiateConnection: boolean, machine-defined
CanAcceptConnectionRequest: boolean, machine-defined
CanUpdatePlannerUserProfile: boolean, machine defined
UserID: PRIMARY, string, machine used only, machine defined, cannot be null, must validate as unique
UserName: string, defined by user, cannot be null, must validate as unique
Password: string, encrypted, defined by user, cannot be null
UserRole: Reference to RoleTable, cannot be null #
FirstName: string, defined by user, cannot be null
LastName: string, defined by user, cannot be null
Image: url, defined by user, reference to storage bucket
Description: string, user editable
Phone: string, user editable, must validate as phone number
Email: string, user editable, must validate as phone email address, {cannot be null?}
AddressLine1: string, user editable
AddressLine2: string, user editable
City: string, user editable
StateID: reference to state table #
PostalCode: string, user editable
Country: Reference to Country Model, currently defined by machine #
-
Website: string, defined by user must validate as url
Twitter: string, user defined, must validate as {twitter?} url
Instagram: string, user defined, must validate as {instagram?} url
Facebook: string, must validate as {facebook?} url
Pinterest: string, user defined, must validate as {pinterest?} url
PasswordLastUpdated: date/time, machine defined, cannot be null
AccountStatus: reference to AccountStatus Model, machine defined #
StripeID: string, machine defined, reference to external API STRIPE
LastSuccessfulSettlement: date/time, machine editable,
SubscriptionRenewalDate: date/time, must validate as future date/time
passwordResetToken: string, must be unique
passwordResetTokenExpiresAt: date/time, defaults to 0
LastSeenAt: date/time, must not be null
NotificationsPreferenceID: string, reference to email notifications preferences model, defaults to ??
WeddingDate: date/time, user defined
EmailNotificationsPreferenceID: reference to EmailNotifications preference model, defaults to {some option}
-
InvoiceID: PRIMARY, string, machine defined, must not be null, must be unique-in-table
PayerID: string, reference to User Model, must not be null #
PayeeID: string, reference to User Model, must not be null #
Amount: number, must not be null
Description: string, user defined, can be null
CreatedDate: date/time, machine defined, must not be null
LastAlteredDate: date/time, machine defined, must not be null
StripeID: string, reference to EXTERNAL API: stripe
InvoiceStateID: Reference to invoice State Model, must not be null
IsFinalInvoice: boolean, defaults to false
TotalAmountThisService: number, defaults to ""
Gratuity: number, defaults to ""
Tax: number, defaults to 0
EventID: PRIMARY, string, machine defined, must be unique-in-table, must not be null
UserID: string, reference to User Model, must not be null #
EventTimeStamp: date/time, must validate as date/time, must not be null
EventMessage, string, must not be null
EventCategoryID, string, reference to Event Category Model, must not be null
DocumentID: reference to contract or invoice models, must not be null
ContractID: PRIMARY, string, machine-defined, must be unique-in-table, must not be null
PromissorID: string, reference to User Model, must validate as known user ID, must not be null #
PromisseeID: string, reference to User Model, must validate as known user ID, must not be null #
CreatedDate: date/time, machine defined, must not be null
DocusignID: string, reference to EXTERNAL API: docusign, must not be null
ContractStateID: string, reference to Contract State Model, must not be null #
-
-
-
State Model: read only
StateID: PRIMARY, string, machine defined, must validate as unique-in-table, cannot be null
Name: string, machine defined, cannot be null
CountryiD: string, Reference to Country model, cannot be null #
Abbreviation: string, machine defined, cannot be null
Invoice Events Model
EventID: PRIMARY, string, machine defined, must not be null, must be unique-in-table
InitiatingUserID: string, reference to User Table
InvoiceID: string, reference to Invoice Model, must not be null #
Event Description: string, must not be null {Wants definition}
-
Country Model: read only
CountryID: PRIMARY, string, machine defined, must validate as unique-in-table, cannot be null
Name: string, machine defined, must validate as unique-in-table, cannot be null
-
User Search Parameters Model: read only #
ParameterID: PRIMARY, string, machine defined, must be unique-in-table, must not be null
ParameterName: string, user readable, must not be null
Event Category Model: read only #
EventCategoryID: PRIMARY, string, machine defined, must be unique-in-table, must not be null
Name: string, super-user-defined, user readable, must not be null
-
Invoice State Model: read only #
InvoiceStateID: PRIMARY, string, machine defined, must be unique-in-table, must not be null
Name: string, human readable, super-user-defined, must not be null
-
-