# LRS43 Database Schema Documentation

Generated: 2025-11-12T10:03:51.318411

Total Tables: 169

---

## Schema: LRSAdmin

### JBPM_ACTION

**Full Name:** `LRSAdmin.JBPM_ACTION`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `class` | char(1) | ✗ |  |
| `NAME_` | nvarchar(255) | ✓ |  |
| `ISPROPAGATIONALLOWED_` | tinyint | ✓ |  |
| `ACTIONEXPRESSION_` | nvarchar(255) | ✓ |  |
| `ISASYNC_` | tinyint | ✓ |  |
| `REFERENCEDACTION_` | numeric | ✓ |  |
| `ACTIONDELEGATION_` | numeric | ✓ |  |
| `EVENT_` | numeric | ✓ |  |
| `PROCESSDEFINITION_` | numeric | ✓ |  |
| `TIMERNAME_` | nvarchar(255) | ✓ |  |
| `DUEDATE_` | nvarchar(255) | ✓ |  |
| `REPEAT_` | nvarchar(255) | ✓ |  |
| `TRANSITIONNAME_` | nvarchar(255) | ✓ |  |
| `TIMERACTION_` | numeric | ✓ |  |
| `EXPRESSION_` | nvarchar(-1) | ✓ |  |
| `EVENTINDEX_` | int | ✓ |  |
| `EXCEPTIONHANDLER_` | numeric | ✓ |  |
| `EXCEPTIONHANDLERINDEX_` | int | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `REFERENCEDACTION_` | `LRSAdmin.JBPM_ACTION.ID_` |
| `TIMERACTION_` | `LRSAdmin.JBPM_ACTION.ID_` |
| `PROCESSDEFINITION_` | `LRSAdmin.JBPM_PROCESSDEFINITION.ID_` |
| `EVENT_` | `LRSAdmin.JBPM_EVENT.ID_` |
| `ACTIONDELEGATION_` | `LRSAdmin.JBPM_DELEGATION.ID_` |
| `EXCEPTIONHANDLER_` | `LRSAdmin.JBPM_EXCEPTIONHANDLER.ID_` |

---

### JBPM_BYTEARRAY

**Full Name:** `LRSAdmin.JBPM_BYTEARRAY`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `NAME_` | nvarchar(255) | ✓ |  |
| `FILEDEFINITION_` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `FILEDEFINITION_` | `LRSAdmin.JBPM_MODULEDEFINITION.ID_` |

---

### JBPM_BYTEBLOCK

**Full Name:** `LRSAdmin.JBPM_BYTEBLOCK`  
**Type:** BASE TABLE

**Primary Keys:** `PROCESSFILE_`, `INDEX_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `PROCESSFILE_` | numeric | ✗ |  |
| `BYTES_` | varbinary(1024) | ✓ |  |
| `INDEX_` | int | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `PROCESSFILE_` | `LRSAdmin.JBPM_BYTEARRAY.ID_` |

---

### JBPM_COMMENT

**Full Name:** `LRSAdmin.JBPM_COMMENT`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `VERSION_` | int | ✗ |  |
| `ACTORID_` | nvarchar(255) | ✓ |  |
| `TIME_` | datetime | ✓ |  |
| `MESSAGE_` | nvarchar(-1) | ✓ |  |
| `TOKEN_` | numeric | ✓ |  |
| `TASKINSTANCE_` | numeric | ✓ |  |
| `TOKENINDEX_` | int | ✓ |  |
| `TASKINSTANCEINDEX_` | int | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `TOKEN_` | `LRSAdmin.JBPM_TOKEN.ID_` |
| `TASKINSTANCE_` | `LRSAdmin.JBPM_TASKINSTANCE.ID_` |

---

### JBPM_DECISIONCONDITIONS

**Full Name:** `LRSAdmin.JBPM_DECISIONCONDITIONS`  
**Type:** BASE TABLE

**Primary Keys:** `DECISION_`, `INDEX_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `DECISION_` | numeric | ✗ |  |
| `TRANSITIONNAME_` | nvarchar(255) | ✓ |  |
| `EXPRESSION_` | nvarchar(255) | ✓ |  |
| `INDEX_` | int | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `DECISION_` | `LRSAdmin.JBPM_NODE.ID_` |

---

### JBPM_DELEGATION

**Full Name:** `LRSAdmin.JBPM_DELEGATION`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `CLASSNAME_` | nvarchar(-1) | ✓ |  |
| `CONFIGURATION_` | nvarchar(-1) | ✓ |  |
| `CONFIGTYPE_` | nvarchar(255) | ✓ |  |
| `PROCESSDEFINITION_` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `PROCESSDEFINITION_` | `LRSAdmin.JBPM_PROCESSDEFINITION.ID_` |

---

### JBPM_EVENT

**Full Name:** `LRSAdmin.JBPM_EVENT`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `EVENTTYPE_` | nvarchar(255) | ✓ |  |
| `TYPE_` | char(1) | ✓ |  |
| `GRAPHELEMENT_` | numeric | ✓ |  |
| `PROCESSDEFINITION_` | numeric | ✓ |  |
| `NODE_` | numeric | ✓ |  |
| `TRANSITION_` | numeric | ✓ |  |
| `TASK_` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `PROCESSDEFINITION_` | `LRSAdmin.JBPM_PROCESSDEFINITION.ID_` |
| `TRANSITION_` | `LRSAdmin.JBPM_TRANSITION.ID_` |
| `NODE_` | `LRSAdmin.JBPM_NODE.ID_` |
| `TASK_` | `LRSAdmin.JBPM_TASK.ID_` |

---

### JBPM_EXCEPTIONHANDLER

**Full Name:** `LRSAdmin.JBPM_EXCEPTIONHANDLER`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `EXCEPTIONCLASSNAME_` | nvarchar(-1) | ✓ |  |
| `TYPE_` | char(1) | ✓ |  |
| `GRAPHELEMENT_` | numeric | ✓ |  |
| `PROCESSDEFINITION_` | numeric | ✓ |  |
| `GRAPHELEMENTINDEX_` | int | ✓ |  |
| `NODE_` | numeric | ✓ |  |
| `TRANSITION_` | numeric | ✓ |  |
| `TASK_` | numeric | ✓ |  |

---

### JBPM_JOB

**Full Name:** `LRSAdmin.JBPM_JOB`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `CLASS_` | char(1) | ✗ |  |
| `VERSION_` | int | ✗ |  |
| `DUEDATE_` | datetime | ✓ |  |
| `PROCESSINSTANCE_` | numeric | ✓ |  |
| `TOKEN_` | numeric | ✓ |  |
| `TASKINSTANCE_` | numeric | ✓ |  |
| `ISSUSPENDED_` | tinyint | ✓ |  |
| `ISEXCLUSIVE_` | tinyint | ✓ |  |
| `LOCKOWNER_` | nvarchar(255) | ✓ |  |
| `LOCKTIME_` | datetime | ✓ |  |
| `EXCEPTION_` | nvarchar(-1) | ✓ |  |
| `RETRIES_` | int | ✓ |  |
| `NAME_` | nvarchar(255) | ✓ |  |
| `REPEAT_` | nvarchar(255) | ✓ |  |
| `TRANSITIONNAME_` | nvarchar(255) | ✓ |  |
| `ACTION_` | numeric | ✓ |  |
| `GRAPHELEMENTTYPE_` | nvarchar(255) | ✓ |  |
| `GRAPHELEMENT_` | numeric | ✓ |  |
| `NODE_` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `PROCESSINSTANCE_` | `LRSAdmin.JBPM_PROCESSINSTANCE.ID_` |
| `ACTION_` | `LRSAdmin.JBPM_ACTION.ID_` |
| `TOKEN_` | `LRSAdmin.JBPM_TOKEN.ID_` |
| `NODE_` | `LRSAdmin.JBPM_NODE.ID_` |
| `TASKINSTANCE_` | `LRSAdmin.JBPM_TASKINSTANCE.ID_` |

---

### JBPM_LOG

**Full Name:** `LRSAdmin.JBPM_LOG`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `CLASS_` | char(1) | ✗ |  |
| `INDEX_` | int | ✓ |  |
| `DATE_` | datetime | ✓ |  |
| `TOKEN_` | numeric | ✓ |  |
| `PARENT_` | numeric | ✓ |  |
| `MESSAGE_` | nvarchar(-1) | ✓ |  |
| `EXCEPTION_` | nvarchar(-1) | ✓ |  |
| `ACTION_` | numeric | ✓ |  |
| `NODE_` | numeric | ✓ |  |
| `ENTER_` | datetime | ✓ |  |
| `LEAVE_` | datetime | ✓ |  |
| `DURATION_` | numeric | ✓ |  |
| `NEWLONGVALUE_` | numeric | ✓ |  |
| `TRANSITION_` | numeric | ✓ |  |
| `CHILD_` | numeric | ✓ |  |
| `SOURCENODE_` | numeric | ✓ |  |
| `DESTINATIONNODE_` | numeric | ✓ |  |
| `VARIABLEINSTANCE_` | numeric | ✓ |  |
| `OLDBYTEARRAY_` | numeric | ✓ |  |
| `NEWBYTEARRAY_` | numeric | ✓ |  |
| `OLDDATEVALUE_` | datetime | ✓ |  |
| `NEWDATEVALUE_` | datetime | ✓ |  |
| `OLDDOUBLEVALUE_` | float | ✓ |  |
| `NEWDOUBLEVALUE_` | float | ✓ |  |
| `OLDLONGIDCLASS_` | nvarchar(255) | ✓ |  |
| `OLDLONGIDVALUE_` | numeric | ✓ |  |
| `NEWLONGIDCLASS_` | nvarchar(255) | ✓ |  |
| `NEWLONGIDVALUE_` | numeric | ✓ |  |
| `OLDSTRINGIDCLASS_` | nvarchar(255) | ✓ |  |
| `OLDSTRINGIDVALUE_` | nvarchar(255) | ✓ |  |
| `NEWSTRINGIDCLASS_` | nvarchar(255) | ✓ |  |
| `NEWSTRINGIDVALUE_` | nvarchar(255) | ✓ |  |
| `OLDLONGVALUE_` | numeric | ✓ |  |
| `OLDSTRINGVALUE_` | nvarchar(-1) | ✓ |  |
| `NEWSTRINGVALUE_` | nvarchar(-1) | ✓ |  |
| `TASKINSTANCE_` | numeric | ✓ |  |
| `TASKACTORID_` | nvarchar(255) | ✓ |  |
| `TASKOLDACTORID_` | nvarchar(255) | ✓ |  |
| `SWIMLANEINSTANCE_` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `SOURCENODE_` | `LRSAdmin.JBPM_NODE.ID_` |
| `DESTINATIONNODE_` | `LRSAdmin.JBPM_NODE.ID_` |
| `TOKEN_` | `LRSAdmin.JBPM_TOKEN.ID_` |
| `TRANSITION_` | `LRSAdmin.JBPM_TRANSITION.ID_` |
| `TASKINSTANCE_` | `LRSAdmin.JBPM_TASKINSTANCE.ID_` |
| `CHILD_` | `LRSAdmin.JBPM_TOKEN.ID_` |
| `OLDBYTEARRAY_` | `LRSAdmin.JBPM_BYTEARRAY.ID_` |
| `SWIMLANEINSTANCE_` | `LRSAdmin.JBPM_SWIMLANEINSTANCE.ID_` |
| `NEWBYTEARRAY_` | `LRSAdmin.JBPM_BYTEARRAY.ID_` |
| `ACTION_` | `LRSAdmin.JBPM_ACTION.ID_` |
| `VARIABLEINSTANCE_` | `LRSAdmin.JBPM_VARIABLEINSTANCE.ID_` |
| `NODE_` | `LRSAdmin.JBPM_NODE.ID_` |
| `PARENT_` | `LRSAdmin.JBPM_LOG.ID_` |

---

### JBPM_MODULEDEFINITION

**Full Name:** `LRSAdmin.JBPM_MODULEDEFINITION`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `CLASS_` | char(1) | ✗ |  |
| `NAME_` | nvarchar(255) | ✓ |  |
| `PROCESSDEFINITION_` | numeric | ✓ |  |
| `STARTTASK_` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `STARTTASK_` | `LRSAdmin.JBPM_TASK.ID_` |
| `PROCESSDEFINITION_` | `LRSAdmin.JBPM_PROCESSDEFINITION.ID_` |

---

### JBPM_MODULEINSTANCE

**Full Name:** `LRSAdmin.JBPM_MODULEINSTANCE`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `CLASS_` | char(1) | ✗ |  |
| `VERSION_` | int | ✗ |  |
| `PROCESSINSTANCE_` | numeric | ✓ |  |
| `TASKMGMTDEFINITION_` | numeric | ✓ |  |
| `NAME_` | nvarchar(255) | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `PROCESSINSTANCE_` | `LRSAdmin.JBPM_PROCESSINSTANCE.ID_` |
| `TASKMGMTDEFINITION_` | `LRSAdmin.JBPM_MODULEDEFINITION.ID_` |

---

### JBPM_NODE

**Full Name:** `LRSAdmin.JBPM_NODE`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `CLASS_` | char(1) | ✗ |  |
| `NAME_` | nvarchar(255) | ✓ |  |
| `DESCRIPTION_` | nvarchar(-1) | ✓ |  |
| `PROCESSDEFINITION_` | numeric | ✓ |  |
| `ISASYNC_` | tinyint | ✓ |  |
| `ISASYNCEXCL_` | tinyint | ✓ |  |
| `ACTION_` | numeric | ✓ |  |
| `SUPERSTATE_` | numeric | ✓ |  |
| `SUBPROCNAME_` | nvarchar(255) | ✓ |  |
| `SUBPROCESSDEFINITION_` | numeric | ✓ |  |
| `DECISIONEXPRESSION_` | nvarchar(255) | ✓ |  |
| `DECISIONDELEGATION` | numeric | ✓ |  |
| `SCRIPT_` | numeric | ✓ |  |
| `PARENTLOCKMODE_` | nvarchar(255) | ✓ |  |
| `SIGNAL_` | int | ✓ |  |
| `CREATETASKS_` | tinyint | ✓ |  |
| `ENDTASKS_` | tinyint | ✓ |  |
| `NODECOLLECTIONINDEX_` | int | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `DECISIONDELEGATION` | `LRSAdmin.JBPM_DELEGATION.ID_` |
| `PROCESSDEFINITION_` | `LRSAdmin.JBPM_PROCESSDEFINITION.ID_` |
| `ACTION_` | `LRSAdmin.JBPM_ACTION.ID_` |
| `SUBPROCESSDEFINITION_` | `LRSAdmin.JBPM_PROCESSDEFINITION.ID_` |
| `SCRIPT_` | `LRSAdmin.JBPM_ACTION.ID_` |
| `SUPERSTATE_` | `LRSAdmin.JBPM_NODE.ID_` |

---

### JBPM_POOLEDACTOR

**Full Name:** `LRSAdmin.JBPM_POOLEDACTOR`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `VERSION_` | int | ✗ |  |
| `ACTORID_` | nvarchar(255) | ✓ |  |
| `SWIMLANEINSTANCE_` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `SWIMLANEINSTANCE_` | `LRSAdmin.JBPM_SWIMLANEINSTANCE.ID_` |

---

### JBPM_PROCESSDEFINITION

**Full Name:** `LRSAdmin.JBPM_PROCESSDEFINITION`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `CLASS_` | char(1) | ✗ |  |
| `NAME_` | nvarchar(255) | ✓ |  |
| `DESCRIPTION_` | nvarchar(-1) | ✓ |  |
| `VERSION_` | int | ✓ |  |
| `ISTERMINATIONIMPLICIT_` | tinyint | ✓ |  |
| `STARTSTATE_` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `STARTSTATE_` | `LRSAdmin.JBPM_NODE.ID_` |

---

### JBPM_PROCESSINSTANCE

**Full Name:** `LRSAdmin.JBPM_PROCESSINSTANCE`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `VERSION_` | int | ✗ |  |
| `KEY_` | nvarchar(255) | ✓ |  |
| `START_` | datetime | ✓ |  |
| `END_` | datetime | ✓ |  |
| `ISSUSPENDED_` | tinyint | ✓ |  |
| `PROCESSDEFINITION_` | numeric | ✓ |  |
| `ROOTTOKEN_` | numeric | ✓ |  |
| `SUPERPROCESSTOKEN_` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `PROCESSDEFINITION_` | `LRSAdmin.JBPM_PROCESSDEFINITION.ID_` |
| `ROOTTOKEN_` | `LRSAdmin.JBPM_TOKEN.ID_` |
| `SUPERPROCESSTOKEN_` | `LRSAdmin.JBPM_TOKEN.ID_` |

---

### JBPM_RUNTIMEACTION

**Full Name:** `LRSAdmin.JBPM_RUNTIMEACTION`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `VERSION_` | int | ✗ |  |
| `EVENTTYPE_` | nvarchar(255) | ✓ |  |
| `TYPE_` | char(1) | ✓ |  |
| `GRAPHELEMENT_` | numeric | ✓ |  |
| `PROCESSINSTANCE_` | numeric | ✓ |  |
| `ACTION_` | numeric | ✓ |  |
| `PROCESSINSTANCEINDEX_` | int | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `PROCESSINSTANCE_` | `LRSAdmin.JBPM_PROCESSINSTANCE.ID_` |
| `ACTION_` | `LRSAdmin.JBPM_ACTION.ID_` |

---

### JBPM_SWIMLANE

**Full Name:** `LRSAdmin.JBPM_SWIMLANE`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `NAME_` | nvarchar(255) | ✓ |  |
| `ACTORIDEXPRESSION_` | nvarchar(255) | ✓ |  |
| `POOLEDACTORSEXPRESSION_` | nvarchar(255) | ✓ |  |
| `ASSIGNMENTDELEGATION_` | numeric | ✓ |  |
| `TASKMGMTDEFINITION_` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `ASSIGNMENTDELEGATION_` | `LRSAdmin.JBPM_DELEGATION.ID_` |
| `TASKMGMTDEFINITION_` | `LRSAdmin.JBPM_MODULEDEFINITION.ID_` |

---

### JBPM_SWIMLANEINSTANCE

**Full Name:** `LRSAdmin.JBPM_SWIMLANEINSTANCE`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `VERSION_` | int | ✗ |  |
| `NAME_` | nvarchar(255) | ✓ |  |
| `ACTORID_` | nvarchar(255) | ✓ |  |
| `SWIMLANE_` | numeric | ✓ |  |
| `TASKMGMTINSTANCE_` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `TASKMGMTINSTANCE_` | `LRSAdmin.JBPM_MODULEINSTANCE.ID_` |
| `SWIMLANE_` | `LRSAdmin.JBPM_SWIMLANE.ID_` |

---

### JBPM_TASK

**Full Name:** `LRSAdmin.JBPM_TASK`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `NAME_` | nvarchar(255) | ✓ |  |
| `DESCRIPTION_` | nvarchar(-1) | ✓ |  |
| `PROCESSDEFINITION_` | numeric | ✓ |  |
| `ISBLOCKING_` | tinyint | ✓ |  |
| `ISSIGNALLING_` | tinyint | ✓ |  |
| `CONDITION_` | nvarchar(255) | ✓ |  |
| `DUEDATE_` | nvarchar(255) | ✓ |  |
| `PRIORITY_` | int | ✓ |  |
| `ACTORIDEXPRESSION_` | nvarchar(255) | ✓ |  |
| `POOLEDACTORSEXPRESSION_` | nvarchar(255) | ✓ |  |
| `TASKMGMTDEFINITION_` | numeric | ✓ |  |
| `TASKNODE_` | numeric | ✓ |  |
| `STARTSTATE_` | numeric | ✓ |  |
| `ASSIGNMENTDELEGATION_` | numeric | ✓ |  |
| `SWIMLANE_` | numeric | ✓ |  |
| `TASKCONTROLLER_` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `STARTSTATE_` | `LRSAdmin.JBPM_NODE.ID_` |
| `PROCESSDEFINITION_` | `LRSAdmin.JBPM_PROCESSDEFINITION.ID_` |
| `ASSIGNMENTDELEGATION_` | `LRSAdmin.JBPM_DELEGATION.ID_` |
| `SWIMLANE_` | `LRSAdmin.JBPM_SWIMLANE.ID_` |
| `TASKNODE_` | `LRSAdmin.JBPM_NODE.ID_` |
| `TASKMGMTDEFINITION_` | `LRSAdmin.JBPM_MODULEDEFINITION.ID_` |
| `TASKCONTROLLER_` | `LRSAdmin.JBPM_TASKCONTROLLER.ID_` |

---

### JBPM_TASKACTORPOOL

**Full Name:** `LRSAdmin.JBPM_TASKACTORPOOL`  
**Type:** BASE TABLE

**Primary Keys:** `TASKINSTANCE_`, `POOLEDACTOR_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `TASKINSTANCE_` | numeric | ✗ |  |
| `POOLEDACTOR_` | numeric | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `TASKINSTANCE_` | `LRSAdmin.JBPM_TASKINSTANCE.ID_` |
| `POOLEDACTOR_` | `LRSAdmin.JBPM_POOLEDACTOR.ID_` |

---

### JBPM_TASKCONTROLLER

**Full Name:** `LRSAdmin.JBPM_TASKCONTROLLER`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `TASKCONTROLLERDELEGATION_` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `TASKCONTROLLERDELEGATION_` | `LRSAdmin.JBPM_DELEGATION.ID_` |

---

### JBPM_TASKINSTANCE

**Full Name:** `LRSAdmin.JBPM_TASKINSTANCE`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `CLASS_` | char(1) | ✗ |  |
| `VERSION_` | int | ✗ |  |
| `NAME_` | nvarchar(255) | ✓ |  |
| `DESCRIPTION_` | nvarchar(-1) | ✓ |  |
| `ACTORID_` | nvarchar(255) | ✓ |  |
| `CREATE_` | datetime | ✓ |  |
| `START_` | datetime | ✓ |  |
| `END_` | datetime | ✓ |  |
| `DUEDATE_` | datetime | ✓ |  |
| `PRIORITY_` | int | ✓ |  |
| `ISCANCELLED_` | tinyint | ✓ |  |
| `ISSUSPENDED_` | tinyint | ✓ |  |
| `ISOPEN_` | tinyint | ✓ |  |
| `ISSIGNALLING_` | tinyint | ✓ |  |
| `ISBLOCKING_` | tinyint | ✓ |  |
| `TASK_` | numeric | ✓ |  |
| `TOKEN_` | numeric | ✓ |  |
| `PROCINST_` | numeric | ✓ |  |
| `SWIMLANINSTANCE_` | numeric | ✓ |  |
| `TASKMGMTINSTANCE_` | numeric | ✓ |  |
| `JBPM_ENGINE_NAME` | nvarchar(50) | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `PROCINST_` | `LRSAdmin.JBPM_PROCESSINSTANCE.ID_` |
| `TASKMGMTINSTANCE_` | `LRSAdmin.JBPM_MODULEINSTANCE.ID_` |
| `TOKEN_` | `LRSAdmin.JBPM_TOKEN.ID_` |
| `SWIMLANINSTANCE_` | `LRSAdmin.JBPM_SWIMLANEINSTANCE.ID_` |
| `TASK_` | `LRSAdmin.JBPM_TASK.ID_` |

---

### JBPM_TOKEN

**Full Name:** `LRSAdmin.JBPM_TOKEN`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `VERSION_` | int | ✗ |  |
| `NAME_` | nvarchar(255) | ✓ |  |
| `START_` | datetime | ✓ |  |
| `END_` | datetime | ✓ |  |
| `NODEENTER_` | datetime | ✓ |  |
| `NEXTLOGINDEX_` | int | ✓ |  |
| `ISABLETOREACTIVATEPARENT_` | tinyint | ✓ |  |
| `ISTERMINATIONIMPLICIT_` | tinyint | ✓ |  |
| `ISSUSPENDED_` | tinyint | ✓ |  |
| `LOCK_` | nvarchar(255) | ✓ |  |
| `NODE_` | numeric | ✓ |  |
| `PROCESSINSTANCE_` | numeric | ✓ |  |
| `PARENT_` | numeric | ✓ |  |
| `SUBPROCESSINSTANCE_` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `SUBPROCESSINSTANCE_` | `LRSAdmin.JBPM_PROCESSINSTANCE.ID_` |
| `PROCESSINSTANCE_` | `LRSAdmin.JBPM_PROCESSINSTANCE.ID_` |
| `NODE_` | `LRSAdmin.JBPM_NODE.ID_` |
| `PARENT_` | `LRSAdmin.JBPM_TOKEN.ID_` |

---

### JBPM_TOKENVARIABLEMAP

**Full Name:** `LRSAdmin.JBPM_TOKENVARIABLEMAP`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `VERSION_` | int | ✗ |  |
| `TOKEN_` | numeric | ✓ |  |
| `CONTEXTINSTANCE_` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `TOKEN_` | `LRSAdmin.JBPM_TOKEN.ID_` |
| `CONTEXTINSTANCE_` | `LRSAdmin.JBPM_MODULEINSTANCE.ID_` |

---

### JBPM_TRANSITION

**Full Name:** `LRSAdmin.JBPM_TRANSITION`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `NAME_` | nvarchar(255) | ✓ |  |
| `DESCRIPTION_` | nvarchar(-1) | ✓ |  |
| `PROCESSDEFINITION_` | numeric | ✓ |  |
| `FROM_` | numeric | ✓ |  |
| `TO_` | numeric | ✓ |  |
| `CONDITION_` | nvarchar(255) | ✓ |  |
| `FROMINDEX_` | int | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `FROM_` | `LRSAdmin.JBPM_NODE.ID_` |
| `PROCESSDEFINITION_` | `LRSAdmin.JBPM_PROCESSDEFINITION.ID_` |
| `TO_` | `LRSAdmin.JBPM_NODE.ID_` |

---

### JBPM_VARIABLEACCESS

**Full Name:** `LRSAdmin.JBPM_VARIABLEACCESS`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `VARIABLENAME_` | nvarchar(255) | ✓ |  |
| `ACCESS_` | nvarchar(255) | ✓ |  |
| `MAPPEDNAME_` | nvarchar(255) | ✓ |  |
| `PROCESSSTATE_` | numeric | ✓ |  |
| `TASKCONTROLLER_` | numeric | ✓ |  |
| `INDEX_` | int | ✓ |  |
| `SCRIPT_` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `PROCESSSTATE_` | `LRSAdmin.JBPM_NODE.ID_` |
| `SCRIPT_` | `LRSAdmin.JBPM_ACTION.ID_` |
| `TASKCONTROLLER_` | `LRSAdmin.JBPM_TASKCONTROLLER.ID_` |

---

### JBPM_VARIABLEINSTANCE

**Full Name:** `LRSAdmin.JBPM_VARIABLEINSTANCE`  
**Type:** BASE TABLE

**Primary Keys:** `ID_`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ID_` | numeric | ✗ |  |
| `CLASS_` | char(1) | ✗ |  |
| `VERSION_` | int | ✗ |  |
| `NAME_` | nvarchar(255) | ✓ |  |
| `CONVERTER_` | char(1) | ✓ |  |
| `TOKEN_` | numeric | ✓ |  |
| `TOKENVARIABLEMAP_` | numeric | ✓ |  |
| `PROCESSINSTANCE_` | numeric | ✓ |  |
| `BYTEARRAYVALUE_` | numeric | ✓ |  |
| `DATEVALUE_` | datetime | ✓ |  |
| `DOUBLEVALUE_` | float | ✓ |  |
| `LONGIDCLASS_` | nvarchar(255) | ✓ |  |
| `LONGVALUE_` | numeric | ✓ |  |
| `STRINGIDCLASS_` | nvarchar(255) | ✓ |  |
| `STRINGVALUE_` | nvarchar(255) | ✓ |  |
| `TASKINSTANCE_` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `PROCESSINSTANCE_` | `LRSAdmin.JBPM_PROCESSINSTANCE.ID_` |
| `TOKENVARIABLEMAP_` | `LRSAdmin.JBPM_TOKENVARIABLEMAP.ID_` |
| `TOKEN_` | `LRSAdmin.JBPM_TOKEN.ID_` |
| `BYTEARRAYVALUE_` | `LRSAdmin.JBPM_BYTEARRAY.ID_` |
| `TASKINSTANCE_` | `LRSAdmin.JBPM_TASKINSTANCE.ID_` |

---

### JMS_MESSAGES

**Full Name:** `LRSAdmin.JMS_MESSAGES`  
**Type:** BASE TABLE

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `MESSAGEID` | int | ✗ |  |
| `DESTINATION` | varchar(1024) | ✗ |  |
| `TXID` | int | ✓ |  |
| `TXOP` | char(1) | ✓ |  |
| `MESSAGEBLOB` | image(2147483647) | ✓ |  |

---

### JMS_ROLES

**Full Name:** `LRSAdmin.JMS_ROLES`  
**Type:** BASE TABLE

**Primary Keys:** `USERID`, `ROLEID`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ROLEID` | varchar(32) | ✗ |  |
| `USERID` | varchar(32) | ✗ |  |

---

### JMS_SUBSCRIPTIONS

**Full Name:** `LRSAdmin.JMS_SUBSCRIPTIONS`  
**Type:** BASE TABLE

**Primary Keys:** `CLIENTID`, `SUBNAME`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `CLIENTID` | varchar(128) | ✗ |  |
| `SUBNAME` | varchar(128) | ✗ |  |
| `TOPIC` | varchar(255) | ✗ |  |
| `SELECTOR` | varchar(255) | ✓ |  |

---

### JMS_TRANSACTIONS

**Full Name:** `LRSAdmin.JMS_TRANSACTIONS`  
**Type:** BASE TABLE

**Primary Keys:** `TXID`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `TXID` | int | ✗ |  |

---

### JMS_USERS

**Full Name:** `LRSAdmin.JMS_USERS`  
**Type:** BASE TABLE

**Primary Keys:** `USERID`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `USERID` | varchar(32) | ✗ |  |
| `PASSWD` | varchar(32) | ✗ |  |
| `CLIENTID` | varchar(128) | ✓ |  |

---

### alf_access_control_entry

**Full Name:** `LRSAdmin.alf_access_control_entry`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `permission_id` | numeric | ✗ |  |
| `authority_id` | numeric | ✗ |  |
| `allowed` | tinyint | ✗ |  |
| `applies` | int | ✗ |  |
| `context_id` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `context_id` | `LRSAdmin.alf_ace_context.id` |
| `permission_id` | `LRSAdmin.alf_permission.id` |
| `authority_id` | `LRSAdmin.alf_authority.id` |

---

### alf_access_control_list

**Full Name:** `LRSAdmin.alf_access_control_list`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `acl_id` | nvarchar(36) | ✗ |  |
| `latest` | tinyint | ✗ |  |
| `acl_version` | numeric | ✗ |  |
| `inherits` | tinyint | ✗ |  |
| `inherits_from` | numeric | ✓ |  |
| `type` | int | ✗ |  |
| `inherited_acl` | numeric | ✓ |  |
| `is_versioned` | tinyint | ✗ |  |
| `requires_version` | tinyint | ✗ |  |
| `acl_change_set` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `acl_change_set` | `LRSAdmin.alf_acl_change_set.id` |

---

### alf_ace_context

**Full Name:** `LRSAdmin.alf_ace_context`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `class_context` | nvarchar(1024) | ✓ |  |
| `property_context` | nvarchar(1024) | ✓ |  |
| `kvp_context` | nvarchar(1024) | ✓ |  |

---

### alf_acl_change_set

**Full Name:** `LRSAdmin.alf_acl_change_set`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |

---

### alf_acl_member

**Full Name:** `LRSAdmin.alf_acl_member`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `acl_id` | numeric | ✗ |  |
| `ace_id` | numeric | ✗ |  |
| `pos` | int | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `ace_id` | `LRSAdmin.alf_access_control_entry.id` |
| `acl_id` | `LRSAdmin.alf_access_control_list.id` |

---

### alf_activity_feed

**Full Name:** `LRSAdmin.alf_activity_feed`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `post_id` | numeric | ✓ |  |
| `post_date` | datetime | ✗ |  |
| `activity_summary` | nvarchar(1024) | ✓ |  |
| `feed_user_id` | nvarchar(255) | ✓ |  |
| `activity_type` | nvarchar(255) | ✗ |  |
| `activity_format` | nvarchar(10) | ✓ |  |
| `site_network` | nvarchar(255) | ✓ |  |
| `app_tool` | nvarchar(36) | ✓ |  |
| `post_user_id` | nvarchar(255) | ✗ |  |
| `feed_date` | datetime | ✗ |  |

---

### alf_activity_feed_control

**Full Name:** `LRSAdmin.alf_activity_feed_control`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `feed_user_id` | nvarchar(255) | ✗ |  |
| `site_network` | nvarchar(255) | ✓ |  |
| `app_tool` | nvarchar(36) | ✓ |  |
| `last_modified` | datetime | ✗ |  |

---

### alf_activity_post

**Full Name:** `LRSAdmin.alf_activity_post`  
**Type:** BASE TABLE

**Primary Keys:** `sequence_id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `sequence_id` | numeric | ✗ |  |
| `post_date` | datetime | ✗ |  |
| `status` | nvarchar(10) | ✗ |  |
| `activity_data` | nvarchar(1024) | ✗ |  |
| `post_user_id` | nvarchar(255) | ✗ |  |
| `job_task_node` | int | ✗ |  |
| `site_network` | nvarchar(255) | ✓ |  |
| `app_tool` | nvarchar(36) | ✓ |  |
| `activity_type` | nvarchar(255) | ✗ |  |
| `last_modified` | datetime | ✗ |  |

---

### alf_applied_patch

**Full Name:** `LRSAdmin.alf_applied_patch`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | nvarchar(64) | ✗ |  |
| `description` | nvarchar(1024) | ✓ |  |
| `fixes_from_schema` | int | ✓ |  |
| `fixes_to_schema` | int | ✓ |  |
| `applied_to_schema` | int | ✓ |  |
| `target_schema` | int | ✓ |  |
| `applied_on_date` | datetime | ✓ |  |
| `applied_to_server` | nvarchar(64) | ✓ |  |
| `was_executed` | tinyint | ✓ |  |
| `succeeded` | tinyint | ✓ |  |
| `report` | nvarchar(1024) | ✓ |  |

---

### alf_attributes

**Full Name:** `LRSAdmin.alf_attributes`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `type` | nvarchar(1) | ✗ |  |
| `version` | numeric | ✗ |  |
| `acl_id` | numeric | ✓ |  |
| `bool_value` | tinyint | ✓ |  |
| `byte_value` | tinyint | ✓ |  |
| `short_value` | int | ✓ |  |
| `int_value` | int | ✓ |  |
| `long_value` | numeric | ✓ |  |
| `float_value` | float | ✓ |  |
| `double_value` | float | ✓ |  |
| `string_value` | nvarchar(1024) | ✓ |  |
| `serializable_value` | image(2147483647) | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `acl_id` | `LRSAdmin.alf_access_control_list.id` |

---

### alf_audit_app

**Full Name:** `LRSAdmin.alf_audit_app`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | int | ✗ |  |
| `app_name_id` | numeric | ✗ |  |
| `audit_model_id` | numeric | ✗ |  |
| `disabled_paths_id` | numeric | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `app_name_id` | `LRSAdmin.alf_prop_value.id` |
| `audit_model_id` | `LRSAdmin.alf_audit_model.id` |
| `disabled_paths_id` | `LRSAdmin.alf_prop_root.id` |

---

### alf_audit_entry

**Full Name:** `LRSAdmin.alf_audit_entry`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `audit_app_id` | numeric | ✗ |  |
| `audit_time` | numeric | ✗ |  |
| `audit_user_id` | numeric | ✓ |  |
| `audit_values_id` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `audit_app_id` | `LRSAdmin.alf_audit_app.id` |
| `audit_user_id` | `LRSAdmin.alf_prop_value.id` |
| `audit_values_id` | `LRSAdmin.alf_prop_root.id` |

---

### alf_audit_model

**Full Name:** `LRSAdmin.alf_audit_model`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `content_data_id` | numeric | ✗ |  |
| `content_crc` | numeric | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `content_data_id` | `LRSAdmin.alf_content_data.id` |

---

### alf_authority

**Full Name:** `LRSAdmin.alf_authority`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `authority` | nvarchar(100) | ✓ |  |
| `crc` | numeric | ✓ |  |

---

### alf_authority_alias

**Full Name:** `LRSAdmin.alf_authority_alias`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `auth_id` | numeric | ✗ |  |
| `alias_id` | numeric | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `auth_id` | `LRSAdmin.alf_authority.id` |
| `alias_id` | `LRSAdmin.alf_authority.id` |

---

### alf_child_assoc

**Full Name:** `LRSAdmin.alf_child_assoc`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `parent_node_id` | numeric | ✗ |  |
| `type_qname_id` | numeric | ✗ |  |
| `child_node_name_crc` | numeric | ✗ |  |
| `child_node_name` | nvarchar(50) | ✗ |  |
| `child_node_id` | numeric | ✗ |  |
| `qname_ns_id` | numeric | ✗ |  |
| `qname_localname` | nvarchar(255) | ✗ |  |
| `qname_crc` | numeric | ✗ |  |
| `is_primary` | tinyint | ✓ |  |
| `assoc_index` | int | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `child_node_id` | `LRSAdmin.alf_node.id` |
| `parent_node_id` | `LRSAdmin.alf_node.id` |
| `qname_ns_id` | `LRSAdmin.alf_namespace.id` |
| `type_qname_id` | `LRSAdmin.alf_qname.id` |

---

### alf_content_data

**Full Name:** `LRSAdmin.alf_content_data`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `content_url_id` | numeric | ✓ |  |
| `content_mimetype_id` | numeric | ✓ |  |
| `content_encoding_id` | numeric | ✓ |  |
| `content_locale_id` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `content_mimetype_id` | `LRSAdmin.alf_mimetype.id` |
| `content_encoding_id` | `LRSAdmin.alf_encoding.id` |
| `content_locale_id` | `LRSAdmin.alf_locale.id` |

---

### alf_content_url

**Full Name:** `LRSAdmin.alf_content_url`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `content_url` | nvarchar(255) | ✗ |  |
| `content_url_short` | nvarchar(12) | ✗ |  |
| `content_url_crc` | numeric | ✗ |  |
| `content_size` | numeric | ✗ |  |
| `orphan_time` | numeric | ✓ |  |

---

### alf_encoding

**Full Name:** `LRSAdmin.alf_encoding`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `encoding_str` | nvarchar(100) | ✗ |  |

---

### alf_global_attributes

**Full Name:** `LRSAdmin.alf_global_attributes`  
**Type:** BASE TABLE

**Primary Keys:** `name`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `name` | nvarchar(160) | ✗ |  |
| `attribute` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `attribute` | `LRSAdmin.alf_attributes.id` |

---

### alf_list_attribute_entries

**Full Name:** `LRSAdmin.alf_list_attribute_entries`  
**Type:** BASE TABLE

**Primary Keys:** `list_id`, `mindex`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `list_id` | numeric | ✗ |  |
| `mindex` | int | ✗ |  |
| `attribute_id` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `attribute_id` | `LRSAdmin.alf_attributes.id` |
| `list_id` | `LRSAdmin.alf_attributes.id` |

---

### alf_locale

**Full Name:** `LRSAdmin.alf_locale`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `locale_str` | nvarchar(20) | ✗ |  |

---

### alf_lock

**Full Name:** `LRSAdmin.alf_lock`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `shared_resource_id` | numeric | ✗ |  |
| `excl_resource_id` | numeric | ✗ |  |
| `lock_token` | nvarchar(36) | ✗ |  |
| `start_time` | numeric | ✗ |  |
| `expiry_time` | numeric | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `shared_resource_id` | `LRSAdmin.alf_lock_resource.id` |
| `excl_resource_id` | `LRSAdmin.alf_lock_resource.id` |

---

### alf_lock_resource

**Full Name:** `LRSAdmin.alf_lock_resource`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `qname_ns_id` | numeric | ✗ |  |
| `qname_localname` | nvarchar(255) | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `qname_ns_id` | `LRSAdmin.alf_namespace.id` |

---

### alf_map_attribute_entries

**Full Name:** `LRSAdmin.alf_map_attribute_entries`  
**Type:** BASE TABLE

**Primary Keys:** `map_id`, `mkey`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `map_id` | numeric | ✗ |  |
| `mkey` | nvarchar(160) | ✗ |  |
| `attribute_id` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `attribute_id` | `LRSAdmin.alf_attributes.id` |
| `map_id` | `LRSAdmin.alf_attributes.id` |

---

### alf_mimetype

**Full Name:** `LRSAdmin.alf_mimetype`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `mimetype_str` | nvarchar(100) | ✗ |  |

---

### alf_namespace

**Full Name:** `LRSAdmin.alf_namespace`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `uri` | nvarchar(100) | ✗ |  |

---

### alf_node

**Full Name:** `LRSAdmin.alf_node`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `store_id` | numeric | ✗ |  |
| `uuid` | nvarchar(36) | ✗ |  |
| `transaction_id` | numeric | ✗ |  |
| `node_deleted` | tinyint | ✗ |  |
| `type_qname_id` | numeric | ✗ |  |
| `acl_id` | numeric | ✓ |  |
| `audit_creator` | nvarchar(255) | ✓ |  |
| `audit_created` | nvarchar(30) | ✓ |  |
| `audit_modifier` | nvarchar(255) | ✓ |  |
| `audit_modified` | nvarchar(30) | ✓ |  |
| `audit_accessed` | nvarchar(30) | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `acl_id` | `LRSAdmin.alf_access_control_list.id` |
| `store_id` | `LRSAdmin.alf_store.id` |
| `type_qname_id` | `LRSAdmin.alf_qname.id` |
| `transaction_id` | `LRSAdmin.alf_transaction.id` |

---

### alf_node_aspects

**Full Name:** `LRSAdmin.alf_node_aspects`  
**Type:** BASE TABLE

**Primary Keys:** `node_id`, `qname_id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `node_id` | numeric | ✗ |  |
| `qname_id` | numeric | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `node_id` | `LRSAdmin.alf_node.id` |
| `qname_id` | `LRSAdmin.alf_qname.id` |

---

### alf_node_assoc

**Full Name:** `LRSAdmin.alf_node_assoc`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `source_node_id` | numeric | ✗ |  |
| `target_node_id` | numeric | ✗ |  |
| `type_qname_id` | numeric | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `source_node_id` | `LRSAdmin.alf_node.id` |
| `target_node_id` | `LRSAdmin.alf_node.id` |
| `type_qname_id` | `LRSAdmin.alf_qname.id` |

---

### alf_node_properties

**Full Name:** `LRSAdmin.alf_node_properties`  
**Type:** BASE TABLE

**Primary Keys:** `node_id`, `qname_id`, `list_index`, `locale_id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `node_id` | numeric | ✗ |  |
| `actual_type_n` | int | ✗ |  |
| `persisted_type_n` | int | ✗ |  |
| `boolean_value` | tinyint | ✓ |  |
| `long_value` | numeric | ✓ |  |
| `float_value` | float | ✓ |  |
| `double_value` | float | ✓ |  |
| `string_value` | nvarchar(1024) | ✓ |  |
| `serializable_value` | image(2147483647) | ✓ |  |
| `qname_id` | numeric | ✗ |  |
| `list_index` | int | ✗ |  |
| `locale_id` | numeric | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `locale_id` | `LRSAdmin.alf_locale.id` |
| `node_id` | `LRSAdmin.alf_node.id` |
| `qname_id` | `LRSAdmin.alf_qname.id` |

---

### alf_permission

**Full Name:** `LRSAdmin.alf_permission`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `type_qname_id` | numeric | ✗ |  |
| `name` | nvarchar(100) | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `type_qname_id` | `LRSAdmin.alf_qname.id` |

---

### alf_prop_class

**Full Name:** `LRSAdmin.alf_prop_class`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `java_class_name` | nvarchar(255) | ✗ |  |
| `java_class_name_short` | nvarchar(32) | ✗ |  |
| `java_class_name_crc` | numeric | ✗ |  |

---

### alf_prop_date_value

**Full Name:** `LRSAdmin.alf_prop_date_value`  
**Type:** BASE TABLE

**Primary Keys:** `date_value`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `date_value` | numeric | ✗ |  |
| `full_year` | int | ✗ |  |
| `half_of_year` | tinyint | ✗ |  |
| `quarter_of_year` | tinyint | ✗ |  |
| `month_of_year` | tinyint | ✗ |  |
| `week_of_year` | tinyint | ✗ |  |
| `week_of_month` | tinyint | ✗ |  |
| `day_of_year` | int | ✗ |  |
| `day_of_month` | tinyint | ✗ |  |
| `day_of_week` | tinyint | ✗ |  |

---

### alf_prop_double_value

**Full Name:** `LRSAdmin.alf_prop_double_value`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `double_value` | float | ✗ |  |

---

### alf_prop_link

**Full Name:** `LRSAdmin.alf_prop_link`  
**Type:** BASE TABLE

**Primary Keys:** `root_prop_id`, `contained_in`, `prop_index`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `root_prop_id` | numeric | ✗ |  |
| `prop_index` | numeric | ✗ |  |
| `contained_in` | numeric | ✗ |  |
| `key_prop_id` | numeric | ✗ |  |
| `value_prop_id` | numeric | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `root_prop_id` | `LRSAdmin.alf_prop_root.id` |
| `key_prop_id` | `LRSAdmin.alf_prop_value.id` |
| `value_prop_id` | `LRSAdmin.alf_prop_value.id` |

---

### alf_prop_root

**Full Name:** `LRSAdmin.alf_prop_root`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | int | ✗ |  |

---

### alf_prop_serializable_value

**Full Name:** `LRSAdmin.alf_prop_serializable_value`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | bigint | ✗ |  |
| `serializable_value` | image(2147483647) | ✗ |  |

---

### alf_prop_string_value

**Full Name:** `LRSAdmin.alf_prop_string_value`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `string_value` | nvarchar(1024) | ✗ |  |
| `string_end_lower` | nvarchar(16) | ✗ |  |
| `string_crc` | numeric | ✗ |  |

---

### alf_prop_unique_ctx

**Full Name:** `LRSAdmin.alf_prop_unique_ctx`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | int | ✗ |  |
| `value1_prop_id` | numeric | ✗ |  |
| `value2_prop_id` | numeric | ✗ |  |
| `value3_prop_id` | numeric | ✗ |  |
| `prop1_id` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `value1_prop_id` | `LRSAdmin.alf_prop_value.id` |
| `value2_prop_id` | `LRSAdmin.alf_prop_value.id` |
| `value3_prop_id` | `LRSAdmin.alf_prop_value.id` |
| `prop1_id` | `LRSAdmin.alf_prop_root.id` |

---

### alf_prop_value

**Full Name:** `LRSAdmin.alf_prop_value`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `actual_type_id` | numeric | ✗ |  |
| `persisted_type` | tinyint | ✗ |  |
| `long_value` | numeric | ✗ |  |

---

### alf_qname

**Full Name:** `LRSAdmin.alf_qname`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `ns_id` | numeric | ✗ |  |
| `local_name` | nvarchar(200) | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `ns_id` | `LRSAdmin.alf_namespace.id` |

---

### alf_server

**Full Name:** `LRSAdmin.alf_server`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `ip_address` | nvarchar(39) | ✗ |  |

---

### alf_store

**Full Name:** `LRSAdmin.alf_store`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `protocol` | nvarchar(50) | ✗ |  |
| `identifier` | nvarchar(100) | ✗ |  |
| `root_node_id` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `root_node_id` | `LRSAdmin.alf_node.id` |

---

### alf_transaction

**Full Name:** `LRSAdmin.alf_transaction`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `server_id` | numeric | ✓ |  |
| `change_txn_id` | nvarchar(56) | ✗ |  |
| `commit_time_ms` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `server_id` | `LRSAdmin.alf_server.id` |

---

### alf_usage_delta

**Full Name:** `LRSAdmin.alf_usage_delta`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version` | numeric | ✗ |  |
| `node_id` | numeric | ✗ |  |
| `delta_size` | numeric | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `node_id` | `LRSAdmin.alf_node.id` |

---

### avm_aspects

**Full Name:** `LRSAdmin.avm_aspects`  
**Type:** BASE TABLE

**Primary Keys:** `node_id`, `qname_id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `node_id` | numeric | ✗ |  |
| `qname_id` | numeric | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `node_id` | `LRSAdmin.avm_nodes.id` |
| `qname_id` | `LRSAdmin.alf_qname.id` |

---

### avm_child_entries

**Full Name:** `LRSAdmin.avm_child_entries`  
**Type:** BASE TABLE

**Primary Keys:** `parent_id`, `lc_name`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `parent_id` | numeric | ✗ |  |
| `lc_name` | nvarchar(160) | ✗ |  |
| `name` | nvarchar(160) | ✗ |  |
| `child_id` | numeric | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `child_id` | `LRSAdmin.avm_nodes.id` |
| `parent_id` | `LRSAdmin.avm_nodes.id` |

---

### avm_history_links

**Full Name:** `LRSAdmin.avm_history_links`  
**Type:** BASE TABLE

**Primary Keys:** `ancestor`, `descendent`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `ancestor` | numeric | ✗ |  |
| `descendent` | numeric | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `descendent` | `LRSAdmin.avm_nodes.id` |
| `ancestor` | `LRSAdmin.avm_nodes.id` |

---

### avm_merge_links

**Full Name:** `LRSAdmin.avm_merge_links`  
**Type:** BASE TABLE

**Primary Keys:** `mfrom`, `mto`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `mfrom` | numeric | ✗ |  |
| `mto` | numeric | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `mfrom` | `LRSAdmin.avm_nodes.id` |
| `mto` | `LRSAdmin.avm_nodes.id` |

---

### avm_node_properties

**Full Name:** `LRSAdmin.avm_node_properties`  
**Type:** BASE TABLE

**Primary Keys:** `node_id`, `qname_id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `node_id` | numeric | ✗ |  |
| `actual_type_n` | int | ✗ |  |
| `persisted_type_n` | int | ✗ |  |
| `multi_valued` | tinyint | ✗ |  |
| `boolean_value` | tinyint | ✓ |  |
| `long_value` | numeric | ✓ |  |
| `float_value` | float | ✓ |  |
| `double_value` | float | ✓ |  |
| `string_value` | nvarchar(1024) | ✓ |  |
| `serializable_value` | image(2147483647) | ✓ |  |
| `qname_id` | numeric | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `node_id` | `LRSAdmin.avm_nodes.id` |
| `qname_id` | `LRSAdmin.alf_qname.id` |

---

### avm_nodes

**Full Name:** `LRSAdmin.avm_nodes`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `class_type` | nvarchar(20) | ✗ |  |
| `vers` | numeric | ✗ |  |
| `version_id` | int | ✗ |  |
| `guid` | nvarchar(36) | ✓ |  |
| `creator` | nvarchar(255) | ✗ |  |
| `owner` | nvarchar(255) | ✗ |  |
| `lastModifier` | nvarchar(255) | ✗ |  |
| `createDate` | numeric | ✗ |  |
| `modDate` | numeric | ✗ |  |
| `accessDate` | numeric | ✗ |  |
| `is_root` | tinyint | ✓ |  |
| `store_new_id` | numeric | ✓ |  |
| `acl_id` | numeric | ✓ |  |
| `deletedType` | int | ✓ |  |
| `layer_id` | numeric | ✓ |  |
| `indirection` | nvarchar(1024) | ✓ |  |
| `indirection_version` | int | ✓ |  |
| `primary_indirection` | tinyint | ✓ |  |
| `opacity` | tinyint | ✓ |  |
| `content_url` | nvarchar(128) | ✓ |  |
| `mime_type` | nvarchar(100) | ✓ |  |
| `encoding` | nvarchar(16) | ✓ |  |
| `length` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `acl_id` | `LRSAdmin.alf_access_control_list.id` |
| `store_new_id` | `LRSAdmin.avm_stores.id` |

---

### avm_store_properties

**Full Name:** `LRSAdmin.avm_store_properties`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `avm_store_id` | numeric | ✓ |  |
| `qname_id` | numeric | ✗ |  |
| `actual_type_n` | int | ✗ |  |
| `persisted_type_n` | int | ✗ |  |
| `multi_valued` | tinyint | ✗ |  |
| `boolean_value` | tinyint | ✓ |  |
| `long_value` | numeric | ✓ |  |
| `float_value` | float | ✓ |  |
| `double_value` | float | ✓ |  |
| `string_value` | nvarchar(1024) | ✓ |  |
| `serializable_value` | image(2147483647) | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `avm_store_id` | `LRSAdmin.avm_stores.id` |
| `qname_id` | `LRSAdmin.alf_qname.id` |

---

### avm_stores

**Full Name:** `LRSAdmin.avm_stores`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `vers` | numeric | ✗ |  |
| `name` | nvarchar(255) | ✓ |  |
| `next_version_id` | int | ✗ |  |
| `current_root_id` | numeric | ✓ |  |
| `acl_id` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `current_root_id` | `LRSAdmin.avm_nodes.id` |
| `acl_id` | `LRSAdmin.alf_access_control_list.id` |

---

### avm_version_layered_node_entry

**Full Name:** `LRSAdmin.avm_version_layered_node_entry`  
**Type:** BASE TABLE

**Primary Keys:** `version_root_id`, `md5sum`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `version_root_id` | numeric | ✗ |  |
| `md5sum` | nvarchar(32) | ✗ |  |
| `path` | nvarchar(1024) | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `version_root_id` | `LRSAdmin.avm_version_roots.id` |

---

### avm_version_roots

**Full Name:** `LRSAdmin.avm_version_roots`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `version_id` | int | ✗ |  |
| `avm_store_id` | numeric | ✗ |  |
| `create_date` | numeric | ✗ |  |
| `creator` | nvarchar(255) | ✗ |  |
| `root_id` | numeric | ✗ |  |
| `tag` | nvarchar(255) | ✓ |  |
| `description` | nvarchar(1024) | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `avm_store_id` | `LRSAdmin.avm_stores.id` |
| `root_id` | `LRSAdmin.avm_nodes.id` |

---

### lr_address

**Full Name:** `LRSAdmin.lr_address`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `address_area_name` | nvarchar(250) | ✓ |  |
| `street_number` | nvarchar(50) | ✓ |  |
| `street_name` | nvarchar(100) | ✓ |  |
| `building_name` | nvarchar(50) | ✓ |  |
| `building_number` | int | ✓ |  |
| `layout_name` | numeric | ✓ |  |
| `postal_code` | nvarchar(10) | ✓ |  |
| `city` | nvarchar(100) | ✓ |  |
| `ward` | nvarchar(100) | ✓ |  |
| `cell` | nvarchar(100) | ✓ |  |
| `local_government_area` | numeric | ✓ |  |
| `country` | numeric | ✗ |  |
| `region` | numeric | ✗ |  |
| `origin_region` | numeric | ✓ |  |
| `district` | numeric | ✗ |  |
| `cadregion` | numeric | ✗ |  |
| `subdistrict` | numeric | ✗ |  |
| `subcounty` | nvarchar(30) | ✓ |  |
| `address_line1` | nvarchar(50) | ✓ |  |
| `address_line2` | nvarchar(100) | ✓ |  |
| `address_line3` | nvarchar(100) | ✓ |  |
| `district_text` | nvarchar(100) | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `cadregion` | `LRSAdmin.lr_dictionary.Id` |
| `subdistrict` | `LRSAdmin.lr_dictionary.Id` |
| `local_government_area` | `LRSAdmin.lr_dictionary.Id` |
| `region` | `LRSAdmin.lr_dictionary.Id` |
| `country` | `LRSAdmin.lr_dictionary.Id` |
| `layout_name` | `LRSAdmin.lr_dictionary.Id` |
| `district` | `LRSAdmin.lr_dictionary.Id` |
| `origin_region` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_admin_document_party

**Full Name:** `LRSAdmin.lr_admin_document_party`  
**Type:** BASE TABLE

**Primary Keys:** `document`, `party_index`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `document` | numeric | ✗ |  |
| `party` | numeric | ✗ |  |
| `party_index` | int | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `document` | `LRSAdmin.lr_source_document.id` |
| `party` | `LRSAdmin.lr_party.id` |

---

### lr_admin_document_rrr

**Full Name:** `LRSAdmin.lr_admin_document_rrr`  
**Type:** BASE TABLE

**Primary Keys:** `document`, `rrr_index`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `document` | numeric | ✗ |  |
| `rrr` | numeric | ✗ |  |
| `rrr_index` | int | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `document` | `LRSAdmin.lr_source_document.id` |
| `rrr` | `LRSAdmin.lr_rrr.id` |

---

### lr_admin_source_document

**Full Name:** `LRSAdmin.lr_admin_source_document`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `purchase_price` | float | ✓ |  |
| `memo_text` | nvarchar(2500) | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `id` | `LRSAdmin.lr_source_document.id` |

---

### lr_applicant

**Full Name:** `LRSAdmin.lr_applicant`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `application_type` | numeric | ✗ |  |
| `delivery_type` | numeric | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `application_type` | `LRSAdmin.lr_dictionary.Id` |
| `id` | `LRSAdmin.lr_party.id` |
| `delivery_type` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_batch

**Full Name:** `LRSAdmin.lr_batch`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `batch_number` | nvarchar(50) | ✓ |  |
| `application_status` | numeric | ✗ |  |
| `invoice_number` | nvarchar(150) | ✓ |  |
| `create_date` | datetime | ✓ |  |
| `delivery_date` | datetime | ✓ |  |
| `office` | numeric | ✓ |  |
| `comments` | nvarchar(800) | ✓ |  |
| `decision` | nvarchar(100) | ✓ |  |
| `decision_date` | datetime | ✓ |  |
| `decision_number` | nvarchar(50) | ✓ |  |
| `attachments` | nvarchar(255) | ✓ |  |
| `registrar` | nvarchar(50) | ✓ |  |
| `registration_date` | datetime | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `office` | `LRSAdmin.lr_registry_office.id` |
| `application_status` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_batch_party

**Full Name:** `LRSAdmin.lr_batch_party`  
**Type:** BASE TABLE

**Primary Keys:** `batch`, `party_index`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `batch` | numeric | ✗ |  |
| `party` | numeric | ✗ |  |
| `party_index` | int | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `batch` | `LRSAdmin.lr_batch.id` |
| `party` | `LRSAdmin.lr_party.id` |

---

### lr_batch_related

**Full Name:** `LRSAdmin.lr_batch_related`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `parent_id` | numeric | ✗ |  |
| `child_id` | numeric | ✗ |  |
| `process_id` | numeric | ✓ |  |

---

### lr_billing

**Full Name:** `LRSAdmin.lr_billing`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `invoice_number` | nvarchar(50) | ✓ |  |
| `total_amount` | float | ✓ |  |
| `status` | numeric | ✗ |  |
| `invoice_type` | numeric | ✗ |  |
| `wires_trx_id` | numeric | ✓ |  |
| `wrx_date_submitted` | datetime | ✓ |  |
| `wrx_date_accepted` | datetime | ✓ |  |
| `due_date` | datetime | ✓ |  |
| `party` | numeric | ✓ |  |
| `party_contact` | numeric | ✓ |  |
| `ref_number` | nvarchar(50) | ✓ |  |
| `description` | nvarchar(800) | ✓ |  |
| `comments` | nvarchar(800) | ✓ |  |
| `submitted_by` | nvarchar(50) | ✓ |  |
| `bil1` | nvarchar(50) | ✓ |  |
| `bil2` | nvarchar(50) | ✓ |  |
| `bil_dict1` | numeric | ✗ |  |
| `bil_dict2` | numeric | ✗ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `party` | `LRSAdmin.lr_party.id` |
| `status` | `LRSAdmin.lr_dictionary.Id` |
| `party_contact` | `LRSAdmin.lr_person.id` |
| `bil_dict2` | `LRSAdmin.lr_dictionary.Id` |
| `invoice_type` | `LRSAdmin.lr_dictionary.Id` |
| `bil_dict1` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_billing_dist_line

**Full Name:** `LRSAdmin.lr_billing_dist_line`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `trans_code` | nvarchar(50) | ✓ |  |
| `amount` | float | ✓ |  |
| `flex_field_1` | nvarchar(250) | ✓ |  |
| `flex_field_2` | nvarchar(250) | ✓ |  |
| `flex_field_3` | nvarchar(250) | ✓ |  |
| `flex_field_4` | nvarchar(250) | ✓ |  |
| `flex_field_5` | nvarchar(250) | ✓ |  |
| `wires_dist_line_id` | nvarchar(50) | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |
| `line_id` | numeric | ✓ |  |
| `line_index` | int | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `line_id` | `LRSAdmin.lr_billing_line.id` |

---

### lr_billing_line

**Full Name:** `LRSAdmin.lr_billing_line`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `line_type` | nvarchar(50) | ✓ |  |
| `quantity` | float | ✓ |  |
| `amount` | float | ✓ |  |
| `total_amount` | float | ✓ |  |
| `wires_line_id` | nvarchar(50) | ✓ |  |
| `description` | nvarchar(800) | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |
| `bill_id` | numeric | ✓ |  |
| `bill_index` | int | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `bill_id` | `LRSAdmin.lr_billing.id` |

---

### lr_building

**Full Name:** `LRSAdmin.lr_building`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `compl_number` | nvarchar(30) | ✓ |  |
| `actual_use_type` | numeric | ✗ |  |
| `number_of_units` | int | ✓ |  |
| `number_of_floors` | int | ✓ |  |
| `floor_area` | float | ✓ |  |
| `floor_area_unit_type` | numeric | ✗ |  |
| `internal_area` | float | ✓ |  |
| `internal_area_unit_type` | numeric | ✗ |  |
| `unit_factor` | int | ✓ |  |
| `adjacents` | nvarchar(500) | ✓ |  |
| `build_category` | numeric | ✗ |  |
| `build_purpose` | numeric | ✗ |  |
| `build_date1` | datetime | ✓ |  |
| `build_date2` | datetime | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `build_purpose` | `LRSAdmin.lr_dictionary.Id` |
| `id` | `LRSAdmin.lr_spatial_unit.id` |
| `internal_area_unit_type` | `LRSAdmin.lr_dictionary.Id` |
| `actual_use_type` | `LRSAdmin.lr_dictionary.Id` |
| `build_category` | `LRSAdmin.lr_dictionary.Id` |
| `floor_area_unit_type` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_building_unit

**Full Name:** `LRSAdmin.lr_building_unit`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `unit_number` | nvarchar(30) | ✓ |  |
| `building_number` | nvarchar(30) | ✓ |  |
| `compl_number` | nvarchar(30) | ✓ |  |
| `condo_plan` | nvarchar(20) | ✓ |  |
| `use_type` | numeric | ✗ |  |
| `bunit_type` | numeric | ✓ |  |
| `bunit_category` | numeric | ✗ |  |
| `bunit_purpose` | numeric | ✗ |  |
| `use_typespecificbld` | nvarchar(50) | ✓ |  |
| `unit_factor` | int | ✓ |  |
| `unit_type` | numeric | ✗ |  |
| `number_of_units` | int | ✓ |  |
| `number_of_floors` | int | ✓ |  |
| `floor_type` | numeric | ✗ |  |
| `floor_area` | float | ✓ |  |
| `floor_area_unit_type` | numeric | ✗ |  |
| `internal_area` | float | ✓ |  |
| `internal_area_unit_type` | numeric | ✗ |  |
| `adjacents` | nvarchar(500) | ✓ |  |
| `bunit1` | nvarchar(50) | ✓ |  |
| `bunit2` | nvarchar(50) | ✓ |  |
| `bunit_dict1` | numeric | ✗ |  |
| `bunit_dict2` | numeric | ✗ |  |
| `bunit_date1` | datetime | ✓ |  |
| `bunit_date2` | datetime | ✓ |  |
| `bunit_count1` | int | ✓ |  |
| `bunit_count2` | int | ✓ |  |
| `plot_uid` | nvarchar(50) | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `bunit_dict1` | `LRSAdmin.lr_dictionary.Id` |
| `bunit_dict2` | `LRSAdmin.lr_dictionary.Id` |
| `bunit_purpose` | `LRSAdmin.lr_dictionary.Id` |
| `bunit_type` | `LRSAdmin.lr_dictionary.Id` |
| `id` | `LRSAdmin.lr_spatial_unit.id` |
| `internal_area_unit_type` | `LRSAdmin.lr_dictionary.Id` |
| `use_type` | `LRSAdmin.lr_dictionary.Id` |
| `floor_type` | `LRSAdmin.lr_dictionary.Id` |
| `unit_type` | `LRSAdmin.lr_dictionary.Id` |
| `bunit_category` | `LRSAdmin.lr_dictionary.Id` |
| `floor_area_unit_type` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_business_calendar

**Full Name:** `LRSAdmin.lr_business_calendar`  
**Type:** BASE TABLE

**Primary Keys:** `Id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `Id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `code` | nvarchar(255) | ✗ |  |
| `label` | nvarchar(255) | ✗ |  |
| `day_part` | nvarchar(500) | ✓ |  |

---

### lr_condition

**Full Name:** `LRSAdmin.lr_condition`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `condition_type` | numeric | ✗ |  |
| `condition_seq` | numeric | ✓ |  |
| `condition_number` | nvarchar(100) | ✓ |  |
| `cond_stage` | nvarchar(150) | ✓ |  |
| `condition_text` | nvarchar(1500) | ✓ |  |
| `original_text` | nvarchar(1000) | ✓ |  |
| `custom_condition` | tinyint | ✓ |  |
| `last_edited_by` | nvarchar(255) | ✓ |  |
| `sign_by` | nvarchar(100) | ✓ |  |
| `validated_by` | nvarchar(100) | ✓ |  |
| `last_edited` | datetime | ✓ |  |
| `received_date` | datetime | ✓ |  |
| `validated_date` | datetime | ✓ |  |
| `monitored` | tinyint | ✓ |  |
| `cond_status` | numeric | ✗ |  |
| `cond1` | nvarchar(50) | ✓ |  |
| `cond2` | nvarchar(50) | ✓ |  |
| `cond_dict1` | numeric | ✗ |  |
| `cond_dict2` | numeric | ✗ |  |
| `cond_count1` | int | ✓ |  |
| `cond_count2` | int | ✓ |  |
| `transaction_` | numeric | ✓ |  |
| `condition_index` | int | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `cond_status` | `LRSAdmin.lr_dictionary.Id` |
| `condition_type` | `LRSAdmin.lr_dictionary.Id` |
| `transaction_` | `LRSAdmin.lr_transaction.id` |
| `cond_dict1` | `LRSAdmin.lr_dictionary.Id` |
| `cond_dict2` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_contact

**Full Name:** `LRSAdmin.lr_contact`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `contact_type` | numeric | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `id` | `LRSAdmin.lr_person.id` |
| `contact_type` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_corporation

**Full Name:** `LRSAdmin.lr_corporation`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `name` | nvarchar(150) | ✓ |  |
| `represent_name` | nvarchar(50) | ✓ |  |
| `gsm_number` | nvarchar(50) | ✓ |  |
| `cac_number` | nvarchar(50) | ✓ |  |
| `corp1` | nvarchar(50) | ✓ |  |
| `corp2` | nvarchar(50) | ✓ |  |
| `corp_dict1` | numeric | ✗ |  |
| `corp_dict2` | numeric | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `corp_dict2` | `LRSAdmin.lr_dictionary.Id` |
| `id` | `LRSAdmin.lr_person.id` |
| `corp_dict1` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_dictionary

**Full Name:** `LRSAdmin.lr_dictionary`  
**Type:** BASE TABLE

**Primary Keys:** `Id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `Id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `code` | nvarchar(64) | ✗ |  |
| `label` | nvarchar(254) | ✗ |  |
| `descr` | nvarchar(1000) | ✓ |  |
| `category` | nvarchar(64) | ✗ |  |
| `general_term` | tinyint | ✓ |  |
| `sort_order` | int | ✓ |  |
| `hidden` | tinyint | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |
| `label_lang` | nvarchar(254) | ✓ |  |
| `descr_lang` | nvarchar(1000) | ✓ |  |
| `parentcode` | nvarchar(64) | ✓ |  |

---

### lr_document_ext

**Full Name:** `LRSAdmin.lr_document_ext`  
**Type:** BASE TABLE

**Primary Keys:** `parent_id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `parent_id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `extended_comments` | nvarchar(2000) | ✓ |  |
| `extended_params` | nvarchar(1000) | ✓ |  |

---

### lr_extension_link

**Full Name:** `LRSAdmin.lr_extension_link`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `parent_class` | nvarchar(255) | ✗ |  |
| `child_class` | nvarchar(255) | ✗ |  |

---

### lr_fee_rate

**Full Name:** `LRSAdmin.lr_fee_rate`  
**Type:** BASE TABLE

**Primary Keys:** `Id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `Id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `fee_name` | numeric | ✗ |  |
| `transaction_type` | numeric | ✓ |  |
| `area` | numeric | ✓ |  |
| `size` | numeric | ✓ |  |
| `measuremente_unit_type` | numeric | ✓ |  |
| `location` | numeric | ✓ |  |
| `land_use_type_category` | numeric | ✓ |  |
| `land_use_type` | numeric | ✓ |  |
| `size_range_upper_bound` | numeric | ✓ |  |
| `size_range_lower_bound` | numeric | ✓ |  |
| `size_range_type` | numeric | ✓ |  |
| `rate_type` | numeric | ✓ |  |
| `rate` | numeric | ✓ |  |
| `id_fee_structure` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `fee_name` | `LRSAdmin.lr_dictionary.Id` |
| `area` | `LRSAdmin.lr_dictionary.Id` |
| `location` | `LRSAdmin.lr_dictionary.Id` |
| `rate_type` | `LRSAdmin.lr_dictionary.Id` |
| `transaction_type` | `LRSAdmin.lr_transaction_metadata.Id` |
| `size_range_type` | `LRSAdmin.lr_dictionary.Id` |
| `land_use_type_category` | `LRSAdmin.lr_dictionary.Id` |
| `land_use_type` | `LRSAdmin.lr_dictionary.Id` |
| `measuremente_unit_type` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_fee_structure

**Full Name:** `LRSAdmin.lr_fee_structure`  
**Type:** BASE TABLE

**Primary Keys:** `Id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `Id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `fee_name` | numeric | ✗ |  |
| `is_transaction_type` | tinyint | ✓ |  |
| `is_property_area` | tinyint | ✓ |  |
| `is_property_size` | tinyint | ✓ |  |
| `is_property_location` | tinyint | ✓ |  |
| `is_property_land_use_type_category` | tinyint | ✓ |  |
| `is_property_land_use_type` | tinyint | ✓ |  |
| `is_size_range` | tinyint | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `fee_name` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_formfield

**Full Name:** `LRSAdmin.lr_formfield`  
**Type:** BASE TABLE

**Primary Keys:** `Id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `Id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `form_name` | nvarchar(64) | ✗ |  |
| `class_name` | nvarchar(64) | ✗ |  |
| `attribute_name` | nvarchar(64) | ✗ |  |
| `xsd_type` | nvarchar(64) | ✗ |  |
| `data_length` | int | ✓ |  |
| `caption` | nvarchar(128) | ✓ |  |
| `mandatory` | tinyint | ✓ |  |
| `category` | nvarchar(64) | ✓ |  |
| `mru` | tinyint | ✓ |  |
| `format` | nvarchar(255) | ✓ |  |
| `format_sample` | nvarchar(64) | ✓ |  |
| `attribute_precision` | int | ✓ |  |
| `enabled_for` | nvarchar(255) | ✓ |  |
| `readonly_for` | nvarchar(255) | ✓ |  |
| `validation_rule` | nvarchar(255) | ✓ |  |
| `condition_rule` | nvarchar(1500) | ✓ |  |
| `multiline` | tinyint | ✓ |  |
| `language` | nvarchar(5) | ✓ |  |
| `monolingual` | tinyint | ✓ |  |
| `group_name` | nvarchar(255) | ✓ |  |
| `ins_position` | nvarchar(1) | ✓ |  |
| `description` | nvarchar(512) | ✓ |  |

---

### lr_ground_rent

**Full Name:** `LRSAdmin.lr_ground_rent`  
**Type:** BASE TABLE

**Primary Keys:** `Id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `Id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `propertyNumber` | nvarchar(50) | ✗ |  |
| `paidYear` | nvarchar(10) | ✗ |  |
| `amount` | float | ✓ |  |
| `paidSum` | float | ✓ |  |

---

### lr_incoming_document

**Full Name:** `LRSAdmin.lr_incoming_document`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `establish_right` | tinyint | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `id` | `LRSAdmin.lr_source_document.id` |

---

### lr_individual

**Full Name:** `LRSAdmin.lr_individual`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `first_name` | nvarchar(150) | ✓ |  |
| `second_name` | nvarchar(150) | ✓ |  |
| `last_name` | nvarchar(150) | ✓ |  |
| `last_name2` | nvarchar(150) | ✓ |  |
| `gender` | numeric | ✗ |  |
| `salutation` | numeric | ✗ |  |
| `civil_state` | numeric | ✗ |  |
| `profession` | numeric | ✗ |  |
| `occupation` | nvarchar(50) | ✓ |  |
| `clan_name` | nvarchar(30) | ✓ |  |
| `father_name` | nvarchar(50) | ✓ |  |
| `grandfather_name` | nvarchar(50) | ✓ |  |
| `paye_number` | nvarchar(50) | ✓ |  |
| `indiv1` | nvarchar(50) | ✓ |  |
| `indiv2` | nvarchar(50) | ✓ |  |
| `indiv_dict1` | numeric | ✗ |  |
| `indiv_dict2` | numeric | ✗ |  |
| `driver_licence_region` | numeric | ✗ |  |
| `driver_licence_number` | nvarchar(20) | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `civil_state` | `LRSAdmin.lr_dictionary.Id` |
| `indiv_dict2` | `LRSAdmin.lr_dictionary.Id` |
| `id` | `LRSAdmin.lr_person.id` |
| `indiv_dict1` | `LRSAdmin.lr_dictionary.Id` |
| `profession` | `LRSAdmin.lr_dictionary.Id` |
| `gender` | `LRSAdmin.lr_dictionary.Id` |
| `driver_licence_region` | `LRSAdmin.lr_dictionary.Id` |
| `salutation` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_launit

**Full Name:** `LRSAdmin.lr_launit`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `unit_uid` | nvarchar(50) | ✓ |  |
| `old_property_id` | nvarchar(50) | ✓ |  |
| `tenure_type` | numeric | ✗ |  |
| `name` | nvarchar(250) | ✓ |  |
| `rental_amount` | float | ✓ |  |
| `build_value` | float | ✓ |  |
| `build_term` | int | ✓ |  |
| `register_type` | nvarchar(100) | ✓ |  |
| `purpose_clause` | nvarchar(50) | ✓ |  |
| `reg_date` | datetime | ✓ |  |
| `volumefolio` | nvarchar(50) | ✓ |  |
| `cert_numbers` | nvarchar(1500) | ✓ |  |
| `is_exists` | tinyint | ✓ |  |
| `legal_description` | nvarchar(2000) | ✓ |  |
| `note` | nvarchar(2000) | ✓ |  |
| `transaction_cancel` | nvarchar(50) | ✓ |  |
| `archive_date` | datetime | ✓ |  |
| `lau_date1` | datetime | ✓ |  |
| `lau_date2` | datetime | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |
| `source_id` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `tenure_type` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_launit_lineage

**Full Name:** `LRSAdmin.lr_launit_lineage`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `child_id` | numeric | ✓ |  |
| `parent_id` | numeric | ✓ |  |
| `child_uid` | nvarchar(50) | ✓ |  |
| `parent_uid` | nvarchar(50) | ✗ |  |
| `transaction_number` | nvarchar(50) | ✓ |  |
| `transaction_cancel` | nvarchar(50) | ✓ |  |
| `archive_date` | datetime | ✓ |  |

---

### lr_launit_spatial_unit

**Full Name:** `LRSAdmin.lr_launit_spatial_unit`  
**Type:** BASE TABLE

**Primary Keys:** `launit`, `unit_index`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `launit` | numeric | ✗ |  |
| `spatial_unit` | numeric | ✗ |  |
| `unit_index` | int | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `spatial_unit` | `LRSAdmin.lr_spatial_unit.id` |
| `launit` | `LRSAdmin.lr_launit.id` |

---

### lr_mc_job

**Full Name:** `LRSAdmin.lr_mc_job`  
**Type:** BASE TABLE

**Primary Keys:** `Id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `Id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `job_instance_id` | numeric | ✗ |  |
| `job_id` | numeric | ✗ |  |
| `job_priority` | numeric | ✗ |  |
| `job_name` | nvarchar(250) | ✓ |  |
| `job_status` | int | ✓ |  |
| `job_started` | datetime | ✓ |  |
| `job_updated` | datetime | ✓ |  |
| `job_ended` | datetime | ✓ |  |
| `job_comments` | nvarchar(800) | ✓ |  |
| `job_parameters` | nvarchar(2000) | ✓ |  |
| `transaction_id` | numeric | ✗ |  |

---

### lr_mortgage

**Full Name:** `LRSAdmin.lr_mortgage`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `amount` | float | ✓ |  |
| `interest_rate` | float | ✓ |  |
| `ranking` | int | ✓ |  |
| `mortgage_type` | numeric | ✗ |  |
| `mrg1` | nvarchar(50) | ✓ |  |
| `mrg2` | nvarchar(50) | ✓ |  |
| `mrg_dict1` | numeric | ✗ |  |
| `mrg_dict2` | numeric | ✗ |  |
| `party` | numeric | ✓ |  |
| `right_id` | numeric | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `party` | `LRSAdmin.lr_party.id` |
| `mortgage_type` | `LRSAdmin.lr_dictionary.Id` |
| `right_id` | `LRSAdmin.lr_rrr.id` |
| `mrg_dict2` | `LRSAdmin.lr_dictionary.Id` |
| `mrg_dict1` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_parcel

**Full Name:** `LRSAdmin.lr_parcel`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `actual_use_type` | numeric | ✗ |  |
| `land_type` | numeric | ✓ |  |
| `land_category` | numeric | ✗ |  |
| `land_purpose` | numeric | ✗ |  |
| `survey_plan_no` | nvarchar(50) | ✓ |  |
| `survey_type` | numeric | ✗ |  |
| `survey_date` | datetime | ✓ |  |
| `parcel_number` | nvarchar(4) | ✓ |  |
| `survey_name` | nvarchar(32) | ✓ |  |
| `boundaries_description` | nvarchar(800) | ✓ |  |
| `adjacents` | nvarchar(500) | ✓ |  |
| `use_typespecific` | nvarchar(50) | ✓ |  |
| `parc1` | nvarchar(50) | ✓ |  |
| `parc2` | nvarchar(50) | ✓ |  |
| `parc_dict1` | numeric | ✗ |  |
| `parc_dict2` | numeric | ✗ |  |
| `parc_date1` | datetime | ✓ |  |
| `parc_date2` | datetime | ✓ |  |
| `parc_count1` | int | ✓ |  |
| `parc_count2` | int | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `land_type` | `LRSAdmin.lr_dictionary.Id` |
| `id` | `LRSAdmin.lr_spatial_unit.id` |
| `survey_type` | `LRSAdmin.lr_dictionary.Id` |
| `land_category` | `LRSAdmin.lr_dictionary.Id` |
| `land_purpose` | `LRSAdmin.lr_dictionary.Id` |
| `actual_use_type` | `LRSAdmin.lr_dictionary.Id` |
| `parc_dict1` | `LRSAdmin.lr_dictionary.Id` |
| `parc_dict2` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_party

**Full Name:** `LRSAdmin.lr_party`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `party_type` | numeric | ✗ |  |
| `party_role_type` | numeric | ✗ |  |
| `name` | nvarchar(250) | ✓ |  |
| `name2` | nvarchar(250) | ✓ |  |
| `person` | numeric | ✓ |  |
| `share_nominator` | int | ✓ |  |
| `share_denominator` | int | ✓ |  |
| `share_description` | nvarchar(250) | ✓ |  |
| `shares` | nvarchar(255) | ✓ |  |
| `share_type` | numeric | ✗ |  |
| `tax_exempt` | tinyint | ✓ |  |
| `title_holder` | tinyint | ✓ |  |
| `cert_no` | nvarchar(100) | ✓ |  |
| `unit_uid` | nvarchar(500) | ✓ |  |
| `ruid` | numeric | ✓ |  |
| `part1` | nvarchar(50) | ✓ |  |
| `part2` | nvarchar(50) | ✓ |  |
| `part_dict1` | numeric | ✗ |  |
| `part_dict2` | numeric | ✗ |  |
| `comments` | nvarchar(800) | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |
| `source_id` | numeric | ✓ |  |
| `previous_id` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `share_type` | `LRSAdmin.lr_dictionary.Id` |
| `party_role_type` | `LRSAdmin.lr_dictionary.Id` |
| `party_type` | `LRSAdmin.lr_dictionary.Id` |
| `part_dict1` | `LRSAdmin.lr_dictionary.Id` |
| `person` | `LRSAdmin.lr_person.id` |
| `part_dict2` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_party_contact

**Full Name:** `LRSAdmin.lr_party_contact`  
**Type:** BASE TABLE

**Primary Keys:** `contact`, `contact_index`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `contact` | numeric | ✗ |  |
| `party` | numeric | ✗ |  |
| `contact_index` | int | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `party` | `LRSAdmin.lr_person.id` |
| `contact` | `LRSAdmin.lr_party.id` |

---

### lr_party_ext

**Full Name:** `LRSAdmin.lr_party_ext`  
**Type:** BASE TABLE

**Primary Keys:** `parent_id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `parent_id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `extended_comments` | nvarchar(2000) | ✓ |  |
| `extended_params` | nvarchar(1000) | ✓ |  |

---

### lr_party_group

**Full Name:** `LRSAdmin.lr_party_group`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `group_type` | numeric | ✗ |  |
| `address` | numeric | ✓ |  |
| `fax` | nvarchar(64) | ✓ |  |
| `email` | nvarchar(64) | ✓ |  |
| `phone1_number` | nvarchar(20) | ✓ |  |
| `phone1_extension` | nvarchar(5) | ✓ |  |
| `phone1_type` | numeric | ✗ |  |
| `phone2_number` | nvarchar(20) | ✓ |  |
| `phone2_extension` | nvarchar(5) | ✓ |  |
| `phone2_type` | numeric | ✗ |  |
| `phone3_number` | nvarchar(20) | ✓ |  |
| `phone3_extension` | nvarchar(5) | ✓ |  |
| `phone3_type` | numeric | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `phone1_type` | `LRSAdmin.lr_dictionary.Id` |
| `id` | `LRSAdmin.lr_party.id` |
| `phone2_type` | `LRSAdmin.lr_dictionary.Id` |
| `address` | `LRSAdmin.lr_address.id` |
| `phone3_type` | `LRSAdmin.lr_dictionary.Id` |
| `group_type` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_party_launit

**Full Name:** `LRSAdmin.lr_party_launit`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `launit` | numeric | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `id` | `LRSAdmin.lr_party.id` |
| `launit` | `LRSAdmin.lr_launit.id` |

---

### lr_party_member

**Full Name:** `LRSAdmin.lr_party_member`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `share_nominator` | int | ✓ |  |
| `share_denominator` | int | ✓ |  |
| `party_ref` | numeric | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |
| `group_ref` | numeric | ✓ |  |
| `member_index` | int | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `group_ref` | `LRSAdmin.lr_party.id` |
| `party_ref` | `LRSAdmin.lr_party.id` |

---

### lr_payment

**Full Name:** `LRSAdmin.lr_payment`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `transaction_number` | nvarchar(50) | ✓ |  |
| `is_paid` | tinyint | ✓ |  |
| `invoice_number` | nvarchar(50) | ✓ |  |
| `receipt_number` | numeric | ✓ |  |
| `payment_type` | numeric | ✗ |  |
| `payment_date` | datetime | ✓ |  |
| `payment_status` | numeric | ✗ |  |
| `receipt_no` | nvarchar(30) | ✓ |  |
| `internal_receipt_no` | nvarchar(30) | ✓ |  |
| `bank_type` | numeric | ✗ |  |
| `bank_name` | nvarchar(50) | ✓ |  |
| `account_name` | nvarchar(50) | ✓ |  |
| `account_number` | nvarchar(30) | ✓ |  |
| `paid_sum` | float | ✓ |  |
| `balance_owed` | float | ✓ |  |
| `penalty` | float | ✓ |  |
| `paid_year` | int | ✓ |  |
| `create_date` | datetime | ✓ |  |
| `begin_date` | datetime | ✓ |  |
| `end_date` | datetime | ✓ |  |
| `pay_period_year` | int | ✓ |  |
| `pay_period_month` | int | ✓ |  |
| `comments` | nvarchar(800) | ✓ |  |
| `pm1` | nvarchar(50) | ✓ |  |
| `pm2` | nvarchar(50) | ✓ |  |
| `pm_dict1` | numeric | ✗ |  |
| `pm_dict2` | numeric | ✗ |  |
| `pm_date1` | datetime | ✓ |  |
| `pm_date2` | datetime | ✓ |  |
| `pm_count1` | int | ✓ |  |
| `pm_count2` | int | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |
| `batch_id` | numeric | ✓ |  |
| `batch_index` | int | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `batch_id` | `LRSAdmin.lr_batch.id` |
| `pm_dict1` | `LRSAdmin.lr_dictionary.Id` |
| `payment_status` | `LRSAdmin.lr_dictionary.Id` |
| `payment_type` | `LRSAdmin.lr_dictionary.Id` |
| `bank_type` | `LRSAdmin.lr_dictionary.Id` |
| `pm_dict2` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_payment_transaction

**Full Name:** `LRSAdmin.lr_payment_transaction`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `calculated_fee` | float | ✓ |  |
| `manual_fee` | float | ✓ |  |
| `transaction_params` | nvarchar(2000) | ✓ |  |
| `receipt_no` | nvarchar(30) | ✓ |  |
| `payment_type` | numeric | ✗ |  |
| `payment_date` | datetime | ✓ |  |
| `bank_type` | numeric | ✗ |  |
| `bank_name` | nvarchar(50) | ✓ |  |
| `account_name` | nvarchar(50) | ✓ |  |
| `account_number` | nvarchar(30) | ✓ |  |
| `paid_sum` | float | ✓ |  |
| `penalty` | float | ✓ |  |
| `paid_year` | int | ✓ |  |
| `pay_transaction_id` | float | ✓ |  |
| `transaction_code` | nvarchar(50) | ✓ |  |
| `create_date` | datetime | ✓ |  |
| `begin_date` | datetime | ✓ |  |
| `end_date` | datetime | ✓ |  |
| `pay_period_year` | int | ✓ |  |
| `pay_period_month` | int | ✓ |  |
| `comments` | nvarchar(800) | ✓ |  |
| `pmt1` | nvarchar(50) | ✓ |  |
| `pmt2` | nvarchar(50) | ✓ |  |
| `pmt_dict1` | numeric | ✗ |  |
| `pmt_dict2` | numeric | ✗ |  |
| `pmt_date1` | datetime | ✓ |  |
| `pmt_date2` | datetime | ✓ |  |
| `pmt_count1` | int | ✓ |  |
| `pmt_count2` | int | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |
| `demandnotice_number` | nvarchar(12) | ✓ |  |
| `property_number` | nvarchar(255) | ✓ |  |
| `payment` | numeric | ✓ |  |
| `payment_index` | int | ✓ |  |
| `transaction_id` | numeric | ✓ |  |
| `transaction_index` | int | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `payment` | `LRSAdmin.lr_payment.id` |
| `pmt_dict2` | `LRSAdmin.lr_dictionary.Id` |
| `transaction_id` | `LRSAdmin.lr_transaction.id` |
| `payment_type` | `LRSAdmin.lr_dictionary.Id` |
| `bank_type` | `LRSAdmin.lr_dictionary.Id` |
| `pmt_dict1` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_person

**Full Name:** `LRSAdmin.lr_person`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `address` | numeric | ✓ |  |
| `person_type` | numeric | ✗ |  |
| `person_id_type` | numeric | ✗ |  |
| `person_id_number` | nvarchar(64) | ✓ |  |
| `person_id_date` | datetime | ✓ |  |
| `person_id_issue` | nvarchar(255) | ✓ |  |
| `tin` | nvarchar(50) | ✓ |  |
| `fax` | nvarchar(64) | ✓ |  |
| `email` | nvarchar(64) | ✓ |  |
| `phone1_number` | nvarchar(20) | ✓ |  |
| `phone1_extension` | nvarchar(5) | ✓ |  |
| `phone1_type` | numeric | ✗ |  |
| `phone2_number` | nvarchar(20) | ✓ |  |
| `phone2_extension` | nvarchar(5) | ✓ |  |
| `phone2_type` | numeric | ✗ |  |
| `phone3_number` | nvarchar(20) | ✓ |  |
| `phone3_extension` | nvarchar(5) | ✓ |  |
| `phone3_type` | numeric | ✗ |  |
| `birth_date` | datetime | ✓ |  |
| `pers1` | nvarchar(50) | ✓ |  |
| `pers2` | nvarchar(50) | ✓ |  |
| `pers_dict1` | numeric | ✗ |  |
| `pers_dict2` | numeric | ✗ |  |
| `pers_cost1` | float | ✓ |  |
| `pers_cost2` | float | ✓ |  |
| `pers_count1` | int | ✓ |  |
| `pers_count2` | int | ✓ |  |
| `pers_date1` | datetime | ✓ |  |
| `pers_date2` | datetime | ✓ |  |
| `is_submiter` | tinyint | ✓ |  |
| `submiter` | nvarchar(800) | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |
| `source_id` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `phone1_type` | `LRSAdmin.lr_dictionary.Id` |
| `person_type` | `LRSAdmin.lr_dictionary.Id` |
| `pers_dict1` | `LRSAdmin.lr_dictionary.Id` |
| `phone2_type` | `LRSAdmin.lr_dictionary.Id` |
| `address` | `LRSAdmin.lr_address.id` |
| `pers_dict2` | `LRSAdmin.lr_dictionary.Id` |
| `person_id_type` | `LRSAdmin.lr_dictionary.Id` |
| `phone3_type` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_process_event

**Full Name:** `LRSAdmin.lr_process_event`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `event_type` | numeric | ✗ |  |
| `event_date` | datetime | ✓ |  |
| `description` | nvarchar(800) | ✓ |  |
| `actor` | nvarchar(50) | ✓ |  |
| `history` | numeric | ✓ |  |
| `event_index` | int | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `event_type` | `LRSAdmin.lr_dictionary.Id` |
| `history` | `LRSAdmin.lr_process_history.id` |

---

### lr_process_history

**Full Name:** `LRSAdmin.lr_process_history`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `process_id` | numeric | ✓ |  |
| `process_name` | nvarchar(255) | ✓ |  |
| `task_id` | numeric | ✓ |  |
| `task_name` | nvarchar(255) | ✓ |  |
| `task_description` | nvarchar(255) | ✓ |  |
| `task_create` | datetime | ✓ |  |
| `task_complete` | datetime | ✓ |  |
| `task_transition` | nvarchar(255) | ✓ |  |
| `actor` | nvarchar(255) | ✓ |  |
| `duration` | numeric | ✓ |  |
| `transaction_id` | numeric | ✓ |  |

---

### lr_registry

**Full Name:** `LRSAdmin.lr_registry`  
**Type:** BASE TABLE

**Primary Keys:** `Id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `Id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `code` | nvarchar(32) | ✗ |  |
| `description` | nvarchar(255) | ✗ |  |
| `lodgment_class` | nvarchar(255) | ✗ |  |
| `transaction_class` | nvarchar(255) | ✗ |  |

---

### lr_registry_office

**Full Name:** `LRSAdmin.lr_registry_office`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `string_code` | nvarchar(10) | ✓ |  |
| `digital_code` | int | ✓ |  |
| `office_name` | nvarchar(100) | ✓ |  |
| `office_type` | nvarchar(100) | ✓ |  |
| `address` | nvarchar(255) | ✓ |  |
| `head_name` | nvarchar(100) | ✓ |  |
| `phone` | nvarchar(255) | ✓ |  |
| `fax` | nvarchar(64) | ✓ |  |
| `email` | nvarchar(64) | ✓ |  |
| `web_site` | nvarchar(255) | ✓ |  |
| `main` | tinyint | ✓ |  |
| `active` | tinyint | ✓ |  |
| `comments` | nvarchar(800) | ✓ |  |

---

### lr_rejection

**Full Name:** `LRSAdmin.lr_rejection`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `rejection_date` | datetime | ✓ |  |
| `comments` | datetime | ✓ |  |
| `lodgment_id` | numeric | ✓ |  |

---

### lr_rejection_reason

**Full Name:** `LRSAdmin.lr_rejection_reason`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `reason_type` | numeric | ✗ |  |
| `comments` | nvarchar(2000) | ✓ |  |
| `rejection_id` | numeric | ✓ |  |
| `rejection_index` | int | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `rejection_id` | `LRSAdmin.lr_rejection.id` |
| `reason_type` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_rental_amount_revision

**Full Name:** `LRSAdmin.lr_rental_amount_revision`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `effective_date` | datetime | ✗ |  |
| `annual_rental_amount` | float | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |
| `property_number` | nvarchar(50) | ✗ |  |

---

### lr_replicationcontent

**Full Name:** `LRSAdmin.lr_replicationcontent`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `node_path` | nvarchar(254) | ✗ |  |
| `parent_path` | nvarchar(254) | ✗ |  |
| `package` | numeric | ✓ |  |
| `create_date` | datetime | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `package` | `LRSAdmin.lr_replicationpackage.id` |

---

### lr_replicationlog

**Full Name:** `LRSAdmin.lr_replicationlog`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `package` | numeric | ✓ |  |
| `batch_id` | numeric | ✗ |  |
| `entity_id` | numeric | ✗ |  |
| `entity_classname` | nvarchar(128) | ✗ |  |
| `logged_at` | datetime | ✗ |  |
| `uploaded_at` | datetime | ✓ |  |
| `uploaded` | tinyint | ✓ |  |
| `repeat_number` | int | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `package` | `LRSAdmin.lr_replicationpackage.id` |

---

### lr_replicationpackage

**Full Name:** `LRSAdmin.lr_replicationpackage`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `package_name` | nvarchar(128) | ✗ |  |
| `status` | numeric | ✗ |  |
| `modify_date` | datetime | ✗ |  |
| `create_date` | datetime | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `status` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_rrr

**Full Name:** `LRSAdmin.lr_rrr`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `rrr_type` | numeric | ✗ |  |
| `transaction_source` | nvarchar(50) | ✓ |  |
| `transaction_cancel` | nvarchar(50) | ✓ |  |
| `share_nominator` | int | ✓ |  |
| `share_denominator` | int | ✓ |  |
| `description` | nvarchar(1500) | ✓ |  |
| `time_spec` | datetime | ✓ |  |
| `start_date` | datetime | ✓ |  |
| `expiration_date` | datetime | ✓ |  |
| `end_date` | datetime | ✓ |  |
| `term_year` | int | ✓ |  |
| `term_month` | int | ✓ |  |
| `condition_approved_by` | nvarchar(100) | ✓ |  |
| `condition_approved_on` | datetime | ✓ |  |
| `right1` | nvarchar(50) | ✓ |  |
| `right2` | nvarchar(50) | ✓ |  |
| `party` | numeric | ✓ |  |
| `la_unit` | numeric | ✓ |  |
| `create_date` | datetime | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |
| `source_id` | numeric | ✓ |  |
| `pay_period_year` | int | ✓ |  |
| `term_day` | int | ✓ |  |
| `consideration` | float | ✓ |  |
| `consideration_currency` | numeric | ✓ |  |
| `rental_amount` | float | ✓ |  |
| `build_value` | float | ✓ |  |
| `improvement_amount_currency` | numeric | ✓ |  |
| `build_term` | int | ✓ |  |
| `security_number_1` | nvarchar(255) | ✓ |  |
| `security_number_2` | nvarchar(255) | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `party` | `LRSAdmin.lr_party.id` |
| `rrr_type` | `LRSAdmin.lr_rrr_metadata.Id` |
| `la_unit` | `LRSAdmin.lr_launit.id` |
| `consideration_currency` | `LRSAdmin.lr_dictionary.Id` |
| `improvement_amount_currency` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_rrr_billing

**Full Name:** `LRSAdmin.lr_rrr_billing`  
**Type:** BASE TABLE

**Primary Keys:** `rrr`, `rrr_index`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `rrr` | numeric | ✗ |  |
| `billing` | numeric | ✗ |  |
| `rrr_index` | int | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `rrr` | `LRSAdmin.lr_rrr.id` |
| `billing` | `LRSAdmin.lr_billing.id` |

---

### lr_rrr_condition

**Full Name:** `LRSAdmin.lr_rrr_condition`  
**Type:** BASE TABLE

**Primary Keys:** `rrr`, `rrr_index`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `rrr` | numeric | ✗ |  |
| `condition` | numeric | ✗ |  |
| `rrr_index` | int | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `condition` | `LRSAdmin.lr_condition.id` |
| `rrr` | `LRSAdmin.lr_rrr.id` |

---

### lr_rrr_deleted

**Full Name:** `LRSAdmin.lr_rrr_deleted`  
**Type:** BASE TABLE

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `rrr_type` | numeric | ✗ |  |
| `transaction_source` | nvarchar(50) | ✓ |  |
| `transaction_cancel` | nvarchar(50) | ✓ |  |
| `share_nominator` | int | ✓ |  |
| `share_denominator` | int | ✓ |  |
| `description` | nvarchar(1500) | ✓ |  |
| `time_spec` | datetime | ✓ |  |
| `start_date` | datetime | ✓ |  |
| `expiration_date` | datetime | ✓ |  |
| `end_date` | datetime | ✓ |  |
| `term_year` | int | ✓ |  |
| `term_month` | int | ✓ |  |
| `condition_approved_by` | nvarchar(100) | ✓ |  |
| `condition_approved_on` | datetime | ✓ |  |
| `right1` | nvarchar(50) | ✓ |  |
| `right2` | nvarchar(50) | ✓ |  |
| `party` | numeric | ✓ |  |
| `la_unit` | numeric | ✓ |  |
| `create_date` | datetime | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |
| `source_id` | numeric | ✓ |  |
| `pay_period_year` | int | ✓ |  |
| `term_day` | int | ✓ |  |
| `consideration` | float | ✓ |  |
| `consideration_currency` | numeric | ✓ |  |
| `rental_amount` | float | ✓ |  |
| `build_value` | float | ✓ |  |
| `improvement_amount_currency` | numeric | ✓ |  |
| `build_term` | int | ✓ |  |
| `security_number_1` | nvarchar(255) | ✓ |  |
| `security_number_2` | nvarchar(255) | ✓ |  |

---

### lr_rrr_metadata

**Full Name:** `LRSAdmin.lr_rrr_metadata`  
**Type:** BASE TABLE

**Primary Keys:** `Id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `Id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `code` | nvarchar(64) | ✗ |  |
| `label` | nvarchar(254) | ✗ |  |
| `descr` | nvarchar(1000) | ✓ |  |
| `category` | nvarchar(64) | ✗ |  |
| `general_term` | tinyint | ✓ |  |
| `sort_order` | int | ✓ |  |
| `hidden` | tinyint | ✓ |  |
| `rrr_type` | int | ✗ |  |
| `action_type` | int | ✗ |  |
| `can_expire` | tinyint | ✗ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |

---

### lr_rrr_patched

**Full Name:** `LRSAdmin.lr_rrr_patched`  
**Type:** BASE TABLE

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✓ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `rrr_type` | numeric | ✗ |  |
| `transaction_source` | nvarchar(50) | ✓ |  |
| `transaction_cancel` | nvarchar(50) | ✓ |  |
| `share_nominator` | int | ✓ |  |
| `share_denominator` | int | ✓ |  |
| `description` | nvarchar(1500) | ✓ |  |
| `time_spec` | datetime | ✓ |  |
| `start_date` | datetime | ✓ |  |
| `expiration_date` | datetime | ✓ |  |
| `end_date` | datetime | ✓ |  |
| `term_year` | int | ✓ |  |
| `term_month` | int | ✓ |  |
| `condition_approved_by` | nvarchar(100) | ✓ |  |
| `condition_approved_on` | datetime | ✓ |  |
| `right1` | nvarchar(50) | ✓ |  |
| `right2` | nvarchar(50) | ✓ |  |
| `party` | numeric | ✗ |  |
| `la_unit` | numeric | ✓ |  |
| `create_date` | datetime | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |
| `source_id` | numeric | ✓ |  |
| `pay_period_year` | int | ✓ |  |
| `term_day` | int | ✓ |  |
| `consideration` | float | ✓ |  |
| `rental_amount` | float | ✓ |  |
| `build_value` | float | ✓ |  |
| `build_term` | int | ✓ |  |
| `security_number_1` | nvarchar(255) | ✓ |  |
| `security_number_2` | nvarchar(255) | ✓ |  |
| `consideration_currency` | numeric | ✓ |  |
| `improvement_amount_currency` | numeric | ✓ |  |

---

### lr_setting

**Full Name:** `LRSAdmin.lr_setting`  
**Type:** BASE TABLE

**Primary Keys:** `Id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `Id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `category` | nvarchar(64) | ✗ |  |
| `name` | nvarchar(150) | ✗ |  |
| `value` | nvarchar(1000) | ✗ |  |
| `description` | nvarchar(1000) | ✓ |  |

---

### lr_simplecounter

**Full Name:** `LRSAdmin.lr_simplecounter`  
**Type:** BASE TABLE

**Primary Keys:** `Id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `Id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `counter` | nvarchar(255) | ✗ |  |
| `value` | numeric | ✗ |  |
| `office_prefix` | tinyint | ✓ |  |
| `digital_prefix` | tinyint | ✓ |  |
| `digital_length` | int | ✗ |  |
| `modify_date` | datetime | ✓ |  |
| `with_rollback` | tinyint | ✓ |  |
| `own_prefix` | nvarchar(5) | ✓ |  |
| `reset_new_year` | tinyint | ✓ |  |
| `advance_config` | nvarchar(255) | ✓ |  |

---

### lr_simplecounter_pool

**Full Name:** `LRSAdmin.lr_simplecounter_pool`  
**Type:** BASE TABLE

**Primary Keys:** `Id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `Id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `counter` | nvarchar(255) | ✗ |  |
| `value` | numeric | ✗ |  |
| `ref_number` | nvarchar(255) | ✓ |  |
| `modify_date` | datetime | ✓ |  |

---

### lr_site_analysis

**Full Name:** `LRSAdmin.lr_site_analysis`  
**Type:** BASE TABLE

**Primary Keys:** `Id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `Id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `neighbourhood` | nvarchar(50) | ✓ |  |
| `max_high_allow` | numeric | ✓ |  |
| `devlopment_status` | numeric | ✓ |  |
| `density` | numeric | ✓ |  |
| `with_planning_schema` | tinyint | ✓ |  |
| `tps_nopta_number` | nvarchar(50) | ✓ |  |
| `max_area_development` | float | ✓ |  |
| `topography` | numeric | ✓ |  |
| `soli_condition` | numeric | ✓ |  |
| `access_road_status` | numeric | ✓ |  |
| `hierachy_road` | nvarchar(50) | ✓ |  |
| `federal_road_access` | tinyint | ✓ |  |
| `access_road_width` | float | ✓ |  |
| `access_road_terminate` | tinyint | ✓ |  |
| `development_hinder_future_development` | tinyint | ✓ |  |
| `proximity_to_school` | float | ✓ |  |
| `proximity_to_hospital` | float | ✓ |  |
| `proximity_to_shop` | float | ✓ |  |
| `proximity_to_worship` | float | ✓ |  |
| `proximity_to_sportarena` | float | ✓ |  |
| `proximity_to_office` | float | ✓ |  |
| `proximity_to_industry` | float | ✓ |  |
| `proximity_to_other` | float | ✓ |  |
| `proximity_comment` | nvarchar(800) | ✓ |  |
| `proximity_to_utility` | float | ✓ |  |
| `proximity_to_electricity` | float | ✓ |  |
| `capacity` | float | ✓ |  |
| `proximity_to_Water` | float | ✓ |  |
| `proximity_to_nnpc` | float | ✓ |  |
| `proximity_to_telephone` | float | ✓ |  |
| `proximity_further_comment` | nvarchar(800) | ✓ |  |
| `distance_to_lake` | float | ✓ |  |
| `distance_to_mountain` | float | ✓ |  |
| `distance_to_quarry` | float | ✓ |  |
| `distance_to_river` | float | ✓ |  |
| `distance_to_gully` | float | ✓ |  |
| `distance_to_railway` | float | ✓ |  |
| `distance_to_expressway` | float | ✓ |  |
| `distance_to_others` | float | ✓ |  |
| `distance_to_feature_comment` | nvarchar(800) | ✓ |  |
| `setback_building1` | float | ✓ |  |
| `setback_building1_land_use` | numeric | ✓ |  |
| `setback_building2` | float | ✓ |  |
| `setback_building2_land_use` | numeric | ✓ |  |
| `setback_building3` | float | ✓ |  |
| `setback_building3_land_use` | numeric | ✓ |  |
| `setback_building4` | float | ✓ |  |
| `setback_building4_land_use` | numeric | ✓ |  |
| `setback_access_road` | float | ✓ |  |
| `setback_other_comment` | nvarchar(800) | ✓ |  |
| `household_utility_access` | tinyint | ✓ |  |
| `conformity_of_development` | nvarchar(50) | ✓ |  |
| `fencing_encourage` | tinyint | ✓ |  |
| `fencing_type` | nvarchar(50) | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `devlopment_status` | `LRSAdmin.lr_dictionary.Id` |
| `setback_building3_land_use` | `LRSAdmin.lr_dictionary.Id` |
| `setback_building2_land_use` | `LRSAdmin.lr_dictionary.Id` |
| `setback_building1_land_use` | `LRSAdmin.lr_dictionary.Id` |
| `topography` | `LRSAdmin.lr_dictionary.Id` |
| `access_road_status` | `LRSAdmin.lr_dictionary.Id` |
| `soli_condition` | `LRSAdmin.lr_dictionary.Id` |
| `density` | `LRSAdmin.lr_dictionary.Id` |
| `max_high_allow` | `LRSAdmin.lr_dictionary.Id` |
| `setback_building4_land_use` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_source_document

**Full Name:** `LRSAdmin.lr_source_document`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `document_number` | nvarchar(50) | ✓ |  |
| `ref_number` | nvarchar(50) | ✓ |  |
| `minute_number` | nvarchar(50) | ✓ |  |
| `document_type` | numeric | ✗ |  |
| `duplicate` | tinyint | ✓ |  |
| `access_type` | numeric | ✗ |  |
| `acceptance` | datetime | ✓ |  |
| `recordation` | datetime | ✓ |  |
| `submission` | datetime | ✓ |  |
| `issued_by` | nvarchar(500) | ✓ |  |
| `page_count` | int | ✓ |  |
| `comments` | nvarchar(800) | ✓ |  |
| `create_date` | datetime | ✓ |  |
| `modified_at` | datetime | ✓ |  |
| `modified_by` | nvarchar(255) | ✓ |  |
| `property_file_page` | nvarchar(50) | ✓ |  |
| `sdoc1` | nvarchar(50) | ✓ |  |
| `sdoc2` | nvarchar(50) | ✓ |  |
| `sdoc_dict1` | numeric | ✗ |  |
| `sdoc_dict2` | numeric | ✗ |  |
| `sdoc_count1` | int | ✓ |  |
| `sdoc_count2` | int | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `access_type` | `LRSAdmin.lr_dictionary.Id` |
| `sdoc_dict1` | `LRSAdmin.lr_dictionary.Id` |
| `sdoc_dict2` | `LRSAdmin.lr_dictionary.Id` |
| `document_type` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_spatial_unit

**Full Name:** `LRSAdmin.lr_spatial_unit`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `suid` | nvarchar(50) | ✓ |  |
| `old_property_id` | nvarchar(50) | ✓ |  |
| `tenure_type` | numeric | ✗ |  |
| `label` | nvarchar(250) | ✓ |  |
| `note` | nvarchar(500) | ✓ |  |
| `comments` | nvarchar(800) | ✓ |  |
| `spatial_unit_type` | numeric | ✗ |  |
| `status` | numeric | ✗ |  |
| `property_kind` | numeric | ✓ |  |
| `purpose` | numeric | ✗ |  |
| `zone` | numeric | ✗ |  |
| `layout` | numeric | ✗ |  |
| `block_name` | nvarchar(50) | ✓ |  |
| `refnum` | nvarchar(60) | ✓ |  |
| `upin` | nvarchar(30) | ✓ |  |
| `su_number` | nvarchar(30) | ✓ |  |
| `local_number` | nvarchar(30) | ✓ |  |
| `block_number` | nvarchar(50) | ✓ |  |
| `lot_number` | nvarchar(50) | ✓ |  |
| `plan_number` | nvarchar(40) | ✓ |  |
| `tracing_number` | nvarchar(32) | ✓ |  |
| `specific` | nvarchar(50) | ✓ |  |
| `volume` | nvarchar(20) | ✓ |  |
| `folio` | nvarchar(20) | ✓ |  |
| `volumefolio` | nvarchar(150) | ✓ |  |
| `is_exists` | tinyint | ✓ |  |
| `area` | float | ✓ |  |
| `area_unit_type` | numeric | ✗ |  |
| `area_planned` | float | ✓ |  |
| `areapl_unit_type` | numeric | ✗ |  |
| `area_buildings` | float | ✓ |  |
| `areabld_unit_type` | numeric | ✗ |  |
| `percent_covered` | float | ✓ |  |
| `balance_date` | datetime | ✓ |  |
| `balance_sum` | float | ✓ |  |
| `spatial_value1` | float | ✓ |  |
| `spatial_date1` | datetime | ✓ |  |
| `spatial_value2` | float | ✓ |  |
| `spatial_date2` | datetime | ✓ |  |
| `rec1` | nvarchar(50) | ✓ |  |
| `rec2` | nvarchar(50) | ✓ |  |
| `rec_dict1` | numeric | ✗ |  |
| `rec_dict2` | numeric | ✗ |  |
| `cost1` | float | ✓ |  |
| `cost2` | float | ✓ |  |
| `count1` | int | ✓ |  |
| `count2` | int | ✓ |  |
| `spu_date` | datetime | ✓ |  |
| `subdivision` | nvarchar(128) | ✓ |  |
| `transaction_cancel` | nvarchar(50) | ✓ |  |
| `archive_date` | datetime | ✓ |  |
| `address` | numeric | ✓ |  |
| `restrictions` | nvarchar(1500) | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |
| `source_id` | numeric | ✓ |  |
| `SiteAnalysis` | numeric | ✓ |  |
| `property_area` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `address` | `LRSAdmin.lr_address.id` |
| `status` | `LRSAdmin.lr_dictionary.Id` |
| `property_kind` | `LRSAdmin.lr_dictionary.Id` |
| `rec_dict2` | `LRSAdmin.lr_dictionary.Id` |
| `rec_dict1` | `LRSAdmin.lr_dictionary.Id` |
| `purpose` | `LRSAdmin.lr_dictionary.Id` |
| `spatial_unit_type` | `LRSAdmin.lr_dictionary.Id` |
| `layout` | `LRSAdmin.lr_dictionary.Id` |
| `areabld_unit_type` | `LRSAdmin.lr_dictionary.Id` |
| `zone` | `LRSAdmin.lr_dictionary.Id` |
| `tenure_type` | `LRSAdmin.lr_dictionary.Id` |
| `SiteAnalysis` | `LRSAdmin.lr_site_analysis.Id` |
| `area_unit_type` | `LRSAdmin.lr_dictionary.Id` |
| `areapl_unit_type` | `LRSAdmin.lr_dictionary.Id` |
| `property_area` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_spatial_unit_ext

**Full Name:** `LRSAdmin.lr_spatial_unit_ext`  
**Type:** BASE TABLE

**Primary Keys:** `parent_id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `parent_id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `extended_comments` | nvarchar(2000) | ✓ |  |
| `extended_params` | nvarchar(1000) | ✓ |  |

---

### lr_spatial_unit_member

**Full Name:** `LRSAdmin.lr_spatial_unit_member`  
**Type:** BASE TABLE

**Primary Keys:** `parent_unit`, `unit_index`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `parent_unit` | numeric | ✗ |  |
| `child_unit` | numeric | ✗ |  |
| `unit_index` | int | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `parent_unit` | `LRSAdmin.lr_spatial_unit.id` |
| `child_unit` | `LRSAdmin.lr_spatial_unit.id` |

---

### lr_survey_plan

**Full Name:** `LRSAdmin.lr_survey_plan`  
**Type:** BASE TABLE

**Primary Keys:** `Id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `Id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `plan_number` | nvarchar(40) | ✓ |  |
| `local_government_area` | numeric | ✓ |  |
| `zone` | numeric | ✗ |  |
| `layout` | numeric | ✗ |  |
| `city` | nvarchar(100) | ✓ |  |
| `cell` | nvarchar(100) | ✓ |  |
| `ward` | nvarchar(100) | ✓ |  |
| `district_text` | nvarchar(100) | ✓ |  |
| `region` | numeric | ✗ |  |
| `country` | numeric | ✗ |  |
| `surveyor_plan_no` | nvarchar(50) | ✓ |  |
| `area` | float | ✓ |  |
| `area_unit_type` | numeric | ✗ |  |
| `survey_start_date` | datetime | ✓ |  |
| `survey_end_date` | datetime | ✓ |  |
| `surveyor_name` | nvarchar(32) | ✓ |  |
| `tracing_number` | nvarchar(32) | ✓ |  |
| `approval_date` | datetime | ✓ |  |
| `survey_type` | numeric | ✗ |  |
| `plots_Amount` | int | ✗ |  |
| `terrain_type` | numeric | ✗ |  |
| `beacon_amount_re_establish` | int | ✗ |  |
| `beacon_amount_perimeter` | int | ✗ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |
| `surveyor_type` | numeric | ✗ |  |
| `comments` | nvarchar(2000) | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `layout` | `LRSAdmin.lr_dictionary.Id` |
| `survey_type` | `LRSAdmin.lr_dictionary.Id` |
| `surveyor_type` | `LRSAdmin.lr_dictionary.Id` |
| `zone` | `LRSAdmin.lr_dictionary.Id` |
| `local_government_area` | `LRSAdmin.lr_dictionary.Id` |
| `country` | `LRSAdmin.lr_dictionary.Id` |
| `region` | `LRSAdmin.lr_dictionary.Id` |
| `terrain_type` | `LRSAdmin.lr_dictionary.Id` |
| `area_unit_type` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_taxation

**Full Name:** `LRSAdmin.lr_taxation`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `tax_amount` | float | ✓ |  |
| `tax_type` | numeric | ✗ |  |
| `tax_date` | datetime | ✓ |  |
| `comments` | nvarchar(800) | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `tax_type` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_tempcounter

**Full Name:** `LRSAdmin.lr_tempcounter`  
**Type:** BASE TABLE

**Primary Keys:** `Id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `Id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `counter` | numeric | ✗ |  |
| `value_text` | nvarchar(255) | ✗ |  |
| `ref_number` | nvarchar(255) | ✓ |  |
| `transaction_id` | numeric | ✓ |  |
| `transaction_index` | int | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `transaction_id` | `LRSAdmin.lr_transaction.id` |
| `counter` | `LRSAdmin.lr_simplecounter.Id` |

---

### lr_transaction

**Full Name:** `LRSAdmin.lr_transaction`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `transaction_number` | nvarchar(50) | ✓ |  |
| `transaction_type` | numeric | ✓ |  |
| `transaction_status` | numeric | ✗ |  |
| `transaction_source` | numeric | ✗ |  |
| `source_property_ids` | nvarchar(500) | ✓ |  |
| `target_property_ids` | nvarchar(500) | ✓ |  |
| `old_property_id` | nvarchar(50) | ✓ |  |
| `parent_property_ids` | nvarchar(500) | ✓ |  |
| `tenure_type` | numeric | ✗ |  |
| `is_search_oldfile` | tinyint | ✓ |  |
| `registration_fee` | float | ✓ |  |
| `consideration` | float | ✓ |  |
| `interest_money` | float | ✓ |  |
| `create_date` | datetime | ✓ |  |
| `complete_date` | datetime | ✓ |  |
| `start_date` | datetime | ✓ |  |
| `expiration_date` | datetime | ✓ |  |
| `sign_date` | datetime | ✓ |  |
| `registration_date` | datetime | ✓ |  |
| `application_date` | datetime | ✓ |  |
| `firstpay_date` | datetime | ✓ |  |
| `balance_date` | datetime | ✓ |  |
| `balance_sum` | float | ✓ |  |
| `partial` | tinyint | ✓ |  |
| `pageNumber` | nvarchar(16) | ✓ |  |
| `cert_nos` | nvarchar(255) | ✓ |  |
| `term_year` | int | ✓ |  |
| `term_month` | int | ✓ |  |
| `term_year_ext` | int | ✓ |  |
| `term_month_ext` | int | ✓ |  |
| `lease_extension` | numeric | ✗ |  |
| `lease_duration` | numeric | ✗ |  |
| `duration` | int | ✓ |  |
| `build_term` | int | ✓ |  |
| `build_value` | float | ✓ |  |
| `pay_period_year` | int | ✓ |  |
| `pay_period_month` | int | ✓ |  |
| `volume` | nvarchar(20) | ✓ |  |
| `folio` | nvarchar(20) | ✓ |  |
| `volume_linked` | nvarchar(20) | ✓ |  |
| `folio_linked` | nvarchar(20) | ✓ |  |
| `recordingno` | nvarchar(30) | ✓ |  |
| `internal_receipt_no` | nvarchar(30) | ✓ |  |
| `serial_number` | nvarchar(30) | ✓ |  |
| `general_number` | nvarchar(50) | ✓ |  |
| `related_number` | nvarchar(50) | ✓ |  |
| `related_page_number` | nvarchar(50) | ✓ |  |
| `related_volume` | nvarchar(50) | ✓ |  |
| `deed_case` | numeric | ✗ |  |
| `related_instr_number` | nvarchar(50) | ✓ |  |
| `lodgment_number` | nvarchar(50) | ✓ |  |
| `boxno` | nvarchar(20) | ✓ |  |
| `special_condition` | nvarchar(50) | ✓ |  |
| `inscription` | nvarchar(800) | ✓ |  |
| `inscription2` | nvarchar(800) | ✓ |  |
| `reg_initials` | nvarchar(20) | ✓ |  |
| `blockplot` | nvarchar(200) | ✓ |  |
| `volumefolio` | nvarchar(150) | ✓ |  |
| `filetype` | numeric | ✗ |  |
| `region` | numeric | ✗ |  |
| `district` | numeric | ✗ |  |
| `is_delivered` | tinyint | ✓ |  |
| `is_right_required` | tinyint | ✓ |  |
| `is_inactive` | tinyint | ✓ |  |
| `is_mem_transaction` | tinyint | ✓ |  |
| `comments` | nvarchar(800) | ✓ |  |
| `site_analysis` | nvarchar(800) | ✓ |  |
| `inspection_officer` | nvarchar(50) | ✓ |  |
| `gis_params` | nvarchar(800) | ✓ |  |
| `tran1` | nvarchar(50) | ✓ |  |
| `tran2` | nvarchar(50) | ✓ |  |
| `tran_date1` | datetime | ✓ |  |
| `tran_date2` | datetime | ✓ |  |
| `tran_dict1` | numeric | ✗ |  |
| `tran_dict2` | numeric | ✗ |  |
| `tran_cost1` | float | ✓ |  |
| `tran_cost2` | float | ✓ |  |
| `tran_count1` | int | ✓ |  |
| `tran_count2` | int | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |
| `demandnotice_number` | nvarchar(12) | ✓ |  |
| `batch` | numeric | ✓ |  |
| `transaction_index` | int | ✓ |  |
| `term_day` | int | ✓ |  |
| `consideration_currency` | numeric | ✓ |  |
| `temp_consideration` | nvarchar(30) | ✓ |  |
| `improvement_amount_currency` | numeric | ✓ |  |
| `data_corrected_transaction_number` | nvarchar(50) | ✓ |  |
| `data_corrected_transaction_type` | numeric | ✓ |  |
| `data_corrected_comments` | nvarchar(800) | ✓ |  |
| `data_corrected_create_date` | datetime | ✓ |  |
| `data_corrected_complete_date` | datetime | ✓ |  |
| `recommendation_memorandum` | nvarchar(800) | ✓ |  |
| `SurveyPlan` | numeric | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `transaction_type` | `LRSAdmin.lr_transaction_metadata.Id` |
| `transaction_source` | `LRSAdmin.lr_dictionary.Id` |
| `lease_extension` | `LRSAdmin.lr_dictionary.Id` |
| `batch` | `LRSAdmin.lr_batch.id` |
| `tran_dict1` | `LRSAdmin.lr_dictionary.Id` |
| `lease_duration` | `LRSAdmin.lr_dictionary.Id` |
| `tran_dict2` | `LRSAdmin.lr_dictionary.Id` |
| `tenure_type` | `LRSAdmin.lr_dictionary.Id` |
| `filetype` | `LRSAdmin.lr_dictionary.Id` |
| `transaction_status` | `LRSAdmin.lr_dictionary.Id` |
| `region` | `LRSAdmin.lr_dictionary.Id` |
| `deed_case` | `LRSAdmin.lr_dictionary.Id` |
| `district` | `LRSAdmin.lr_dictionary.Id` |
| `consideration_currency` | `LRSAdmin.lr_dictionary.Id` |
| `data_corrected_transaction_type` | `LRSAdmin.lr_transaction_metadata.Id` |
| `improvement_amount_currency` | `LRSAdmin.lr_dictionary.Id` |
| `SurveyPlan` | `LRSAdmin.lr_survey_plan.Id` |

---

### lr_transaction_document

**Full Name:** `LRSAdmin.lr_transaction_document`  
**Type:** BASE TABLE

**Primary Keys:** `transaction_id`, `document_index`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `transaction_id` | numeric | ✗ |  |
| `document_id` | numeric | ✗ |  |
| `document_index` | int | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `document_id` | `LRSAdmin.lr_source_document.id` |
| `transaction_id` | `LRSAdmin.lr_transaction.id` |

---

### lr_transaction_ext

**Full Name:** `LRSAdmin.lr_transaction_ext`  
**Type:** BASE TABLE

**Primary Keys:** `parent_id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `parent_id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `extended_comments` | nvarchar(2000) | ✓ |  |
| `extended_params` | nvarchar(1000) | ✓ |  |
| `NonExistingPropertiesSearch` | nvarchar(1000) | ✓ |  |
| `CountPropertiesSearch` | numeric | ✓ |  |

---

### lr_transaction_launit

**Full Name:** `LRSAdmin.lr_transaction_launit`  
**Type:** BASE TABLE

**Primary Keys:** `transaction_id`, `launit_index`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `transaction_id` | numeric | ✗ |  |
| `launit_id` | numeric | ✗ |  |
| `launit_index` | int | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `launit_id` | `LRSAdmin.lr_launit.id` |
| `transaction_id` | `LRSAdmin.lr_transaction.id` |

---

### lr_transaction_metadata

**Full Name:** `LRSAdmin.lr_transaction_metadata`  
**Type:** BASE TABLE

**Primary Keys:** `Id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `Id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `code` | nvarchar(64) | ✗ |  |
| `label` | nvarchar(128) | ✗ |  |
| `descr` | nvarchar(1000) | ✓ |  |
| `category` | nvarchar(64) | ✗ |  |
| `general_term` | tinyint | ✓ |  |
| `sort_order` | int | ✓ |  |
| `hidden` | tinyint | ✓ |  |
| `group_name` | nvarchar(255) | ✓ |  |
| `workflow` | nvarchar(255) | ✓ |  |
| `group_code` | nvarchar(3) | ✓ |  |
| `normal_duration` | numeric | ✓ |  |
| `lapsed_duration` | numeric | ✓ |  |
| `max_duration` | numeric | ✓ |  |
| `right_type` | nvarchar(64) | ✓ |  |
| `meta_type` | int | ✗ |  |
| `action_type` | int | ✗ |  |
| `source_party_type` | nvarchar(255) | ✓ |  |
| `target_party_type` | nvarchar(255) | ✓ |  |
| `related_transaction_code` | nvarchar(64) | ✓ |  |
| `blocking_transaction_code` | nvarchar(2000) | ✓ |  |
| `non_withdrawable_tasks` | nvarchar(500) | ✓ |  |
| `cashier_transaction_code` | nvarchar(500) | ✓ |  |
| `mandatory_docs_codes` | nvarchar(255) | ✓ |  |
| `complete_reports_codes` | nvarchar(1000) | ✓ |  |
| `reject_reports_codes` | nvarchar(1000) | ✓ |  |
| `report_templates` | nvarchar(1000) | ✓ |  |
| `detachable` | tinyint | ✓ |  |
| `related_active_rrrs` | nvarchar(500) | ✓ |  |
| `blocked_by_active_rrrs` | nvarchar(500) | ✓ |  |
| `discharge_active_rrrs` | nvarchar(500) | ✓ |  |
| `modify_active_rrrs` | nvarchar(500) | ✓ |  |
| `create_new_rrrs` | nvarchar(500) | ✓ |  |
| `retrieve_source_parties` | nvarchar(255) | ✓ |  |
| `retrieve_target_parties` | nvarchar(255) | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |
| `stamp_duty` | nvarchar(255) | ✓ |  |
| `cashier_code_based_on_source` | nvarchar(500) | ✓ |  |
| `mandatory_scan_outgoing_document_codes` | varchar(500) | ✓ |  |

---

### lr_transaction_note

**Full Name:** `LRSAdmin.lr_transaction_note`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `note_type` | numeric | ✗ |  |
| `comments` | nvarchar(800) | ✓ |  |
| `user_name` | nvarchar(150) | ✓ |  |
| `task_id` | numeric | ✓ |  |
| `task_name` | nvarchar(250) | ✓ |  |
| `comment_ref` | nvarchar(250) | ✓ |  |
| `create_date` | datetime | ✓ |  |
| `transaction_id` | numeric | ✓ |  |
| `note_index` | int | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `transaction_id` | `LRSAdmin.lr_transaction.id` |
| `note_type` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_transaction_party

**Full Name:** `LRSAdmin.lr_transaction_party`  
**Type:** BASE TABLE

**Primary Keys:** `transaction_id`, `party_index`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `transaction_id` | numeric | ✗ |  |
| `party_id` | numeric | ✗ |  |
| `party_index` | int | ✗ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `party_id` | `LRSAdmin.lr_party.id` |
| `transaction_id` | `LRSAdmin.lr_transaction.id` |

---

### lr_transaction_record

**Full Name:** `LRSAdmin.lr_transaction_record`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `operation_type` | numeric | ✗ |  |
| `source_rrr` | numeric | ✓ |  |
| `target_rrr` | numeric | ✓ |  |
| `transaction_id` | numeric | ✓ |  |
| `record_index` | int | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `transaction_id` | `LRSAdmin.lr_transaction.id` |
| `operation_type` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_usage

**Full Name:** `LRSAdmin.lr_usage`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `usage_type` | numeric | ✗ |  |
| `comments` | nvarchar(800) | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `usage_type` | `LRSAdmin.lr_dictionary.Id` |

---

### lr_valuation

**Full Name:** `LRSAdmin.lr_valuation`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `Hjtype` | nvarchar(255) | ✗ |  |
| `value` | float | ✓ |  |
| `value_type` | numeric | ✗ |  |
| `value_date` | datetime | ✓ |  |
| `comments` | nvarchar(800) | ✓ |  |
| `valu1` | nvarchar(50) | ✓ |  |
| `valu2` | nvarchar(50) | ✓ |  |
| `valu_dict1` | numeric | ✗ |  |
| `valu_dict2` | numeric | ✗ |  |
| `valu_date1` | datetime | ✓ |  |
| `valu_date2` | datetime | ✓ |  |
| `valu_count1` | int | ✓ |  |
| `valu_count2` | int | ✓ |  |
| `suid` | nvarchar(50) | ✓ |  |
| `transaction_number` | nvarchar(50) | ✓ |  |
| `version` | numeric | ✓ |  |
| `begin_lifespan_version` | datetime | ✓ |  |
| `end_lifespan_version` | datetime | ✓ |  |

**Foreign Keys:**

| Column | References |
|--------|------------|
| `value_type` | `LRSAdmin.lr_dictionary.Id` |
| `valu_dict1` | `LRSAdmin.lr_dictionary.Id` |
| `valu_dict2` | `LRSAdmin.lr_dictionary.Id` |

---

### sdms_bootstrap

**Full Name:** `LRSAdmin.sdms_bootstrap`  
**Type:** BASE TABLE

**Primary Keys:** `id`

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `resource_name` | nvarchar(255) | ✗ |  |
| `res_version` | int | ✗ |  |
| `created` | datetime | ✗ |  |
| `modified` | datetime | ✗ |  |
| `is_model` | tinyint | ✗ |  |
| `resource_type` | nvarchar(255) | ✓ |  |

---

### tqb_transaction_type

**Full Name:** `LRSAdmin.tqb_transaction_type`  
**Type:** VIEW

**Columns:**

| Column | Type | Nullable | Default |
|--------|------|----------|----------|
| `id` | numeric | ✗ |  |
| `label` | nvarchar(128) | ✗ |  |

---