rist - 2025-04-08 02:07:53
Tables (7)
ASSET_EQUIPMENT (Untitled)
- ASSET_ID (Key) — NUMBER — Primary key — NOT NULL
- ASSET_NUMBER (Field) — VARCHAR2
- CATEGORY_1 (Field2) — VARCHAR2
- CATEGORY_2 (Field3) — VARCHAR2
- CATEGORY_3 (Field4) — VARCHAR2
- CATEGORY_4 (Field5) — VARCHAR2
- CATEGORY_DESC (Field6) — VARCHAR2
- CREATE_DATE (Field7) — DATE
- CREATER_NO (Field8) — NUMBER(5)
- DEPT_CODE (Field9) — VARCHAR2
- DEPT_NAME (Field10) — VARCHAR2
- DISPOSAL_DATE (Field11) — DATE
- EMPLOYEE_NO (Field12) — VARCHAR2
- EQUIP_NAME (Field13) — VARCHAR2
- EQUIP_NO (Field14) — NUMBER(9)
- EQUIP_SPEC (Field15) — VARCHAR2
- MANUFACTURER_NAME (Field16) — VARCHAR2
- MODEL_NAME (Field17) — VARCHAR2
- OLD_ASSET_NUM (Field18) — VARCHAR2
- ORIGINAL_COST (Field19) — NUMBER
- RET_TYPE_CODE (Field20) — VARCHAR2
- SERVICE_DATE (Field21) — DATE
- SYNC_DATE (Field22) — DATE
- USER_NAME (Field23) — VARCHAR2
SP_LIMSIF_GET_ASSET_BOOK_V (ASSET_EQUIPMENT)
TEST_ASSIGN_EQUIP (Untitled2)
- ASSIGN_ASSIGN_EQUIP_NO (Key) — NUMBER(9) — Primary key — NOT NULL
- TEST_MTD_EQUIP_NO (Key3) — NUMBER — Foreign key → TEST_MTD_ASSET_EQUIP.TEST_MTD_EQUIP_NO — NOT NULL
- TEST_MTD_NO (Key23) — NUMBER(5) — Foreign key — NOT NULL
- TEST_ASSIGN_NO (Field) — NUMBER(9)
- TEST_COUNT (Field2) — NUMBER(9)
- TEST_MTD_RESULT_NO (Field4) — NUMBER(9)
- TEST_OPER_TIME (Field5) — NUMBER
TEST_MTD (Untitled4)
- TEST_MTD_NO (Key) — NUMBER(5) — Primary key — NOT NULL
- Field
TEST_MTD_ASSET_EQUIP (Untitled3)
- TEST_MTD_EQUIP_NO (Key) — NUMBER — Primary key — NOT NULL
- TEST_MTD_NO (Key4) — NUMBER(5) — Foreign key → TEST_MTD.TEST_MTD_NO — NOT NULL
- OPER_TIME (Field2) — NUMBER
- USE_FLAG (Field3) — CHAR(1)
- UPDATER_NO (Field4) — NUMBER(5)
- UPDATE_DATE (Field5) — DATE
- UI_INDEX (Field6) — NUMBER
- SORT_ORDER (Field7) — NUMBER
- MEMO (Field8) — VARCHAR2(500)
- EQUIP_NO (Field9) — NUMBER(9)
- CREATEER_NO (Field10) — NUMBER(5)
- CREATE_DATE (Field11) — DATE
TEST_MTD_RESULT (CopyOfUntitled4)
- TEST_MTD_RESULT_NO (Key) — NUMBER(5) — Primary key — NOT NULL
V_ASSET_TEST_MTD_RESULT (TEST_MTD_RESULT)