zanbanzero
Tables (21)
CaclulateMenu (메뉴 판매량 데이터)
- id (Key) — Long — Primary key — NOT NULL
- calculate_id (Key2) — Foreign key → Calculate.id — NOT NULL
- menu (Field) — String
- count (Field2) — int
Calculate (정산 데이터)
- id (Key) — Long — Primary key — NOT NULL
- date (Field) — LocalDate
Store (식당 정보)
- id (Key) — AUTO-INCREMENT — Primary key — NOT NULL
- name (Field) — VARCHAR
- info (Field2) — VARCHAR
- image (Field3) — VARCHAR
User (일반 사용자)
- id (PK) — AUTO-INCREMENT — Primary key — NOT NULL
- username (Field) — VARCHAR
- password (Field2) — VARCHAR
- roles (Field3) — VARCHAR
- loginDate (Field4) — LocalDate
User (유저 테이블)
- id (Key) — Long — Primary key — NOT NULL
UserMypage (유저 마이페이지)
- id (Key) — Long — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.id — NOT NULL
UserPolicy (유저 정책)
- id (Key) — Long — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.id — NOT NULL
calculate (정산 결과)
- id (PK) — AUTO-INCREMENT — Primary key — NOT NULL
- date (Field2) — VARCHAR
- today (Field) — INT
- sales (Field3) — INT
calculate_pre (식쟤료 소비량 예측 데이터)
- id (PK) — AUTO-INCREMENT — Foreign key → calculate.id — NOT NULL
- predict_user (Field) — INT
- predict_food (Field2) — String
calculate_pre_week (Untitled)
- id (Key) — Long — Primary key — NOT NULL
- date (Field) — LocalDate
- monday (Field2)
- tuesday (Field3)
- wednesday (Field4)
- thursday (Field5)
- friday (Field6)
caluculate_menu (정산 결과-메뉴 정보)
- id (PK) — AUTO-INCREMENT — Primary key — NOT NULL
- calculate_id (FK) — AUTO-INCREMENT — Foreign key → calculate.id — NOT NULL
- menu (Field3) — String
- count (Field) — INT
- sales (Field2) — INT
leftover (잔반 발생량)
- leftover_pre_id (PK) — AUTO-INCREMENT — Foreign key → leftover_pre.calculate_id — NOT NULL
- leftover (Field2) — DOUBLE
leftover_pre (잔반 발생 예측량)
- calculate_id (PK) — AUTO-INCREMENT — Foreign key → calculate.id — NOT NULL
- predict (Field) — DOUBLE
menu (메뉴)
- id (PK) — AUTO-INCREMENT — Primary key — NOT NULL
- menu_food_id (FK) — INT — Foreign key → menu_food.id — NOT NULL
- cost (Field) — INT
- image (Field2) — VARCHAR
- name (Field3) — VARCHAR
- sold (Field4) — BOOLEAN
- use_planner (Field5) — BOOLEAN
menu_food (식재료 정보)
- id (Key) — AUTO-INCREMENT — Primary key — NOT NULL
- name (Field2) — VARCHAR
- food (Field) — VARCHAR
menu_info (메뉴 상세정보)
- menu_id (PK) — AUTO-INCREMENT — Foreign key → menu.id — NOT NULL
- id (Key) — AUTO-INCREMENT — Foreign key → menu.menu_food_id — NOT NULL
- details (Field) — VARCHAR
- info (Field2) — VARCHAR
orders (사용자 개인 예약 정보)
- id (PK) — AUTO-INCREMENT — Primary key — NOT NULL
- user_id (FK) — AUTO-INCREMENT — Foreign key → User.id — NOT NULL
- menu (Field2) — String
- cost (Field) — INT
- order_date (Field3) — VARCHAR
- recognize (Field4) — BOOLEAN
planner (식단표 정보)
- id (PK) — AUTO-INCREMENT — Primary key — NOT NULL
- menu_id (PK2) — AUTO-INCREMENT — Foreign key → menu.id — NOT NULL
- id (Key) — AUTO-INCREMENT — Foreign key → menu.menu_food_id — NOT NULL
- date (Field) — VARCHAR
- menus (Field2) — VARCHAR
store_state (식당 영업일)
- id (PK) — AUTO-INCREMENT — Primary key — NOT NULL
- store_id (FK) — AUTO-INCREMENT — Foreign key → Store.id — NOT NULL
- date (Field) — VARCHAR
- off (Field2) — BOOLEAN
user_mypage (사용자 마이페이지)
- user_id (PK) — AUTO-INCREMENT — Foreign key → User.id — NOT NULL
- coupon (Field) — VARCHAR
- point (Field2) — INT
user_policy (사용자 정책)
- user_id (PK) — AUTO-INCREMENT — Foreign key → User.id — NOT NULL
- default_menu (Field) — BIGINT
- monday (Field2) — BOOLEAN
- tuesday (Field3) — BOOLEAN
- wednesday (Field4) — BOOLEAN
- thursday (Field5) — BOOLEAN
- friday (Field6) — BOOLEAN