사료관리시스템
테이블 (11)
계층별분류체계 (LEVELCLSS)
- LEVEL_CLSS_ID (level_clss_id) — varchar(7) — 기본 키 — NOT NULL
- CLSS_NAME (clss_name) — varchar(100)
- PROC_DEPT_ID (proc_dept_id) — varchar(7)
- REGISTER (register) — varchar(50)
- REG_DATE (reg_date) — varchar(8)
- EDITOR (editor) — varchar(50)
- EDIT_DATE (edit_date) — varchar(8)
- CONTENT (contents) — varchar(500)
- UPPER_CLSS_ID (upper_clss_id) — varchar(7)
- LOWER_CLSS_ID (lower_clss_id) — varchar(7)
- DEPT_ID (dept_id2) — varchar(7) — 외래 키 → 부서.DEPT_ID — NOT NULL
리드 (LEAD)
- LEAD_ID (lead_id) — varchar(7) — 기본 키 — NOT NULL
- LEAD_NAME (lead_name) — varchar(50)
- LEAD_AUTH_NAME (lead_auth_name) — varchar(50)
- LEAD_TYPE (lead_type) — varchar(1)
- TEL_NUM (tel_num) — varchar(14)
- EMAIL (email) — varchar(50)
- CELL_PHONE (cell_phone) — varchar(11)
- HOMEPAGE (homepage) — varchar(50)
- ADDRESS (address) — varchar(100)
- REGISTER (register) — char(50)
- DETAIL_INFO (detail_info) — CLOB
- HIST_ACT (hist_act) — CLOB
- FILE (file) — varchar(256)
부서 (DEPT)
- DEPT_ID (dept_id) — varchar(7) — 기본 키 — NOT NULL
- DEPT_NAME (dept_name) — varchar(50)
- UPPER_DEPT_ID (upper_dept_id) — varchar(7)
- LOWER_DEPT_ID (lower_dept_id) — varchar(7)
- EXIST_FLAG (exist_flag) — varchar(1)
사료 (HISTITEM)
- HIST_ITEM_ID (hist_item_id) — varchar(7) — 기본 키 — NOT NULL
- LEVEL_CLSS_ID (level_clss_id) — varchar(7) — 외래 키 → 계층별분류체계.LEVEL_CLSS_ID — NOT NULL
- HIST_ITEM_TITLE (hist_item_title) — varchar(100)
- HIST_ITEM_SUB_TITLE (hist_item_sub_title) — varchar(100)
- REGISTER (register) — char(50)
- EDITOR (editor) — varchar(50)
- REG_DATE (reg_date) — varchar(8)
- EDIT_DATE (edit_date) — varchar(8)
- LEVEL_CLSS_NAME (level_clss_name) — varchar(50)
- SUB_CLSS_ID (sub_clss_id) — varchar(7)
- SUB_CLSS_NAME (sub_clss_name) — varchar(50)
- HIST_ITEM_TYPE (hist_item_type) — varchar(1)
- HIST_ITEM_DETAIL_TYPE (hist_item_detail_type) — varchar(1)
- HIST_ITEM_FILE (hist_item_file) — varchar(256)
- CREATOR (creator) — varchar(50)
- CREATE_DATE (create_date) — varchar(8)
- DONOR (donor) — varchar(100)
- DONATED_DATE (donated_date) — varchar(8)
- OPEN_FLAG (open_flag) — varchar(1)
- OPEN_LIMIT_FLAG (open_limit_flag) — varchar(1)
- COPYRIGHT (copyright) — varchar(200)
- ELECT_FLAG (elect_flag) — varchar(1)
- ORIGN_FLAG (orign_flag) — varchar(1)
- COPY_INFO (copy_info) — varchar(100)
- DUPLIC_INFO (duplic_info) — varchar(100)
- LANG (lang) — varchar(1)
- LOCAL_INFO (local_info) — varchar(100)
- LOCAL_DETAIL_INFO (local_detail_info) — varchar(100)
- DESCRIPTOR (descriptor) — varchar(50)
- DESC_DATE (desc_date) — varchar(8)
- DESC_STANDARD (desc_standard) — varchar(30)
- CREATOR_HIST (creator_hist) — CLOB
- DONOR_INFO (donor_info) — CLOB
- MNG_HIST (mng_hist) — CLOB
- HIST_ITEM_INFO (hist_item_info) — CLOB
- HIST_ITEM_PROC_SCH_INFO (hist_item_proc_sch_info) — CLOB
- READ_USE_INFO (read_use_info) — CLOB
- REL_RCD_INFO (rel_rcd_info) — CLOB
- OTHER_INFO (other_info) — CLOB
- YEAR_CLSS_ID (year_clss_id) — varchar(7) — 외래 키 → 연도별분류체계.YEAR_CLSS_ID — NOT NULL
- SUB_CLSS_ID (sub_clss_id2) — varchar(7) — 외래 키 → 주제별분류체계.SUB_CLSS_ID — NOT NULL
사용자 (USER)
- USER_ID (user_id) — varchar(20) — 기본 키 — NOT NULL
- USER_PWD (user_pwd) — varchar(50)
- USER_NAME (user_name) — varchar(50)
- DEPT_ID (dept_id) — varchar(50)
- PHONE_NUM (phone_num) — varchar(14)
- USER_TYPE (user_type) — varchar(1)
- DEPT_ID (dept_id2) — varchar(7) — 외래 키 → 부서.DEPT_ID — NOT NULL
수집정보 (COLLECTINFO)
- COLLECT_INFO_ID (collect_info_id) — varchar(7) — 기본 키 — NOT NULL
- LEAD_ID (lead_id) — varchar(7) — 외래 키 → 리드.LEAD_ID — NOT NULL
- LEAD_NAME (lead_name) — varchar(50)
- COLLECT_DATE (colllect_date) — varchar(8)
- COLLECT_NUM (collect_num) — varchar(7)
- COLLECT_TYPE (collect_type) — varchar(1)
- HIST_TYPE (hist_type) — varchar(1)
- QUANTITY (quantity) — int
- EMAIL (email) — varchar(50)
- REGISTER (register) — varchar(50)
- REG_DATE (reg_date) — varchar(8)
- EDITOR (editor) — varchar(50)
- EDIT_DATE (edit_date) — varchar(8)
- HIST_CONTENTS (hist_contents) — CLOB
- COLLECT_CON (collect_con) — CLOB
- PROC_DATE (proc_date) — char(1)
- CONTRACT_DATE (contract_date) — varchar(8)
- AMT_CON (amt_con) — int
연도별분류체계 (YEARCLSS)
- YEAR_CLSS_ID (year_clss_id) — varchar(7) — 기본 키 — NOT NULL
- CLSS_NAME (clss_name) — varchar(100)
- PROC_DEPT_ID (proc_dept_id) — varchar(7)
- REGISTER (register) — varchar(50)
- REG_DATE (reg_date) — varchar(8)
- EDITOR (editor) — varchar(50)
- EDIT_DATE (edit_date) — varchar(8)
- CONTENT (contents) — varchar(500)
- UPPER_CLSS_ID (upper_clss_id) — varchar(7)
- LOWER_CLSS_ID (lower_clss_id) — varchar(7)
- DEPT_ID (dept_id2) — varchar(7) — 외래 키 → 부서.DEPT_ID — NOT NULL
열람신청 (REQREADING)
- REQ_ID (req_id) — varchar(7) — 기본 키 — NOT NULL
- USER_ID (user_id) — varchar(20) — 외래 키 → 사용자.USER_ID — NOT NULL
- HIST_ITEM_ID (hist_item_id) — varchar(7) — 외래 키 → 사료.HIST_ITEM_ID — NOT NULL
- LEVEL_CLSS_ID (level_clss_id2) — varchar(7) — 외래 키 → 사료.LEVEL_CLSS_ID — NOT NULL
- REQ_DATE (req_date) — varchar(8)
- REQ_APROV_FLAG (req_aprov_flag) — varchar(1)
- REQ_APROV_REASON (req_aprov_reason) — varchar(500)
- REQ_APROV_PROC_STATUS (req_aprov_proc_status) — varchar(1)
전거 (AUTHORITY)
- AUTH_ID (auth_id) — varchar(7) — 기본 키 — NOT NULL
- LEAD_ID (lead_id) — varchar(7) — 외래 키 → 리드.LEAD_ID — NOT NULL
- HIST_ITEM_ID (hist_item_id) — varchar(7) — 외래 키 → 사료.HIST_ITEM_ID — NOT NULL
- LEVEL_CLSS_ID (level_clss_id) — varchar(7) — 외래 키 → 사료.LEVEL_CLSS_ID — NOT NULL
- AUTH_NAME (auth_name) — varchar(100)
- AUTH_TERM_PERIOD (auth_term_period) — varchar(20)
- AUTH_LOCA (auth_loca) — varchar(500)
- AUTH_LIMIT_LANG (auth_limit_lang) — varchar(100)
- AUTH_PROC_STATUS (auth_proc_status) — char(1)
- AUTH_ADMIN_HIST (auth_admin_hist) — CLOB
- AUTH_ADDR (auth_addr) — varchar(100)
- AUTH_TEL (auth_tel) — varchar(14)
- AUTH_NAT (auth_nat) — varchar(30)
- AUTH_PERIOD (auth_period) — varchar(50)
- AUTH_WORK_PERIOD (auth_work_period) — varchar(50)
- EQUV_SIGN_POST (equv_sign_post) — varchar(100)
- BICHAETAEGEO (gichaetaegeo) — varchar(100)
- HYPERNYM (hypernym) — varchar(100)
- HYPONYM (hyponym) — varchar(100)
- PREV_NAME (prev_name) — varchar(100)
- SUBSEQ_NAME (subseq_name) — varchar(100)
- RELTUM (reltum) — varchar(100)
전시 (EXHIBITION)
- EXHB_ID (exhb_id) — varchar(7) — 기본 키 — NOT NULL
- EXHB_START (exhb_start) — varchar(8)
- EXHB_END (exhb_end) — varchar(8)
- EXHB_CON (exhb_con) — varchar(1000)
- EXHB_REGISTER — varchar(50)
- EXHB_FILE (exhb_file) — varchar(256)
- USER_ID (user_id) — varchar(20) — 외래 키 → 사용자.USER_ID — NOT NULL
주제별분류체계 (SUBCLSS)
- SUB_CLSS_ID (sub_clss_id) — varchar(7) — 기본 키 — NOT NULL
- CLSS_NAME (clss_name) — varchar(100)
- PROC_DEPT_ID (proc_dept_id) — varchar(7)
- REGISTER (register) — varchar(50)
- REG_DATE (reg_date) — varchar(8)
- EDITOR (editor) — varchar(50)
- EDIT_DATE (edit_date) — varchar(8)
- CONTENT (contents) — varchar(500)
- UPPER_CLSS_ID (upper_clss_id) — varchar(7)
- LOWER_CLSS_ID (lower_clss_id) — varchar(7)
- DEPT_ID (dept_id2) — varchar(7) — 외래 키 → 부서.DEPT_ID — NOT NULL