Stca database schema

The database schema is created when the stca project has been run. Below is a list of tables and information regarding the records that are stored in each along with their description.

##Commit_Patterns This table stores the information for commit pattern. A commit pattern describes the social and technical dependency between two people in a commit. Columns are as follows.

commit_id	p_id1	p_id2	type	social_weight	technical_weight	technical_weight_fuzzy
character varying(255)	character varying(255)	character varying(255)	character varying(255)	real	real	real

Each pattern has a type of:

1. SOCIAL_ONLY - two people discussed about the commit but they didn't have code dependency.
2. TECHNICAL_ONLY - two people had code dependency but they didn't talk to each other.
3. SOCIAL_TECHNICAL - two people had code dependency and they talked to each other.

###Notes

• Primary Key: (commit_id, p_id1, p_id2)
• Social_weight: the number of social items created by both people in this commit. 0 and up
• Technical_weight: the dependent impact between function's callee and caller in this commit. 0 and up
• Technical_weight_fuzzy: same as Technical_weight, except the dependency is uncertain. There might be a relation between two people. 0 and up

##Patterns This table stores the statistics for a pattern. A pattern is a link between two people and the failure/successful rate to all commits. Columns are as follows.

p_id1	p_id2	type	passed	failed
character varying(255)	character varying(255)	character varying(255)	real	real

Each pattern has a type of:

1. SOCIAL_ONLY - two people discussed about the commit but they didn't have code dependency.
2. TECHNICAL_ONLY - two people had code dependency but they didn't talk to each other.
3. SOCIAL_TECHNICAL - two people had code dependency and they talked to each other.

###Notes

• Primary Key: (p_id1, p_id2, type).
• Passed: the number of passed commits that has this pattern.
• Failed: the number of failed commits that has this pattern.
• Failed commit: a commit considered as a fail when it produced a bug. See fixinducingchanges for more details