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