+ dbo.crimes
Columns
crime_id (PK, int, not null)
criminal_id (FK, int, null)
classification (char(1), null)
date_charged (date, null)
status (char(2), null)
hearing_date (date, null)
appeal_cut_date (date, null)
date_recorded (date, null)
Keys
Constraints
Triggers
Indexes
Statistics
dbo.criminals
Columns
criminal_id (PK, int, not null)
last (varchar(15), null)
first (varchar(10), null)
street (varchar(30), null)
city (varchar(20), null)
state (char(2), null)
zip (char(5), null)
phone (char(10), null)
v_status (char(1), null)
p_status (char(1), null)