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