Posted by Frankly on 06/19/06 17:37

the databases i post to on the internet usually have these fields.
Fee disclosure.
posted by
rent
bedrooms.
Posting Title.
Area
Comments - i would like to include a map of the intersection.
posted by email
dogs.
cats.

I post different ads to different places. I would like to keep track of
what I post to where.
so I am thinking I can ad feilds like this to my apartments table.

i will need to add 10 feilds.

Website, to save space i think i will just make this a Varchar ( 40) there
is no need for this to be a link.

Posted to - Varchar (20)i sometimes post the same add to more than 1 place
or sometimes only 1. this one is confusing to me.

Edit link. Varchar (255)
Date posted. date 0000-00-00
Fee Disclosure. Varchar (70)will need 4 choices. but can put them in by
hand.
Posted by - will need choice of 2 of about (30) needs to be Name of agent
and name of firm.
Subject - Varchar (70) usually includes a brief discription of apartment
Comments. Varchar (255) about apartment -
MyContactinfo - Varchar (255) 2 choices this usually displays in the same
field as comments. i usually include a bit of html.
Email-

Email, Posted by, MyContactInfo, I think INT can be used. 0 for me and of
course my wife can be number 1 :).
the realy tricky one for me is how can i disply where i posted to.
can i have something like 4 check boxes each box representing a different
website?
if i had no one to ask i would use enum for the FeeDisclosure. lol i would
have also used that for most of the fields :).
i guess i could also use INT for fee discloser but i think that is a little
tricky.
my choices for fee discloser are - the only thing i can think of is enum or
INT and have 5 choices.
No Broker fee.
Low Broker Fee.
Broker Fee Negotiable.
15% broker fee. < hardly ever used but sometimes her boss wont except less.
1 Month Broker Fee.
all of them include a $40 credit check fee.

If i had my own place i would make them all 1 month fee. i think that is
very reasonable.

Frank

[Back to original message]