aa

Tables (8)

book

  • Key — Primary key — NOT NULL
  • user_id — varchar2(20) — NOT NULL
  • word_num — number — NOT NULL
  • book_id — number — NOT NULL
  • /*REFERENCES — book_list
  • */ — star
  • Field

book_list

  • book_id — number
  • book_name — varchar2(20) — NOT NULL
  • user_id — varchar2(20) — NOT NULL
  • kind_id — number — NOT NULL
  • book_memo — varchar2(4000)
  • hit — number

grade

  • Key — Foreign key → member.Key — NOT NULL
  • grade_id — number
  • t_date — date — NOT NULL
  • user_id — varchar2(20) — NOT NULL
  • book_id — number — NOT NULL
  • crr — number
  • incrr — number

kind

  • kind_id — number
  • kind_name — varchar2(50) — NOT NULL

member

  • Key — Primary key — NOT NULL
  • user_id — varchar2(20)
  • user_pass — varchar2(20) — NOT NULL
  • user_name — varchar2(20) — NOT NULL
  • image — varchar2(20) — NOT NULL
  • email — varchar2(50) — NOT NULL
  • favor — number — NOT NULL
  • isadmin — number — NOT NULL

notice

  • notice_num — number
  • title — varchar2(50) — NOT NULL
  • content — varchar2(4000) — NOT NULL
  • w_date — date — NOT NULL
  • writer — varchar2(20) — NOT NULL

qna

  • qna_num — number
  • title — varchar2(50) — NOT NULL
  • content — varchar2(4000) — NOT NULL
  • w_date — date
  • writer — varchar2(20) — NOT NULL
  • ans — varchar2(4000) — NOT NULL
  • read — number — NOT NULL

word

  • word_num — number
  • word — varchar2(50) — NOT NULL
  • meaning — varchar2(4000) — NOT NULL
  • kind_id — number — NOT NULL