Difference between revisions of "Public.resourcereference (table)"

From dbscript Online Help
Jump to: navigation, search
 
(3 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| public.resourcereference
 
| public.resourcereference
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 17: Line 15:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| id
 
| id
 
| integer
 
| integer
 
| not null
 
| not null
| nextval('opennmsnxtid'::regclass)
 
 
|  
 
|  
|-
+
|
 +
|- valign="top"
 
| resourceid
 
| resourceid
 
| varchar(255)
 
| varchar(255)
Line 37: Line 35:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| pk_resourcereference_id
 
| pk_resourcereference_id
 
| id
 
| id
Line 48: Line 46:
 
| '''Type
 
| '''Type
 
| '''Columns
 
| '''Columns
+
 
|-
+
|- valign="top"
 
| resourcereference_resourceid
 
| resourcereference_resourceid
| Unique
+
|  
 
| resourceid
 
| resourceid
 
|}
 
|}
Line 61: Line 59:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
+
 
|-
+
|- valign="top"
 
| [[public.statisticsreportdata_(table)|public.statisticsreportdata]]
 
| [[public.statisticsreportdata_(table)|public.statisticsreportdata]]
 
| id
 
| id
 
| resourceid
 
| resourceid
 
|}
 
|}

Latest revision as of 10:25, 27 August 2011

wikibot[edit]

Table public.resourcereference

Columns[edit]

Column Data Type Nullable Default Description
id integer not null
resourceid varchar(255) not null

Primary Key[edit]

Primary Key Columns
pk_resourcereference_id id

Indexes[edit]

Index Type Columns
resourcereference_resourceid resourceid

Detail Tables[edit]

Detail Table Column Referencing Column
public.statisticsreportdata id resourceid