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