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

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

Invoice_Item Table

Invoice_Item Table
Field Name Data Type Constraints Default Value Description

Item_Number

Int

Primary Key

 

System Generated Incremental Number

Invoice_Number

Int

Foreign Key

References Invoice

 

User_Number

Int

Foreign Key

References User

 

Item_Description

String (60)

Not NULL

 

Description of the line item for the invoice

Item_Amount

Float

Not NULL

0.00

Amount of the line item for the invoice

 

  • Log in [1] to post comments

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

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