.com Solutions Inc. - logo  
Products - Header Buttons
.
Repgen bullet item 7b Installgen bullet item 7b FmPro Migratorbullet item 7b CGIScripter
.
.
.

.
.

FmPro Migrator - Oracle Files - Title Graphic

FmPro Migrator Features and Benefits

FmPro Migrator Demo Available for download...

Bookmark This Page

email a friend

.

Contact_Management.fp5 Database Structure Report

Copyright 2003 by .com Solutions Inc.

This output file was created by FmPro Migrator version 1.23 on Thu Apr 3 12:21:05 2003. By .com Solutions Inc. www.dotcomsolutionsinc.net

----------------------- Database Summary --------------------------

FileMaker Version: FileMaker Pro 5.5v1 Dev
FileMaker Database Name: Contact_Management.fp5
Converting To: Oracle 8i-9i
Oracle 8i-9i Table: contact_management
Schema: user1 New
Tablespace Name: users New
Tablespace Filename: /u01/prod1/users01.dbf
Index Tablespace Name: indx New
Index Tablespace Filename: /u01/prod1/indx01.dbf
Fields: 40
Layouts: 15
Scripts: 23

----------------------- Fields Summary --------------------------
Number of Fields: 40

Original Field Name Renamed As Original Type Converted To Primary Key
Last Name last_name text VARCHAR2(4000) no
First Name first_name text VARCHAR2(4000) no
Company company text VARCHAR2(4000) no
Title title text VARCHAR2(4000) no
Street 1 street_1 text VARCHAR2(4000) no
City 1 city_1 text VARCHAR2(4000) no
State Province 1 state_province_1 text VARCHAR2(4000) no
Postal Code 1 postal_code_1 text VARCHAR2(4000) no
Notes notes text VARCHAR2(4000) no
Phone 1 phone_1 text VARCHAR2(4000) no
Date Created date_created date/time DATE no
Date Modified date_modified date/time DATE no
Identification Number identification_number text VARCHAR2(4000) no
Image Data image_data container BLOB no
Template Information Global template_information_global text CLOBNote2 no
Created By created_by text VARCHAR2(4000) no
Last Layout last_layout number NUMBER no
Email email text VARCHAR2(4000) no
Phone 2 phone_2 text VARCHAR2(4000) no
Current Date current_date date/time DATE no
Similar By similar_by text VARCHAR2(4000) no
Similars Key similars_key text VARCHAR2(4000) no
Similars MultiKey similars_multikey text VARCHAR2(4000) no
Similars Count similars_count number NUMBER no
Similars Tab Label similars_tab_label text VARCHAR2(4000) no
Similar Name Key similar_name_key text VARCHAR2(4000) no
Similar Company Key similar_company_key text VARCHAR2(4000) no
Street 2 street_2 text VARCHAR2(4000) no
City 2 city_2 text VARCHAR2(4000) no
State Province 2 state_province_2 text VARCHAR2(4000) no
Postal Code 2 postal_code_2 text VARCHAR2(4000) no
Address Type 1 address_type_1 text VARCHAR2(4000) no
Address Type 2 address_type_2 text VARCHAR2(4000) no
Scratch scratch text VARCHAR2(4000) no
Thumbnail thumbnail container BLOBNote 3 no
Contact ID contact_id number NUMBER no
Most Recent Form Layout most_recent_form_layout number NUMBER no
Letter Body Text letter_body_text text VARCHAR2(4000) no
Email Address with Name email_address_with_name text VARCHAR2(4000) no
Thumbnail Display thumbnail_display container BLOB no



----------------------- Fields Detail --------------------------

Note: Long formulas usually wrap around to the next text line. The info presented here has been HTML formatted for improved readability.

