New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Simple book-keeping database schema #2

Open

achakravarti opened this issue Apr 7, 2021 · 0 comments

Assignees

Labels

Owner

achakravarti commented Apr 7, 2021 •

edited

Loading

Tables

gaap

Field	Properties
id	serial pk
tag	varchar (8) unique

category

Field	Properties
id	serial pk
tag	varchar (64)
gaap	serial fk -> gaap
debit	char (1)
credit	char (1)

chart

Field	Properties
id	bigserial pk
tag	varchar (256)
category	serial fk -> category

journal

Field	Properties
timestamp	datetime pk
transaction	varchar (1024)
amount	real
debit	bigserial -> chart
credit	bigserial -> chart
posted	bool default false

ledger

Field	Properties
id	uuid pk
account	bigserial -> chart
transaction	uuid fk -> journal
balance	real

memo

Field	Properties
id	serial pk
transaction	uuid fk -> journal
memo	blob

References

achakravarti added the enhancement label

achakravarti self-assigned this

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment