Adding a constraint - SQL Recipes a FREE cookbook of SQL queries and examples

AriesABCD · #1 (**permalink**) 07-03-2008, 12:11 PM

I have a question on adding a constraint to a table.

The following are my tables.

1. Attribute table that will define the attributes

Code:

Attribute
AtId       AtName
1            Age
2            Gender

2. Attribute value table that will store value for attributes

Code:

AttributeValue
AtValId     AtId               AtDesc
1             1                    10 - 20
2             1                    21 - 30
3             1                    31 - 40
4             2                    Male
5             2                    Female

3. User table that will contain list of users and their profile

Code:

User
UserId    User Name         Age   Gender
1           Matt thompson    2        4

Is there any way to set a constraint on the columns Age and Gender of User table to have the values only from attribute table?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

User Name		Remember Me?
Password