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

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
content	string	not null
start_perek_id	integer	not null, indexed, foreign key
start_pasuk_id	integer	not null, indexed, foreign key
end_perek_id	integer	not null, indexed, foreign key
end_pasuk_id	integer	not null, indexed, foreign key
created_at	datetime	not null
updated_at	datetime	not null

• index on start_perek_id
• index on start_pasuk_id
• index on end_perek_id
• index on end_pasuk_id

perakim

column name	data type	details
id	integer	not null, primary key
book_id	integer	not null, indexed, foreign key
created_at	datetime	not null
updated_at	datetime	not null

• index on book_id

pesukim

column name	data type	details
id	integer	not null, primary key
text_he	string	not null
text_en	string	not null
unkelos	string	not null
perek_id	integer	not null, indexed, foreign key
created_at	datetime	not null
updated_at	datetime	not null

• index on perek_id

haftoros