Alert {
caused_member_id: unsigned int,
content_type: string,
content_id: unsigned int,
alert_type: string,
alert_date: unsigned int,
}Conversation {
conversation_id: unsigned int,
title: string,
creation_date: unsigned int,
creator_id: unsigned int,
last_message_date: unsigned int,
last_read_date: unsigned int,
open: bool,
reply_count: unsigned int,
recipient_ids: unsigned int[],
}Reply {
message_id: unsigned int,
message_date: unsigned int,
author_id: unsigned int,
message: string,
}Member {
member_id: unsigned int,
username: string,
join_date: unsigned int,
last_activity_date: optional unsigned int,
banned: bool,
suspended: bool,
restricted: bool,
disabled: bool,
premium: bool,
supreme: bool,
ultimate: bool,
discord_id: optional unsigned int,
avatar_url: string,
post_count: unsigned int,
resource_count: unsigned int,
purchase_count: unsigned int,
feedback_positive: unsigned int,
feedback_neutral: unsigned int,
feedback_negative: unsigned int,
}Ban {
member_id: unsigned int,
banned_by_id: unsigned int,
ban_date: unsigned int,
reason: string,
}ProfilePost {
profile_post_id: unsigned int,
author_id: unsigned int,
post_date: unsigned int,
message: string,
comment_count: unsigned int,
} BasicResource {
resource_id: unsigned int,
author_id: usigned int,
title: string,
tag_line: string,
price: floating point,
currency: string,
}Resource {
resource_id: unsigned int,
author_id: unsigned int,
title: string,
tag_line: string,
description: string,
release_date: unsigned int,
last_update_date: unsigned int,
category_title: string,
current_version_id: unsigned int,
price: floating point,
currency: string,
purchase_count: unsigned int,
download_count: unsigned int,
review_count: unsigned int,
review_average: floating point,
}Version {
version_id: unsigned int,
update_id: unsigned int,
name: string,
release_date: unsigned int,
download_count: unsigned int,
}Update {
update_id: unsigned int,
title: string,
message: string,
update_date: unsigned int,
}Review {
review_id: unsigned int,
reviewer_id: unsigned int,
review_date: unsigned int,
rating: unsigned int,
message: string,
response: string,
}Purchase {
purchase_id: unsigned int,
purchaser_id: unsigned int,
license_id: unsigned int,
renewal: bool,
status: string,
price: floating point,
currency: string,
purchase_date: unsigned int,
validation_date: unsigned int,
}License {
license_id: unsigned int,
purchaser_id: unsigned int,
validated: bool,
active: bool,
permanent: bool,
start_date: unsigned int,
end_date: unsigned int,
previous_end_date: unsigned int,
}Download {
download_id: unsigned int,
version_id: unsigned int,
downloader_id: unsigned int,
download_date: unsigned int,
}Download {
field: string,
type: string,
value: mixed,
search: optional string,
}BatchEdit {
batch_id: unsigned int,
created_at: unsigned int,
completed_at: unsigned int,
errors: map<string, array[string]> // A map of resource ids => an array of errors
}BasicThread {
thread_id: unsigned int,
title: string,
reply_count: unsigned int,
view_count: unsigned int,
creation_date: unsigned int,
last_message_date: unsigned int,
}Thread {
thread_id: unsigned int,
forum_name: string,
title: string,
reply_count: unsigned int,
view_count: unsigned int,
post_date: unsigned int,
thread_type: string,
thread_open: bool,
last_post_date: unsigned int,
}Reply {
reply_id: unsigned int,
author_id: unsigned int,
post_date: unsigned int,
message: string,
}