Database Schema

AGO3 DB SCHEMA

Artwork

• id
• user_id
• type_id
• category_id
• license_id
• version
• description
• date_added

nb: (thumbnail can be generated from user_id+artwork_id)

Downloads

• id
• artwork_id
• file
• download_count
• resolution_id -» in case of download being a background this field will have an value assigned

Resolutions

• id
• name -» name?
• size

Licences

• id
• name
• summary
• link

Types

• id
• name (= metacity,background,gtk2,icon,collection,screenshot,etc)
• description

Categories

• id
• name (= nature,abstract,gnome,etc)

Collection

• id
• description
• date
• user_id

Artwork_Collection

• artwork_id
• collection_id

Comments

• id
• artwork_id
• collection_id
• user_id
• body
• date
• (edit_date)
• status -» status ?

Votes

• artwork_id
• collection_id
• user_id
• rating

Users

• user_id
• username
• real_name
• password
• email
• homepage
• info (description)
• timezone
• location
• level (user, developer, moderator, admin)
• status (active, inactive, blocked, etc)

FAQ

• id
• type_id
• question
• answer

News

• id
• date
• title
• body
• user_id

Pages

• id
• date_edited
• body
• identifier