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 — varchar(100)
  • SIDE_2 — varchar(100)
  • SIDE_3 — varchar(100)
  • SIDE_4 — varchar(100)
  • SIDE_5 — varchar(100)
  • SIDE_6 — varchar(100)
  • KCAL — varchar(100)
  • MENU_ORIGIN — varchar(100) — NOT NULL
  • SP_MENU_SEQ — char(2)
  • SP_MENU_NM — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

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)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

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 — char(4)
  • CANCLE — char(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

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
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

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)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =