ActuallyACat/cs4920 — pull request #2 by mcho421 (2012-09-22 03:38:55+00:00)
Title: Schema edit

- Added comments,
- Changed how UE phrase vs sentence works (0=phrase, 1=sentence)
- Changed names: Usage->UE
- Changed names of tables
- Significantly changed UEpartofList table
- Minor edits elsewhere

Also I was wondering if you could clarify a few things:

Meaning from Usage Example:
---

Library: Kenkyusha

Entry: せんせい１【先生】 (sensei)
Meaning 1: 〔教師〕 a teacher; a master; an instructor; 〔技術指導者〕 an instructor.
姉は小学校の先生になりました.　My elder sister became an elementary [a primary] school teacher.
いい先生に巡り合えた.　I was blessed with a good teacher.
Meaning 2: 〔医者〕 a doctor.
先生, 母の容態はいかがでしょう.　How is my mother, doctor?

Entry: けんこう４【健康】 (kenkō)
Meaning 1: health; fitness; 〔心身の調子〕 the state of one's health; one's (physical) condition; 〔健全〕 healthiness; wholesomeness.
鈴木先生の健康を祝して乾杯!　Here's to your health, Mr. Suzuki!

Given a Usage Example (say from Lookup Mode), how do we get which meaning the Usage Example came from? For example, how can we obtain that
"先生, 母の容態はいかがでしょう."
came from Kenkyusha->先生->'a doctor' from the database?

UE partOf Library (UESource) relationship
---
I'm not sure if this is necessary with the current schema as according to the ER diagram, a UE must be contained in an Entry, an Entry must be part of a Library.

It was necessary in my schema because I abstracted the idea of a 'word' (string) outside the idea of a (dictionary) Entry, and used the relationship: UEs may have a meaning, meanings must be part of an entry, entries must be part of a library.

Could you clarify this point?

Word Lists
---
Although it might be a bit early to discuss this, but how would we implement Word Lists as opposed to UE Lists (the currently implemented table - Lists)?