search

JavierCabezas / expenses

A small software to keep track of the expenses on my appartment. I'm going to use it to teach myself Ruby on Rails so I don't expect to do anything serious with this.
0 stars 0 forks source link

Add database model #1

Closed JavierCabezas closed 9 years ago

JavierCabezas commented 9 years ago

The database should have these tables:

User: username (string)

Expense: type_id (int) paid_by (optional, int) month_id (int) ammount (int) status (int) (must define what these statues are going to be) comment (optional, text)

Expense type: name (string) is_bill (bool): True if the expense is a monthly bill (water, electricity, etc.)

Month: month (int) year (int) payed (bool) (default false, when every expense is payed then this goes to true)

JavierCabezas commented 9 years ago

User section is done.

JavierCabezas commented 9 years ago

To the future me: Take this link as a reference to create database columns.

http://stackoverflow.com/questions/10900778/rails-migration-to-make-a-column-null-true