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)