Create Invoices Table

[theNatePi]

Welcome to your first sprint task!

Setup

1. Clone this repository to your local machine
2. On the right side of this issue, create a new branch
   • Check the right side of the GitHub UI
3. Use the commands provided to switch to that branch before you begin working
   • The commands will pop up once you make the branch
      

IMPORTANT

• We are using Yarn. NEVER npm install, always use Yarn
• BEFORE you commit, use git add <names of files>. ONLY add files you modified, including the yarn.lock if you added new modules
• BEFORE you commit, use git status. Ensure files you changed are in green, irrelevant files are in red
• Make sure you always push to your new branch, never push to main
• See the bottom of this doc for resources on Git if you are lost, and feel free to reach out to Nate and Jessie at any time!
   
  NOTE:
  We are using PostgreSQL, not just SQL. Be sure to include Postgres when searching for documentation.
  For time/datetime types, see this documentation: link

Task

1. Implement the invoices table (found in the DB model linked below)
   • A template has been created for you on this website
   • This template will let you implement and test your invoices table
2. When done on the DB Fiddle, create a new file called invoices.sql in /lpa/server/db/schema/
   • Do this locally in VS code or your files, do not do this on the GitHub website
   • The GitHub desktop client is not recommended, it is a good skill to learn the command line!
3. Put the create statement for invoices table in that file. DO NOT put any of the other template SQL or comments
4. Commit and push these changes to GitHub
5. Create a PR describing the changes you made
    

Pre-submit checklist

 

• The invoices table on DB fiddle runs without errors
• The provided insert statements run
• I have written more insert statements to test unique constraints and defaults
• Changes are committed to a new branch for this issue (don't commit to MAIN!!)
• These changes are pushed to the remote repo
   
  Now, create the PR!

Please complete before November 30th
 

Resources

• DB Model
• Git Resources