test

Tables (3)

authorid (Untitled2)

  • author_id — number(5) — Primary key — NOT NULL — 저자번호
  • category (book_category) — varchar2(50) — NOT NULL — 카테고리명
  • authorName (Field) — varchar2(50) — NOT NULL — 저자이름
  • book_title — varchar2(100) — Foreign key → booktitle.book_title — NOT NULL — 책제목

bookid (Untitled)

  • book_id — number(5) — Primary key — NOT NULL — 책번호
  • authorName (book_author) — varchar2(50) — NOT NULL — 저자이름
  • publish_date (Field) — DATE — NOT NULL — 발행일
  • author_id — number(5) — Foreign key → authorid.author_id — NOT NULL — 저자번호

booktitle (Untitled3)

  • book_title — varchar2(100) — Primary key — NOT NULL — 책제목
  • bookPrice (book_price) — number(10) — NOT NULL — 책가격
  • bookStock (Field) — number(5) — NOT NULL — 책재고
  • book_id — number(5) — Foreign key → bookid.book_id — NOT NULL — 책번호