@@ -12,14 +12,16 @@
classification.name as classification,
bridge.name as child_relationship,
authorized_rel.name as auth_relationship,
authorized_parent.name as auth_parent
authorized_parent.name as auth_parent,
res.name as grouping_agency
from ruleform.attribute_network_authorization auth
join ruleform.attribute classification on auth.classification = classification.id
join ruleform.relationship classifier on auth.classifier = classifier.id
join ruleform.relationship bridge on auth.child_relationship = bridge.id
join ruleform.attribute authorized_parent on auth.authorized_parent = authorized_parent.id
join ruleform.relationship authorized_rel on auth.authorized_relationship = authorized_rel.id;
left join ruleform.relationship bridge on auth.child_relationship = bridge.id
left join ruleform.attribute authorized_parent on auth.authorized_parent = authorized_parent.id
left join ruleform.relationship authorized_rel on auth.authorized_relationship = authorized_rel.id
left join ruleform.agency res on auth.grouping_agency = res.id
]]>
</createView>
<rollback>
@@ -12,6 +12,7 @@
cls.name AS classifier,
b.name AS classification,
att.name AS authorized_attribute,
natt.name AS authorized_network_attribute,
base_table.sequence_number,
base_table.text_value,
base_table.integer_value,
@@ -24,9 +25,9 @@
LEFT JOIN agency res ON base_table.grouping_agency = res.id
LEFT JOIN relationship cls ON na.classifier = cls.id
LEFT JOIN attribute att ON base_table.authorized_attribute = att.id
LEFT JOIN attribute natt ON base_table.authorized_network_attribute = natt.id
LEFT JOIN agency b ON na.classification = b.id
LEFT JOIN agency up ON base_table.updated_by = up.id
WHERE base_table.authorized_attribute IS NOT NULL;
]]>
</createView>
<rollback>

This file was deleted.

@@ -12,17 +12,16 @@
classification.name as classification,
bridge.name as child_relationship,
authorized_rel.name as auth_relationship,
authorized_parent.name as auth_parent
authorized_parent.name as auth_parent,
res.name as grouping_agency
from ruleform.interval_network_authorization auth
join ruleform.interval classification on auth.classification = classification.id
join ruleform.relationship classifier on auth.classifier = classifier.id
join ruleform.relationship bridge on auth.child_relationship = bridge.id
join ruleform.interval authorized_parent on auth.authorized_parent = authorized_parent.id
join ruleform.relationship authorized_rel on auth.authorized_relationship = authorized_rel.id;
ALTER TABLE readable.interval_network_authorization
OWNER TO core;
left join ruleform.relationship bridge on auth.child_relationship = bridge.id
left join ruleform.interval authorized_parent on auth.authorized_parent = authorized_parent.id
left join ruleform.relationship authorized_rel on auth.authorized_relationship = authorized_rel.id
left join ruleform.agency res on auth.grouping_agency = res.id
]]>
</createView>
<rollback>
@@ -12,6 +12,7 @@
cls.name AS classifier,
b.name AS classification,
att.name AS authorized_attribute,
natt.name AS authorized_network_attribute,
base_table.sequence_number,
base_table.text_value,
base_table.integer_value,
@@ -25,8 +26,8 @@
LEFT JOIN relationship cls ON na.classifier = cls.id
LEFT JOIN location b ON na.classification = b.id
LEFT JOIN attribute att ON base_table.authorized_attribute = att.id
LEFT JOIN attribute natt ON base_table.authorized_network_attribute = natt.id
LEFT JOIN agency up ON base_table.updated_by = up.id
WHERE base_table.authorized_attribute IS NOT NULL
]]>
</createView>
<rollback>

This file was deleted.

