rist

Tables (4)

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

TEST_ASSIGN_EQUIP (Untitled2)

  • ASSIGN_ASSIGN_EQUIP_NO (Key) — NUMBER(9) — Primary key — NOT NULL
  • TEST_MTD_EQUIP_NO (Key2) — NUMBER — Foreign key → TEST_MTD_ASSET_EQUIP.TEST_MTD_EQUIP_NO — NOT NULL
  • TEST_MTD_NO (Key22) — NUMBER(5) — Foreign key → TEST_MTD_ASSET_EQUIP.TEST_MTD_NO — 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 (Key2) — 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