medline

Tables (10)

article_info

  • article_id — serial4 — Primary key — NOT NULL
  • article_type — text — NOT NULL
  • article_title — text
  • article_content — text
  • created_time — timestamp
  • modified_time — timestamp
  • author_member_id — int4

article_meta

  • meta_id — serial4 — Primary key — NOT NULL
  • article_id — int4
  • meta_key — text
  • meta_value — text

book_info

  • book_id — serial4 — Primary key — NOT NULL
  • book_code — text
  • book_type — text
  • special_general_type — text
  • tech_classification — text
  • book_title — text
  • book_authors — text
  • book_publisher — text
  • summary_and_toc — text
  • publication_year — text
  • page_count — text
  • book_isbn — text
  • unikorea_url — text
  • upload_tim — timestamp

meddic_info

  • meddic_id — serial4 — Primary key — NOT NULL
  • drug_name_eng — text
  • drug_name_kor — text
  • meddic_type — text
  • synonyms_eng — text
  • synonyms_kor — text
  • drug_content — text
  • page_count — text
  • upload_time — timestamp

medterm_info

  • medterm_id — serial4 — Primary key — NOT NULL
  • medterm_eng — text
  • medterm_south — text
  • medterm_north — text
  • medterm_department — text
  • source_and_structure — text
  • medterm_synonyms — text
  • upload_time — timestamp

member_info

  • member_id — serial4 — Primary key — NOT NULL
  • member_email — text
  • member_password — text
  • member_role — _text
  • created_time — timestamp

news_info

  • news_id — int4 — Primary key — NOT NULL
  • news_code — text
  • publication_date — date
  • news_content — text
  • news_source — text
  • page_count — text
  • news_type_code — text
  • upload_time — timestamp

news_type_scheme

  • type_id — serial4 — Primary key — NOT NULL
  • type_name — text
  • parent_type_id — int4
  • type_code — text

report_info

  • report_id — int4 — Primary key — NOT NULL
  • report_number — text
  • report_type — text
  • report_code — text
  • title_kor — text
  • title_eng — text
  • report_bibliographic — text
  • publication_period — text
  • report_authors — varchar
  • publishing_organ — text
  • report_summary — varchar
  • table_of_contents — text
  • report_keyword — text
  • original_url — text
  • original_url2 — text
  • original_file_name — text
  • is_exist_original — text
  • upload_time — timestamp

thesis_info

  • thesis_id — serial4 — Primary key — NOT NULL
  • thesis_code — text
  • journal_code — text
  • publications_type — text
  • journal_name — text
  • publication_year — text
  • publication_number — text
  • page_count — text
  • thesis_title_kor — text
  • thesis_authors — text
  • research_performance — text
  • closing_remarks — text
  • thesis_title_eng — varchar
  • thesis_summary — text
  • upload_time — timestamp