-
Notifications
You must be signed in to change notification settings - Fork 0
Actors
Actors are any character, from player, to POV to NPC.
Here's the scema for Actors:
id SERIAL PRIMARY KEY,
first_name TEXT,
middle_name TEXT,
last_name TEXT,
title TEXT,
actor_age INT,
class_id INT,
actor_level INT,
background_id INT,
job TEXT,
actor_role TEXT,
race_id INT,
sub_race_id INT,
alignment VARCHAR(2),
strength INT,
dexterity INT,
constitution INT,
intelligence INT,
wisdom INT,
charisma INT,
ideal TEXT,
bond TEXT,
flaw TEXT,
appearance TEXT,
strengths TEXT,
weaknesses TEXT,
notes TEXT,
FOREIGN KEY (class_id) REFERENCES classes(id),
FOREIGN KEY (background_id) REFERENCES background(id),
FOREIGN KEY (race_id) REFERENCES race(id),
FOREIGN KEY (sub_race_id) REFERENCES sub_race(id)Let's break it down one element at a time:
As any ID in PostgreSQL, this one is auto generated.
First Name of the Actor
Middle Name of the Actor (can be blank)
Last Name of the Actor
Things like Dr., Arch Mage, that kind of thing.
How old the Actor is.
ID (as int) of class found in the class list.
INT of the character's level overall.
ID (as int) of Background found in the Backgrounds table
What job does this Actor do? Are they homeless? A Blacksmith?
Why is this character in your story? Are they a villian? Sidekick?
ID (as int) of the characters Race found in race table
ID (as int) of a sub race (if any)
2 letter code to represent alignment and disposition. CG NG LG
CN NN LN
CE NE LE
Int (typically out of 20) to represent Actor's Strength. (10=Default)
Int (typically out of 20) to represent Actor's Dexterity (10=Default)
Int (typically out of 20) to represent Actor's Constitution (10=Default)
Int (typically out of 20) to represent Actor's Intelligence (10=Default)
Int (typically out of 20) to represent Actor's Wisdom (10=Default)
Int (typically out of 20) to represent Actor's Charisma (10=Default)
A text description of what ideals the Actor strives for. Kindness, Equality, Power, that sort of thing.
A text description of something that the Actor cares a great deal for. Person, place, Thing, w/e.
A text description of a specific flaw the Actor has. Something that usually can be exploited.
A text description of what the Actor looks like. As long as needed.
A text description of what the Actor is good at. As long as needed.
A text description of what the Actor struggles with. What they are bad at. As long as needed.
A place for any additional notes not covered previously.