How do you reference a column name in another table to avoid repeating the values?
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Benjamin Pflugmann Sent: Tuesday, May 28, 2002 6:24 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: first mysql table; syntax qustion 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 --------------------------------------------------------------------- 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
