[Back to "Design Synopsis: Creating database blueprints"]
Sample Design Synopsis Output (sidebar)
Below is an abbreviated sample of Design Synopsis output for the Public Address Book. For this sample, we selected the Database, Replication, Form (Person form only), and View (Person view only) options.
Lotus Notes Database Synopsis - Generated at 12:02:50 PM on 10/14/97
| Path: | e:\NOTEFILE\names1.nsf |
| Title: | Pub Names |
| Date Created: | 05/14/97 10:45:49 AM |
| Last Data Modification: | 05/14/97 11:57:52 AM |
| Last Non-Data Modification: | 05/14/97 10:45:57 AM |
| Categories: | [None Assigned] |
| Template Name: | [None Assigned] |
| Inherit Design From Template: | StdR4PublicAddressBook |
| Text Compression: | Disabled |
| Full-Text Indexing: | Disabled |
| Local Encryption Key Name: | [Not Assigned] |
| Replica ID: | 85256497:0051197F |
| Priority: | Medium |
| Propagate Deletions: | Enabled |
| Replication | Enabled |
| Cutoff Document Deletion: | Disabled |
| Truncate Large Documents: | Disabled |
| Replicate Title: | Enabled |
| Replicate Categories: | Enabled |
| Replicate Design Template Names: | Enabled |
| Form: | Person |
| Last Modification: | 05/14/97 10:45:51 AM |
| Type: | Document |
| Window Title Formula: | SELECT @V2If(@IsNewDoc; "New Person"; @Name([Abbreviate]; @Subset(FullName; 1))); |
| Include in Compose Menu: | Yes |
| Include in Query by Form: | Yes |
| Default Database Form: | Yes |
| Automatically Refresh Fields: | No |
| Mail New Documents When Saving: | No |
| Store Form In Documents: | No |
| Inherit Default Field Values: | No |
| Updates Become Responses: | No |
| Retain Prior Versions As Responses: | No |
| Activate Objects When Composing: | No |
| Activate Objects When Editing: | No |
| Activate Objects When Reading: | No |
| Document Encryption Keys: | [None Assigned] |
| Composed Documents May Be Read By: | All Users |
| Form May Be Composed By: | [UserCreator] |
| Field: | DisplayName |
| Datatype: | Names |
| Help Description: | [Not Assigned] |
| Field Type: | Computed for display |
| Sign When Mailing/In Section: | No |
| Encryption: | Disabled |
| Update Requires Editor Access: | No |
| Formula: | @If(FullName = ""; ""; ": " + @Name([Abbreviate]; @Subset(FullName; 1)));
|
| Field: | DisplayMailAddress |
| Datatype: | Text |
| Help Description: | [Not Assigned] |
| Field Type: | Computed for display |
| Sign When Mailing/In Section: | No |
| Encryption: | Disabled |
| Update Requires Editor Access: | No |
| Formula: | name := @Name([Abbreviate]; @Subset(FullName; 1)); @If(MailDomain != "" & MailAddress != ""; @Name([Abbreviate]; MailAddress) + " @ " + MailDomain; MailDomain != ""; name + " @ " + MailDomain; MailAddress != ""; @Name([Abbreviate]; MailAddress); name); |
| Field: | FirstName |
| Datatype: | Text |
| Input Multi-Value Separator(s): | Comma, Semicolon, New Line, Blank Line |
| Display Multi-Value Separator: | Semicolon |
| Help Description: | First name(s) and nicknames - e.g. John; Johnny |
| Field Type: | Editable |
| Sign When Mailing/In Section: | No |
| Encryption: | Disabled |
| Update Requires Editor Access: | Yes |
| Input Translation Formula: | @Trim(FirstName) |
| Field: | MailSystem |
| Datatype: | Keywords |
| Help Description: | [Not Assigned] |
| Field Type: | Editable |
| Keyword User Interface: | Standard |
| Allow Values Not In List: | No |
| Allowable Keywords: | Notes|1 cc:Mail|2 Internet|5 POP3|6 X.400|4 Other|3 None|100 No |
| Sign When Mailing/In Section: | Disabled |
| Encryption: | No |
| Update Requires Editor Access: | @If(MailAddress = ""; "1"; "5"); |
| Default Value Formula: | |
| Field: | MiddleInitial |
| Datatype: | Text |
| Input Multi-Value Separator(s): | Comma, Semicolon, New Line, Blank Line |
| Display Multi-Value Separator: | Semicolon |
| Help Description: | Middle Initial with a trailing period (optional) |
| Field Type: | Editable |
| Sign When Mailing/In Section: | No |
| Encryption: | Disabled |
| Update Requires Editor Access: | Yes |
| Input Translation Formula: | @Trim(MiddleInitial) |
| Field: | MailDomain |
| Datatype: | Text |
| Help Description: | Domain name of person's mail server |
| Field Type: | Editable |
| Sign When Mailing/In Section: | No |
| Encryption: | Disabled |
| Update Requires Editor Access: | Yes |
| Input Translation Formula: | @Trim(MailDomain); |
| Field: | LastName |
| Datatype: | Text |
| Input Multi-Value Separator(s): | Comma, Semicolon, New Line, Blank Line |
| Display Multi-Value Separator: | Semicolon |
| Help Description: | Last name - e.g. Smith |
| Field Type: | Editable |
| Sign When Mailing/In Section: | No |
| Encryption: | Disabled |
| Update Requires Editor Access: | Yes |
| Input Translation Formula: | @Trim(LastName) |
| Input Validation Formula: | @V2If(LastName = ""; @Failure("Last Name is required"); @Success) |
| Field: | MailServer |
| Datatype: | Names |
| Help Description: | Distinguished name of person's mail server - e.g. Marketing |
| Field Type: | Editable |
| Sign When Mailing/In Section: | No |
| Encryption: | Disabled |
| Update Requires Editor Access: | Yes |
| Input Translation Formula: | @Trim(MailServer) |
| Field: | Type |
| Datatype: | Text |
| Help Description: | [Not Assigned] |
| Field Type: | Computed when composed |
| Sign When Mailing/In Section: | No |
| Encryption: | Disabled |
| Update Requires Editor Access: | Yes |
| Formula: | "Person" |
| Shared Field Reference: | DocumentAccess |
| ...more fields here |
| View Name: | People |
| Last Modification: | 05/14/97 10:45:53 AM |
| Default Database View: | Yes |
| No Response Hierarchy: | Disabled |
| Categories Initially: | Expanded |
| Unread Marks: | None |
| Refresh Frequency: | Automatic |
| Discard Index: | Never |
| View May Be Used By: | All Users |
| Time Relative Formulae: | No |
| Selection Formula: | SELECT Type = "Person"; |
| Column Number: | 1 |
| Column Title: | Name |
| Column Formula: | @Trim(@Subset(LastName; 1)) + @If(Firstname != ""; ", " + @Trim(@Subset(FirstName; 1)); ""); |
| Column Width: | 13 Characters |
| List Separator: | |
| Hidden: | No |
| Responses Only: | No |
| Icon: | No |
| Number Format: | General |
| Percentage (value * 100)%: | No |
| Parentheses on Negative Numbers: | No |
| Punctuated at Thousands: | No |
| Time Format: | 10/14/97 12:02:50 PM |
| Sorting: | Ascending |
| Justification: | Left |
| Totals: | None |
| Hide Detail Values: | No |
| Column Number: | 2 |
| Column Title: | Telephone |
| Column Formula: | OfficePhoneNumber : PhoneNumber; |
| Column Width: | 14 Characters |
| List Separator: | New Line |
| Hidden: | No |
| Responses Only: | No |
| Icon: | No |
| Number Format: | General |
| Percentage (value * 100)%: | No |
| Parentheses on Negative Numbers: | No |
| Punctuated at Thousands: | No |
| ...more columns here |