FmPro
Migrator Features and Benefits
FmPro
Migrator Demo Available for download...
Bookmark
This Page
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 Typ e |
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 |
CLOB |
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 |
BLOB |
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
----------------------- 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 |