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
