Simple database layout is provided below. For more details (data types, fields restrictions and default values) please refer to lms.mysql, lms.pgsql in doc/ directory.
| id - serial number |
| login - login |
| name - first and last name |
| email - user's email address |
| rights - binary access rights |
| hosts - list of hosts allowed to login |
| passwd - password to login |
| lastlogindate - date of last login |
| lastloginip - IP of last login |
| failedlogindate - date of last failed login attempt |
| failedloginip - IP of last failed login attempt |
| deleted - if is deleted boolean (0/1) |
| id - serial number |
| lastname - last/company name |
| name - first name |
| status - customer status (3-connected, 2-awaiting, 1-prospect) |
| email - email address |
| pin - pin number (for authentication) |
| address - street address (street, apartment, flat, etc) |
| zip - zip code |
| city - location (city) |
| ten - tax exempt number |
| ssn - social security number |
| regon - business registration number |
| rbe - register of business entities |
| icn - identity card number |
| info - additional informations |
| notes - notes |
| serviceaddr - correspondence address |
| creationdate - record creation date |
| moddate - record modification date |
| creatorid - serial of LMS user who created this record |
| modid - serial of LMS user last modification this record |
| deleted - if is deleted from database boolean (0/1) |
| message - message to be displayed if warnings enabled |
| id - serial number |
| name - group name |
| description - group description |
| id - serial number |
| customergroupid - group serial number |
| customerid - customer serial number |
| id - serial number |
| userid - user serial number |
| customergroupid - group serial number |
| id - serial number |
| name - network name |
| address - IP address |
| mask - network mask |
| interface - network interface (eg. eth1) |
| gateway - gateway IP address |
| dns - IP address of dns server |
| dns2 - IP address of secondary dns server |
| domain - domain of the network |
| wins - WINS server address |
| dhcpstart - first address of dynamic DHCP range |
| dhcpend - last address of dynamic DHCP range |
| id - serial number |
| name - device name |
| mac - MAC address |
| ipaddr - IP address |
| passwd - computer password for radius/pppoe login |
| ownerid - serial number of the owner ('0' if network device) |
| creationdate - creation timestamp |
| moddate - last modification timestamp |
| creatorid - creator's serial number |
| modid - modifier's serial number |
| netdev - serial number of connected network device |
| linktype - type of connection (0-cable, 1-wireless) |
| access - connected/disconnected (cutoff) (1/0) |
| warning - should be warned with administration message? (1/0) |
| chkmac - enable/disable MAC checking? (1/0) |
| halfduplex - half/full duplex mode (0/1) |
| lastonline - last network activity timestamp |
| info - additional information |
| location - location (address) |
| id - serial number |
| name - name |
| location - physical location |
| description - device summary |
| producer - manufacturer's name |
| model - model number |
| serialnumber - products serial number (not DB identifier) |
| ports - number of connections available |
| id - serial number |
| src - connection's beginning |
| dst- connection's end |
| type - type of connection (0-cable, 1-wireless) |
| id - serial number |
| time - timestamp of operation |
| type - type of operation (1-payment, 0-liability) |
| userid - LMS user id |
| value - amount in dollars |
| taxid - tax rate identifier |
| customerid - customer's serial number ('0' - does not apply) |
| docid - serial number for document (e.g. invoice) related to this operation |
| itemid - document item identifier |
| comment - description of operation |
| id - serial number |
| date - timestamp of operation |
| customer - customer data |
| value - amount |
| taxid - tax rate identifier |
| customerid - customer's serial number |
| description - operation description |
| hash - unique operation identifier |
| closed - yes (1), if operation was moved to cash table |
| id - serial number |
| name - subscription name |
| value - amount |
| taxid - tax rate identifier |
| prodid - product/service classification number |
| uprate - upload warranty |
| upceil - upload boundary |
| downrate - download warranty |
| downceil - download boundary |
| climit - limit of concurrent connections |
| plimit - limit of packets per second |
| dlimit - limit of data per time unit |
| description - description for subscription |
| id - serial number |
| name - liability name/description |
| value - amount |
| taxid - tax rate identifier |
| prodid - product/service classification number |
| id - serial number |
| name - name |
| value - amount |
| creditor - creditor name |
| period - interval of operation: daily/weekly/monthly/quarterly/annually (1/2/3/4/5) |
| at - pay day |
| description - description for payment |
| id - serial number |
| tariffid - subscription serial number |
| liabilityid - liability serial number |
| customerid - customer serial number |
| period - interval of operation: daily/weekly/monthly/quarterly/annually (1/2/3/4/5) |
| at - pay day |
| datefrom - start date for assignment |
| dateto - end date for assignment |
| invoice - invoice writeout? (1 - yes, 0 - no) |
| discount - discount percentage |
| suspended - is this payment suspended? (1 - yes, 0 - no) |
| settlement - do deficient period settlement? (1 - yes, 0 - no) |
| id - serial number |
| assignmentid - financial assignment serial number |
| nodeid - node serial number |
| id - serial number |
| value - tax value |
| taxed - "is taxed" flag |
| label - rate label |
| validfrom - binding period start |
| validto - binding period end |
| id - serial number |
| template - number template (pattern) |
| period - numbering time span: day/week/month/quarter/year |
| doctype - document type |
| isdefault - '1' if this plan is default for respondent doctype, else '0' |
| id - serial number |
| name - registry name |
| description - additional description |
| in_numberplanid - numbering plan identifier for cash-in receipts |
| out_numberplanid - numbering plan identifier for cash-out receipts |
| disabled - summary disabling (0/1) |
| id - serial number |
| regid - registry serial number |
| userid - user serial number |
| rights - (1-read, 2-write, 3-advanced) |
| id - serial number |
| regid - registry serial number |
| userid - user serial number |
| time - entry timestamp |
| value - real cash state value |
| snapshot - cash state value |
| description - additional informations |
| id - serial number |
| number - document number (%N) |
| extnumber - additional (extended) number part (%I) |
| numberplanid - numbering plan identifier |
| type - document type (1 - invoice, 2 - cash receipt) |
| cdate - date of write out |
| paytime - deadline in days |
| paytype - payment method (cash/transfer/etc.) |
| customerid - customer (buyer) serial number |
| userid - user serial number |
| name - name of customer |
| address - address of customer |
| ssn - SSN of customer |
| ten - Tax Exempt Number of customer |
| zip - zip code of customer |
| city - location of customer |
| closed - is document (invoice) closed (accounted)? (0/1) |
| reference - document ID reference |
| reason - e.g. invoice note reason |
| docid - document serial number |
| title - document title |
| fromdate - start of binding period |
| todate - end of binding period |
| filename - document file name |
| contenttype - file type |
| md5sum - file md5 sum |
| description - additional informations |
| docid - invoice serial number |
| itemid - invoice item identifier |
| value - amount |
| discount - discount percentage |
| taxid - tax rate identifier |
| prodid - product/service classification number |
| content - used unit (usually 'pc.') |
| count - unit count |
| description - description for invoice |
| tariffid - subscription serial number |
| docid - receipt serial number |
| itemid - receipt item identifier |
| regid - registry serial number |
| value - amount |
| description - description for receipt item |
| id - serial number |
| customerid - customer serial number |
| uid - messenger user name/identifier |
| type - messenger type (0-gadu-gadu, 1-yahoo, 2-skype) |
| id - serial number |
| customerid - customer serial number |
| phone - phone number |
| name - contact name/description |
| id - serial number |
| ownerid - customer serial number (0 - "system" account) |
| login - login name |
| password - password encrypted with crypt() |
| realname - additional name |
| lastlogin - last login date |
| uid - account system UID (usually ownerid+200) |
| home - account home directory |
| type - account type (binary sum: 1-shell, 2-email, 4-www, 8-ftp) |
| expdate - account expire date |
| domainid - domain serial number |
| createtime - account creation date |
| quota_sh - shell space limits |
| quota_mail - email space limits |
| quota_www - www space limits |
| quota_ftp - ftp space limits |
| quota_sql - sql database space limits |
| id - serial number |
| name - domain name |
| description - comments |
| id - serial number |
| login - account name (without domain) |
| accountid - account serial number |
| nodeid - node serial number |
| dt - timestamp |
| upload - number of bytes sent |
| download - number of bytes received |
| id - serial number |
| name - queue name |
| email - email account for the queue |
| description - main description for the queue |
| id - serial number |
| queueid - queue serial number |
| requestor - reporter name and email |
| customerid - customer serial number (if reported by customer) |
| subject - ticket name) |
| state - status (0-new, 1-open, 2-resolved, 3-dead) |
| cause - request cause (0-unknown, 1-customer, 2-company) |
| owner - LMS user serial number (ticket owner) |
| createtime - timestamp of report |
| id - serial number |
| ticketid - ticket serial number |
| userid - LMS user serial number (if ticket sender) |
| customerid - customer serial number (if ticket sender) |
| mailfrom - sender email |
| subject - message subject |
| messageid - Message-ID message header |
| inreplyto - thread serial number (if threaded) |
| replyto - Reply-To message header |
| headers - all message headers |
| body - content of message body |
| createtime - date of creation/send/delivery |
| messageid - message serial number |
| filename - name of file attachment |
| contenttype - type of file |
| id - serial number |
| ticketid - ticket serial number |
| userid - LMS user serial number |
| body - content of note |
| createtime - date of creation |
| id - serial number |
| queueid - queue serial number |
| userid - LMS user serial number |
| rights - permissions (1-read, 2-write) |
| id - serial number |
| section - config section name |
| var - config variable name |
| value - config variable value |
| description - option description or comment |
| disabled - is option disabled? (0-active, 1-disabled/default) |
| id - identifier |
| title - title |
| description - info |
| note - note |
| date - event date |
| begintime - beginning of event |
| endtime - end of event |
| userid - event creator ID |
| customerid - customer ID |
| private - status (private/public) |
| closed - is event closed? (1-yes/0-no) |
| eventid - event identifier |
| userid - user identifier |
| id - session identifier |
| ctime - create time |
| mtime - last modification time |
| atime - last access time |
| vdata - verification data |
| content - data |
| id - identifier |
| name - host name |
| description - additional informations |
| lastreload - last reload date |
| reload - reload order |
| id - identifier |
| name - instance name |
| hostid - host identifier |
| module - module file path and name |
| crontab - time of reload |
| priority - reload priority |
| description - additional informations |
| disabled - status (enabled/disabled) |
| id - identifier |
| instanceid - instance identifier |
| var - option name |
| value - option value |
| description - additional informations |
| disabled - status (enabled/disabled) |
| keytype - type |
| keyvalue - value |