hej,
jag hade tänkt mig att databasen skulle se ut på följande sätt, kom gärna med förslag om hur den kan förbättras:
Kod:
table: users
uid: user id of the user
email: email of the advertiser
password: password of the advertisement
table: advertisement_sell (All the advertisement are saved here.)
id: unique id for every advertisement
uid: user if of the advertisement
accepted: is the advertisement accepted? 0=no, 1=yes
name: full name of the advertiser
phone_numer: phone number of the advertiser
phone_numer_hide: hide the phone number of the advertiser? 0=no, 1=yes
type_id: advertisement type id (private or company)?
advertisement_paid: has the advertiser paid for the advertisement? 0=no, 1=yes
category_id: category of the advertisement
province_id province of the advertisement (län)
region_id region of the advertisement (kommun)
subject: subject of the advertisement
text: text of the advertisement
price: price of the advertisement public
image_main: main image of the advertisement
video: video for the advertisement
zipcode: zipcode so it can be used with google map
ip: ip adress of the advertiser