C # 's financial system database

Financial Charge System Supplement database table

1. Student Table (f_student)

Name	Code	Data type	Mandatory for
Id	s_id	Int	TRUE
Student Name	Stu_name	varchar (50)	TRUE
ID number	Stu_card	varchar (18)	TRUE
Grade	Stu_ear	Int	TRUE
Professional	Stu_specialty	varchar (50)	TRUE
Status of the nationality	Stu_state	Int	TRUE

| f_student | CREATE table ' f_student ' (  ' s_id ' Mediumint (Ten) not NULL auto_increment COMMENT ' Student table ID ',  ' stu_name ' varchar (N) OT null COMMENT ' student name ',  ' stu_card ' varchar (7) NOT null COMMENT ' Social Security Number ',  ' stu_ear ' smallint () not null COMMENT ' Grade ',  ' stu_specialty ' varchar (+) NOT null COMMENT ' professional ',  ' stu_state ' tinyint (2) NOT null COMMENT ' in the state ',  PRIMARY KEY (' s_id ')) Engine=myisam DEFAULT Charset=utf8                      |

2. Tuition and Fees table (f_incidental)

Name	Code	Data type	Mandatory for
Id	Id	Int	TRUE
Student ID	student_id	Int	TRUE
Payment Number	Payid	Int	TRUE
Payment Amount	Itemmoney	Float	TRUE
Payment method	Methodofpay	Int	TRUE
Payment Time	Paywhen	Datetime	TRUE
Payment term number	Term_code	varchar (50)	TRUE
is valid	Ifactive	Int	TRUE
Remark: Payment Method 1, Cash 2, swipe 3, remittance

| F_incidental |  CREATE TABLE ' f_incidental ' (  ' x_id ' int (one) not NULL auto_increment COMMENT ' learn miscellaneous ID ',  ' x_stu_id ' mediumint () not Null COMMENT ' student ID ',  ' X_payid ' int (ten) NOT null COMMENT ' payment number ',  ' X_itemmoney ' float not null COMMENT ' contribution amount ',  ' X_methodofpay ' tinyint (3) NOT null COMMENT ' 1 cash, 2 swipe, 3 remittance ',  ' x_paywhen ' datetime NOT NULL COMMENT ' payment time ',  ' x_term _code ' varchar ' NOT null COMMENT ' payment term number ',  ' x_ifactive ' tinyint (2) NOT null COMMENT ' valid ',  PRIMARY KEY (' x_id ') )) Engine=myisam DEFAULT Charset=utf8                                 |

　　

3. Schedule of tuition and fees (f_detaied)

Name	Code	Data type	Mandatory for
Id	Id	Int	TRUE
Payment Number	Payid	Int	TRUE
Charge items	ItemName	varchar (50)	TRUE
Fee sub-item	Itemchild	varchar (50)	TRUE
Fee Grade	Itemtermyear	varchar (50)	TRUE
Charging method	Termoryear	varchar (50)	TRUE
Project Amount	Itemmoney	Float	TRUE
Discount	Itemreduce	Datetime	TRUE
Amount paid	Itemfinalmoney	Float	TRUE
is valid	Ifactive	Int	TRUE
Payment Time	Paywhen	Datetime	TRUE
Remark: The payment method is based on one school year or one semester

| f_detaied | CREATE TABLE ' f_detaied ' (  ' d_id ' int () NOT NULL auto_increment COMMENT ' tuition schedule ',  ' D_payid ' int (ten) NOT null COM ment ' Payment number ',  ' d_itemname ' varchar (a) NOT null COMMENT ' charge item ',  ' d_itemchild ' varchar (NOT NULL COMMENT ' Charge subkey '),  ' d_itemtermyear ' varchar (NOT NULL COMMENT ' toll grade ',  ' d_termoryear ' varchar ') ' NOT null COMMENT ' fee method by one academic year or by one school Period ',  ' D_itemmoney ' float (6,2) NOT null COMMENT ' project amount ',  ' d_itemreduce ' datetime NOT NULL COMMENT ' discount ',  ' D_ Itemfinalmoney ' float (6,2) NOT null COMMENT ' paid amount ',  ' d_ifactive ' tinyint (2) NOT null COMMENT ' valid ',  ' D_paywhen ' DateTime not NULL COMMENT ' payment time ',  PRIMARY KEY (' d_id ') Engine=myisam DEFAULT Charset=utf8

　　

4. Tuition Fee Number Table

Name	Code	Data type	Mandatory for
Number	Num	Int	TRUE

| F_za_code | CREATE TABLE ' F_za_code ' (  ' num ' int (ten) not NULL,  PRIMARY KEY (' num ')) Engine=innodb DEFAULT Charset=utf8 |

　　

5, the Charge Clerk log table

Name	Code	Data type	Mandatory for
Id	Id	Int	TRUE
Toll Clerk	Tollcollector	varchar (50)	TRUE
Charge items	ItemName	varchar (50)	TRUE
Charge Amount	Itemmoney	Float	TRUE
Payment Number	Payid	Int	TRUE
Payment Time	Paywhen	Datetime	TRUE
Credit card Amount	Cardmoney	Float	TRUE
Cash Amount	Nowmoney	Float	TRUE
Remittance Amount	Tranmoney	Float	TRUE

| f_accounting | CREATE TABLE ' f_accounting ' (  ' a_id ' int (one) not NULL auto_increment COMMENT ' toll id ',  ' a_tollcollector ' varchar ( Not NULL COMMENT ' charge member ',  ' a_itemname ' varchar (a) NOT null COMMENT ' charge item ',  ' A_itemmoney ' float (6,2) NOT null CO Mment ' charge amount ',  ' A_payid ' int (ten) NOT null COMMENT ' payment number ',  ' a_paywhen ' datetime NOT NULL COMMENT ' payment time ',  ' A_car Dmoney ' float (6,2) not null COMMENT ' swipe amount ',  ' A_nowmoney ' float (6,2) not null COMMENT ' cash amount ',  ' A_tranmoney ' float ( 6,2) not NULL COMMENT ' remittance amount ',  PRIMARY KEY (' a_id ')) Engine=myisam DEFAULT Charset=utf8                                   |

　　

C # 's financial system database