메뉴리스트

테이블 (3)

M_COMPANY_INFO

  • CompanyID — varchar(6) — 외래 키 → M_COMPANY_SCREEN_INFO.CompanyID — NOT NULL
  • Key — 외래 키 → M_COMPANY_SCREEN_INFO.Key — NOT NULL
  • SourcingCompanyID — varchar(6)
  • IssuerCompanyID — varchar(6)
  • CompanyName — varchar(256)
  • CompanyType — varchar(1)
  • SourcingAllowYN — varchar(1)
  • IssuePossibleYN — varchar(1)
  • UseYN — varchar(1)

M_COMPANY_SCREEN_INFO

  • Key — 기본 키 — NOT NULL
  • CompanyID — varchar(6) — 외래 키 → M_SCREEN_INFO.ScreenID — NOT NULL
  • ScreenID
  • UseYN — varchar(1)
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7
  • Field8
  • Field
  • Field2

M_SCREEN_INFO (Untitled2)

  • ScreenID — varchar(6) — 기본 키 — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7
  • Field8