aurora_standard.styjobcr
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| job_cat | char(6) | YES | ||||
| job_desc | char(30) | YES | ||||
| class1_rate | decimal(10,2) | YES | ||||
| class1_hrs | int(11) | YES | ||||
| class2_rate | decimal(10,2) | YES | ||||
| class2_hrs | int(11) | YES | ||||
| class3_rate | decimal(10,2) | YES | ||||
| class3_hrs | int(11) | YES | ||||
| class4_rate | decimal(10,2) | YES | ||||
| class4_hrs | int(11) | YES | ||||
| class5_rate | decimal(10,2) | YES | ||||
| class5_hrs | int(11) | YES | ||||
| class6_rate | decimal(10,2) | YES | ||||
| class6_hrs | int(11) | YES | ||||
| class7_rate | decimal(10,2) | YES | ||||
| class7_hrs | int(11) | YES | ||||
| class8_rate | decimal(10,2) | YES | ||||
| class8_hrs | int(11) | YES | ||||
| class9_rate | decimal(10,2) | YES | ||||
| class9_hrs | int(11) | YES | ||||
| class10_rate | decimal(10,2) | YES | ||||
| class10_hrs | int(11) | YES | ||||
| chs_rowid | bigint(20) unsigned | NO | PRI | auto_increment |
References
| Local Column | References | ||||
|---|---|---|---|---|---|
| job_cat |
|