Niedermayer.ca
Published on Niedermayer.ca (https://niedermayer.ca)

Home > User Management System (UMS) -- Detailed System Design > System Architecture > Data Model > Invoice Table

Invoice Table

Invoice Table
Field Name Data Type Constraints Default Value Description

Invoice_Number

Int

Primary Key

 

System Generated Incremental Number

User_Number

Int

Foreign Key

References User

 

Invoice_Date

Time­stamp

Not NULL

 

Date on which the invoice was issued

Invoice_Medium

 String (20)

Not NULL

 

One of “e-mail”, “paper”, “fax” or some other such descriptor of the method in which the invoice was delivered

Invoice_Amount

Float

Not NULL

 

The total value of the invoice

Invoice_EnteredBy

 String (16)

Not NULL

 

The name of the GPFN Volunteer adding this invoice to the system

 

  • Log in [1] to post comments

Source URL:https://niedermayer.ca/node/94

Links
[1] https://niedermayer.ca/user/login?destination=node/94%23comment-form