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