# == Schema Information # # Table name: info_requests # # id :integer not null, primary key # title :text not null # user_id :integer # public_body_id :integer not null # created_at :datetime not null # updated_at :datetime not null # described_state :string(255) not null # awaiting_description :boolean default(FALSE), not null # prominence :string(255) default("normal"), not null # url_title :text not null # law_used :string(255) default("foi"), not null # allow_new_responses_from :string(255) default("anybody"), not null # handle_rejected_responses :string(255) default("bounce"), not null # idhash :string(255) not null # external_user_name :string(255) # external_url :string(255) # attention_requested :boolean default(FALSE) # comments_allowed :boolean default(TRUE), not null # info_request_batch_id :integer # fancy_dog_request: id: 101 title: Why do you have & such a fancy dog? url_title: why_do_you_have_such_a_fancy_dog created_at: 2007-10-11 18:15:57 updated_at: 2007-10-11 18:15:57 public_body_id: 2 user_id: 1 described_state: waiting_response awaiting_description: true comments_allowed: true idhash: 50929748 naughty_chicken_request: id: 103 title: How much public money is wasted on breeding naughty chickens? url_title: how_much_public_money_is_wasted_o created_at: 2007-10-13 18:15:57 updated_at: 2007-10-13 18:15:57 public_body_id: 2 user_id: 1 described_state: waiting_response awaiting_description: false comments_allowed: true idhash: e8d18c84 badger_request: id: 104 title: Are you really a badger? url_title: are_you_really_a_badger created_at: 2011-10-13 18:15:57 updated_at: 2011-10-13 18:15:57 public_body_id: 3 user_id: 1 described_state: waiting_response awaiting_description: false comments_allowed: true idhash: e8d18c84 boring_request: id: 105 title: The cost of boring url_title: the_cost_of_boring created_at: 2006-01-12 01:56:58.586598 updated_at: 2008-08-12 12:05:12.879634 public_body_id: 3 user_id: 1 described_state: successful awaiting_description: false comments_allowed: true idhash: 173fd003 another_boring_request: id: 106 title: The cost of boring url_title: the_cost_of_boring_two # Not _2, because we want to avoid the search collapsing these two created_at: 2006-01-12 01:56:58.586598 updated_at: 2007-11-13 18:09:20.042061 public_body_id: 5 user_id: 1 described_state: successful awaiting_description: false comments_allowed: true idhash: 173fd004 # A pair of identical requests (with url_title differing only in the numeric suffix) # used to test the request de-duplication features. spam_1_request: id: 107 title: Cheap v1agra url_title: spam_1 created_at: 2010-01-01 01:23:45.6789100 updated_at: 2010-01-01 01:23:45.6789100 public_body_id: 5 user_id: 5 described_state: successful awaiting_description: false comments_allowed: false idhash: 173fd005 spam_2_request: id: 108 title: Cheap v1agra url_title: spam_2 created_at: 2010-01-01 02:23:45.6789100 updated_at: 2010-01-01 02:23:45.6789100 public_body_id: 6 user_id: 5 described_state: successful awaiting_description: false comments_allowed: true idhash: 173fd005 external_request: id: 109 title: Balalas url_title: balalas external_user_name: Bob Smith external_url: http://www.example.org/request/balala public_body_id: 2 described_state: waiting_response awaiting_description: false comments_allowed: true idhash: a1234567 anonymous_external_request: id: 110 title: Anonymous request url_title: anonymous_request external_user_name: external_url: http://www.example.org/request/anonymous_requesr public_body_id: 2 described_state: waiting_response awaiting_description: false comments_allowed: true idhash: 7654321a other_request: id: 111 title: Another request url_title: another_request created_at: 2010-01-01 02:23:45.6789100 updated_at: 2010-01-01 02:23:45.6789100 public_body_id: 7 user_id: 6 described_state: waiting_response awaiting_description: false comments_allowed: true idhash: b234567