THEN Lab Archive DB

Tables (3)

books

  • book_id — SERIAL — Primary key
  • title — VARCHAR(200) — NOT NULL
  • author — VARCHAR(100) — NOT NULL
  • publisher — VARCHAR(100) — NOT NULL
  • publication_date — DATE
  • total_pages — INTEGER — NOT NULL
  • category_id — SERIAL — Foreign key → categories.category_id

categories

  • category_id — SERIAL — Primary key
  • category_name — VARCHAR(50) — NOT NULL
  • parent_category_id — INTEGER

pages

  • page_id — SERIAL — Primary key
  • page_number — INTEGER — NOT NULL
  • content — TEXT — NOT NULL
  • book_id — SERIAL — Foreign key → books.book_id