Welcome Guest, Not a member yet? Register   Sign In
Real estate Database
#4

@PaulD. I said in title that the database is a Real Estate one. So the table names are pretty intuitive.

proprietati -> proprietes
zone -> zone
strazi -> streets
proprietari -> owners
agents -> agents
tip_proprietati -> property type


Foreign keys:

proprietati.adaugat_de -> agenti.id_agent
proprietati.id_proprietar -> proprietari.id_proprietar
proprietati.id_tip_proprietate -> tip_proprietate.id_tip_proprietate
proprietati.id_zona -> zone.id_zona
zone.id_zona -> strazi.id_zona
strazi.id_strada -> adrese.id_strada


@solidcodes The language is romanian and the pictures are print screen from Navicat, if you used you may recognise the layout.
Reply


Messages In This Thread
Real estate Database - by sebastianvirlan - 11-06-2015, 12:36 AM
RE: Real estate Database - by PaulD - 11-06-2015, 07:26 PM
RE: Real estate Database - by solidcodes - 11-06-2015, 08:14 PM
RE: Real estate Database - by sebastianvirlan - 11-09-2015, 12:47 AM
RE: Real estate Database - by sintakonte - 11-09-2015, 04:41 AM
RE: Real estate Database - by sebastianvirlan - 12-07-2015, 07:24 AM



Theme © iAndrew 2016 - Forum software by © MyBB