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