Skip to main content

By clicking Submit, you agree to the developerWorks terms of use.

The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

  • Close [x]

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

By clicking Submit, you agree to the developerWorks terms of use.

All information submitted is secure.

  • Close [x]

developerWorks Community:

  • Close [x]

Design Synopsis: Creating database blueprints (Sample Design Synopsis Output sidebar)

[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

Database Information:

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]

Replication Information:

Replica ID: 85256497:0051197F
Priority:Medium
Propagate Deletions: Enabled
ReplicationEnabled
Cutoff Document Deletion: Disabled
Truncate Large Documents: Disabled
Replicate Title:Enabled
Replicate Categories: Enabled
Replicate Design Template Names: Enabled

Form Information:

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 Information:

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