Need Help Determine What Tables / Fields to Setup for SQL

**OVERVIEW:**

We have 1,000's of flat text files that need to be imported into a mySQL DB. We need someone who can tell us what tables/fields we need to setup and how to link them.

**OUR GOAL:**

Our goal is to be able to import these flat text files into a SQL DB that will allow us to query the data properly. Many of the variable=data fields are similar so should be setup in a proper table. We will then need to query the DB to pull information from the records.

**EXAMPLES:**

Here is an example of a file we would import:

<[url removed, login to view]>

The file being imported is a flat variable=data format. If you look at the example you will see there are several items that should be put in a unique table. Example:

schedObjId_0

This should be put into a table called "Scheduled" because there is a schedObjId_0, schedObjId_1, schedObjId_2 and so on. Same goes with this example zoneObjId_0. There is a zoneObjId_0, zoneObjId_1, and so on.

DELIVERABLE:

1) We need someone who can understand from this list the best table/fields setup need to import correctly into a mySQL DB.

2) Deliver an SQL import file that will setup these tables and fields along with what field/data should be imported into them.

I know this is a bit difficult to explain so if you have questions please let me know.

PHP

Identifikační číslo projektu: #3550275

O projektu