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 — =