os_revisions

21 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
REV BIGINT 19 √ null
cat_collection_protocol_aud.REV FK_dyoqily0s2m061bxvxik0wou5R
cat_consent_tier_response_aud.REV FK_7crokk0uhxa3aqqh626nasp9qR
cat_specimen_coll_group_aud.REV FK_7nmb9yn4uq0fojtbh2nl7stv2R
catissue_coll_coordinators_aud.REV FK_cx3wxvecf9prg0ulwaw3bwb2sR
catissue_coll_prot_event_aud.REV FK_9xhryw88q1uv2s2oxcn53rsdhR
catissue_coll_prot_reg_aud.REV FK_4rwywid6his5vawygbbok91h7R
catissue_consent_tier_aud.REV FK_hmdofymkui8jf2mhk2a4ub8qmR
catissue_cp_req_specimen_aud.REV FK_r51pe9nboapngjjh34hbm3i2sR
catissue_institution_aud.REV FK_c4n30y077ycht0hl58ri6fko7R
catissue_part_medical_id_aud.REV FK_pkjkhvgsgjkgpwjrg65viug05R
catissue_participant_aud.REV FK_hs8crr2d3nwca17qqfli82ymR
catissue_race_aud.REV FK_qaypykblepjftrcv2xe056rvhR
catissue_site_aud.REV FK_isb8mltbk8qaa3q4epkoy9ellR
catissue_site_coordinators_aud.REV FK_w3jps5e5byvocjpg18nuyffyR
catissue_site_cp_aud.REV FK_8bytnb90kr6dd9hr194p9ei57R
catissue_specimen_aud.REV FK_ctda38ykfjtwuljy7pb6y753dR
catissue_user_aud.REV FK_m9slxw75ecrvrk31nwwamd7ngR
os_container_positions_aud.REV FK_8qr9yjmig276s5njj5q9s5kvmR
os_departments_aud.REV FK_fhlbe4ciavool7n6hrydsxm0aR
os_revision_entities.REV FK_t69kea3hasj6uc6ddn5ck5r9yR
os_revision_entity_records.REV FK_REV_ENTITYR
os_specimen_biohazards_aud.REV FK_SPEC_BIOHAZARD_AUD_REVR
os_spmn_external_ids_aud.REV FK_SPMN_EXT_IDS_AUD_REVR
os_stor_cont_spec_classes_aud.REV FK_lguqtanqxx49uiynh9ihcbjhcR
os_stor_cont_spec_types_aud.REV FK_h1dxr1mk3lbojld9cpgcjos2eR
os_stor_container_cps_aud.REV FK_itwt8wch7fujeieknvgju804wR
os_stor_container_dps_aud.REV FK_OS_STORE_CONT_DPS_AUD_REVR
os_storage_containers_aud.REV FK_i34f99d4j0u2hcato9dww1mxwR
REVTSTMP DATETIME 19 √ null
USER_ID BIGINT 19 √ null
IP_ADDRESS VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc REV

Relationships

Close relationships within degrees of separation