CREATE TABLE user_preferences (
user_id integer PRIMARY KEY NOT NULL,
prefer_text_only_p bool DEFAULT false,
language_preference char(2) DEFAULT 'en'::bpchar,
dont_spam_me_p bool DEFAULT false,
email_type varchar(64),
locale varchar(30),
timezone varchar(100),
CONSTRAINT user_preferences_locale_fk REFERENCES ad_locales (),
CONSTRAINT user_preferences_pk REFERENCES ad_locales (),
CONSTRAINT user_prefs_user_id_fk REFERENCES ad_locales (),
CONSTRAINT user_prefs_user_id_fk REFERENCES users (),
CONSTRAINT user_preferences_locale_fk REFERENCES users (),
CONSTRAINT user_preferences_pk REFERENCES users ()
);
CREATE TRIGGER RI_ConstraintTrigger_c_343039 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343040 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343044 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343045 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
-- Table size: 950,272 bytes
-- Table rows: 21,372
Tables: