Oracle Build Table Script record

--DeleteDrop TableDianfei;--Create a tableCreate TableDianfei (UoNvarchar2(Ten) not NULL, Mmonthvarchar2(6) not NULL, DDF Number(6,2) not NULL, Djftime date not NULL, Djfztvarchar2(3) not NULL, DSYJF date not NULL);--NotesComment on TableDianfei is 'Electric Meter'; Comment on columnDianfei.uon is 'user number (from key)'; Comment on columnDianfei.mmonth is 'Payment month (from key)'; Comment on columnDianfei.ddf is 'amount of electricity'; Comment on columnDianfei.djftime is 'Payment Date'; Comment on columnDianfei.djfzt is 'Payment Status'; Comment on columnDianfei.dsyjf is 'last month payment date';--Create primary key, from keyAlter TableDianfeiAdd constraintPk_dianfeiForeign Key(UoN)ReferencesUuser (uon);Alter TableDianfeiAdd constraintPk_dianfeiaForeign Key(Mmonth)References  Money(Mmonth);

Oracle Build Table Script record