Biblo
Tables (5)
BOOK
- book_id — bigint — Primary key — NOT NULL
- book_title — text
- book_author — text
- book_genre — text[]
- book_concept — text[]
- book_object — text[]
- book_event — text[]
- book_place — text[]
- book_character — text[]
- book_target_audience — text[]
- book_purpose — text[]
- book_synopsis — text[]
- book _tone_and_style — text[]
- book_notable_features — text[]
- book_isbn — varchar
- created_date — datetime
- last_update — datetime
- work_id — bigint — Foreign key → WORK.work_id — NOT NULL
MD_COMMENT
- comment_id — bigint — Primary key — NOT NULL
- comment — text
- md_name — varcher
- created_date — datetime
- last_update — datetime
- book_id — bigint — Foreign key → BOOK.book_id — NOT NULL
SKKU_BIBLIO
- biblio_id — bigint — Primary key — NOT NULL
- title — varchar
- author — varchar
- author_info — text
- publisher — varchar
- publish_year — varchar
- isbn — varchar
- content — text
- toc — text
- publisher_note — text
- author_preface — text
- created_date — datetime
- last_update — datetime
- book_id — bigint — Foreign key → BOOK.book_id — NOT NULL
SNIPPET
- snippet_id — bigint — Primary key — NOT NULL
- snippet — text
- created_date — datetime
- last_update — datetime
- book_id — bigint — Foreign key → BOOK.book_id — NOT NULL
WORK
- work_id — bigint — Primary key — NOT NULL
- work_title — text
- work_author — text
- work_genre — text[]
- work_concept — text[]
- work_object — text[]
- work_event — text[]
- work_place — text[]
- work_character — text[]
- work_target_audience — text[]
- work_purpose — text[]
- work_synopsis — text[]
- work _tone_and_style — text[]
- created_date — datetime
- last_update — datetime