I'm really busy at work with many other projects, I haven't
forgot about the database design I proposed. I finished
the songs table, input is welcome. I will work on the
other tables as soon as I can. I added a few things, changed
a few names of variables and tables to make it easier to type
and easier to understand. Below the table are the bulletin
points that highlight the capabilities. If a datatype doesn't
look correct or isn't long enough, let me know. Could be a typo
in there too, when I create the table I'll weed out syntax errors.

CREATE TABLE songs (
song_id NUMBER (3),
song_level NUMBER (3),
song_name VARCHAR2 (50),
song_effect VARCHAR2 (100),
song_cost NUMBER (6),
song_mana NUMBER (4) DEFAULT 0,
song_duration NUMBER (3) DEFAULT 3,
song_casting_time NUMBER (3) DEFAULT 3,
song_recovery_time NUMBER (3) DEFAULT 0,
song_hold_time NUMBER (3) DEFAULT 12,
song_req_instrument CHAR (1) DEFAULT 'N',
song_skill_id NUMBER (2),
song_target_id NUMBER (2),
song_taunt_id NUMBER (1),
song_aoe_range NUMBER (3),
song_formula VARCHAR2 (50),
song_analysis_by NUMBER (3),
song_updated_by NUMBER (3),

CONSTRAINT songs_pk PRIMARY KEY (song_id),
CONSTRAINT songs_fk1 FOREIGN KEY (song_skill_id)
REFERENCES skill (skill_id),
CONSTRAINT songs_fk2 FOREIGN KEY (song_target_id)
REFERENCES targets (target_id),
CONSTRAINT songs_fk3 FOREIGN KEY (song_taunt_id)
REFERENCES taunts (taunt_id),
CONSTRAINT songs_fk4 FOREIGN KEY (song_taunt_id)
REFERENCES taunts (taunt_id),
CONSTRAINT songs_fk5 FOREIGN KEY (song_analysis_by)
REFERENCES players (player_id),
CONSTRAINT songs_fk6 FOREIGN KEY (song_updated_by)
REFERENCES players (player_id),
CONSTRAINT songs_ch1 CHECK (song_req_instrument IN ('Y','N'))
)

o supports up to 999 songs
o supports song cost up to 999999 copper (999.999 plat)
o supports mana cost up to 9999 mana
o supports duration up to 999 ticks
o supports casting time up to 999 secs
o supports recovery time up to 999 secs
o supports hold time up to 999 secs
o supports up to 99 skills
o supports up to 99 target types
o supports up to 9 taunt levels
o supports up to 999' song radius
o supports up to 999 contributors (us, the people who test)

Harmonic.