Hi.

Looks okay, except that you probably want to reference via pro_id and
d_id in table available_properties (given that I understood your table
layout correctly). It is usally considered bad design to repeat the
values itself (the varchars) in several tables.

Bye,

        Benjamin.


On Tue, May 28, 2002 at 12:17:55PM -0700, [EMAIL PROTECTED] wrote:
> Hello list, this is my first table for a simple php page and I'm hoping
> someone could briefly review its structure.  The only fields I'll be
> sharing are property_name and type.  Are they set up properly for select
> join queries?
> 
> thank you, justin
> 
> Database=properties
> 
> Tables are available_properties, property_names, and details
> 
> create table available_properties (
> av_pro_id int not null auto_increment 
> property_name varchar (50) not null
> type varchar (25)
> city varchar (25) 
> description varchar (125)
> number_of_units varchar (25)
> primary key (av_pro_id)
> );
> 
> create table property_names (
> pro_id int not null auto_increment
> property_name varchar (50) not null 
> address varchar (100)
> cross_street varchar (50)
> primary key (pro_id)
> );
> 
> create table details (
> d_id int not null auto_increment
> type varchar (25)
> price smallint
> floor varchar (15)
> sq_ft smallint
> suite smallint
> description text
> available varchar (15)
> primary key (d_id)
> );
> 

-- 
[EMAIL PROTECTED]

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to