SQL

Create a table called Money with the following fields and constraints. a. mid: int primary key auto_increment, code varchar(50) unique, cid: int, sid: int, type: char(1), amount: float, mydatetime: datetime, note: varchar(255) b. All fields cannot have NULL values, except note. c. type should have only two values D: deposit, W: withdraw d. mid is the primary key, and the value should be auto increment by the DBMS. e. cid is a foreign key references to the id field in CPS3740.Customers table. f. code should be unique. g. sid is a foreign key references to the id field in CPS3740.Sources table