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