Prepare a database table structure for population

You can manually configure a database structure and populate it with NetLogic methods or use methods invoked by an OPC UA client.
  1. In
    Project view
    , select a
    Database
     object.
  2. In
    Properties
    , next to
    Tables
    , select
    Add
    Add
    .
    You added a new database table.
  3. Next to
    Columns
    , create table columns by selecting
    Add
    Add
    .
  4. Next to
    Column#
    , select
    Edit
    Edit
     to change the column name.
  5. If you use an embedded database, set
    Record limit
    .
      • The
        Record limit
         property only takes effect if there is at least one column in the table named
        Timestamp
         or
        Time
         of the DateTime type.
        NOTE: The
        Timestamp
         or
        Time
         columns are automatically added to the table if you use a database to store data from a logger.
      • The minimum
        Record limit
         value is
        1000
        .
      • At the start of the project, any records in excess of the set limit are deleted.
        IMPORTANT: Records are deleted when they exceed a threshold equals to
        0.1%
         of the limit value. For example, if
        Record limit
         is set to
        10000
        , once
        10010
         records are reached, the
        10
         oldest records are automatically deleted.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.