KORENET

Tables (4)

organization (Untitled)

  • id (Key) — varchar(255) — Primary key — NOT NULL
  • org_id (Field) — varchar(255)
  • kr_nmae (Field2) — varchar(255)
  • en_name (Field3) — varchar(255)

product (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • category (Field) — varchar(192) — NOT NULL
  • doc_num (Field2) — varchar(192)
  • auth_list (Field3) — text
  • kr_keywords (Field4) — text
  • ne_keywords (Field5) — text
  • kr_coauth (Field6) — text
  • en_coauth (Field7) — text
  • kr_journal (Field8) — varchar(255)
  • en_journal (Field9) — varchar(255)
  • issn (Field10) — varchar(64)
  • kr_publisher (Field11) — varchar(255)
  • en_publisher (Field12) — varchar(255)
  • kr_title (Field13) — text
  • en_title (Field14) — text
  • ddc (Field15) — varchar(64)
  • ipc (Field16) — varchar(255)
  • language (Field17) — varchar(32)
  • doi (Field18) — varchar(255)
  • pub_year (Field19) — int

product_auth_map (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • product_id (Field) — int
  • auth_id (Field2) — varchar(16)
  • auth_indec (Field3) — int

researcher (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — varchar(255) — Foreign key → organization.id — NOT NULL
  • auth_id (Field) — varchar(64) — NOT NULL
  • org_id (Field2) — varchar(64) — NOT NULL
  • kr_name (Field3) — varchar(192)
  • en_name (Field4) — varchar(192)
  • kr_keywords (Field5) — text
  • product (Field7) — longtext
  • en_keywords (Field6) — text
  • total (Field8) — int
  • email (Field9) — varchar(192)
  • year (Field10) — int
  • like_count (Field11) — int
  • updated (Field12) — datetime