Biblo(연구소용)

테이블 (5)

BOOK

  • book_id — bigint — 기본 키 — 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[]
  • created_date — datetime
  • last_update — datetime
  • work_id — bigint — 외래 키 → WORK.work_id — NOT NULL

MD_COMMENT

  • comment_id — bigint — 기본 키 — NOT NULL
  • comment — text
  • md_name — varcher
  • created_date — datetime
  • last_update — datetime
  • book_id — bigint — 외래 키 → BOOK.book_id — NOT NULL

SKKU_BIBLIO

  • biblio_id — bigint — 기본 키 — 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 — 외래 키 → BOOK.book_id — NOT NULL

SNIPPET

  • snippet_id — bigint — 기본 키 — NOT NULL
  • snippet — text
  • created_date — datetime
  • last_update — datetime
  • book_id — bigint — 외래 키 → BOOK.book_id — NOT NULL

WORK

  • work_id — bigint — 기본 키 — 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