Git Product home page Git Product logo

database's Introduction

database

Schema

Available in tables.sql file.

UML

ER diagram

Relations not implemented at SQL level:

  • CUSTOMFIELDDATA.REFID (depends on CUSTOMFIELD.REFTYPE)
  • ATTACHMENT.REFID (depends on ATTACHMENT.REFTYPE)
  • TRANSLINK.LINKRECORDID (depends on TRANSLINK.LINKTYPE)

Initialization

Initial category / subcategory hierarchy:

  • Bills
    • Telephone
    • Electricity
    • Gas
    • Internet
    • Rent
    • Cable TV
    • Water
  • Food
    • Groceries
    • Dining out
  • Leisure
    • Movies
    • Video Rental
    • Magazines
  • Automobile
    • Maintenance
    • Gas
    • Parking
    • Registration
  • Education
    • Books
    • Tuition
    • Others
  • Homeneeds
    • Clothing
    • Furnishing
    • Others
  • Healthcare
    • Health
    • Dental
    • Eyecare
    • Physician
    • Prescriptions
  • Insurance
    • Life
    • Home
    • Health
    • Auto
  • Vacation
    • Travel
    • Lodging
    • Sightseeing
  • Taxes
    • Income Tax
    • House Tax
    • Water Tax
    • Others
  • Miscellaneous
  • Gifts
  • Income
    • Salary
    • Reimbursement/Refunds
    • Investment Income
  • Other Income
  • Other Expenses
  • Transfer

database's People

Contributors

dbolton avatar gabriele-v avatar guanlisheng avatar slodki avatar stef145g avatar vomikan avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.