Please write the SQL command that will create a table named machineequpment with the following attributes: (pages 131-132 for syntax summary)

A unique primary key called machineID

purchase date as a date field defaulting to the current date

purchase price as a number field not null

etypeid as a number(2) not null

ename as a varchar - you determine the length, not null