judge _ alias |
Text |
Part of the table composite primary key . |
The alias used in the cases report for the judges . |
judge _ code |
Text |
Part of the table composite primary key . |
The code of the judge that the alias belongs to . |
case _ lexis _ reporter |
Text |
Part of the table composite primary key The case _ lexis _ reporter Foreign key from the table “ cases ” to connect the cases with the judges who voted on the case and their decisions on that case |
judge _ alias |
Text |
Part of the table composite primary key |
judge _ code |
Text |
The judge alias and code
Foreign key from the table “ Judge _ rosters ” to connect the cases with the judges who voted on the case and their decisions on that case
|
decision _ type |
Text |
The judge ’ s decision on the case which could be opinion |
writer ( O ) or dissent writer ( D ) or concurring writer ( C ) |
disposition _ value |
Number |
Primary key of the table . |
The code number of the disposition . |