@@ -12,14 +12,16 @@
classification.name as classification,
bridge.name as child_relationship,
authorized_rel.name as auth_relationship,
authorized_parent.name as auth_parent
authorized_parent.name as auth_parent,
res.name as grouping_agency
from ruleform.location_network_authorization auth
join ruleform.location classification on auth.classification = classification.id
join ruleform.relationship classifier on auth.classifier = classifier.id
join ruleform.relationship bridge on auth.child_relationship = bridge.id
join ruleform.location authorized_parent on auth.authorized_parent = authorized_parent.id
join ruleform.relationship authorized_rel on auth.authorized_relationship = authorized_rel.id;
left join ruleform.relationship bridge on auth.child_relationship = bridge.id
left join ruleform.location authorized_parent on auth.authorized_parent = authorized_parent.id
left join ruleform.relationship authorized_rel on auth.authorized_relationship = authorized_rel.id
left join ruleform.agency res on auth.grouping_agency = res.id
]]>
</createView>
<rollback>
@@ -12,6 +12,7 @@
cls.name AS classifier,
b.name AS classification,
att.name AS authorized_attribute,
natt.name AS authorized_network_attribute,
base_table.sequence_number,
base_table.text_value,
base_table.integer_value,
@@ -25,8 +26,8 @@
LEFT JOIN relationship cls ON na.classifier = cls.id
LEFT JOIN product b ON na.classification = b.id
LEFT JOIN attribute att ON base_table.authorized_attribute = att.id
LEFT JOIN attribute natt ON base_table.authorized_network_attribute = natt.id
LEFT JOIN agency up ON base_table.updated_by = up.id
WHERE base_table.authorized_attribute IS NOT NULL
]]>
</createView>
<rollback>

This file was deleted.

@@ -12,14 +12,16 @@
classification.name as classification,
bridge.name as child_relationship,
authorized_rel.name as auth_relationship,
authorized_parent.name as auth_parent
authorized_parent.name as auth_parent,
res.name as grouping_agency
from ruleform.product_network_authorization auth
join ruleform.product classification on auth.classification = classification.id
join ruleform.relationship classifier on auth.classifier = classifier.id
join ruleform.relationship bridge on auth.child_relationship = bridge.id
join ruleform.product authorized_parent on auth.authorized_parent = authorized_parent.id
join ruleform.relationship authorized_rel on auth.authorized_relationship = authorized_rel.id
left join ruleform.relationship bridge on auth.child_relationship = bridge.id
left join ruleform.product authorized_parent on auth.authorized_parent = authorized_parent.id
left join ruleform.relationship authorized_rel on auth.authorized_relationship = authorized_rel.id
left join ruleform.agency res on auth.grouping_agency = res.id
]]>
</createView>
<rollback>
@@ -12,6 +12,7 @@
cls.name AS classifier,
b.name AS classification,
att.name AS authorized_attribute,
natt.name AS authorized_network_attribute,
base_table.sequence_number,
base_table.text_value,
base_table.integer_value,
@@ -25,8 +26,8 @@
LEFT JOIN relationship cls ON na.classifier = cls.id
LEFT JOIN relationship b ON na.classification = b.id
LEFT JOIN attribute att ON base_table.authorized_attribute = att.id
LEFT JOIN attribute natt ON base_table.authorized_network_attribute = natt.id
LEFT JOIN agency up ON base_table.updated_by = up.id
WHERE base_table.authorized_attribute IS NOT NULL
]]>
</createView>
<rollback>

This file was deleted.

