ERP

Tables (22)

cmmcode

  • CODE (Key) — Primary key — NOT NULL

cmmcodm

  • CODE_ID (Key) — Primary key — NOT NULL
  • CODE (Key2) — Foreign key → cmmcode.CODE — NOT NULL

comp_info

    device_info

    • GAS_SERIAL_NUMBER (Key) — Primary key — NOT NULL

    finish_day_info

      jiro_cominfo

        jiro_cusmt

        • CSTMR_JIRO_NO (Key) — Primary key — NOT NULL
        • GAS_SERIAL_NUMBER (Key2) — Foreign key → device_info.GAS_SERIAL_NUMBER — NOT NULL

        menu001

        • (Field)

        menu002

        • PROG_ID (Key) — Primary key — NOT NULL

        menu003

        • MENU_NO (Key) — Primary key — NOT NULL

        menu004

        • PROG_ID (Key3) — Foreign key → menu002.PROG_ID — NOT NULL
        • MENU_NO (Key2) — Foreign key → menu003.MENU_NO — NOT NULL

        menu005

        • USER_GROUP_CODE (Key) — Primary key — NOT NULL
        • MENU_GROUP_CODE (Key2) — Foreign key → menu006.MENU_GROUP_CODE — NOT NULL

        menu006

        • MENU_GROUP_CODE (Key) — Primary key — NOT NULL

        menu007

        • MENU_NO (Key) — Primary key — NOT NULL
        • MENU_GROUP_CODE (Key2) — Foreign key → menu006.MENU_GROUP_CODE — NOT NULL

        mnby_read

        • READ_YM (Key) — Primary key — NOT NULL
        • GAS_SERIAL_NUMBER (Key2) — Foreign key → device_info.GAS_SERIAL_NUMBER — NOT NULL

        unit_info

          user001

          • EMPLOYEE_NO (Key) — Primary key — NOT NULL

          user002

          • AUTHOR_CODE (Key) — Primary key — NOT NULL

          user003

          • GROUP_ID (Key) — Primary key — NOT NULL

          user004

          • DEPT_ID (Key) — Primary key — NOT NULL

          user005

          • USER_GROUP_CODE (Key) — Primary key — NOT NULL

          user006 (Untitled)

          • USER_GROUP_CODE (Key) — Foreign key → user005.USER_GROUP_CODE — NOT NULL
          • EMPLOYEE_NO (Key2) — Foreign key → user001.EMPLOYEE_NO — NOT NULL