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 — 등록상태