aaa

Tables (8)

patent

  • application_number — bigint — NOT NULL
  • application_date — date — 출원일자
  • astrt_cont — text — 요약
  • big_drawing — character — 대표도면
  • drawing — character — 도면
  • invention_title — character — 발명의
  • open_date — date — 공개일자
  • open_number — bigint — 공개번호
  • publication_date — date — 공고일자
  • publication_number — bigint — 공고번호
  • register_date — date — 등록일자
  • register_number — bigint — 등록번호
  • register_status — character — 등록상태

patent_applicant

  • application_number — bigint — NOT NULL
  • applicant_name — character — NOT NULL — 출원인

patent_applicant_person

  • id — integer — NOT NULL
  • application_number — bigint — 출원번호
  • address — character — 주소
  • code — character — 코드
  • country — character — 국가
  • eng_name — character — 출원인
  • name — character — 출원인

patent_bibliography

  • application_number — bigint — NOT NULL
  • application_date — date — 출원일자
  • claim_count — integer — 청구항
  • final_disposal — character — 최종처분
  • invention_title — character — 발명의
  • invention_title_eng — character — 발명의
  • open_date — date — 공개일자
  • open_number — character — 공개번호
  • original_application_date — date — 원출원일자
  • original_application_kind — character — 원출원종류
  • original_application_number — character — 원출원번호
  • original_examination_request_date — date — 원심사청구일자
  • original_examination_request_flag — character(1) — 원심사청구여부
  • publication_date — date — 공고일자
  • publication_number — character — 공고번호
  • register_date — date — 등록일자
  • register_number — character — 등록번호
  • register_status — character — 등록상태
  • translation_submit_date — date — 번역문제출일자

patent_family

  • family_id — bigint — NOT NULL
  • kr_application_number — bigint — 한국
  • application_country_code — character — 출원국가코드
  • application_date — date — 출원일자
  • application_kind_code — character — 출원종류코드
  • application_number — character — 출원번호
  • docdb_family_id — bigint — DOCDB
  • publication_country_code — character — 공개국가코드
  • publication_date — date — 공개일자
  • publication_kind_code — character — 공개종류코드
  • publication_number — character — 공개번호

patent_inventor

  • inventor_id — integer — NOT NULL
  • application_number — bigint — 출원번호
  • address — character — 주소
  • code — character — 코드
  • country — character — 국가
  • eng_name — character — 발명자
  • name — character — 발명자

patent_ipc_code

  • application_number — bigint — NOT NULL
  • ipc_code — character — NOT NULL — IPC
  • ipc_first_char — character(1) — IPC
  • ipc_code_3char — character — IPC
  • ipc_code_4char — character — IPC

raw_patent

  • application_number — bigint — NOT NULL
  • applicant_name — character — 출원인
  • application_date — date — 출원일자
  • astrt_cont — text — 요약
  • big_drawing — character — 대표도면
  • drawing — character — 도면
  • index_no — integer — 인덱스
  • invention_title — character — 발명의
  • ipc_number — character — IPC
  • open_date — date — 공개일자
  • open_number — bigint — 공개번호
  • publication_date — date — 공고일자
  • publication_number — bigint — 공고번호
  • register_date — date — 등록일자
  • register_number — bigint — 등록번호
  • register_status — character — 등록상태