`lib/yiddish-dictionary/yiddish_dictionary.sqlite`

167 lines
SQLite format 3@  .WJ��
��GA#3Dear Bubbe Core VocabularyInternalProprietary2025-11-19 19:27:32
����entries
	sources+bubbe_favorites
2�8��M
�
�
Z
	�Q��F
�
�
 	�	X��8��'�c�2U%'		3טאָכעסtuchesbuttocksnounbody,informaltuch0012025-11-19 19:27:32u7+%3		3מאַזל טאָווmazel tovcongratulationsinterjectionexpression,positivemaz0012025-11-19 19:27:32a)9		3זאַפטיקzaftigplumpadjectiveappearance,descriptivezaf0012025-11-19 19:27:32a)1)		3פּלאַצןplotzburst with emotionverbemotion,strongplot0012025-11-19 19:27:32_-+		3מישיגאָסmishegosscrazinessnounbehavior,commonmish0012025-11-19 19:27:32W)'		3קיביצערkibitzermeddlernounbehavior,mildkib0012025-11-19 19:27:32Y%'#		3שלעמילshlemielclumsy personnouninsult,mildshl0032025-11-19 19:27:32[%)#		3שלימזלshlimazelunlucky personnouninsult,mildshl0022025-11-19 19:27:32g)'=		3מאַמעלעmamelehlittle mothernounendearment,condescendingmam0012025-11-19 19:27:32[%5		3בובעלעbubelehsweetienounendearment,sarcasticbub0012025-11-19 19:27:32X%7		3פעfehdisgustinterjectionexpression,dismissivefeh0012025-11-19 19:27:32e-%/		3געוואַלדgevaltoh my godinterjectionexpression,stronggev0012025-11-19 19:27:32_+%/		3אוי ווייoy veyoh nointerjectionexpression,commonoy0012025-11-19 19:27:32t97)		3פאַרקלעמפּטverklemptovercome with emotionadjectiveemotion,commonver0012025-11-19 19:27:32Q!+		3שוויץshvitzsweatverbphysical,commonshv0012025-11-19 19:27:32[%)%		3שמאַלץshmaltzsentimentalitynounemotion,foodshma0022025-11-19 19:27:32Z-'		3טשאַטשקעtchotchketrinketnounobject,commontch0012025-11-19 19:27:32S
%+		3שמאַטעshmatteragnounclothing,insultshma0012025-11-19 19:27:32X%+		3חוצפּהchutzpahaudacitynounbehavior,commonchu0012025-11-19 19:27:32Y)/		3באָבקעסbupkisnothingnounexpression,commonbup0012025-11-19 19:27:32[
!#3		3מענטשmenschgood personnouncompliment,positivemen0012025-11-19 19:27:32O	!'		3שמועסshmoozechatverbsocial,commonshm0032025-11-19 19:27:32J#		3נאָשnoshsnackverbfood,commonnosh0012025-11-19 19:27:32M!'		3שלעפּshlepdragverbaction,commonshl0012025-11-19 19:27:32V%-		3קוועטשkvetchcomplainverbcomplaint,commonkv0012025-11-19 19:27:32N%#		3נודניקnudnikpestnouninsult,mildnud0012025-11-19 19:27:32N!'		3שמאַקshmuckjerknouninsult,strongshm0022025-11-19 19:27:32I'		3פוץputzfoolnouninsult,commonputz0012025-11-19 19:27:32c-1#		3שמענדריקshmendrikineffectual personnouninsult,mildshm0012025-11-19 19:27:32a-!%'		3משוגענערmeshugenercrazy personnouninsult,commonmesh0012025-11-19 19:27:32
��
�
������
�
)�4x
/�
�]
Ia
�
eH�w��%	טאָכעסbuttocks*7+	מאַזל טאָווcongratulations)	זאַפטיקplump&)1	פּלאַצןburst with emotion-	מישיגאָסcraziness)	קיביצערmeddler%'	שלעמילclumsy person %)	שלימזלunlucky person!)'	מאַמעלעlittle mother%	בובעלעsweetie	פעdisgust-	געוואַלדoh my god+	אוי ווייoh no197	פאַרקלעמפּטovercome with emotion!	שוויץsweat %)	שמאַלץsentimentality-	טשאַטשקעtrinket%	שמאַטעrag
%	חוצפּהaudacity)	באָבקעסnothing!#	מענטשgood person
!	שמועסchat		נאָשsnack!	שלעפּdrag%	קוועטשcomplain%	נודניקpest!	שמאַקjerk	פוץfool(-1	שמענדריקineffectual person!-%		משוגענערcrazy person

��N��=
�
��<a��)����Q�ud�,�p�%טאָכעס7מאַזל טאָוו)זאַפטיק)פּלאַצן-מישיגאָס)קיביצער%שלעמיל%שלימזל)מאַמעלע%בובעלעפע-געוואַלד+אוי וויי9פאַרקלעמפּט!שוויץ%שמאַלץ-טשאַטשקע%שמאַטע
%חוצפּה)באָבקעס!מענטש
!שמועס	נאָש!שלעפּ%קוועטש%נודניק!שמאַק
פוץ-שמענדריק-	משוגענער
��x#��������.�����Rl���G^�9�
tuches
mazel tov
zaftig	plotz
mishegosskibitzershlemiel
shlimazelmamelehbubelehfeh
gevalt
oy vey
verklempt
shvitzshmaltz
tchotchkeshmatte
chutzpah
bupkis
mensch
shmooze	nosh	shlep
kvetch
nudnik
shmuckputz
shmendrik
!	meshugener
^l�^���k����������y	!�dE�;�X�buttocks+congratulations	plump1burst with emotion
crazinessmeddler'clumsy person)unlucky person'little mothersweetiedisgust
oh my god	oh no7overcome with emotion	sweat)sentimentalitytrinketrag
audacitynothing#good person
chat		snackdragcomplainpestjerkfool1ineffectual person%	crazy person
k�������������������������zupk																		
			
											
k�������������������������zupk																		
			
											
�c�RA0�����������z'������q�noun%interjection
adjectiveverbnounnounnounnounnounnoun%interjection%interjection%interjection
adjectiveverbnounnounnoun
nounnounnoun
verb	verbverbverbnounnounnounnoun	noun