Name ID FileMaker Type Empty Values Unique Values Repeating Global Access Protection Calculation
Last Name 2 text Empty Ok Not Unique No No read/write formulas protected  
First Name 4 text Empty Ok Not Unique No No read/write formulas protected  
Company 7 text Empty Ok Not Unique No No read/write formulas protected  
Title 12 text Empty Ok Not Unique No No read/write formulas protected  
Street 1 15 text Empty Ok Not Unique No No read/write formulas protected  
City 1 16 text Empty Ok Not Unique No No read/write formulas protected  
State Province 1 17 text Empty Ok Not Unique No No read/write formulas protected  
Postal Code 1 18 text Empty Ok Not Unique No No read/write formulas protected  
Notes 19 text Empty Ok Not Unique No No read/write formulas protected  
Phone 1 21 text Empty Ok Not Unique No No read/write formulas protected  
Date Created 24 date/time Empty Ok Not Unique No No note read only  
Date Modified 25 date/time Empty Ok Not Unique No No note read only  
Identification Number 31 text Empty Ok Not Unique No No read/write formulas protected  
Image Data 41 container Empty Ok Not Unique No No read/write formulas protected  
Template Information Global 44 text Empty Ok Not Unique No Yes read/write formulas protected  
Created By 45 text Empty Ok Not Unique No No read/write formulas protected  
Last Layout 46 number Empty Ok Not Unique No Yes read/write formulas protected  
Email 67 text Empty Ok Not Unique No No read/write formulas protected  
Phone 2 68 text Empty Ok Not Unique No No read/write formulas protected  
Current Date 76 date/time Empty Ok Not Unique No No note read only Status(CurrentDate)
Similar By 77 text Empty Ok Not Unique No Yes read/write formulas protected  
Similars Key 78 text Empty Ok Not Unique No No note read only Case(
Similar By = \"Name\",
Similar Name Key,
Similar By = \"Company\",
Similar Company Key,
Similar By = \"City\",
City 1,
\"\")
Similars MultiKey 79 text Empty Ok Not Unique No No note read only Similar Name Key & \"¦\" &
Company & \"¦\" &
City 1
Similars Count Empty 80 number Empty Ok Not Unique No No note read only Count(Similars::Similars Key)
Similars Tab Label 81 text Empty Ok Not Unique No No note read only \"Related Contacts\" &
If(Similars Count,
\": \" & Similars Count & \" by \" & Similar By,
\"\")
Similar Name Key 82 text Empty Ok Not Unique No No note read only Last Name
Similar Company Key 83 text Empty Ok Not Unique No No note read only Company
Street 2 84 text Empty Ok Not Unique No No read/write formulas protected  
City 2 85 text Empty Ok Not Unique No No read/write formulas protected  
State Province 2 86 text Empty Ok Not Unique No No read/write formulas protected  
Postal Code 2 87 text Empty Ok Not Unique No No read/write formulas protected  
Address Type 1 88 text Empty Ok Not Unique No No read/write formulas protected  
Address Type 2 89 text Empty Ok Not Unique No No read/write formulas protected  
Scratch 90 text Empty Ok Not Unique No Yes read/write formulas protected  
Thumbnail 91 container Empty Ok Not Unique No No read/write formulas protected  
Contact ID Not Unique No No 92 number Empty Ok Not Unique No No read/write formulas protected  
Most Recent Form Layout 93 number Empty Ok Not Unique No Yes read/write formulas protected  
Letter Body Text 94 text Empty Ok Not Unique No Yes read/write formulas protected  
Email Address with Name 95 text Empty Ok Not Unique No No note read only First Name & \" \" & Last Name & \" <\" & Email & \">\"
Thumbnail Display 96 container Empty Ok Not Unique No No note read only If(
IsEmpty(Thumbnail),
Image Data,
Thumbnail
)

----------------------- Layouts Summary --------------------------
Layouts: 15

Name ID Visible Access Protection Lock Status
Form - Main Address 1 Yes read/write formulas protected unlocked
List 2 Yes read/write formulas protected unlocked
Information 4 Yes read/write formulas protected unlocked
- 8 Yes read/write formulas protected unlocked
Form - Second Address 11 Yes read/write formulas protected unlocked
Form - Similars 14 Yes read/write formulas protected unlocked
Letter 17 No read/write formulas protected unlocked
Web List 19 No read/write formulas protected unlocked
- 20 No read/write formulas protected unlocked
Web Form 21 No read/write formulas protected unlocked
Avery 5160 22 No read/write formulas protected unlocked
- 23 No read/write formulas protected unlocked
Table 37 No read/write formulas protected unlocked
List Report 38 No read/write formulas protected unlocked
Letter: Address Confirmation 40 No read/write formulas protected unlocked

----------------------- Layout Details For Layout: Form - Main Address --------------------------
Number of Fields: 14
Field Name

First Name
Company
Image Data
Title
Phone 1
Phone 2
Email
Notes
Similars Tab Label
Street 1
Address Type 1
City 1
State Province 1
Postal Code 1

----------------------- Layout Details For Layout: List --------------------------
Number of Fields: 5
Field Name

First Name
Company
Thumbnail Display
Phone 1
Title

----------------------- Layout Details For Layout: Information --------------------------
Number of Fields: 1
Field Name

Template Information Global

----------------------- Layout Details For Layout: - --------------------------
Number of Fields: 0
Field Name


----------------------- Layout Details For Layout: Form - Second Address --------------------------
Number of Fields: 14
Field Name

First Name
Company
Image Data
Title
Phone 1
Phone 2
Email
Notes
Similars Tab Label
Street 2
Address Type 2
City 2
State Province 2
Postal Code 2

----------------------- Layout Details For Layout: Form - Similars --------------------------
Number of Fields: 12
Field Name

First Name
Company
Image Data
Title
Phone 1
Phone 2
Email
Notes
Similars Tab Label
Similar By
Similars::First Name
Similars::Company
Note1

----------------------- Layout Details For Layout: Letter --------------------------
Number of Fields: 2
Field Name

Current Date
Letter Body Text

----------------------- Layout Details For Layout: Web List --------------------------
Number of Fields: 5
Field Name

First Name
Last Name
Title
Company
Phone 1

----------------------- Layout Details For Layout: - --------------------------
Number of Fields: 0
Field Name


----------------------- Layout Details For Layout: Web Form --------------------------
Number of Fields: 14
Field Name

First Name
Last Name
Phone 1
Company
Title
Email
Street 1
City 1
State Province 1
Postal Code 1
Phone 2
Date Modified
Image Data
Notes

----------------------- Layout Details For Layout: Avery 5160 --------------------------
Number of Fields: 1
Field Name

Postal Code 1

----------------------- Layout Details For Layout: - --------------------------
Number of Fields: 0
Field Name


----------------------- Layout Details For Layout: Table --------------------------
Number of Fields: 15
Field Name

First Name
Company
Title
Phone 1
Email
Notes
Street 1
City 1
State Province 1
Postal Code 1
Phone 2
Street 2
City 2
State Province 2
Postal Code 2

----------------------- Layout Details For Layout: List Report --------------------------
Number of Fields: 3
Field Name

Title
Company
Phone 1

----------------------- Layout Details For Layout: Letter: Address Confirmation --------------------------
Number of Fields: 1
Field Name

Current Date

----------------------- Scripts Summary --------------------------
Number of Scripts: 23

Name ID
View Contact List 7
Open Script 10
- 11
Dial Extension 12
Dial Home Phone 13
Dial Emergency Phone 14
Find 15
Go to Information Layout 16
Go to Reports Layout 18
Write Letter 20
Avery 5160 22
- 36
- 38
Go to List Layout 39
Your Own Report 40
Go to Form Layout 41
Go to Table Layout 43
Swap Main and Second Addresses 44
Write Letter to Main Address 45
Send Email 46
Go to Form Layout 1 47
Go to Form Layout 2 48
Go to Form Layout 3 49


.

hline

. .

.

. .
 

Home | Products | Services | Downloads | Order | Support | Contact

Legal Notices

.
.   .
.
Home Products Services Downloads Order Support Contact