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
device_info
- GAS_SERIAL_NUMBER (Key) — Primary key — NOT NULL
jiro_cusmt
- CSTMR_JIRO_NO (Key) — Primary key — NOT NULL
- GAS_SERIAL_NUMBER (Key2) — Foreign key → device_info.GAS_SERIAL_NUMBER — NOT NULL
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
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