Database Structure

The following is the database structure as per the live database on tf2clan.co.uk/swtor (v1.8)

Table	Fields
advclasses	id , advclass
alignments	id , alignment
character	id , name , race_id , class_id , advclass_id , level , skill1_id , skill1level , skill2_id , skill2level , skill3_id , skill3level , honor , social , alignment_id , owner_id , rank , title_id
charlist	view
classes	id , class
crafting	id , name , skill , description , comments , dh , character_id , slot
equipment	id , char_id , ear , implant1 , implant2 , wrist , relic1 , relic2 , head , chest , gloves , belt , legs , boots , weapon1 , weapon2
genders	id , gender
guild_ranks	id , rank , rank_level
items	id , dh_id , dh_link , slot , name
races	id , race
roles	id , role
skills	id , skill
system	variable , value
titles	id , title , pos , description
users	id , username , password , role_id , date_reg , legacy