����	�a	?�t�V�|��6����Z3uindexidx_phrases_yiddishphrasesCREATE INDEX idx_phrases_yiddish ON phrases(yiddish)�'�%tablephrasesphrasesCREATE TABLE phrases (
    id              INTEGER PRIMARY KEY AUTOINCREMENT,
    yiddish         TEXT NOT NULL,
    yiddish_latin   TEXT,
    english         TEXT NOT NULL,
    literal_meaning TEXT,                       -- Word-for-word translation
    usage_context   TEXT,                       -- When/how to use it
    cultural_note   TEXT,
    source_id       INTEGER,
    bubbe_approved  INTEGER DEFAULT 1,
    created_at      TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (source_id) REFERENCES sources(id)
)b
3!indexidx_variations_textvariationsCREATE INDEX idx_variations_text ON variations(variation)c5!indexidx_variations_entryvariations
CREATE INDEX idx_variations_entry ON variations(entry_id)�r!!�/tablevariationsvariationsCREATE TABLE variations (
    id              INTEGER PRIMARY KEY AUTOINCREMENT,
    entry_id        INTEGER NOT NULL,
    variation       TEXT NOT NULL,
    variation_type  TEXT,                       -- 'spelling', 'regional', 'historical'
    notes           TEXT,
    FOREIGN KEY (entry_id) REFERENCES entries(id) ON DELETE CASCADE
)N
+eindexidx_entries_posentriesCREATE INDEX idx_entries_pos ON entries(pos)p	A�indexidx_entries_bubbe_approvedentries
CREATE INDEX idx_entries_bubbe_approved ON entries(bubbe_approved)Z1windexidx_entries_sourceentries	CREATE INDEX idx_entries_source ON entries(source_id)Z3uindexidx_entries_englishentriesCREATE INDEX idx_entries_english ON entries(english)m?�
indexidx_entries_yiddish_latinentriesCREATE INDEX idx_entries_yiddish_latin ON entries(yiddish_latin)Z3uindexidx_entries_yiddishentriesCREATE INDEX idx_entries_yiddish ON entries(yiddish)�C�]tableentriesentriesCREATE TABLE entries (
    id              INTEGER PRIMARY KEY AUTOINCREMENT,
    yiddish         TEXT NOT NULL,              -- Original Yiddish text (Hebrew script)
    yiddish_latin   TEXT,                       -- Latin transliteration
    english         TEXT NOT NULL,              -- English translation
    pos             TEXT,                       -- Part of speech (noun, verb, adj, etc.)
    gender          TEXT,                       -- Grammatical gender (m/f/n)
    plural          TEXT,                       -- Plural form
    tags            TEXT,                       -- Comma-separated tags (slang, archaic, etc.)
    usage_example   TEXT,                       -- Example sentence
    cultural_note   TEXT,                       -- Cultural context or usage notes
    source_id       INTEGER NOT NULL,
    source_entry_id TEXT,                       -- Original ID from source
    bubbe_approved  INTEGER DEFAULT 1,          -- 1=safe for Bubbe, 0=needs review, -1=banned
    notes           TEXT,
    created_at      TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (source_id) REFERENCES sources(id),
    UNIQUE (yiddish, english, source_id) ON CONFLICT IGNORE
)-Aindexsqlite_autoindex_entries_1entriesP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)��}tablesourcessourcesCREATE TABLE sources (
    id              INTEGER PRIMARY KEY AUTOINCREMENT,
    name            TEXT NOT NULL,
    url             TEXT,
    license         TEXT,
    notes           TEXT,
    imported_at     TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)
