ims
Tables (4)
IMS_CD_ITEM
- item_gubun — VARCHAR2(2)
- item_code — VARCHAR2(20) — NOT NULL
- item_type — VARCHAR2(1)
- item_name — VARCHAR2(500) — NOT NULL
- item_ename — VARCHAR2(500)
- item_spec — VARCHAR2(1000)
- item_unit — VARCHAR2(10)
- item_maker — VARCHAR2(200)
- item_lastprice — NUMBER(12,1)
- item_system — VARCHAR2(1)
- item_part — VARCHAR2(200)
- item_group — VARCHAR2(20)
- item_detail — VARCHAR2(3)
- reg_user — VARCHAR2(10)
- reg_date — DATE
- mode_user — VARCHAR2(10)
- mode_date — DATE
IMS_CD_ITEM_EQUIP
- item_code — VARCHAR2(20) — NOT NULL
- item_equip — VARCHAR2(10) — NOT NULL
- reg_user — VARCHAR2(10)
- reg_date — DATE
- mod_user — VARCHAR2(10)
- mod_date — DATE
IMS_CD_ITEM_GROUP
- group_code — VARCHAR2(20) — NOT NULL
- group_pr_code — VARCHAR2(20)
- group_nm — VARCHAR2(20)
- group_desc — VARCHAR2(100)
- group_seq — NUMBER
- use_yn — VARCHAR2(2)
- reg_user — VARCHAR2(10)
- reg_date — DATE
- mod_user — VARCHAR2(10)
- mod_date — DATE
Untitled
- Key — Primary key — NOT NULL
- Key2 — Primary key — NOT NULL
- Field
- Field2
- Field3