Overview
This reference documents the structure of the SYSNOW data table 9outbu_sysnow_licenses. It is intended to help administrators understand the fields stored by the related application/module. This article describes schema only and does not expose customer or operational record values.
How this table is used
The owning module reads and writes records in this table according to its workflow, permissions, and validation rules. Use the module interface for normal data entry; do not edit production rows directly unless following an approved maintenance procedure.
Field-by-field reference
The following fields were discovered from the database schema. “Significance” is an inferred guide based on the field name and type; verify business rules with the owning module before changing data.
| Field | Data type | Required / key | Significance |
|---|---|---|---|
id |
Number / Boolean bigint unsigned |
Required by schema; key: PRI | Unique identifier used to distinguish this record from other records. |
license_id |
Text / Choice char(32) |
Required by schema; key: UNI | Unique identifier used to distinguish this record from other records. |
activation_code_hash |
Text / Choice char(64) |
Required by schema; key: UNI | Text value used to store this attribute for display, search, or application processing. Confirm the exact business meaning with the owning module. |
activation_token |
Text / Choice longtext |
Optional by schema | Sensitive authentication/security value. Do not expose it in knowledge articles or share it with other users. |
target_type |
Text / Choice varchar(30) |
Required by schema; key: MUL | Classification that determines the record kind or behaviour. |
target_value |
Text / Choice varchar(255) |
Required by schema | Text value used to store this attribute for display, search, or application processing. Confirm the exact business meaning with the owning module. |
target_domain |
Text / Choice varchar(255) |
Required by schema; key: MUL | Text value used to store this attribute for display, search, or application processing. Confirm the exact business meaning with the owning module. |
target_user_email |
Text / Choice varchar(190) |
Required by schema; key: MUL | Email address used for contact, notifications, or account identification. |
client_id |
Number / Boolean bigint unsigned |
Required by schema; key: MUL | Unique identifier used to distinguish this record from other records. |
activation_date |
Date / Time datetime |
Required by schema | Date/time value used to record when an event occurs or a validity period applies. |
duration_value |
Number / Boolean int unsigned |
Required by schema | Numeric value used by the application for counting, ordering, or calculation. |
duration_unit |
Text / Choice varchar(20) |
Required by schema | Text value used to store this attribute for display, search, or application processing. Confirm the exact business meaning with the owning module. |
expires_at |
Date / Time datetime |
Required by schema | Date or time value recording when an event occurs or a period applies. |
license_cost |
Number / Boolean decimal(18,2) |
Required by schema | Financial amount used for tracking or calculating a charge, budget, or cost. |
currency |
Text / Choice varchar(10) |
Required by schema | Text value used to store this attribute for display, search, or application processing. Confirm the exact business meaning with the owning module. |
status |
Text / Choice varchar(30) |
Required by schema; key: MUL | Current state of the record; commonly used to track progress or availability. |
sent_at |
Date / Time datetime |
Optional by schema | Date or time value recording when an event occurs or a period applies. |
sent_to |
Text / Choice varchar(190) |
Required by schema | Text value used to store this attribute for display, search, or application processing. Confirm the exact business meaning with the owning module. |
notes |
Text / Choice text |
Optional by schema | Additional context, observations, or handling details. |
issued_by |
Number / Boolean bigint unsigned |
Required by schema; key: MUL | Numeric value used by the application for counting, ordering, or calculation. |
created_at |
Date / Time datetime |
Required by schema | Timestamp showing when the record was created. |
updated_at |
Date / Time datetime |
Required by schema | Timestamp showing when the record was last updated. |
sys_id |
Text / Choice char(32) |
Optional by schema | Unique identifier used to distinguish this record from other records. |
created_by |
Number / Boolean bigint unsigned |
Required by schema | User or process that originally created the record. |
updated_by |
Number / Boolean bigint unsigned |
Required by schema | User or process that most recently updated the record. |
Access and safety
Restrict schema and database maintenance to authorized administrators. Back up the database before structural changes. Inferred field meanings are guidance, not a substitute for module source code or business-process documentation.