A revised shape for the same design — confirm before any build runs.
erDiagram
CT1_LEMMA ||--o{ CT2_SENSE : "has meanings"
CT2_SENSE ||--o{ CT3_FORM : "has forms (unchanged, one parent)"
CT2_SENSE ||--o{ SENSE_RELATION : "mentions"
SENSE_RELATION }o--|| CT2_TARGET : "points at one target card"
CT1_UMBRELLA ||--o{ CT2_TARGET : "Cluster phrases container for phrase targets"
CT1_LEMMA ||--o{ CT2_TARGET : "a word target is a meaning of its lemma"
SENSE_RELATION ||--o{ RELATION_GLOSS : "meaning next to this sense, one row per language"
SENSE_RELATION ||--o{ RELATION_NOTE : "context note, one row per language"
CT2_TARGET ||--o{ CARD_GLOSS_L1 : "general meaning, one row per language"
CT2_TARGET ||--o{ CARD_EXAMPLE : "two Indonesian examples"
CARD_EXAMPLE ||--o{ EXAMPLE_TEXT : "translation, one row per language"
CT2_TARGET }o..o| ENRICH_QUEUE_ROW : "the plus on a lite card queues its full enrichment"
SENSE_RELATION {
uuid relation_id PK
uuid source_card_id FK "the owning CT2 sense"
uuid target_card_id FK "the CT2 target"
text relation_kind "similar | opposite | informal | related_compound"
int ordinal
text register "formal | informal | slang | neutral — of the pairing, authored"
bool is_idiom
text tag_raw "jenis as authored"
jsonb provenance "opaque, stored whole"
}
CT2_TARGET {
uuid card_id PK "an existing sense, or a new lite row"
text card_archetype "vocabulary | phrase"
int card_tier "2"
uuid parent_card_id FK "its lemma, or the Cluster phrases umbrella"
text enrichment_level "full | lite — the new state (see §4)"
text pronunciation
text audio "t100 rows by card_id, as today"
}
1. CT1 is a lemma — or, for cluster phrases with no natural lemma, an umbrella container that holds them.
2. CT2 is the learnable card — a specific meaning a learner can actually study.
3. CT3 is a form of one specific sense — unchanged by this design.
4. The linking table is not a card — it just records that one sense mentions one target, and what that mention means in context.
| Relation | Target text | Target type | Register | Is idiom | Eng meaning | Ind paraphrase |
|---|---|---|---|---|---|---|
| informal | mam | Lite word (CT1+CT2) | to be authored | to be authored | baby talk for 'eat' used with small children at home | to be authored |
| informal | mamam | Lite word (CT1+CT2) | to be authored | to be authored | cute child language for 'eat', common when coaxing toddlers | to be authored |
| informal | mkn | Lite word (CT1+CT2) | to be authored | to be authored | texting shorthand for 'makan' in chats | to be authored |
| opposite | berpuasa | Lite word (CT1+CT2) | to be authored | No | to fast (abstain from eating) | to be authored |
| opposite | menahan lapar | Lite phrase — Cluster phrases | to be authored | No | to hold back hunger (not eat) | to be authored |
| related compound | kasih makan | Lite phrase — Cluster phrases | to be authored | to be authored | to give food to a person or animal | memberi makan pada orang atau hewan |
| related compound | kereta makan | Lite phrase — Cluster phrases | to be authored | to be authored | dining car | gerbong kereta api yang dipakai sebagai tempat makan; restorasi |
| related compound | makan malam | Lite phrase — Cluster phrases | to be authored | to be authored | to have dinner | makan pada malam hari |
| related compound | makan pagi | Lite phrase — Cluster phrases | to be authored | to be authored | to have breakfast | makan pada waktu pagi; menyarap |
| related compound | makan siang | Lite phrase — Cluster phrases | to be authored | to be authored | to have lunch | makan pada waktu siang hari |
| related compound | makan sirih | Lite phrase — Cluster phrases | to be authored | to be authored | the habit of chewing betel leaf | kebiasaan mengunyah daun sirih |
| related compound | mencari makan | Lite phrase — Cluster phrases | to be authored | to be authored | to earn a living | mencari nafkah |
| related compound | nafsu makan | Lite phrase — Cluster phrases | to be authored | to be authored | the feeling of wanting to eat | rasa ingin makan |
| related compound | rumah makan | Lite phrase — Cluster phrases | to be authored | to be authored | restaurant | kedai tempat makan (menjual makanan) |
| related compound | sudah makan? | Lite phrase — Cluster phrases | to be authored | to be authored | a friendly greeting asking if you have eaten | sapaan akrab untuk tanya sudah makan |
| similar | bersantap | Lite word (CT1+CT2) | to be authored | No | to dine | to be authored |
| similar | melahap | Lite word (CT1+CT2) | to be authored | No | to devour | to be authored |
| similar | menikmati makanan | Lite phrase — Cluster phrases | to be authored | No | to enjoy a meal | to be authored |
| similar | menyantap | Lite word (CT1+CT2) | to be authored | No | to partake (eat formally) | to be authored |
| Relation | Target text | Target type | Register | Is idiom | Eng meaning | Ind paraphrase |
|---|---|---|---|---|---|---|
| informal | gak makan | Lite phrase — Cluster phrases | to be authored | to be authored | colloquial for 'rem tidak makan' in chat and speech | to be authored |
| opposite | macet | Existing CT2 card | to be authored | No | to jam, to get stuck | to be authored |
| opposite | rem blong | Lite phrase — Cluster phrases | to be authored | No | brakes fail | to be authored |
| opposite | tidak berfungsi | Lite phrase — Cluster phrases | to be authored | No | to not function | to be authored |
| similar | bekerja sebagaimana mestinya | Lite phrase — Cluster phrases | to be authored | No | to work as it should | to be authored |
| similar | berfungsi | Lite word (CT1+CT2) | to be authored | No | to function | to be authored |
| similar | berjalan | Existing CT2 card | to be authored | No | to run properly | to be authored |
| similar | bisa | Existing CT2 card | to be authored | No | to work, can function | to be authored |
| Text | Tier assignment | Card exists today? | Phonetics | Example 1 | Example 2 |
|---|---|---|---|---|---|
| bekerja sebagaimana mestinya | Lite phrase — Cluster phrases | No | to be authored | to be authored | to be authored |
| berfungsi | Lite word (CT1+CT2) | No | to be authored | to be authored | to be authored |
| berjalan | Existing CT2 card | Yes | /bər.ˈdʒa.lan/ · buhr-JAH-lahn | Saya berjalan pagi ini. I walked this morning. | Kemarin kami berjalan ke pasar. Yesterday we walked to the market. |
| berpuasa | Lite word (CT1+CT2) | No | to be authored | to be authored | to be authored |
| bersantap | Lite word (CT1+CT2) | No | to be authored | to be authored | to be authored |
| bisa | Existing CT2 card | Yes | /ˈbi.sa/ · BEE-sah | Saya bisa membaca. I can read. | Kamu bisa berenang? Can you swim? |
| gak makan | Lite phrase — Cluster phrases | No | to be authored | to be authored | to be authored |
| kasih makan | Lite phrase — Cluster phrases | No | to be authored | to be authored | to be authored |
| kereta makan | Lite phrase — Cluster phrases | No | to be authored | to be authored | to be authored |
| macet | Existing CT2 card | Yes | /ˈma.tʃət/ · MAH-chuht | Jalan ke pasar sangat macet pagi ini. The road to the market is very jammed this morning. | Saya beli bumbu kemarin di pasar, lalu saluran air di dapur macet. I bought spices at the market yesterday, then the kitchen drain got blocked. |
| makan malam | Lite phrase — Cluster phrases | No | to be authored | to be authored | to be authored |
| makan pagi | Lite phrase — Cluster phrases | No | to be authored | to be authored | to be authored |
| makan siang | Lite phrase — Cluster phrases | No | to be authored | to be authored | to be authored |
| makan sirih | Lite phrase — Cluster phrases | No | to be authored | to be authored | to be authored |
| mam | Lite word (CT1+CT2) | No | to be authored | to be authored | to be authored |
| mamam | Lite word (CT1+CT2) | No | to be authored | to be authored | to be authored |
| melahap | Lite word (CT1+CT2) | No | to be authored | to be authored | to be authored |
| menahan lapar | Lite phrase — Cluster phrases | No | to be authored | to be authored | to be authored |
| mencari makan | Lite phrase — Cluster phrases | No | to be authored | to be authored | to be authored |
| menikmati makanan | Lite phrase — Cluster phrases | No | to be authored | to be authored | to be authored |
| menyantap | Lite word (CT1+CT2) | No | to be authored | to be authored | to be authored |
| mkn | Lite word (CT1+CT2) | No | to be authored | to be authored | to be authored |
| nafsu makan | Lite phrase — Cluster phrases | No | to be authored | to be authored | to be authored |
| rem blong | Lite phrase — Cluster phrases | No | to be authored | to be authored | to be authored |
| rumah makan | Lite phrase — Cluster phrases | No | to be authored | to be authored | to be authored |
| sudah makan? | Lite phrase — Cluster phrases | No | to be authored | to be authored | to be authored |
| tidak berfungsi | Lite phrase — Cluster phrases | No | to be authored | to be authored | to be authored |
Relation-row table: 23 of 81 cells exist today. Target table: 9 of 81 cells exist today. Combined: 32 of 162 cells exist today — the rest are “to be authored”.