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

.
.

FmPro Migrator - MySQL Files - Title Graphic

FmPro Migrator Features and Benefits

FmPro Migrator Demo Available for download...

Bookmark This Page

email a friend

.

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 Type 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
)



.

hline

. .

.

. .
 

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

Legal Notices

.
.   .
.
Home Products Services Downloads Order Support Contact