Apr 17, 2008


http://oshiete1.goo.ne.jp/qa1388366.html


UNIQUEの項にカッコで複数のカラムを指定すれば、複数のカラムの組合せにユニーク制約を設定することが出来ます。
http://210.224.163.248/Manual/mysql-4.00.12/manual.ja_Reference.htm...
http://dev.mysql.com/doc/mysql/ja/create-table.html

例 ----------------------------------------------
CREATE TABLE test_uniq (
pr_key INTEGER PRIMARY KEY,
u_key1 INTEGER,
u_key2 INTEGER,
UNIQUE (u_key1, u_key2)
)
-------------------------------------------------



rails側

class TeacherSchedule < ActiveRecord::Base
validates_uniqueness_of :teacher_id, :scope => [:semester_id, :class_id]
end


Posted at 09:50
viewed times | Edit

TrackBack ping me at
http://webrec.jp/blog/diary_200804170950.
Post a comment

writeback message: