From: Remco Swoany <remco.zwaan@...>
Date: 2007-10-03T19:37:40+09:00
Subject: Question relations tables

hi,


I have a user-table described as below. That is filled in trough the
sign-in form and available through the edit-method.

Field           | Type         | Null | Key | Default | Extra          |
+-----------------+--------------+------+-----+---------+----------------+
| id              | int(11)      | NO   | PRI | NULL    | auto_increment | 
| username        | varchar(64)  | NO   | MUL |         |                | 
| email           | varchar(128) | NO   |     |         |                | 
| hashed_password | varchar(64)  | YES  |     | NULL    |                | 
| enabled         | tinyint(1)   | NO   |     | 1       |                | 
| profile         | text         | YES  |     | NULL    |                | 
| created_at      | datetime     | YES  |     | NULL    |                | 
| updated_at      | datetime     | YES  |     | NULL    |                | 
| last_login_at   | datetime     | YES  |     | NULL    |                | 
|                 | 
+-----------------+--------------+------+-----+---------+----------------+

Now i want also that the user can fill in the following things:

a)work experience
b)studies
ect.

Must i add a new column in the user-table or make a new table and join
it into the user table?

If you recommended a second table, what is the process to do that?



Grtz..remco
-- 
Posted via http://www.ruby-forum.com/.