RPA

Tables (5)

CAFE_MENU (카페 메뉴 정보)

  • PLANT (사업장) — char(4) — Primary key — NOT NULL
  • YMD (날짜) — char(8) — Primary key — NOT NULL
  • MEAL_TYPE (조중석야코드) — char(2) — Primary key — NOT NULL
  • CAMPUS (캠퍼스) — char(2) — Primary key — NOT NULL
  • CAFETERIA_SEQ (식당코드) — int — Primary key — NOT NULL
  • COURSE_SEQ (코스코드) — int — Primary key — NOT NULL
  • MENU_NM (메뉴코드) — varchar(100) — Primary key — NOT NULL
  • MEAL_TYPE_NAME (조중석야명) — varchar(4)
  • CAFETERIA_NAME (식당명) — varchar(40)
  • COURSE_NAME (코스명) — varchar(40)
  • SIDE_1 (메뉴 1) — varchar(100)
  • SIDE_2 (메뉴 2) — varchar(100)
  • SIDE_3 (메뉴 3) — varchar(100)
  • SIDE_4 (메뉴 4) — varchar(100)
  • SIDE_5 (메뉴 5) — varchar(100)
  • SIDE_6 (메뉴 6) — varchar(100)
  • KCAL (칼로리) — varchar(100)
  • MENU_ORIGIN — varchar(100) — NOT NULL
  • SP_MENU_SEQ — char(2)
  • SP_MENU_NM — varchar(20)

MEAL_MST (식당코드마스터)

  • PLANT (사업장) — char(4) — Primary key — NOT NULL
  • CAFETERIA_SEQ (식당코드) — char(3) — Primary key — NOT NULL
  • COURSE_SEQ (코스코드) — char(3) — Primary key — NOT NULL
  • READERNUM (리더기코드) — char(3) — Primary key — NOT NULL
  • CAFETERIA_NAME (식당명) — varchar(20)
  • COURSE_NAME (코스명) — varchar(20)
  • PAYCODE (페이코코드) — char(10)

cafe_meal (개인별 식당 이용)

  • PLANT (사업장) — char(4) — Primary key — NOT NULL
  • DTIME (타각시간) — varchar(14) — Primary key — NOT NULL
  • MEAL_TYPE (조중석야구분) — char(2) — Primary key — NOT NULL
  • CAFETERIA_SEQ (식당코드) — char(3) — Primary key — NOT NULL
  • COURSE_SEQ (코스코드) — char(3) — Primary key — NOT NULL
  • READERNUM (리더기번호) — char(3) — Primary key — NOT NULL
  • EMP_ID (사번) — varchar(10) — Primary key — NOT NULL
  • YMD (날짜) — char(8)
  • MEAL_TYPE_NAME (조중석야명) — char(10)
  • CAFETERIA_NAME (식당명) — varchar(20)
  • COURSE_NAME (코스명) — varchar(20)
  • COMP_NAME (회사명) — varchar(40)
  • EMP_NAME (이름) — varchar(50)
  • MS_STAR (만족도) — char(1)
  • SEX (성별) — char(1)
  • AGE (나이) — char(2)
  • JOB_TYP (직군) — varchar(10)
  • CHK_TYP (타각방법) — char(1)
  • TME_TERM (10분단위) — char(4)
  • CANCLE (취소) — char(1)

cafe_meal_sum (식당이용기록요약)

  • PLANT (사업장) — char(4) — Primary key — NOT NULL
  • YMD (날자) — char(8) — Primary key — NOT NULL
  • MEAL_TYPE (조중석야코드) — char(2) — Primary key — NOT NULL
  • CAFETERIA_SEQ (식당코드) — char(3) — Primary key — NOT NULL
  • COURSE_SEQ (코스코드) — char(3) — Primary key — NOT NULL
  • COMPANY (회사명) — char(1) — Primary key — NOT NULL
  • MEAL_TYPE_NAME (조중석야구분명) — char(10)
  • CAFETERIA_NAME (식당명) — varchar(20)
  • COURSE_NAME (코스명) — varchar(20)
  • CNT (건수) — int
  • 만족도합계 — int — NOT NULL
  • 응답자 — int — NOT NULL
  • 평균 — int — NOT NULL

satisfi (만족도)

  • PLANT (사업장) — char(4) — Primary key — NOT NULL
  • ISRT_DT (일자) — datetime — Primary key — NOT NULL
  • MS_DATE (만족도일자) — char(8) — Primary key — NOT NULL
  • MS_TERM_TYPE (메뉴유형) — char(2) — Primary key — NOT NULL
  • CAFETERIA_SEQ (식당) — char(3) — Primary key — NOT NULL
  • MS_USER (사번) — varchar(10) — Primary key — NOT NULL
  • MS_TERM_NAME (메뉴명) — char(10)
  • CAFETERIA_NAME (식당명) — varchar(20)
  • COURSE_SEQ (코스번호) — char(3)
  • COURSE_NAME (코스명) — varchar(20)
  • MS_STAR (만족도) — char(2)