Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| subdiv_parcel_intent_id | int8 | 19 | null | 
                                         | 
                                    
                                         | 
                                    System generated sequence number to uniquely identify a SUBDIV PARCEL INTENT  | 
                                |||||
| alr_appl_component_id | int8 | 19 | null | 
                                         | 
                                    
                                        
  | 
                                    System generated sequence number to uniquely identify an ALR APPL COMPONENT  | 
                                |||||
| parcel_area | float8 | 17,17 | null | 
                                         | 
                                    
                                         | 
                                    The surface area of the parcel to be created as the result of a subdivision proposed by the applicant or decided by the Commission  | 
                                |||||
| subdiv_design_parcel_id | int8 | 19 | √ | null | 
                                         | 
                                    
                                        
  | 
                                    System generated sequence number to uniquely identify a SUBDIV DESIGN PARCEL  | 
                                ||||
| who_created | varchar | 32 | null | 
                                         | 
                                    
                                         | 
                                    WHO CREATED is the IDIR or Oracle userid of the person who created the record.  | 
                                |||||
| when_created | timestamp | 29,6 | null | 
                                         | 
                                    
                                         | 
                                    WHEN CREATED is the date/time that the record was created.  | 
                                |||||
| who_updated | varchar | 32 | √ | null | 
                                         | 
                                    
                                         | 
                                    WHO UPDATED is the IDIR or Oracle userid of the person who last updated the record.  | 
                                ||||
| when_updated | timestamp | 29,6 | √ | null | 
                                         | 
                                    
                                         | 
                                    WHEN UPDATED is the date/time that the record was last updated.  | 
                                ||||
| revision_count | int8 | 19 | 0 | 
                                         | 
                                    
                                         | 
                                    REVISION COUNT is used by Hibernate to control optimistic locking  | 
                                
Indexes
| Constraint Name | Type | Sort | Column(s) | 
|---|---|---|---|
| oats_subdiv_parcel_intents_pkey | Primary key | Asc | subdiv_parcel_intent_id | 
| oats_sdpi_apcp_fk_i | Performance | Asc | alr_appl_component_id | 
| oats_sdpi_sddp_fk_i | Performance | Asc | subdiv_design_parcel_id | 

