| Field | Type | Null | Key | Default | Extra |
| iss_id |
int(11) unsigned |
NO |
PRI |
(NULL) |
auto_increment |
| iss_customer_id |
int(11) unsigned |
YES |
|
(NULL) |
|
| iss_customer_contact_id |
int(11) unsigned |
YES |
|
(NULL) |
|
| iss_usr_id |
int(10) unsigned |
NO |
|
0 |
|
| iss_grp_id |
int(11) unsigned |
YES |
MUL |
(NULL) |
|
| iss_prj_id |
int(11) unsigned |
NO |
MUL |
0 |
|
| iss_prc_id |
int(11) unsigned |
NO |
MUL |
0 |
|
| iss_pre_id |
int(10) unsigned |
NO |
|
0 |
|
| iss_pri_id |
smallint(3) |
NO |
|
0 |
|
| iss_sta_id |
tinyint(1) |
NO |
|
0 |
|
| iss_res_id |
int(10) unsigned |
NO |
MUL |
0 |
|
| iss_duplicated_iss_id |
int(11) unsigned |
YES |
MUL |
(NULL) |
|
| iss_created_date |
datetime |
NO |
|
0000-00-00 00:00:00 |
|
| iss_updated_date |
datetime |
YES |
|
(NULL) |
|
| iss_last_response_date |
datetime |
YES |
|
(NULL) |
|
| iss_first_response_date |
datetime |
YES |
|
(NULL) |
|
| iss_closed_date |
datetime |
YES |
|
(NULL) |
|
| iss_last_customer_action_date |
datetime |
YES |
|
(NULL) |
|
| iss_expected_resolution_date |
date |
YES |
|
(NULL) |
|
| iss_summary |
varchar(128) |
NO |
MUL |
|
|
| iss_description |
text |
NO |
|
|
|
| iss_dev_time |
float |
YES |
|
(NULL) |
|
| iss_developer_est_time |
float |
YES |
|
(NULL) |
|
| iss_impact_analysis |
text |
YES |
|
(NULL) |
|
| iss_contact_person_lname |
varchar(64) |
YES |
|
(NULL) |
|
| iss_contact_person_fname |
varchar(64) |
YES |
|
(NULL) |
|
| iss_contact_email |
varchar(255) |
YES |
|
(NULL) |
|
| iss_contact_phone |
varchar(32) |
YES |
|
(NULL) |
|
| iss_contact_timezone |
varchar(64) |
YES |
|
(NULL) |
|
| iss_trigger_reminders |
tinyint(1) |
YES |
|
1 |
|
| iss_last_public_action_date |
datetime |
YES |
|
(NULL) |
|
| iss_last_public_action_type |
varchar(20) |
YES |
|
(NULL) |
|
| iss_last_internal_action_date |
datetime |
YES |
|
(NULL) |
|
| iss_last_internal_action_type |
varchar(20) |
YES |
|
(NULL) |
|
| iss_private |
tinyint(1) |
NO |
|
0 |
|
| iss_percent_complete |
tinyint(3) unsigned |
YES |
|
0 |
|