사료관리시스템

테이블 (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