solproject

Tables (23)

ADMIN

  • ADMIN_ID — BIGINT
  • USERNAME — VARCHAR(50) — NOT NULL
  • PASSWORD — VARCHAR(255) — NOT NULL

ALERT_LOG

  • ALERT_ID — BIGINT
  • STORE_ID — BIGINT — Foreign key → STORE.STORE_ID — NOT NULL
  • ALERT_TYPE — VARCHAR(50) — NOT NULL
  • SEVERITY — VARCHAR(20) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL

ATTENDANCE_LOG

  • LOG_ID — BIGINT
  • USER_ID — BIGINT — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
  • STORE_ID — BIGINT — Foreign key → STORE.STORE_ID — NOT NULL
  • RECORD_TYPE — VARCHAR(10) — NOT NULL
  • RECORD_TIME — TIMESTAMP — NOT NULL
  • CLIENT_IP — VARCHAR(45) — NOT NULL

AUDIT_LOG

  • AUDIT_ID — BIGINT
  • USER_ID — BIGINT — Foreign key → EMPLOYEE.EMPLOYEE_ID
  • ACTION_TYPE — VARCHAR(50) — NOT NULL
  • TARGET_TABLE — VARCHAR(50) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL

COMPETITOR_PRICE

  • COMPETITOR_ID — BIGINT
  • STORE_ID — BIGINT — Foreign key → STORE.STORE_ID — NOT NULL
  • MENU_NAME — VARCHAR(100) — NOT NULL
  • PRICE — DECIMAL(10,2) — NOT NULL
  • OBSERVATION_DATE — DATE — NOT NULL

DEMAND_FORECAST

  • FORECAST_ID — BIGINT
  • STORE_ID — BIGINT — Foreign key → STORE.STORE_ID — NOT NULL
  • FORECAST_DATE — DATE — NOT NULL
  • PREDICTED_SALES_MAX — DECIMAL(10,2) — NOT NULL
  • PREDICTED_VISITORS — INT — NOT NULL

EMPLOYEE

  • EMPLOYEE_ID — BIGINT
  • NAME — VARCHAR(50) — NOT NULL
  • EMAIL — VARCHAR(100) — NOT NULL
  • PHONE — VARCHAR(20) — NOT NULL
  • PROVIDER — VARCHAR(20) — NOT NULL
  • PROVIDER_ID — VARCHAR(100) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL

EXCHANGE_RULE

  • RULE_ID — BIGINT
  • STORE_ID — BIGINT — Foreign key → STORE.STORE_ID — NOT NULL
  • BASE_UNIT — VARCHAR(10) — NOT NULL
  • FACTOR — DECIMAL(10,5) — NOT NULL

INVENTORY

  • ITEM_ID — BIGINT
  • STORE_ID — BIGINT — Foreign key → STORE.STORE_ID — NOT NULL
  • ITEM_NAME — VARCHAR(100) — NOT NULL
  • STOCK_QTY — DECIMAL(10,3) — NOT NULL
  • SAFETY_QTY — DECIMAL(10,3) — NOT NULL
  • EXPIRY_DATE — DATE

MENU_ITEM

  • MENU_ID — BIGINT
  • STORE_ID — BIGINT — Foreign key → STORE.STORE_ID — NOT NULL
  • MENU_NAME — VARCHAR(100) — NOT NULL
  • PRICE — DECIMAL(10,2) — NOT NULL
  • CALCULATED_COST — DECIMAL(10,2) — NOT NULL

ONBOARDING_DATA

  • ONBOARDING_ID — BIGINT
  • USER_ID — BIGINT — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
  • DATA_TYPE — VARCHAR(50) — NOT NULL
  • RAW_JSON_DATA — VARCHAR(4000) — NOT NULL
  • UPLOAD_TIME — TIMESTAMP — NOT NULL

OWNER

  • OWNER_ID — BIGINT
  • USERNAME — VARCHAR(50) — NOT NULL
  • PASSWORD — VARCHAR(255) — NOT NULL
  • NAME — VARCHAR(50) — NOT NULL
  • EMAIL — VARCHAR(100) — NOT NULL
  • PHONE — VARCHAR(20) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL

