While the database is not really part of opentimesheet we publish our reference implementation here. You can simply take our MySQL DDL or create your own for your favorite database system.

Users are users, usersrights build a simple rights management with four levels, props are glue-keys to legacy systems, groups are to be mapped to project-hierarchy's, timespent records working times.