Home

Welcome to the daily-learning wiki!

Schema

users

column name	data type	details
id	integer	not null, primary key
name	string	not null
username	string	not null, indexed, unique
email	string	not null, indexed, unique
password_digest	string	not null
session_token	string	not null, indexed, unique
created_at	datetime	not null
updated_at	datetime	not null

• index on username, unique: true
• index on email, unique: true
• index on session_token, unique: true

books

column name	data type	details
id	integer	not null, primary key
title_en	string	not null
title_he	string	not null
title_he_tr	string	not null
description	string	not null
section_id	integer	not null, indexed, foreign key
created_at	datetime	not null
updated_at	datetime	not null

• index on section_id

sections

column name	data type	details
id	integer	not null, primary key
title_en	string	not null
title_he	string	not null
title_he_tr	string	not null
description	string	not null
created_at	datetime	not null
updated_at	datetime	not null

• has many books

parshios

perakim

pesukim

haftoros