Schema Version: 1.3

acquisition


Description

This represents the scanning of hybridized material. The output of this process is typically a digital image of an array.

Columns

Column Type Size Foreign Key Nullable Default Comments
acquisition_id bigserial 19
nextval('chado.acquisition_acquisition_id_seq'::regclass)
assay_id int8 19
assay.assay_id acquisition_assay_id_fkey C
null
protocol_id int8 19
protocol.protocol_id acquisition_protocol_id_fkey N
√ null
channel_id int8 19
channel.channel_id acquisition_channel_id_fkey N
√ null
acquisitiondate timestamp 29,6
√ now()
name text 2147483647
√ null
uri text 2147483647
√ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
acquisition_pkey Primary key Asc acquisition_id
acquisition_c1 Must be unique Asc name
acquisition_idx1 Performance Asc assay_id
acquisition_idx2 Performance Asc protocol_id
acquisition_idx3 Performance Asc channel_id

Relationships

The following entity relationship (ER) diagram shows the relationships involving the acquisition table.

Show relationships within degrees of separation