@@ -12,14 +12,16 @@
classification.name as classification,
bridge.name as child_relationship,
authorized_rel.name as auth_relationship,
authorized_parent.name as auth_parent
authorized_parent.name as auth_parent,
res.name as grouping_agency
from ruleform.relationship_network_authorization auth
join ruleform.relationship classification on auth.classification = classification.id
join ruleform.relationship classifier on auth.classifier = classifier.id
join ruleform.relationship bridge on auth.child_relationship = bridge.id
join ruleform.relationship authorized_parent on auth.authorized_parent = authorized_parent.id
join ruleform.relationship authorized_rel on auth.authorized_relationship = authorized_rel.id
left join ruleform.relationship bridge on auth.child_relationship = bridge.id
left join ruleform.relationship authorized_parent on auth.authorized_parent = authorized_parent.id
left join ruleform.relationship authorized_rel on auth.authorized_relationship = authorized_rel.id
left join ruleform.agency res on auth.grouping_agency = res.id
]]>
</createView>
<rollback>
@@ -12,6 +12,7 @@
cls.name AS classifier,
b.name AS classification,
att.name AS authorized_attribute,
natt.name AS authorized_network_attribute,
base_table.sequence_number,
base_table.text_value,
base_table.integer_value,
@@ -25,8 +26,8 @@
LEFT JOIN relationship cls ON na.classifier = cls.id
LEFT JOIN status_code b ON na.classification = b.id
LEFT JOIN attribute att ON base_table.authorized_attribute = att.id
LEFT JOIN attribute natt ON base_table.authorized_network_attribute = natt.id
LEFT JOIN agency up ON base_table.updated_by = up.id
WHERE base_table.authorized_attribute IS NOT NULL
]]>
</createView>
<rollback>
@@ -12,14 +12,16 @@
classification.name as classification,
bridge.name as child_relationship,
authorized_rel.name as auth_relationship,
authorized_parent.name as auth_parent
authorized_parent.name as auth_parent,
res.name as grouping_agency
from ruleform.status_code_network_authorization auth
join ruleform.status_code classification on auth.classification = classification.id
join ruleform.relationship classifier on auth.classifier = classifier.id
join ruleform.relationship bridge on auth.child_relationship = bridge.id
join ruleform.status_code authorized_parent on auth.authorized_parent = authorized_parent.id
join ruleform.relationship authorized_rel on auth.authorized_relationship = authorized_rel.id
left join ruleform.relationship bridge on auth.child_relationship = bridge.id
left join ruleform.status_code authorized_parent on auth.authorized_parent = authorized_parent.id
left join ruleform.relationship authorized_rel on auth.authorized_relationship = authorized_rel.id
left join ruleform.agency res on auth.grouping_agency = res.id
]]>
</createView>
<rollback>
@@ -12,6 +12,7 @@
cls.name AS classifier,
b.name AS classification,
att.name AS authorized_attribute,
natt.name AS authorized_network_attribute,
base_table.sequence_number,
base_table.text_value,
base_table.integer_value,
@@ -25,8 +26,8 @@
LEFT JOIN relationship cls ON na.classifier = cls.id
LEFT JOIN unit b ON na.classification = b.id
LEFT JOIN attribute att ON base_table.authorized_attribute = att.id
LEFT JOIN attribute natt ON base_table.authorized_network_attribute = natt.id
LEFT JOIN agency up ON base_table.updated_by = up.id
WHERE base_table.authorized_attribute IS NOT NULL
]]>
</createView>
<rollback>
@@ -12,14 +12,16 @@
classification.name as classification,
bridge.name as child_relationship,
authorized_rel.name as auth_relationship,
authorized_parent.name as auth_parent
authorized_parent.name as auth_parent,
res.name as grouping_agency
from ruleform.unit_network_authorization auth
join ruleform.unit classification on auth.classification = classification.id
join ruleform.relationship classifier on auth.classifier = classifier.id
join ruleform.relationship bridge on auth.child_relationship = bridge.id
join ruleform.unit authorized_parent on auth.authorized_parent = authorized_parent.id
join ruleform.relationship authorized_rel on auth.authorized_relationship = authorized_rel.id
left join ruleform.relationship bridge on auth.child_relationship = bridge.id
left join ruleform.unit authorized_parent on auth.authorized_parent = authorized_parent.id
left join ruleform.relationship authorized_rel on auth.authorized_relationship = authorized_rel.id
left join ruleform.agency res on auth.grouping_agency = res.id
]]>
</createView>
<rollback>