�V
�T�X��V�N�B33�/viewapproved_vocabularyapproved_vocabularyCREATE VIEW approved_vocabulary AS
SELECT 
    e.id,
    e.yiddish,
    e.yiddish_latin,
    e.english,
    e.pos,
    e.gender,
    e.tags,
    e.usage_example,
    e.cultural_note,
    s.name as source_name,
    GROUP_CONCAT(v.variation, ', ') as variations
FROM entries e
LEFT JOIN sources s ON e.source_id = s.id
LEFT JOIN variations v ON e.id = v.entry_id
WHERE e.bubbe_approved = 1
GROUP BY e.id�++�atablebubbe_favoritesbubbe_favoritesCREATE TABLE bubbe_favorites (
    id              INTEGER PRIMARY KEY AUTOINCREMENT,
    yiddish         TEXT NOT NULL,
    english         TEXT NOT NULL,
    context         TEXT,                   -- 'scolding', 'complaining', 'advice'
    intensity       INTEGER DEFAULT 5,      -- 1-10 scale of harshness
    usage_example   TEXT,
    notes           TEXT
)a5#yindexidx_usage_stats_termusage_statsCREATE INDEX idx_usage_stats_term ON usage_stats(term)h7#�indexidx_usage_stats_entryusage_statsCREATE INDEX idx_usage_stats_entry ON usage_stats(entry_id)�U##�qtableusage_statsusage_statsCREATE TABLE usage_stats (
    id          INTEGER PRIMARY KEY AUTOINCREMENT,
    entry_id    INTEGER,
    phrase_id   INTEGER,
    term        TEXT NOT NULL,
    usage_count INTEGER DEFAULT 1,
    last_used   TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    context     TEXT,                       -- 'greeting', 'insult', 'advice', etc.
    FOREIGN KEY (entry_id) REFERENCES entries(id),
    FOREIGN KEY (phrase_id) REFERENCES phrases(id)
)f3%�indexidx_banned_languagebanned_termsCREATE INDEX idx_banned_language ON banned_terms(language)Y+%qindexidx_banned_termbanned_termsCREATE INDEX idx_banned_term ON banned_terms(term)7K%indexsqlite_autoindex_banned_terms_1banned_terms�9%%�5tablebanned_termsbanned_termsCREATE TABLE banned_terms (
    id          INTEGER PRIMARY KEY AUTOINCREMENT,
    term        TEXT NOT NULL UNIQUE,
    language    TEXT NOT NULL,              -- 'yi' for Yiddish, 'en' for English
    category    TEXT,                       -- 'ethnic_slur', 'offensive', 'inappropriate'
    severity    TEXT,                       -- 'critical', 'high', 'medium'
    reason      TEXT,
    replacement TEXT,                       -- Suggested alternative
    notes       TEXT,
    created_at  TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)Z3uindexidx_phrases_englishphrasesCREATE INDEX idx_phrases_english ON phrases(english)��$;;�cviewbubbe_active_vocabularybubbe_active_vocabularyCREATE VIEW bubbe_active_vocabulary AS
SELECT 
    'entry' as type,
    e.yiddish,
    e.yiddish_latin,
    e.english,
    e.usage_example,
    us.usage_count,
    us.last_used
FROM entries e
JOIN usage_stats us ON e.id = us.entry_id
WHERE e.bubbe_approved = 1
UNION ALL
SELECT 
    'phrase' as type,
    p.yiddish,
    p.yiddish_latin,
    p.english,
    p.usage_context as usage_example,
    us.usage_count,
    us.last_used
FROM phrases p
JOIN usage_stats us ON p.id = us.phrase_id
WHERE p.bubbe_approved = 1
UNION ALL
SELECT 
    'favorite' as type,
    bf.yiddish,
    NULL as yiddish_latin,
    bf.english,
    bf.usage_example,
    NULL as usage_count,
    NULL as last_used
FROM bubbe_favorites bf
ORDER BY usage_count DESC, last_used DESC






T�a��C
�
�
TF)OטשעפּעןtchepennaggingDon't tchepen me about my weight!V)%iפּלאַצןplotzoverwhelmingYour mother's gonna plotz when she hears this!M!#_קװעטשkvetchcomplainingStop kvetching and do something about it!^9iפֿאַרקאַקטעfarkaktecomplaintThis farkakte weather is killing my arthritis!V-iשמענדריקshmendrikinsultThat shmendrik can't even boil water properly!d-!משוגענערmeshugenerscoldingYou meshugener! Who quits a job without another lined up?K)_געװאַלדgevaltalarmOy gevalt! Still not married at YOUR age?P%eאױ װײoy veyexasperationOy vey, you spent HOW MUCH on that schmatte?