CHECK versus a Table for an enumeration
От | Melanie Bergeron |
---|---|
Тема | CHECK versus a Table for an enumeration |
Дата | |
Msg-id | 3FE7642F.3020908@globeecom.com обсуждение исходный текст |
Ответы |
Re: CHECK versus a Table for an enumeration
Re: CHECK versus a Table for an enumeration Re: CHECK versus a Table for an enumeration Re: CHECK versus a Table for an enumeration |
Список | pgsql-general |
Hi all! I want to know what's better between these 2 solutions : CREATE TABLE user ( ... user_type text CHECK(user_type='Root' OR user_type = 'Admin' OR user_type = 'Standard')); or the following : CREATE TABLE user_type( user_type_id integer PRIMARY KEY, user_type_desc text); CREATE TABLE user ( ... user_type_id integer, CONSTRAINT user_type_exists FOREIGN KEY (user_type_id) REFERENCES user(user_type_id)); I am really confused so I'll wait for your advices. Thanks, Melanie
В списке pgsql-general по дате отправления: