vocabulary
Tables (6)
StudentAccount ('')
- stuID (Key) — VARCHAR2(20) — Primary key — NOT NULL
- teacherID (Field) — VARCHAR2(20)
memoSequence ('''''')
- memoSeq (Key) — Primary key — NOT NULL
todayVOCA (''')
- vocaSeq (Key3) — VARCHAR2(60) — Foreign key → vocaSequence.vocaSeq — NOT NULL
- id (Key) — VARCHAR2(20) — Foreign key → userAccount.id — NOT NULL
- title (Field) — VARCHAR2(60)
- VOCA (Field2) — VARCHAR2(2000)
- ANSWER (Field4) — VARCHAR2(2000)
- indate (Field3) — DATE
userAccount (')
- id (Key) — VARCHAR2(20) — Primary key — NOT NULL
- stuID (Key2) — VARCHAR2(20) — Foreign key → StudentAccount.stuID — NOT NULL
- pw (Field) — VARCHAR2(20)
- name (Field2) — VARCHAR2(20)
- authority (Field3) — VARCHAR2(20)
userMemo (''''')
- id (Key2) — VARCHAR2(20) — Foreign key → userAccount.id — NOT NULL
- memoSeq (Key3) — VARCHAR2(60) — Foreign key → memoSequence.memoSeq — NOT NULL
- title (Field2) — VARCHAR2(60)
- content (Field3) — VARCHAR2(2000)
- indate (Field4) — DATE
vocaSequence ('''')
- vocaSeq (Key) — Primary key — NOT NULL