Alaveteli DataModel

Source : RailsModels

• AboutMeValidator
  • about_me :text

• PublicBody::Translation

• PublicBody:: Version

• PublicBody
  • name :text
  • short_name :text
  • request_email :text
  • version :integer
  • last_edit_editor :string
  • last_edit_comment :text
  • created_at :datetime
  • updated_at :datetime
  • url_name :text
  • home_page :text
  • notes :text
  • first_Ietter :string
  • publication_scheme :text
  • api_key :string
  • disclosurelog :text

• InfoRequest
  • title :text
  • created_at :datetime
  • updated_at :datetime
  • described_state :string
  • awaiting_description :boolean
  • prominence :string
  • url_title :text
  • law_used :string
  • allow_new_responses_from :string
  • handle_rejected_responses :string
  • idhash :string
  • external_user_name :string
  • external_url :string
  • attention_requested :boolean
  • comments allowed :boolean

• User
  • email :string
  • name :string
  • hashed_password :string
  • salt :string
  • created_at :datetime
  • updated_at :datetime
  • email_confirmed :boolean
  • url_name :text
  • mast_daily_track_email: datetime
  • admin_level :string
  • ban_text :text
  • about_me :text
  • locale :string
  • email_bounced_at :datetime
  • email_bounce_message :text
  • nolimit :boolean
  • receive_email_alerts :boolean
  • address :string
  • dob :date

• ChangeEmailValidator
  • old_email :string
  • new_email :string
  • password :string
  • user_circumstance :string

• Contact Validator
  • name :string
  • email :string
  • subject :text
  • message :text

• Holiday
  • day :date
  • description :text

• PurgeRequest
  • url :string
  • created_at :datetime
  • model :string

• RequestClassification
  • created_at :datetime
  • updated_at :datetime

• Profil ePhoto
  • data :binary
  • draft :booleany

• RawEmail

• MailServerLogDone
  • filename :text
  • last_stat :datetime
  • created_at :datetime
  • updated_at :datetimey

• PostRedirect
  • token :text uri :text
  • post_params_yaml :text
  • created_at :datetime
  • updated_at :datetime
  • email_token :text
  • reason_params_yaml :text
  • circumstance :text

• MailServerLog
  • order :integer
  • line :text
  • created_at :datetime
  • updated_at :datetime
  • outgoing_message_followups

• Comment
  • comment_type :string
  • body :text
  • visible :boolean
  • created_at :datetime
  • updated_at :datetime
  • locale :text

• IncomingMessage
  • created_at :datetime
  • updated_at :datetime
  • cached_attachment_text
  • clipped :text
  • cached_main_body_text
  • folded :text
  • cached_main_body_text
  • unfolded :text
  • subject :text
  • mail_from_domain :text
  • valid_to_reply_to :boolean
  • last_parsed :datetime
  • mail_from :text
  • sent at :datetime

• HasTagString::HasTagStringTag

• TrackThing
  • track_query :string
  • track_medium :string
  • track_type :string
  • created_at :datetime
  • updated_at :datetime

• CensorRule
  • text :text
  • replacement :text
  • last_edit_editor :string
  • Iast_edit_comment :text
  • created_at :datetime
  • updated_at :datetime
  • regexp :boolean

• OutgoingMessage
  • body :text
  • status :string
  • message_type :string
  • created_at :datetime
  • updated_at :datetime
  • last_sent_at :datetime
  • what_doing :string

• FoiAttachment
  • content_type :text
  • filename :text
  • charset :text
  • display_size :text
  • url_part_number :integer
  • within_rfc822_subject :text
  • hexdigest :string_

• InfoRequestEvent
  • event_type :text
  • params_yaml :text
  • created_at :datetime
  • described_state :string
  • calculated_state :string
  • last_described_at :datetime
  • prominence :string

• TrackThingsSentEmail
  • created_at :datetime
  • updated_at :datetime .

• UserlnfoRequestSentAlert
  • alert_type :string