Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| seedlot_audit_id | serial | 10 | √ | nextval('spar.seedlot_audit_seedlot_audit_id_seq'::regclass) |
|
|
Serial Incremental number referring to a unique primary key for this table |
||||
| audit_date | timestamp | 29,6 | now() |
|
|
Date when this audit record was created (representing with some precision when the statement was executed) |
|||||
| spar_audit_code | varchar | 1 | 'I'::character varying |
|
|
Type of statement executed in spar.seedlot table: I=INSERT, U=UPDATE, D=DELETE. Note that DELETE record represents only the latest data whiped out from the seedlot table |
|||||
| db_user | text | 2147483647 | null |
|
|
Postgres database user who executed the statement in spar.seedlot table |
|||||
| audit_revision_version | int4 | 10 | 1 |
|
|
Record registered version for audit purposes. |
|||||
| seedlot_number | varchar | 5 | null |
|
|
Referring value for spar.seedlot.seedlot_number column |
|||||
| seedlot_status_code | varchar | 3 | null |
|
|
Referring value for spar.seedlot.seedlot_status_code column |
|||||
| applicant_client_number | varchar | 8 | √ | null |
|
|
Referring value for spar.seedlot.applicant_client_number column |
||||
| applicant_locn_code | varchar | 2 | √ | null |
|
|
Referring value for spar.seedlot.applicant_locn_code column |
||||
| applicant_email_address | varchar | 100 | √ | null |
|
|
Referring value for spar.seedlot.applicant_email_address column |
||||
| vegetation_code | varchar | 8 | √ | null |
|
|
Referring value for spar.seedlot.vegetation_code column |
||||
| genetic_class_code | varchar | 1 | √ | null |
|
|
Referring value for spar.seedlot.genetic_class_code column |
||||
| seedlot_source_code | varchar | 3 | √ | null |
|
|
Referring value for spar.seedlot.seedlot_source_code column |
||||
| to_be_registrd_ind | bool | 1 | √ | null |
|
|
Referring value for spar.seedlot.to_be_registrd_ind column |
||||
| bc_source_ind | bool | 1 | √ | null |
|
|
Referring value for spar.seedlot.bc_source_ind column |
||||
| collection_client_number | varchar | 8 | √ | null |
|
|
Referring value for spar.seedlot.collection_client_number column |
||||
| collection_locn_code | varchar | 2 | √ | null |
|
|
Referring value for spar.seedlot.collection_locn_code column |
||||
| collection_start_date | timestamp | 29,6 | √ | null |
|
|
Referring value for spar.seedlot.collection_start_date column |
||||
| collection_end_date | timestamp | 29,6 | √ | null |
|
|
Referring value for spar.seedlot.collection_end_date column |
||||
| no_of_containers | numeric | 6,2 | √ | null |
|
|
Referring value for spar.seedlot.no_of_containers column |
||||
| vol_per_container | numeric | 6,2 | √ | null |
|
|
Referring value for spar.seedlot.vol_per_container column |
||||
| clctn_volume | numeric | 6,2 | √ | null |
|
|
Referring value for spar.seedlot.clctn_volume column |
||||
| seedlot_comment | varchar | 2000 | √ | null |
|
|
Referring value for spar.seedlot.seedlot_comment column |
||||
| interm_strg_client_number | varchar | 8 | √ | null |
|
|
Referring value for spar.seedlot.interm_strg_client_number column |
||||
| interm_strg_locn_code | varchar | 2 | √ | null |
|
|
Referring value for spar.seedlot.interm_strg_locn_code column |
||||
| interm_strg_st_date | timestamp | 29,6 | √ | null |
|
|
Referring value for spar.seedlot.interm_strg_st_date column |
||||
| interm_strg_end_date | timestamp | 29,6 | √ | null |
|
|
Referring value for spar.seedlot.interm_strg_end_date column |
||||
| interm_facility_code | varchar | 3 | √ | null |
|
|
Referring value for spar.seedlot.interm_facility_code column |
||||
| female_gametic_mthd_code | varchar | 4 | √ | null |
|
|
Referring value for spar.seedlot.female_gametic_mthd_code column |
||||
| male_gametic_mthd_code | varchar | 4 | √ | null |
|
|
Referring value for spar.seedlot.male_gametic_mthd_code column |
||||
| controlled_cross_ind | bool | 1 | √ | null |
|
|
Referring value for spar.seedlot.controlled_cross_ind column |
||||
| biotech_processes_ind | bool | 1 | √ | null |
|
|
Referring value for spar.seedlot.biotech_processes_ind column |
||||
| pollen_contamination_ind | bool | 1 | √ | null |
|
|
Referring value for spar.seedlot.pollen_contamination_ind column |
||||
| pollen_contamination_pct | int4 | 10 | √ | null |
|
|
Referring value for spar.seedlot.pollen_contamination_pct column |
||||
| contaminant_pollen_bv | numeric | 4,1 | √ | null |
|
|
Referring value for spar.seedlot.contaminant_pollen_bv column |
||||
| pollen_contamination_mthd_code | varchar | 4 | √ | null |
|
|
Referring value for spar.seedlot.pollen_contamination_mthd_code column |
||||
| total_parent_trees | int4 | 10 | √ | null |
|
|
Referring value for spar.seedlot.total_parent_trees column |
||||
| smp_success_pct | int4 | 10 | √ | null |
|
|
Referring value for spar.seedlot.smp_success_pct column |
||||
| effective_pop_size | numeric | 5,1 | √ | null |
|
|
Referring value for spar.seedlot.effective_pop_size column |
||||
| smp_parents_outside | int4 | 10 | √ | null |
|
|
Referring value for spar.seedlot.smp_parents_outside column |
||||
| non_orchard_pollen_contam_pct | int4 | 10 | √ | null |
|
|
Referring value for spar.seedlot.non_orchard_pollen_contam_pct column |
||||
| extractory_client_number | varchar | 8 | √ | null |
|
|
Referring value for spar.seedlot.extractory_client_number column |
||||
| extractory_locn_code | varchar | 2 | √ | null |
|
|
Referring value for spar.seedlot.extractory_locn_code column |
||||
| extraction_st_date | timestamp | 29,6 | √ | null |
|
|
Referring value for spar.seedlot.extraction_st_date column |
||||
| extraction_end_date | timestamp | 29,6 | √ | null |
|
|
Referring value for spar.seedlot.extraction_end_date column |
||||
| temporary_strg_client_number | varchar | 8 | √ | null |
|
|
Referring value for spar.seedlot.temporary_strg_client_number column |
||||
| temporary_strg_locn_code | varchar | 2 | √ | null |
|
|
Referring value for spar.seedlot.temporary_strg_locn_code column |
||||
| temporary_strg_start_date | timestamp | 29,6 | √ | null |
|
|
Referring value for spar.seedlot.temporary_strg_start_date column |
||||
| temporary_strg_end_date | timestamp | 29,6 | √ | null |
|
|
Referring value for spar.seedlot.temporary_strg_end_date column |
||||
| interm_strg_locn | varchar | 55 | √ | null |
|
|
|||||
| declared_userid | varchar | 30 | √ | null |
|
|
Referring value for spar.seedlot.declared_userid column |
||||
| declared_timestamp | timestamp | 29,6 | √ | null |
|
|
Referring value for spar.seedlot.declared_timestamp column |
||||
| entry_userid | varchar | 30 | null |
|
|
Referring value for spar.seedlot.entry_userid column |
|||||
| entry_timestamp | timestamp | 29,6 | null |
|
|
Referring value for spar.seedlot.entry_timestamp column |
|||||
| update_userid | varchar | 30 | null |
|
|
Referring value for spar.seedlot.update_userid column |
|||||
| update_timestamp | timestamp | 29,6 | null |
|
|
Referring value for spar.seedlot.update_timestamp column |
|||||
| revision_count | int4 | 10 | null |
|
|
Referring value for spar.seedlot.revision_count column |
|||||
| seed_plan_unit_id | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.approved_timestamp column |
||||
| bgc_zone_code | varchar | 4 | √ | null |
|
|
Referring value for spar.seedlot.approved_userid column |
||||
| bgc_subzone_code | varchar | 3 | √ | null |
|
|
Referring value for spar.seedlot.bgc_subzone_code column |
||||
| variant | varchar | 1 | √ | null |
|
|
Referring value for spar.seedlot.variant column |
||||
| bec_version_id | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.bec_version_id column |
||||
| elevation | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.elevation column |
||||
| latitude_degrees | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.latitude_degrees column |
||||
| latitude_minutes | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.latitude_minutes column |
||||
| latitude_seconds | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.latitude_seconds column |
||||
| longitude_degrees | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.longitude_degrees column |
||||
| longitude_minutes | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.longitude_minutes column |
||||
| longitude_seconds | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.longitude_seconds column |
||||
| collection_elevation | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.collection_elevation column |
||||
| collection_elevation_min | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.collection_elevation_min column |
||||
| collection_elevation_max | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.collection_elevation_max column |
||||
| collection_latitude_deg | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.collection_latitude_deg column |
||||
| collection_latitude_min | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.collection_latitude_min column |
||||
| collection_latitude_sec | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.collection_latitude_sec column |
||||
| collection_latitude_code | varchar | 1 | √ | null |
|
|
Referring value for spar.seedlot.collection_latitude_code column |
||||
| collection_longitude_deg | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.collection_longitude_deg column |
||||
| collection_longitude_min | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.collection_longitude_min column |
||||
| collection_longitude_sec | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.collection_longitude_sec column |
||||
| collection_longitude_code | varchar | 1 | √ | null |
|
|
Referring value for spar.seedlot.collection_longitude_code column |
||||
| elevation_min | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.elevation_min column |
||||
| elevation_max | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.elevation_max column |
||||
| latitude_deg_min | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.latitude_deg_min column |
||||
| latitude_min_min | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.latitude_min_min column |
||||
| latitude_sec_min | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.latitude_sec_min column |
||||
| latitude_deg_max | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.latitude_deg_max column |
||||
| latitude_min_max | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.latitude_min_max column |
||||
| latitude_sec_max | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.latitude_sec_max column |
||||
| longitude_deg_min | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.longitude_deg_min column |
||||
| longitude_min_min | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.longitude_min_min column |
||||
| longitude_sec_min | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.longitude_sec_min column |
||||
| longitude_deg_max | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.longitude_deg_max column |
||||
| longitude_min_max | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.longitude_min_max column |
||||
| longitude_sec_max | int2 | 5 | √ | null |
|
|
Referring value for spar.seedlot.longitude_sec_max column |
||||
| smp_mean_bv_growth | numeric | 4,1 | √ | null |
|
|
Referring value for spar.seedlot.smp_mean_bv_growth column |
||||
| area_of_use_comment | varchar | 2000 | √ | null |
|
|
Referring value for spar.seedlot.area_of_use_comment column |
||||
| approved_timestamp | timestamp | 29,6 | √ | null |
|
|
Referring value for spar.seedlot.approved_timestamp column |
||||
| approved_userid | varchar | 30 | √ | null |
|
|
Referring value for spar.seedlot.approved_userid column |
||||
| mean_geom | geometry | 2147483647 | √ | null |
|
|
Referring value for spar.seedlot.mean_geom column |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| seedlot_audit_pk | Primary key | Asc | seedlot_audit_id |
Relationships
Close relationships within degrees of separation
