wonikPNE
Tables (73)
auth_deleted_users
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- Email — VARCHAR(255)
- PhoneNumber — VARCHAR(255)
- DeletedAt — DATETIME
- Reason — VARCHAR(255)
- ReregistrationAllowedAt — DATETIME
- CreatedAt — DATETIME
auth_dormant_accounts
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- UserName — VARCHAR(255)
- Email — VARCHAR(255)
- LastLoginAt — DATETIME
- DormantAt — DATETIME
- CreatedAt — DATETIME
auth_email_verification_attempts
- Id — VARCHAR(255)
- Email — VARCHAR(255)
- FailureCount — INT
- IsBlocked — BOOLEAN
- BlockedUntil — DATETIME
- LastFailedAt — DATETIME
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
auth_email_verifications
- Id — VARCHAR(255)
- Email — VARCHAR(255)
- VerificationCode — VARCHAR(255)
- Purpose — INT
- IsVerified — BOOLEAN
- IsLatest — BOOLEAN
- AttemptCount — INT
- RequestedAt — DATETIME
- ExpiresAt — DATETIME
- CreatedAt — DATETIME
- VerifiedAt — DATETIME
- LastAttemptAt — DATETIME
auth_error_simulation_settings
- Id — VARCHAR(255)
- ForceErrorOnLogin — BOOLEAN
- ForceErrorOnSignUp — BOOLEAN
- ForceErrorOnFindId — BOOLEAN
- ForceErrorOnPasswordChange — BOOLEAN
- ForceErrorOnTemporaryPassword — BOOLEAN
- ForceErrorOnPasswordUpdate — BOOLEAN
- ForceErrorOnUserUpdate — BOOLEAN
- ForceErrorOnAccountDeletion — BOOLEAN
- UpdatedBy — VARCHAR(255)
- UpdatedAt — DATETIME
auth_internal_api_keys
- Id — VARCHAR(255)
- Service — VARCHAR(255)
- KeyHash — VARCHAR(255)
- Status — VARCHAR(255)
- Description — VARCHAR(255)
- ExpiresAt — DATETIME
- LastUsedAt — DATETIME
- Scopes — TEXT
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
auth_login_attempts
- Id — VARCHAR(255)
- Email — VARCHAR(255)
- IpAddress — VARCHAR(255)
- Success — BOOLEAN
- FailCount — INT
- FailReason — VARCHAR(255)
- IsBlocked — BOOLEAN
- BlockedUntil — DATETIME
- AttemptedAt — DATETIME
- CreatedAt — DATETIME
auth_logs
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- Type — VARCHAR(255)
- Message — VARCHAR(255)
- IpAddress — VARCHAR(255)
- CreatedAt — DATETIME
auth_phone_verification_attempts
- Id — VARCHAR(255)
- PhoneNumber — VARCHAR(255)
- FailureCount — INT
- IsBlocked — BOOLEAN
- BlockedUntil — DATETIME
- LastFailedAt — DATETIME
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
auth_phone_verifications
- Id — VARCHAR(255)
- PhoneNumber — VARCHAR(255)
- UserId — VARCHAR(255)
- Purpose — INT
- IsVerified — BOOLEAN
- VerificationCode — VARCHAR(255)
- RequestedUserName — VARCHAR(255)
- RequestedPhoneNumber — VARCHAR(255)
- RequestedAt — DATETIME
- UserName — VARCHAR(255)
- Ci — VARCHAR(255)
- RequestedUserCi — VARCHAR(255)
- TxId — VARCHAR(255)
- MTxId — VARCHAR(255)
- IsLatest — BOOLEAN
- ExpiresAt — DATETIME
- CreatedAt — DATETIME
- VerifiedAt — DATETIME
auth_privacy_policies
- Id — VARCHAR(255)
- Version — VARCHAR(255)
- Content — VARCHAR(255)
- IsActive — BOOLEAN
- EffectiveDate — DATETIME
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
auth_refresh_tokens
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- Token — VARCHAR(255)
- ExpiresAt — DATETIME
- Revoked — BOOLEAN
- CreatedAt — DATETIME
- CreatedByIp — VARCHAR(255)
- ReplacedByToken — VARCHAR(255)
- RevokedAt — DATETIME
- RevokedByIp — VARCHAR(255)
- ReasonRevoked — VARCHAR(255)
auth_security_settings
- Id — VARCHAR(255)
- LoginFailLimit — INT
- EmailFailLimit — INT
- BlockDurationMinutes — INT
- BlockDurationHours — INT
- RejoinWaitDays — INT
- TempPasswordExpireHours — INT
- DormantAccountDays — INT
- EmailVerificationExpireMinutes — INT
- PhoneNumberFailLimit — INT
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
auth_temp_password_logs
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- UserEmail — VARCHAR(255)
- IssuedAt — DATETIME
- IsPasswordChanged — BOOLEAN
- PasswordChangedAt — DATETIME
- ChangedAfterLogin — BOOLEAN
- IssuanceMethod — VARCHAR(255)
- IpAddress — VARCHAR(255)
- IsUsedForLogin — BOOLEAN
- FirstLoginAt — DATETIME
- UsedIpAddress — VARCHAR(255)
auth_terms_of_service
- Id — VARCHAR(255)
- Version — VARCHAR(255)
- Content — VARCHAR(255)
- IsActive — BOOLEAN
- EffectiveDate — DATETIME
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
auth_user_sessions
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- SessionToken — VARCHAR(255)
- IpAddress — VARCHAR(255)
- UserAgent — VARCHAR(255)
- IsActive — BOOLEAN
- ExpiresAt — DATETIME
- CreatedAt — DATETIME
- LastAccessedAt — DATETIME
- RevokedAt — DATETIME
- RevokedReason — VARCHAR(255)
auth_users
- Id — VARCHAR(255)
- Email — VARCHAR(255)
- PasswordHash — VARCHAR(255)
- PhoneNumber — VARCHAR(255)
- UserName — VARCHAR(255)
- Ci — VARCHAR(255)
- Role — VARCHAR(255)
- EmailConfirmed — BOOLEAN
- IsDeleted — BOOLEAN
- DeletedAt — DATETIME
- LastLoginAt — DATETIME
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
common_alarm_data
- Id — VARCHAR(255)
- CHANNEL_ID — VARCHAR(255) — Foreign key → common_channel_info.Id
- ALARM_CODE — VARCHAR(255)
- PROCESS_ID — VARCHAR(255)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
common_alarm_definition
- Id — VARCHAR(255)
- ALARM_CODE — VARCHAR(255)
- MESSAGE — VARCHAR(255)
- PRIORITY — INT
- DESCRIPTION — VARCHAR(255)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
common_battery_info
- Id — VARCHAR(255)
- BATTERY_SERIAL_NO — VARCHAR(255)
- USER_ID — VARCHAR(255) — Foreign key
- BATTERY_SPEC — TEXT
- STORAGE_INFO — TEXT
- STATUS — VARCHAR(255)
- LOCATION — VARCHAR(255)
- EQUIPMENT_TYPE — INT
- EQUIPMENT_SPEC — VARCHAR(255)
- CELL_MODEL — VARCHAR(255)
- CELL_INFO — VARCHAR(255)
- TEST_PURPOSE — VARCHAR(255)
- TEST_PLAN — VARCHAR(255)
- INSPECTION_INFO — VARCHAR(255)
- VISUAL_CHECK_RESULT — VARCHAR(255)
- DMM_CHECK_RESULT — VARCHAR(255)
- DMM_MEASURED_VALUE — DOUBLE
- CAPACITY — DOUBLE
- MAX_VOLTAGE — DOUBLE
- MIN_VOLTAGE — DOUBLE
- MAX_CURRENT — DOUBLE
- RECEIVED_AT — DATETIME
- PROCESSING_AT — DATETIME
- STORED_AT — DATETIME
- DISPOSED_AT — DATETIME
- EXPECTED_ARRIVAL_DATE — DATETIME
- EXPECTED_REQUEST_DATE — DATETIME
- DESCRIPTION — VARCHAR(255)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
common_chamber_room_info
- Id — VARCHAR(255)
- ROOM_NUMBER — INT
- CUSTOMER_ID — VARCHAR(255) — Foreign key → common_customer_info.Id
- CHAMBER_ROOM_NM — VARCHAR(255)
- EQUIPMENT_ID — VARCHAR(255) — Foreign key → common_equipment_info.Id
- CHAMBER_MODEL — VARCHAR(255)
- ROOM_CH_COUNT — INT
- CHAMBER_ROOM_PV — DOUBLE
- CHAMBER_ROOM_SP — DOUBLE
- CHAMBER_ROOM_STATUS — INT
- DESCRIPTION — VARCHAR(255)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
common_channel_info
- Id — VARCHAR(255)
- MODULE_NUMBER — INT
- CHANNEL_NUMBER — INT
- EQUIPMENT_ID — VARCHAR(255) — Foreign key → common_equipment_info.Id
- CHAMBER_ROOM_ID — VARCHAR(255) — Foreign key → common_chamber_room_info.Id
- PROCESS_ID — VARCHAR(255)
- CHANNEL_STATUS — INT
- DESCRIPTION — VARCHAR(255)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
common_customer_info
- Id — VARCHAR(255)
- CUSTOMER_NM — VARCHAR(255)
- CUSTOMER_DOMAIN — VARCHAR(255)
- CUSTOMER_CH_COUNT — INT
- CUSTOMER_ROOM_COUNT — INT
- REGISTERED_USER_COUNT — INT
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
common_equipment_info
- Id — VARCHAR(255)
- EQUIPMENT_TYPE — INT
- EQUIPMENT_SPEC — VARCHAR(255)
- EQUIPMENT_STATUS — INT
- SBC_COUNT — INT
- TOTAL_CH_COUNT — INT
- CHAMBER_ROOM_COUNT — INT
- DESCRIPTION — VARCHAR(255)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
common_monitoring_data
- Id — VARCHAR(255)
- CHANNEL_ID — VARCHAR(255) — Foreign key → common_channel_info.Id
- PROCESS_ID — VARCHAR(255)
- STEP_NO — INT
- STEP_TYPE — VARCHAR(255)
- STEP_MODE — VARCHAR(255)
- STEP_STATE — VARCHAR(255)
- INDEX — INT
- CUR_CYCLE_NO — INT
- TOT_CYCLE_NO — INT
- VOLTAGE — DOUBLE
- CURRENT — DOUBLE
- CAPACITY — DOUBLE
- WATT — DOUBLE
- WATT_HOUR — DOUBLE
- IMPEDANCE — DOUBLE
- TEMPERATURE — DOUBLE
- CHAMBER_TEMP — DOUBLE
- STEP_TIME — INT
- TOTAL_TIME — BIGINT
- AVG_VOLTAGE — DOUBLE
- AVG_CURRENT — DOUBLE
- CHARGE_CAP — DOUBLE
- DISCHARGE_CAP — DOUBLE
- CHARGE_WATTHOUR — DOUBLE
- DISCHARGE_WATTHOUR — DOUBLE
- CAPACITY_SUM — DOUBLE
- CHARGE_CAP_SUM — DOUBLE
- DISCHARGE_CAP_SUM — DOUBLE
- TOTAL_CAP_SUM — DOUBLE
- WATTHOUR_SUM — DOUBLE
- CHARGE_WH_SUM — DOUBLE
- DISCHARGE_WH_SUM — DOUBLE
- TOTAL_WH_SUM — DOUBLE
- DATA_SELECT — INT
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
common_process_order_info
- Id — VARCHAR(255)
- PROCESS_ID — VARCHAR(255)
- EQUIPMENT_ID — INT — Foreign key → common_equipment_info.EQUIPMENT_TYPE
- USER_ID — VARCHAR(255) — Foreign key
- RECIPE_ID — INT
- BATTERY_ID — VARCHAR(255)
- PROCESS_NAME — VARCHAR(255)
- DESCRIPTION — VARCHAR(255)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
common_process_result_data
- Id — VARCHAR(255)
- REAL_TIME — DATETIME
- META_DATA — TEXT
- BATTERY_ID — VARCHAR(255)
- EQUIPMENT_ID — INT
- PROCESS_ID — INT
- RECIPE_ID — INT
- USER_ID — VARCHAR(255)
- CH_NO — INT
- STEP_NO — INT
- INDEX — INT
- STEP_TYPE — VARCHAR(255)
- STEP_STATE — VARCHAR(255)
- STEP_MODE — VARCHAR(255)
- CUR_CYCLE_NO — INT
- TOT_CYCLE_NO — INT
- VOLTAGE — DOUBLE
- CURRENT — DOUBLE
- CAPACITY — DOUBLE
- WATT — DOUBLE
- WATT_HOUR — DOUBLE
- STEP_TIME — INT
- TOTAL_TIME — BIGINT
- TEMPERATURE — DOUBLE
- AVG_VOLTAGE — DOUBLE
- AVG_CURRENT — DOUBLE
- CAPACITY_SUM — DOUBLE
- CHARGE_CAP — DOUBLE
- DISCHARGE_CAP — DOUBLE
- WATTHOUR_SUM — DOUBLE
- IMPEDANCE — DOUBLE
- CHARGE_CAP_SUM — DOUBLE
- DISCHARGE_CAP_SUM — DOUBLE
- TOTAL_CAP_SUM — DOUBLE
- CHARGE_WATTHOUR — DOUBLE
- DISCHARGE_WATTHOUR — DOUBLE
- CHARGE_WH_SUM — DOUBLE
- DISCHARGE_WH_SUM — DOUBLE
- TOTAL_WH_SUM — DOUBLE
- CHAMBER_TEMP — DOUBLE
- DATA_SELECT — INT
- CREATED_AT — DATETIME
common_recipe_info
- Id — VARCHAR(255)
- RECIPE_ID — INT
- RECIPE_NAME — VARCHAR(255)
- PROCESS_TYPE — VARCHAR(255)
- DESCRIPTION — VARCHAR(255)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
dashboard_alarm_events
- Id — VARCHAR(255)
- EquipmentSpec — VARCHAR(255)
- AlarmMessage — VARCHAR(255)
- AlarmCode — VARCHAR(255)
- AlarmOccurredAt — DATETIME
- CompanyId — VARCHAR(255)
- ChannelNumber — INT
- RecipeId — INT
- ProcessId — INT
- BatterySerialNo — VARCHAR(255)
- ChamberRoomId — VARCHAR(255)
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
dashboard_cells
- Id — VARCHAR(255)
- SerialNumber — VARCHAR(255)
- Status — VARCHAR(255)
- Voltage — DOUBLE
- Current — DOUBLE
- RequestedByUserId — VARCHAR(255)
- RequestedByEmail — VARCHAR(255)
- ReceivedDate — DATETIME
- DmmResult — BOOLEAN
- DmmVoltage — DOUBLE
- VisualInspectionResult — BOOLEAN
- Capacity — DOUBLE
- UpdatedAt — DATETIME
- CreatedAt — DATETIME
dashboard_current_completed
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- ProcessName — VARCHAR(255)
- BatterySerialNumber — VARCHAR(255)
- Status — INT
- CompletedAt — DATETIME
- TotalProcessTimeSeconds — BIGINT
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
dashboard_equipment_chambers
- Id — VARCHAR(255)
- EQUIPMENT_SPEC — VARCHAR(255)
- EQUIPMENT_TYPE — INT
- CHAMBER_STATUS — INT
- CHAMBER_PV — DOUBLE
- CHAMBER_SP — DOUBLE
- CHAMBER_ID — VARCHAR(255)
- CHAMBER_MODEL — VARCHAR(255)
- CUSTOMER_ID — VARCHAR(255)
- ROOM_NUMBER — INT
- ROOM_CH_COUNT — INT
- DESCRIPTION — VARCHAR(255)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
dashboard_equipment_channels
- Id — VARCHAR(255)
- CHANNEL_ID — VARCHAR(255)
- CHANNEL_STATUS — INT
- CHANNEL_NUMBER — INT
- EQUIPMENT_ID — VARCHAR(255)
- EQUIPMENT_SPEC — VARCHAR(255)
- EQUIPMENT_TYPE — INT
- MODULE_NUMBER — INT
- CHAMBER_ROOM_ID — VARCHAR(255)
- ROOM_NUMBER — INT
- PROCESS_ID — VARCHAR(255)
- PROCESS_NAME — VARCHAR(255)
- BATTERY_SN — VARCHAR(255)
- CELL_TEMPERATURE — DOUBLE
- CUSTOMER_DOMAIN — VARCHAR(255)
- DESCRIPTION — VARCHAR(255)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
dashboard_internal_api_keys
- Id — VARCHAR(255)
- Service — VARCHAR(255)
- KeyHash — VARCHAR(255)
- Status — VARCHAR(255)
- Description — VARCHAR(255)
- ExpiresAt — DATETIME
- LastUsedAt — DATETIME
- Scopes — TEXT
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
dashboard_layout_history
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- UserName — VARCHAR(255)
- UserRole — VARCHAR(255)
- Action — VARCHAR(255)
- Description — VARCHAR(255)
- BeforeData — TEXT
- AfterData — TEXT
- IpAddress — VARCHAR(255)
- UserAgent — VARCHAR(255)
- Timestamp — DATETIME
- CreatedAt — DATETIME
dashboard_layouts
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- Widgets — TEXT
- LastModified — DATETIME
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
dashboard_process_status
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- RunningCount — INT
- PauseCount — INT
- CompletedCount — INT
- TotalCount — INT
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
dashboard_request_progress
- Id — VARCHAR(255)
- ProcessOrderInfoId — VARCHAR(255)
- Status — INT
- ProcessName — VARCHAR(255)
- RecipeName — VARCHAR(255)
- CurrentStepNo — INT
- CurrentStepName — VARCHAR(255)
- StepTimeSeconds — BIGINT
- TotalTimeSeconds — BIGINT
- CurrentCycle — INT
- TotalCycle — INT
- VoltageUV — DOUBLE
- CurrentUA — DOUBLE
- PowerUW — DOUBLE
- CapacityUAh — DOUBLE
- EnergyUWh — DOUBLE
- Temp1Celsius — DOUBLE
- Temp2Celsius — DOUBLE
- Temp3Celsius — DOUBLE
- ChamberTempCelsius — DOUBLE
- BatterySerialNo — VARCHAR(255)
- CompanyId — VARCHAR(255)
- UserId — VARCHAR(255)
- StartedAt — DATETIME
- EndedAt — DATETIME
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
dashboard_running_time_top5
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- TopProcesses — TEXT
- ProcessName — VARCHAR(255)
- TotalTimeSeconds — BIGINT
- Rank — INT
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
dashboard_sync_metadata
- Id — VARCHAR(255)
- JobName — VARCHAR(255)
- LastSyncTime — DATETIME
- LastSyncStatus — INT
- LastSyncCount — INT
- LastErrorMessage — VARCHAR(255)
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
dashboard_user_activities
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- Type — VARCHAR(255)
- Action — VARCHAR(255)
- Message — VARCHAR(255)
- CreatedAt — DATETIME
data_battery_info
- Id — VARCHAR(255)
- BATTERY_SERIAL_NO — VARCHAR(255)
- USER_ID — VARCHAR(255) — Foreign key
- RECEIPT_DATE — VARCHAR(255)
- BATTERY_SPEC — TEXT
- CELL_TYPE — VARCHAR(255)
- NOMINAL_V — DOUBLE
- NOMINAL_C — DOUBLE
- MAX_CHARGE_V — DOUBLE
- CUT_OFF_V — DOUBLE
- CHARGE_I — DOUBLE
- DISCHARGE_I — DOUBLE
- INTERNAL_R — DOUBLE
- CREATED_AT — VARCHAR(255)
data_csv_temps
- Id — VARCHAR(255)
- TOKEN — VARCHAR(255)
- USER_ID — VARCHAR(255) — Foreign key
- FILE_PATH — VARCHAR(255)
- IS_USED — BOOLEAN
- PROCESS_ID — INT
- BATTERY_SERIAL_NO — VARCHAR(255)
- CREATED_AT — DATETIME
data_download_url_limits
- Id — VARCHAR(255)
- URL — VARCHAR(255)
- REMAINING_COUNT — INT
- EXPIRES_AT — DATETIME
- CREATED_AT — DATETIME
data_graph_setting_save
- Id — VARCHAR(255)
- USER_ID — VARCHAR(255) — Foreign key
- TITLE — VARCHAR(255)
- GRAPH_TYPE — VARCHAR(255)
- SELECTED_X_AXIS — VARCHAR(255)
- SELECTED_X_UNIT — VARCHAR(255)
- SELECTED_Y_UNITS — TEXT
- CYCLE_LIST — TEXT
- CHECKED_STEPS — TEXT
- GRAPH_VIEW_TYPE — VARCHAR(255)
- CREATED_AT — DATETIME
data_internal_api_keys
- Id — VARCHAR(255)
- Service — VARCHAR(255)
- KeyHash — VARCHAR(255)
- Status — VARCHAR(255)
- Description — VARCHAR(255)
- ExpiresAt — DATETIME
- LastUsedAt — DATETIME
- Scopes — TEXT
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
data_process_order_info
- Id — VARCHAR(255)
- PROCESS_ID — INT
- EQUIPMENT_ID — INT
- PROCESS_NAME — VARCHAR(255)
- USER_ID — VARCHAR(255) — Foreign key
- RECIPE_ID — INT
- BATTERY_SERIAL_NO — VARCHAR(255)
- DESCRIPTION — VARCHAR(255)
- CRT_DTM — DATETIME
data_process_result_data
- Id — VARCHAR(255)
- REAL_TIME — DATETIME
- META_DATA — TEXT
- RECIPE_ID — INT
- PROCESS_ID — INT
- EQUIPMENT_ID — INT
- USER_ID — VARCHAR(255)
- CH_NO — INT
- STEP_NO — INT
- INDEX — INT
- STEP_TYPE — VARCHAR(255)
- STEP_STATE — VARCHAR(255)
- STEP_MODE — VARCHAR(255)
- CUR_CYCLE_NO — INT
- TOT_CYCLE_NO — INT
- VOLTAGE — DOUBLE
- CURRENT — DOUBLE
- CAPACITY — DOUBLE
- WATT — DOUBLE
- WATT_HOUR — DOUBLE
- STEP_TIME — INT
- TOTAL_TIME — BIGINT
- TEMPERATURE — DOUBLE
- AVG_VOLTAGE — DOUBLE
- AVG_CURRENT — DOUBLE
- CAPACITY_SUM — DOUBLE
- CHARGE_CAP — DOUBLE
- DISCHARGE_CAP — DOUBLE
- WATTHOUR_SUM — DOUBLE
- IMPEDANCE — DOUBLE
- CHARGE_CAP_SUM — DOUBLE
- DISCHARGE_CAP_SUM — DOUBLE
- TOTAL_CAP_SUM — DOUBLE
- CHARGE_WATTHOUR — DOUBLE
- DISCHARGE_WATTHOUR — DOUBLE
- CHARGE_WH_SUM — DOUBLE
- DISCHARGE_WH_SUM — DOUBLE
- TOTAL_WH_SUM — DOUBLE
- CHAMBER_TEMP — DOUBLE
- DATA_SELECT — INT
- CREATED_AT — DATETIME
data_recipe_steps_display
- Id — VARCHAR(255)
- STEP_NO — INT
- STEP_PROC_TYPE — INT
- STEP_TYPE — INT
- STEP_MODE — INT
- V_REF — DOUBLE
- I_REF — DOUBLE
- END_TIME — INT
- END_V — DOUBLE
- END_I — DOUBLE
- END_CAPACITY — DOUBLE
- END_DV — DOUBLE
- END_DI — DOUBLE
- CYCLE_COUNT — INT
- OVER_V — DOUBLE
- LIMIT_V — DOUBLE
- OVER_I — DOUBLE
- LIMIT_I — DOUBLE
- OVER_CAPACITY — DOUBLE
- LIMIT_CAPACITY — DOUBLE
- OVER_IMPEDANCE — DOUBLE
- LIMIT_IMPEDANCE — DOUBLE
- DELTA_TIME — INT
- DELTA_V — DOUBLE
- DELTA_I — DOUBLE
- GRADE — INT
- RECORD_TIME — INT
- RECORD_DELTA_V — DOUBLE
- RECORD_DELTA_I — DOUBLE
- VALUE0 — VARCHAR(255)
- VALUE1 — VARCHAR(255)
- VALUE2 — VARCHAR(255)
- VALUE3 — VARCHAR(255)
- VALUE4 — VARCHAR(255)
- VALUE5 — VARCHAR(255)
- VALUE6 — VARCHAR(255)
- VALUE7 — VARCHAR(255)
- VALUE8 — VARCHAR(255)
- VALUE9 — VARCHAR(255)
- VALUE10 — VARCHAR(255)
- CAP_V_LOW — DOUBLE
- CAP_V_HIGH — DOUBLE
- END_CHECK_V_LOW — DOUBLE
- END_CHECK_V_HIGH — DOUBLE
- END_CHECK_I_LOW — DOUBLE
- END_CHECK_I_HIGH — DOUBLE
data_recipe_versions
- Id — VARCHAR(255)
- RECIPE_ID — INT — Foreign key → data_recipes.RECIPE_ID
- VERSION — INT
- MODIFIED_AT — DATETIME
- MODIFIED_BY — VARCHAR(255)
- DESCRIPTION — VARCHAR(255)
- IS_ACTIVE — BOOLEAN
- RECIPE_DATA — TEXT
data_recipes
- Id — VARCHAR(255)
- RECIPE_ID — INT
- USER_ID — VARCHAR(255) — Foreign key
- RECIPE_NAME — VARCHAR(255)
- DESCRIPTION — VARCHAR(255)
- CREATED_AT — DATETIME
- COMMON_SAFETY — TEXT
- STEPS — TEXT
- VERSION_HISTORY — TEXT
- MAX_VOLTAGE — DOUBLE
- MIN_VOLTAGE — DOUBLE
- MAX_CURRENT — DOUBLE
- MIN_CURRENT — DOUBLE
- MAX_CAPACITY — DOUBLE
- MIN_CAPACITY — DOUBLE
- MAX_TEMPERATURE — DOUBLE
- MIN_TEMPERATURE — DOUBLE
data_system_logs
- Id — VARCHAR(255)
- USER_ID — VARCHAR(255) — Foreign key
- USER_NAME — VARCHAR(255)
- LOG_TYPE — VARCHAR(255)
- MESSAGE — VARCHAR(255)
- EXCEPTION — VARCHAR(255)
- TIMESTAMP — DATETIME
data_system_settings
- Id — VARCHAR(255)
- UserId — VARCHAR(255) — Foreign key
- DataDisplaySettings — TEXT
- NotificationSettings — TEXT
- UnitSettings — TEXT
recipe_battery_info
- Id — VARCHAR(255)
- BATTERY_SERIAL_NO — VARCHAR(255)
- USER_ID — VARCHAR(255)
- RECEIPT_DATE — VARCHAR(255)
- BATTERY_SPEC — TEXT
- CELL_TYPE — VARCHAR(255)
- NOMINAL_V — DOUBLE
- NOMINAL_C — DOUBLE
- MAX_CHARGE_V — DOUBLE
- CUT_OFF_V — DOUBLE
- CHARGE_I — DOUBLE
- DISCHARGE_I — DOUBLE
- INTERNAL_R — DOUBLE
- CREATED_AT — DATETIME
recipe_common_safety_defaults
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- VoltageMin — DOUBLE
- VoltageMax — DOUBLE
- CurrentMin — DOUBLE
- CurrentMax — DOUBLE
- CapacityMin — DOUBLE
- CapacityMax — DOUBLE
- TemperatureMin — DOUBLE
- TemperatureMax — DOUBLE
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
recipe_folders
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- Name — VARCHAR(255)
- Order — DOUBLE
- ParentId — VARCHAR(255)
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
recipe_internal_api_keys
- Id — VARCHAR(255)
- Service — VARCHAR(255)
- KeyHash — VARCHAR(255)
- Status — VARCHAR(255)
- Description — VARCHAR(255)
- ExpiresAt — DATETIME
- LastUsedAt — DATETIME
- Scopes — TEXT
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
recipe_logs
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- Type — VARCHAR(255)
- Message — VARCHAR(255)
- Service — VARCHAR(255)
- Ip — VARCHAR(255)
- Username — VARCHAR(255)
- Metadata — TEXT
- CreatedAt — DATETIME
recipe_mystep_folders
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- Name — VARCHAR(255)
- MyStepCount — INT
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
recipe_mysteps
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- FolderId — VARCHAR(255)
- Name — VARCHAR(255)
- Description — VARCHAR(255)
- Steps — TEXT
- Order — DOUBLE
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
recipe_pattern_folders
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- ParentId — VARCHAR(255)
- Name — VARCHAR(255)
- Order — DOUBLE
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
recipe_patterns
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- FolderId — VARCHAR(255)
- Name — VARCHAR(255)
- Description — VARCHAR(255)
- Metadata — TEXT
- Data — TEXT
- DataValue — TEXT
- TimeValue — TEXT
- StorageType — VARCHAR(255)
- Steps — TEXT
- Order — DOUBLE
- OriginalFileName — VARCHAR(255)
- FileSize — BIGINT
- TotalLines — INT
- HeaderRowIndex — INT
- DataStartRowIndex — INT
- TimeColumn — VARCHAR(255)
- ValueColumn — VARCHAR(255)
- RowIndex — INT
- CycleEndTime — DOUBLE
- MaxCurrentValue — DOUBLE
- GridFsFileId — VARCHAR(255)
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
recipe_process_requests
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- RecipeId — VARCHAR(255)
- RecipeName — VARCHAR(255)
- ProcessName — VARCHAR(255)
- ParallelEnabled — BOOLEAN
- SelectedSerials — TEXT
- ChamberIntegration — BOOLEAN
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
recipe_recipes
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- FolderId — VARCHAR(255)
- Name — VARCHAR(255)
- Description — VARCHAR(255)
- CommonSafety — TEXT
- Steps — TEXT
- Order — DOUBLE
- FunctionSetting — TEXT
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
recipe_reference_voltage_defaults
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- ChargeVoltage — DOUBLE
- DischargeVoltage — DOUBLE
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
recipe_soctracking_folders
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- ParentId — VARCHAR(255)
- Name — VARCHAR(255)
- Order — DOUBLE
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
recipe_soctrackings
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- FolderId — VARCHAR(255)
- Name — VARCHAR(255)
- Description — VARCHAR(255)
- Rows — INT
- Cols — INT
- OptionVoltage — BOOLEAN
- OptionCRate — BOOLEAN
- Units — TEXT
- RowHeaders — TEXT
- ColHeaders — TEXT
- Cells — TEXT
- Cells1d — TEXT
- FilledCount — INT
- SourceFileId — VARCHAR(255)
- Row — VARCHAR(255)
- Col — VARCHAR(255)
- Cell — VARCHAR(255)
- Order — DOUBLE
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
recipe_step_common_safety_defaults
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- MinVoltage — DOUBLE
- MaxVoltage — DOUBLE
- MinCurrent — DOUBLE
- MaxCurrent — DOUBLE
- MinCapacity — DOUBLE
- MaxCapacity — DOUBLE
- MinTemperature — DOUBLE
- MaxTemperature — DOUBLE
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
recipe_step_safety_defaults
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- MinVoltage — DOUBLE
- MaxVoltage — DOUBLE
- MinCurrent — DOUBLE
- MaxCurrent — DOUBLE
- MinCapacity — DOUBLE
- MaxCapacity — DOUBLE
- MinTemperature — DOUBLE
- MaxTemperature — DOUBLE
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
recipe_system_settings
- Id — VARCHAR(255)
- MaxCRate — DOUBLE
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
recipe_temp_pattern_folders
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- Name — VARCHAR(255)
- Order — DOUBLE
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
recipe_temp_patterns
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- FolderId — VARCHAR(255)
- Name — VARCHAR(255)
- Steps — TEXT
- Order — DOUBLE
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
recipe_user_unit_settings
- Id — VARCHAR(255)
- UserId — VARCHAR(255)
- VoltageUnit — VARCHAR(255)
- VoltageDecimal — INT
- CurrentUnit — VARCHAR(255)
- CurrentDecimal — INT
- CapacityUnit — VARCHAR(255)
- CapacityDecimal — INT
- PowerUnit — VARCHAR(255)
- PowerDecimal — INT
- EnergyUnit — VARCHAR(255)
- EnergyDecimal — INT
- TemperatureUnit — VARCHAR(255)
- TemperatureDecimal — INT
- CreatedAt — DATETIME
- UpdatedAt — DATETIME