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