Table sola_cs.administrative.notation
Notations (a.k.a memorials) are text that summarise the affect a transaction has to a property/title. SOLA automatically creates template notations for every RRR change.
Tags: FLOSS SOLA Extension, Change History

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id varchar 40 Identifier for the notation.
ba_unit_id varchar 40  √  null
ba_unit.id notation_ba_unit_id_fk75 C
Identifier of the BA Unit the notation is associated with. Only populated if the notation is linked directly to the BA Unit. NULL if the notation is associated with an RRR.
rrr_id varchar 40  √  null
rrr.id notation_rrr_id_fk76 C
Identifier of the RRR the notation is assocaited with. Must not be populated if ba_unit_id is populated.
transaction_id varchar 40
transaction.id notation_transaction_id_fk73 C
Identifier of the transaction that created the notation.
reference_nr varchar 15 The notation reference number. Value determined using the generate-notation-reference-nr business rule.
notation_text varchar 1000  √  null The text of the notation. Note that template notation text can be obtained from the request type (i.e. service) the notation has been created as part of.
notation_date timestamp 29,6  √  null The date the notation is formalised/registered.
status_code varchar 20 'pending'::character varying
reg_status_type.code notation_status_code_fk74 R
The status of the notation.
rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the notation_historic table
rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
change_action bpchar 1 'i'::bpchar Indicates if the last data modification action that occurred to the row was insert (i), update (u) or delete (d).
change_user varchar 50  √  null The user id of the last person to modify the row.
change_time timestamp 29,6 now() The date and time the row was last modified.
classification_code varchar 20  √  null FROM SOLA State Land Extension: The security classification for this Notation. Only users with the security classification (or a higher classification) will be able to view the record. If null, the record is considered unrestricted.
redact_code varchar 20  √  null FROM SOLA State Land Extension: The redact classification for this Notation. Only users with the redact classification (or a higher classification) will be able to view the record with un-redacted fields. If null, the record is considered unrestricted and no redaction to the record will occur unless bulk redaction classifications have been set for fields of the record.

Analyzed at ?? ??? 16 22:00 ALMT 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc notation_pkey
ba_unit_id Performance Asc notation_ba_unit_id_fk75_ind
rowidentifier Performance Asc notation_index_on_rowidentifier
rrr_id Performance Asc notation_rrr_id_fk76_ind
status_code Performance Asc notation_status_code_fk74_ind
transaction_id Performance Asc notation_transaction_id_fk73_ind

Close relationships  within of separation:

Excluded from diagram's relationships: ba_unit.change_action  mortgage_isbased_in_rrr.change_time  ba_unit_contains_spatial_unit.rowversion  condition_for_rrr.change_user  mortgage_isbased_in_rrr.rowidentifier  rrr_share.rowversion  notifiable_party_for_baunit.change_time  rrr_share.change_action  ba_unit_target.change_action  rrr.change_user  ba_unit_contains_spatial_unit.rowidentifier  required_relationship_baunit.rowversion  condition_for_rrr.change_action  ba_unit_area.change_action  ba_unit.change_time  source_describes_ba_unit.change_time  source_describes_rrr.change_user  ba_unit_area.change_user  party_for_rrr.rowversion  ba_unit.change_user  source_describes_ba_unit.change_action  rrr_share.change_time  ba_unit_area.rowidentifier  mortgage_isbased_in_rrr.change_user  required_relationship_baunit.rowidentifier  rrr.rowversion  mortgage_isbased_in_rrr.change_action  source_describes_ba_unit.change_user  notifiable_party_for_baunit.change_action  ba_unit.rowidentifier  condition_for_rrr.change_time  rrr.change_action  ba_unit.rowversion  required_relationship_baunit.change_user  notifiable_party_for_baunit.change_user  condition_for_rrr.rowidentifier  condition_for_rrr.rowversion  source_describes_ba_unit.rowversion  rrr.rowidentifier  ba_unit_area.rowversion  ba_unit_contains_spatial_unit.change_action  notifiable_party_for_baunit.rowversion  party_for_rrr.rowidentifier  party_for_rrr.change_user  source_describes_rrr.change_action  ba_unit_target.rowidentifier  ba_unit_as_party.rowidentifier  ba_unit_contains_spatial_unit.change_user  rrr_share.change_user  ba_unit_area.change_time  party_for_rrr.change_action  source_describes_rrr.rowidentifier  ba_unit_target.change_time  ba_unit_contains_spatial_unit.change_time  notifiable_party_for_baunit.rowidentifier  source_describes_rrr.change_time  ba_unit_target.rowversion  source_describes_ba_unit.rowidentifier  required_relationship_baunit.change_action  source_describes_rrr.rowversion  party_for_rrr.change_time  rrr.change_time  ba_unit_target.change_user  rrr_share.rowidentifier  required_relationship_baunit.change_time  mortgage_isbased_in_rrr.rowversion