Use of reference table ('look-up-table') and FK constraint
От | Charles Hauser |
---|---|
Тема | Use of reference table ('look-up-table') and FK constraint |
Дата | |
Msg-id | 1034788500.414.63.camel@pandorina.biology.duke.edu обсуждение исходный текст |
Ответы |
Re: Use of reference table ('look-up-table') and FK constraint
Re: Use of reference table ('look-up-table') and FK constraint |
Список | pgsql-sql |
Hi, In fits and starts I am working through converting a sybase schema -> postgres and am hoping to gain some insight on the use of reference tables ('look-up-table') and FK constraints. In the example below I believe the sybase RULE Phone_type_rule is used to restrict input, so that the only values which can be inserted or updated into Phone have to be one of ('work', 'home', 'fax', 'mobile', 'lab', 'unknown'). How would this be accomplished using a look-up or reference table::FK constraint combination? CREATE RULE Phone_type_rule AS @col IN ('work', 'home', 'fax', 'mobile', 'lab', 'unknown') goCREATE TABLE Phone ( phone_id Identifier_type IDENTITY, phone_number varchar(20) NOT NULL, community_id numeric(12) NOT NULL, type varchar(10) NULL) goexec sp_bindrule Phone_type_rule, 'Phone.type' go regards, Charles
В списке pgsql-sql по дате отправления: