Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| natl_regs_id | int identity | 4 | √ | null |
|
|
||||
| orgs_id | int | 4 | √ | null |
|
|
||||
| natl_reg_name | nvarchar | 200 | null |
|
|
|||||
| natl_reg_name_enum | int | 4 | null |
|
|
|||||
| natl_reg_service | nvarchar | 1000 | null |
|
|
|||||
| natl_reg_search_type | int | 4 | null |
|
|
|||||
| natl_reg_auth_type | int | 4 | null |
|
|
|||||
| natl_reg_auth_crt_hash | nvarchar | 200 | √ | null |
|
|
||||
| natl_reg_cust_id | nvarchar | 200 | null |
|
|
|||||
| natl_reg_ord_id | nvarchar | 200 | null |
|
|
|||||
| natl_reg_priority | bit | 1 | √ | null |
|
|
||||
| natl_reg_hsa_id | nvarchar | 200 | √ | null |
|
|
||||
| natl_reg_hsa_base | nvarchar | 1000 | √ | null |
|
|
||||
| natl_reg_hsa_base_end_entity | nvarchar | 1000 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_natl_regs_id | Primary key | Asc | natl_regs_id |