OWNER_DETAIL

  • DETAIL_ID — BIGINT
  • OWNER_ID — BIGINT — Foreign key → OWNER.OWNER_ID — NOT NULL
  • BIZ_NUM — VARCHAR(10) — NOT NULL

PAYROLL_SETTING

  • SETTING_ID — BIGINT
  • USER_ID — BIGINT — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
  • STORE_ID — BIGINT — Foreign key → STORE.STORE_ID — NOT NULL
  • WAGE_TYPE — VARCHAR(20) — NOT NULL
  • BASE_WAGE — DECIMAL(10,2) — NOT NULL
  • DEDUCTION_ITEMS — VARCHAR(4000)

PURCHASE_HISTORY

  • PURCHASE_ID — BIGINT
  • STORE_ID — BIGINT — Foreign key → STORE.STORE_ID — NOT NULL
  • ITEM_NAME — VARCHAR(100) — NOT NULL
  • UNIT_PRICE — DECIMAL(10,2) — NOT NULL
  • PURCHASE_DATE — DATE — NOT NULL

RECIPE_INGREDIENT

  • RECIPE_ID — BIGINT
  • MENU_ID — BIGINT — Foreign key → MENU_ITEM.MENU_ID — NOT NULL
  • ITEM_ID — BIGINT — Foreign key → INVENTORY.ITEM_ID — NOT NULL
  • CONSUMPTION_QTY — DECIMAL(10,3) — NOT NULL

SALES_TRANSACTION

  • TRANSACTION_ID — BIGINT
  • IDEMPOTENCY_KEY — VARCHAR(100)
  • STORE_ID — BIGINT — Foreign key → STORE.STORE_ID — NOT NULL
  • MENU_ID — BIGINT — Foreign key → MENU_ITEM.MENU_ID — NOT NULL
  • TRANSACTION_TIME — TIMESTAMP — NOT NULL
  • SALES_AMOUNT — DECIMAL(10,2) — NOT NULL

SESSION_LOG

  • SESSION_ID — BIGINT
  • USER_ID — BIGINT — Foreign key → OWNER.OWNER_ID — NOT NULL
  • LOGIN_TIME — TIMESTAMP — NOT NULL
  • REFRESH_TOKEN — VARCHAR(255) — NOT NULL

STAFF_ASSIGNMENT

  • ASSIGNMENT_ID — BIGINT
  • EMPLOYEE_ID — BIGINT — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
  • STORE_ID — BIGINT — Foreign key → STORE.STORE_ID — NOT NULL
  • ROLE — VARCHAR(50) — NOT NULL
  • STATUS — VARCHAR(20) — NOT NULL

STORE

  • STORE_ID — BIGINT
  • OWNER_ID — BIGINT — Foreign key → OWNER.OWNER_ID — NOT NULL
  • STORE_NAME — VARCHAR(100) — NOT NULL
  • INDUSTRY — VARCHAR(50) — NOT NULL
  • POS_VENDOR — VARCHAR(50)

SUBSCRIPTION

  • SUB_ID — BIGINT
  • SUB_NAME — VARCHAR(100) — NOT NULL
  • MONTHLY_PRICE — DECIMAL(10,2) — NOT NULL
  • IS_ACTIVE — BOOLEAN — NOT NULL

USER_DOCUMENT

  • DOCUMENT_ID — BIGINT
  • USER_ID — BIGINT — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
  • STORE_ID — BIGINT — Foreign key → STORE.STORE_ID — NOT NULL
  • DOC_TYPE — VARCHAR(50) — NOT NULL
  • FILE_PATH — VARCHAR(255) — NOT NULL
  • RETENTION_END_DATE — DATE — NOT NULL

USER_SUBSCRIPTION

  • USER_SUB_ID — BIGINT
  • USER_ID — BIGINT — Foreign key → OWNER.OWNER_ID — NOT NULL
  • SUB_ID — BIGINT — Foreign key → SUBSCRIPTION.SUB_ID — NOT NULL
  • START_DATE — DATE — NOT NULL
  • EXPIRY_DATE — DATE — NOT NULL