[Rets-dev] How to calculate field sizes

[Allen Schmidt Sr]

General question:

We pull MRIS data using a Python script. Works great for data and
images. We used to use Conduit in console mode and pulled the whole
file onto the filesystem and then used Python to parse it apart into
MySQL tables. The table had been defined long ago and still used the
old names we had like LIST_NUMB, etc.
The current script pulls all the data but I only use maybe 30 of the
fields for our online application.

Now I would like to pull LOTS more data fields and use the
system/standard names (I get them confused.)

I want to define the DDL for a new table that more closely matches the
data I want to pull in. So I want to only define the db fields using
the exact max field size. How can I do that? Is guess simple question
is does anyone have a MySQL table structure for MRIS data they wanna
share??

Out side of that, I notice that in the metadata, for a lookup field,
it only shows the field size as the lookup table ID rather than the
actual largest possible size of the data in that field.

I think I am rambling now. Anyone understand what I am going for?

Thanks for the time.

Allen