Try_Longview

Tables (12)

Untitled (CMN_LOG)

  • Key (APPLICATION_CD) — Primary key — NOT NULL
  • Field (USER_ID)
  • Field2 (LOG_DIV_CD)
  • Field3 (MENU_ID)
  • Field4 (SERVER_IP)
  • Field (USER_IP)
  • Field2 (MODIFY_ID)
  • Field3 (LOAD_TIME)

Untitled (CMN_MENU_ROLE_MENU_MAPPING)

    Untitled (CMN_SOURCE_USER)

      Untitled (CMN_USER_FAVORITE)

        Untitled (CMN_USER_ROLE_MAPPING)

          Untitled (D_CITY)

            Untitled (CMN_MENU_LEVEL03)

            • Key (LEVEL03_CD) — Primary key — NOT NULL
            • Field3 (LEVEL03_NAME)
            • Field4 (LEVEL03_SEQ)
            • Field (USE_YN)
            • Field2 (MODIFY_ID)
            • Field (LOAD_TIME)
            • Key (LEVEL01_CD) — Foreign key → Untitled4.Key — NOT NULL
            • Key (LEVEL02_CD) — Foreign key → Untitled3.Key — NOT NULL

            Untitled2 (CMN_MENU)

            • Key (MENU_ID) — Primary key — NOT NULL
            • Field (MENU_DIV_CD)
            • Field2 (PROGRAM_ID)
            • Field3 (LEVEL01_CD)
            • Field4 (LEVEL02_CD)
            • Field5 (LEVEL03_CD)
            • Field (LEVEL04_CD)
            • Field2 (MENU_DESC)
            • Field (PERIOD_DIV_CD)
            • Field3 (PERIOD_STD_CD)
            • Field (PDF_YN)
            • Field2 (PPT_YN)
            • Field3 (EXCEL_YN)
            • Field (USE_YN)
            • Field2 (COMPLETE_YN)
            • Field3 (ATTR01)
            • Field (ATTR02)
            • Field (ATTR03)
            • Field2 (MODIFY_ID)
            • Field (LOAD_TIME)

            Untitled2 (CMN_MENU_LEVEL04)

            • Key (LEVEL04_CD) — Primary key — NOT NULL
            • Key (LEVEL01_CD) — Foreign key → Untitled4.Key — NOT NULL
            • Key (LEVEL02_CD) — Foreign key → Untitled3.Key — NOT NULL
            • Key (LEVEL03_CD) — Foreign key → Untitled.Key — NOT NULL
            • Field (LEVEL04_NAME)
            • Field2 (LEVEL04_SEQ)
            • Field3 (USE_YN)
            • Field (MODIFY_ID)
            • Field2 (LOAD_TIME)

            Untitled3 (CMN_MENU_LEVEL02)

            • Key (LEVEL02_CD) — Primary key — NOT NULL
            • Field (LEVEL02_NAME)
            • Field2 (LEVEL02_SEQ)
            • Field3 (USE_YN)
            • Field4 (MODIFY_ID)
            • Field (LOAD_TIME)
            • Key (LEVEL01_CD) — Foreign key → Untitled4.Key — NOT NULL

            Untitled4 (CMN_MENU_LEVEL01)

            • Key (LEVEL01_CD) — Primary key — NOT NULL
            • Field (LEVEL01_NAME)
            • Field2 (LEVEL01_SEQ)
            • Field3 (USE_YN)
            • Field4 (MODIFY_ID)
            • Field5 (LOAD_TIME)

            Untitled5 (CMN_ROLE)

            • Key (ROLE_CD) — Primary key — NOT NULL
            • Field (ROLE_NAME)
            • Field2 (ROLE_DESC)
            • Field3 (ROLE_SEQ)
            • Field (USE_YN)
            • Field2 (MODIFY_ID)
            • Field (LOAD_TIME)