FmPro
Migrator Features and Benefits
FmPro
Migrator Demo Available for download...
Bookmark
This Page
Contact_Management Database Structure Report
This output file was created by FmPro Migrator on Tuesday,
April 15, 2008. By .com Solutions Inc. www.fmpromigrator.com
----------------------- Database Summary --------------------------
Source Database |
FileMaker 6 |
Original Table Name |
Contact_Management |
New Table Name |
Contact_Management |
Converting To: |
MySQL |
Fields |
52 |
----------------------- Fields Summary --------------------------
Number of Fields: 52
Original Field Name |
Renamed As |
Original Typ e |
Converted To |
Primary Key |
Last Name |
last_name |
text |
VARCHAR(25) |
no |
First Name |
first_name |
text |
VARCHAR(25) |
no |
Company |
company |
text |
VARCHAR(25) |
no |
Title |
title |
text |
VARCHAR(25) |
no |
Street 1 |
street_1 |
text |
VARCHAR(25) |
no |
City 1 |
city_1 |
text |
VARCHAR(25) |
no |
State Province 1 |
state_province_1 |
text |
VARCHAR(25) |
no |
Postal Code 1 |
postal_code_1 |
text |
VARCHAR(25) |
no |
Notes |
notes |
text |
VARCHAR(25) |
no |
Phone 1 |
phone_1 |
text |
VARCHAR(25) |
no |
Date Created |
date_created |
date/time |
DATE |
no |
Date Modified |
date_modified |
date/time |
DATE |
no |
Identification Number |
identification_number |
text |
VARCHAR(25) |
no |
Image Data |
image_data |
container |
LONGBLOB |
no |
Template Information Global |
template_information_global |
text |
TEXT |
no |
Created By |
created_by |
text |
VARCHAR(25) |
no |
Last Layout |
last_layout |
number |
DOUBLE |
no |
Email |
email |
text |
VARCHAR(25) |
no |
Phone 2 |
phone_2 |
text |
VARCHAR(25) |
no |
Current Date |
current_date |
date/time |
DATE |
no |
Similar By |
similar_by |
text |
VARCHAR(25) |
no |
Similars Key |
similars_key |
text |
VARCHAR(25) |
no |
Similars MultiKey |
similars_multikey |
text |
VARCHAR(25) |
no |
Similars Count |
similars_count |
number |
DOUBLE |
no |
Similars Tab Label |
similars_tab_label |
text |
VARCHAR(25) |
no |
Similar Name Key |
similar_name_key |
text |
VARCHAR(25) |
no |
Similar Company Key |
similar_company_key |
text |
VARCHAR(25) |
no |
Street 2 |
street_2 |
text |
VARCHAR(25) |
no |
City 2 |
city_2 |
text |
VARCHAR(25) |
no |
State Province 2 |
state_province_2 |
text |
VARCHAR(25) |
no |
Postal Code 2 |
postal_code_2 |
text |
VARCHAR(25) |
no |
Address Type 1 |
address_type_1 |
text |
VARCHAR(25) |
no |
Address Type 2 |
address_type_2 |
text |
VARCHAR(25) |
no |
Scratch |
scratch |
text |
VARCHAR(25) |
no |
Thumbnail |
thumbnail |
container |
LONGBLOB |
no |
Contact ID |
contact_id |
number |
DOUBLE |
no |
Most Recent Form Layout |
most_recent_form_layout |
number |
DOUBLE |
no |
Letter Body Text |
letter_body_text |
text |
VARCHAR(25) |
no |
Email Address with Name |
email_address_with_name |
text |
VARCHAR(25) |
no |
Thumbnail Display |
thumbnail_display |
container |
LONGBLOB |
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 |
Original Type |
NULL Status |
Unique Status |
Repeating |
Global |
Calculation |
Last Name |
2 |
text |
NULL |
Not Unique |
No |
Normal |
|
First Name |
4 |
text |
NULL |
Not Unique |
No |
Normal |
|
Company |
7 |
text |
NULL |
Not Unique |
No |
Normal |
|
Title |
12 |
text |
NULL |
Not Unique |
No |
Normal |
|
Street 1 |
15 |
text |
NULL |
Not Unique |
No |
Normal |
|
City 1 |
16 |
text |
NULL |
Not Unique |
No |
Normal |
|
State Province 1 |
17 |
text |
NULL |
Not Unique |
No |
Normal |
|
Postal Code 1 |
18 |
text |
NULL |
Not Unique |
No |
Normal |
|
Notes |
19 |
text |
NULL |
Not Unique |
No |
Normal |
|
Phone 1 |
21 |
text |
NULL |
Not Unique |
No |
Normal |
|
Date Created |
24 |
date |
NULL |
Not Unique |
No |
Normal |
|
Date Modified |
25 |
date |
NULL |
Not Unique |
No |
Normal |
|
Identification Number |
31 |
text |
NOT NULL |
Not Unique |
No |
Normal |
|
Image Data |
41 |
container |
NULL |
Not Unique |
No |
Normal |
|
Template Information Global |
44 |
text |
NULL |
Not Unique |
No |
Global |
|
Created By |
45 |
text |
NULL |
Not Unique |
No |
Normal |
|
Last Layout |
46 |
number |
NULL |
Not Unique |
No |
Global |
|
Email |
67 |
text |
NULL |
Not Unique |
No |
Normal |
|
Phone 2 |
68 |
text |
NULL |
Not Unique |
No |
Normal |
|
Current Date |
76 |
date |
NULL |
Not Unique |
No |
Normal |
Status(CurrentDate) |
Similar By |
77 |
text |
NULL |
Not Unique |
No |
Global |
|
Similars Key |
78 |
text |
NULL |
Not Unique |
No |
Normal |
Case(
Similar By = \"Name\",
Similar Name Key,
Similar By = \"Company\",
Similar Company Key,
Similar By = \"City\",
City 1,
\"\") |
Similars MultiKey |
79 |
text |
NULL |
Not Unique |
No |
Normal |
Similar Name Key & \"¦\"
&
Company & \"¦\" &
City 1 |
Similars Count Empty |
80 |
number |
NULL |
Not Unique |
No |
Normal |
Count(Similars::Similars Key) |
Similars Tab Label |
81 |
text |
NULL |
Not Unique |
No |
Normal |
\"Related Contacts\"
&
If(Similars Count,
\": \" & Similars Count & \" by \"
& Similar By,
\"\") |
Similar Name Key |
82 |
text |
NULL |
Not Unique |
No |
Normal |
Last Name |
Similar Company Key |
83 |
text |
NULL |
Not Unique |
No |
Normal |
Company |
Street 2 |
84 |
text |
NULL |
Not Unique |
No |
Normal |
|
City 2 |
85 |
text |
NULL |
Not Unique |
No |
Normal |
|
State Province 2 |
86 |
text |
NULL |
Not Unique |
No |
Normal |
|
Postal Code 2 |
87 |
text |
NULL |
Not Unique |
No |
Normal |
|
Address Type 1 |
88 |
text |
NULL |
Not Unique |
No |
Normal |
|
Address Type 2 |
89 |
text |
NULL |
Not Unique |
No |
Normal |
|
Scratch |
90 |
text |
NULL |
Not Unique |
No |
Global |
|
Thumbnail |
91 |
container |
NULL |
Not Unique |
No |
Normal |
|
Contact ID Not Unique No No |
92 |
number |
NULL |
Not Unique |
No |
Normal |
|
Most Recent Form Layout |
93 |
number |
NULL |
Not Unique |
No |
Global |
|
Letter Body Text |
94 |
text |
NULL |
Not Unique |
No |
Global |
|
Email Address with Name |
95 |
text |
NULL |
Not Unique |
No |
Normal |
First Name & \" \"
& Last Name & \" <\" & Email & \">\" |
Thumbnail Display |
96 |
container |
NULL |
Not Unique |
No |
Normal |
If(
IsEmpty(Thumbnail),
Image Data,
Thumbnail
) |